Process for Downloading PTF's for DB2 Tools

Document ID : KB000129153
Last Modified Date : 14/03/2019
Show Technical Document Details
Introduction:
As of R20 of the Database Management Solutions for DB2 for z/OS a PTF bucket is not readily available.  
The recommended process for obtaining maintenance for any Mainframe Product is via the CA SMP/E Internet Service Retrieval (RECEIVE ORDER) .
Documentation can be found in this section.

This document illustrates how to download PTF's in Support Online and how to process the file if the Internet Service Retrieval is not being used.
Instructions:
 Obtaining PTF's for DB2 Tools (Database Management Solutions for DB2 for z/OS)  in Support Online:

1. In Support Online Download Center choose PTF's to download, add to the CART, on checkout ensure 'Create a package' is checked to include the prereqs. 

2. After an email is received the package is created, use the User/Password from the expanded 'FTP via Browser' in the job. 
 
Example JCL to download SCART0 to a USS directory:
------------------------------------------------------------------------------

//JOBCARD*
//ESDGET   EXEC PGM=FTP,PARM='(EXIT=08'
//SYSPRINT DD SYSOUT=*
//OUTPUT   DD SYSOUT=*
//INPUT    DD *
ftpdownloads.ca.com
!! Your username see on expanded info from order, usually email !!
OEmFMf9DREW/VCJ8+QKhkA==         <<<<  PW from the Order
BINARY
get  scart0.zip '/a/xxxx/MNT20/scart0.zip' (REP   <<<  directory where file is placed
QUIT
//
See scart0.zip in the USS directory that was specified. 

4. Next UNZIP scart0.zip using CAUNZIP. 

CAUNZIP example JCL:
---------------------------------

//jobcard
//OUTCLASS SET OUTCLASS='*'
//CAUNZIP EXEC PGM=IKJEFT01,DYNAMNBR=10,REGION=0M
//ZIPRPT   DD SYSOUT=&OUTCLASS,RECFM=FBA
//SYSTSPRT DD SYSOUT=&OUTCLASS
//SYSPRINT DD SYSOUT=&OUTCLASS
//STDOUT   DD SYSOUT=&OUTCLASS
//STDERR   DD SYSOUT=&OUTCLASS
//SYSTSIN DD *
 CAUNZIP ZIPPATH(/a/xxxxx/MNT20) -  <<< USS directory where scart0 resides
 zipfilE(scart0.zip)         -
 javapath(/sys/java64bt/v8r0m0/usr/lpp/java/J8.0_64) -
 TEMPHLQ(Hilvl.USER.CAUNZIP)
---------------- 
Update and run CAUNZIP, control cards: 
CAUNZIP ZIPPATH(/a/xxxx/MNT20) - 
000017 zipfilE(scart0.zip) - 
000018 javapath(/sys/java64bt/v8r0m0/usr/lpp/java/J8.0_64) - 

5. CAUNZIP creates this directory in the USS: 
Creating directory '/a/xxxx/MNT20/scart0/SMPNTS/'. 
(Has SMPPTFIN directory) 

The output has a Summary report with example JCL for the RECEIVE. 

6. This does a Receive from the USS directory where the scart was unzipped. 

Receive example JCL:
------------------------------
//jobcard
//S010   EXEC PGM=GIMSMP,PARM='PROCESS=WAIT',DYNAMNBR=120
//SMPCSI   DD DISP=SHR,DSN=your.CSI  <<<<<
//SMPOUT   DD SYSOUT=*
//SMPRPT   DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SMPJHOME DD PATHDISP=KEEP,
//   PATH='/sys/java64bt/v8r0m0/usr/lpp/java/J8.0_64/'
//SMPNTS   DD PATHDISP=KEEP,
//   PATH='/a/xxxx/MNT20/scart0/' <<< Directory on USS
//SMPCNTL  DD *
   SET BOUNDARY(GLOBAL) .
   RECEIVE FROMNTS(SMPNTS)
      SYSMODS
      DELETEPKG.
   /*
-------------------------------------------------------------------------------------------------