Change Download Preference


{{errorInSavingPref}}
Current Preference
{{dwnldPreference}}
Change Preference to:

CA Database Management Solutions for DB2 for z/OS
Downloading PTFs

Last Updated: July 24, 2017

  1. To access PTFs, right click on links below.
  2. Choose the 'Save Target As' or 'Save Link As' option to save this tersed binary file to your PC.
  3. FTP the saved file to the mainframe in binary format as a fixed block file with an LRECL of 1024. (Optionally, JCL can be used to replace steps 1-3. See below for specifics.)
Available PTFs V19.0 PTF Bucket

V18.0 PTF Bucket

V17.0 PTF Bucket


Not available for Incremental Release. Please utilize the Download Center.

FTP this file to the mainframe in binary format as a fixed block file with an LRECL of 1024. (Optionally, JCL below can be used to FTP directly to mainframe.)



Available PTFs Index V19.0 PTF Index

V18.0 PTF Index

V17.0 PTF Index


Not available for Incremental Release. Please utilize the Download Center.

These files contain a list of PTFS and a short description of the contained for each bucket.

 

The following JCL can be used to download the files directly to a mainframe dataset. Depending on the size of the PTF file and space available for the mainframe PTFLIB dataset, it may be necessary to increase/decrease the PRI and SEC values.

PTFS Since GA //FTPSTEP EXEC PGM=FTP,PARM='(EXIT=08'
//SYSTCPD DD DSN=VTAM.TCPIP.TCPIP.DATA,DISP=SHR
//SYSPRINT DD SYSOUT=*
//OUTPUT DD SYSOUT=*
//INPUT DD *
ftp.ca.com 21
anonymous
* email address *
cd * enter FTP Directory listed below *
dir
binary
locsite LR=1024 REC=FB BLOCKSI=0
locsite PRI=240 SEC=20 CY
get *File Name listed below* '* PTFLIB dsn *' (REPLACE
quit

 

The following is a list of FTP directories and file names that should be used within JCL:

Release FTP Directory File Name
V19.0 N/A N/A
V18.0 /pub/db2hyper/D18/D18-PTFPKG/ D18-PTF.BIN.TRS
V17.0 /pub/db2hyper/D17/D17-PTFPKG/ D17-PTF.BIN.TRS



Applying Selected Maintenance

  • After files have been transferred to the mainframe, the PTF files need to be untersed using this sample JCL:

    //UNTERSE EXEC PGM=TRSMAIN,PARM='UNPACK'
    //SYSPRINT DD SYSOUT=*
    //INFILE DD DISP=SHR,DSN=* UPLOADED DATASET *
    //OUTFILE DD DSN=* PTFLIB DATASET *,
    // UNIT=SYSDA,SPACE=(CYL,(240,20),RLSE),
    // DISP=(NEW,CATLG,DELETE)

  • Each PTF is identified using SMP/E ++ASSIGN statements. The following SOURCEID(s) can be found with the PTFS:
CAPyymm Indicates that PTF is part of preventative maintenance where yymm represents year and month that the PTF was created
HIPER Indicates that the PTF resolves a High Impact or Pervasive problem.
PRP Indicates that the PTF resolves a PTF in Error
SPE Indicates that the PTF contains a small programming enhancement.

 

  • RECEIVE and APPLY the PTF and holddata using the following sample JCL. Make the appropriate substitutions for the fields designated by '*':

    //SMPEAPP EXEC PGM=GIMSMP
    //SMPCSI DD DISP=SHR,DSN=* YOUR CSI *
    //SMPHOLD DD DISP=SHR,DSN=* PTFHOLD DATASET *
    //SMPPTFIN DD DISP=SHR,DSN=* PTFLIB DATASET *
    //SMPCNTL DD *
    SET BOUNDARY(GLOBAL).
    RECEIVE SOURCEID(* enter a unique source id).
    SET BOUNDARY(* YOUR TARGET ZONE *).
    APPLY SOURCEID(* source id *)
    GROUPEXTEND
    BYPASS(HOLDSYSTEM).