Process for Downloading PTF's for DB2 Tools
Article ID: 129153
Updated On:
Products
Database Analyzer for DB2 for z/OS
Fast Unload for DB2 for z/OS
Fast Check for DB2 for z/OS
Fast Index for DB2 for z/OS
Rapid Reorg for DB2 for z/OS
Issue/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 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.
Environment
Release:
Component: INS
Component: INS
Resolution
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.
/*
-------------------------------------------------------------------------------------------------
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.
/*
-------------------------------------------------------------------------------------------------
Feedback
Yes
No
Powered by
