Meet the next generation of IBM i innovators

31 May

http://www.ibmsystemsmagpowersystemsdigital.com/nxtbooks/ibmsystemsmag/2017FreshFacesIBMi/

Advertisements

BOX Sync Stops, No Alerts

19 Jan

The place I work has a corporate version of BOX, and I’ve been using BOX on my Windows 7 laptop for the last year or so. I kept some crucial files in the BOX sync folder in Windows Explorer, and I felt relieved to know that these files were being backed up to the “cloud”.
So I got a new laptop the other day and I connected to BOX, and all the files that were downloaded to the new laptop were last updated in June, 2015, seven months ago!
Apparently I logged out of Box Sync back in June and there was no more syncing of my Windows folder.  I may have closed a log-in, or checked a box “do not show again” in haste.  But shouldn’t an essential service like a cloud backup service have barked at least once since then?  I was still using the Box Sync folder?  The services were still running on the laptop!?

Trust but verify.  Or Don’t Trust and verify.  But who has time to verify that a corporate piece of software you were told to use is doing the job corporate wanted the software to do?

It’s a good thing I didn’t have to depend on BOX.

If you are the administrator of Box in a corporate environment, you may want to find a way to confirm active Box syncing by your users.

January 19, 2016

Determining the Technology Refresh PTF level installed

28 Jul

If you are on V7R1.

From IBM Redbook:
IBM i 7.1 Technical Overview with Technology Refresh Updates
December 2014

Determining the Technology Refresh PTF level installed
To determine the Technology Refresh PTF level of 5770-999, use the Display PTF Status
(DSPPTF) command for product 5770-999, as shown in Figure 1-4.
Technology Refresh PTFs for this product are in the format of MF99nnn. The highest number
Technology Refresh PTF on your system, matched with Table 1-1 on page 7, indicates the
Technology Refresh level for this product.

Also known as technical release or TR level.

Unix / sFTP user cannot be more than 8 characters long on iSeries

24 Apr

If you are executing sFTP on an iSeries in batch, the user profile executing the job must be 8 characters or less. This is important.

If you forget this, the error message is “No user exists for uid ###”. This error message does not point you to what is wrong, exactly. It’s a hint. A vague hint.

The iSeries user profile has the uid number.

XMLTABLE – shred XML file into a DB2 file

30 Dec

I initially tried loading a CSV download, but there were issues with stray quote marks in the data, which caused issues for CPYFRMIMPF. I switched to an XML download, because V7R1 on the iSeries has XMLTABLE.

Note the test for empty fields: [text () != “”]

Here is a code sample I use to import XML into a DB2 table.

EXEC SQL SET OPTION COMMIT = *ALL ;
@Stmt = ‘create alias QTEMP/BT__X for bat__v1(‘ +
%trim(@MbrName) + ‘)’;

exec sql execute immediate :@Stmt ;

SQL_Cmd = ‘insert into QTEMP/BT__X ‘ +
‘Select a.* from ‘ +
‘(VALUES(XMLPARSE(DOCUMENT GET_XML_FILE(”’ + %trim(@Dir) + ‘/’ +
%subst(d_name: 1: d_namelen) + ”’)))) as XMLFILE(Invoice), ‘ +
‘XMLTABLE(”Download/Invoice_Download” passing XMLFILE.INVOICE ‘ +
‘COLUMNS F1 Integer default 0 Path ”bill_to_acct_number’+
‘[text () != “”]” ,’ +
‘F2 Integer default 0 Path ”invoice_date[text () != “”]”,’+
‘F3 Integer default 0 Path ”invoice_number’ +
‘[text () != “”]”, ‘+
‘F4 Decimal(8,2) default 0 Path ”original_amount_due ‘ +
‘[text () != “”]”, ‘+
. . . .
) as a ‘ ;
exec sql execute immediate :SQL_Cmd ;

if sqlcod = 0 ;
commit ;
endif ;

@Stmt = ‘drop alias qtemp/BT__X’ ;
exec sql execute immediate :@Stmt ;

Clear DNS cache – iSeries

21 Oct

During a Disaster Recovery (DR) drill, PTF downloads to our iSeries servers were slow.  Painfully slow.  We asked the DR vendor to change the switch settings, check the cabling, etc.  This did not help.

We then checked our TCP settings and soon after noticed our download speeds were much better.  We had inadvertently cleared our DNS cache when we had opened the TCP menu (CFGTCP).

The restores from our SAVSYS tapes were months old and there had been DNS changes on the network in the interim that we had forgotten about.

Question:
Is there a way to clear the DNS resolver cache?

Resolution:
Using the CFGTCP command, select option 12. Pressing the Enter key will
clear the DNS resolver cache (sometimes referred to as the NAME cache).

http://archive.midrange.com/midrange-l/200801/msg00306.html

keyword: Slow PTF downloads.

NetServer Disabled User ID Due to Mapped iSeries Drive

17 Sep

I created an iSeries shared IFS folder and then mapped a network drive on my
Windows 7 PC. Nearly every time I used the mapped drive on my PC, I found that my access was denied and I had to re-enable the NetServer i5/OS user id.

Re-enabling NetServer i5/OS user ids:
– Open iSeries Navigator / select server / Network / Servers / TCP/IP / right click on i5/OS NetServer / select Disabled User Ids.

This issue is caused by identical user ids on the Windows network and on the iSeries, with different passwords. See the link.
http://www-01.ibm.com/support/docview.wss?uid=nas8N1019212

The solution: In iSeries Navigator, right click on the shared IFS folder, and “create shortcut”

2 alternate solutions are either to use different user ids on the 2 systems, or to use the same user id and the same passwords.