search cancel

Sample JCL to APPLY maintenance and published PTFs from scart0.zip.

book

Article ID: 40176

calendar_today

Updated On:

Products

PDSMAN Database Management for DB2 for z/OS - Administration Suite Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - Recovery Suite Database Management for DB2 for z/OS - SQL Performance Suite Database Management for DB2 for z/OS - Utilities Suite DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS

Issue/Introduction

For Database Management for Db2 for z/OS product suite, a PTF bucket with all published PTFs since
the GA Release was published it not available for download. However after a scart0.zip file has been created
with all published PTFs, the maintenance can be easily applied with the following sample JCL.  

Resolution

In order to download all PTFs for Database Management for Db2 for z/OS solutions from Support Online and
create a scart0.zip file with the PTFs to be applied perform the following steps:

1) Select any one of the Database Management for Db2 for z/OS products licensed, for example Detector, from the Published Solutions download page in the Download Center on support.broadcom.com 
2) Click "Select All" to highlight all products
3) Enter a High PTF Number or confirmed since date to limit the PTF's to only those since the last download
4) Click "Go" to generate the list of PTF's.
5) On the 'Published Solutions Downloads' screen click "Add all to cart (per page)" - Note you may want to increase the results per page count in order to get fewer pages to select all from.
6) Click the 'View download cart' and then Checkout.

After 'Checkout' was selected and you answered YES to question 'Do you want a complete package for all?' to include all prerequisites you will receive an Order Number and you have to wait for the package to be created. When the package is created you will receive an e-mail with the FTP Directory where the package is located, now a scart0.zip file has been created with all selected PTF's and Prerequisites.
 
To transfer the created scart0.zip file to your z/OS system you can work with the following JCL, keep in mind the scart0.zip file might be very large so it is better to transfer it directly to a z/OS USS Directory. In the following FTP sample you have to update the z/OS USS Directory names to your own names.  

//*-------------------------------------------------------------------------**
//*                                                                                               **
//* * CAZIPCPY *                                                                          **
//*                                                                                               **
//* FUNCTION: SAMPLE JOB USED TO COPY A ZIP FILE CREATED BY **
//* CA SUPPORT ONLINE TO A USS DIRECTORY.                              **
//*                                                                                               **
//*-------------------------------------------------------------------------**
//* COPYRIGHT (C) 2013 CA. ALL RIGHTS RESERVED.                     **
//*-------------------------------------------------------------------------**
//*
//ZIPCOPY EXEC PGM=FTP,REGION=0K
//SYSTCPD DD DISP=SHR,DSN=VTAM.TCPIP.TCPIP.DATA
//SYSPRINT DD SYSOUT=*
//INPUT DD *
scftpd.ca.com
anonymous [email protected]
cd /ftp/orders/nnnnnn/nnnnnnnzip/ <-- (1)
bin
get scart0.zip /a/userid/mnt190/scart0.zip <--(2)
quit
/*
//

(1) The location on Support Online where the scart0.zip file is found
(2) The existing z/OS USS directory to where the download will be done

The z/OS USS directory has to be quite large as there might be a lot of files created after the scart0.zip file is unzipped.
 
To unzip the scart0.zip file you have to work with CAUNZIP utility, in the following sample JCL update the names with your own names.
 
//*-----------------------------------------------------------------------------**
//* * CAUNZIP *                                                                                **
//* FUNCTION: SAMPLE JOB USED TO EXECUTE THE CAUNZIP UTILITY. **
//* THIS UTILITY WILL UNZIP YOUR SCART0.ZIP FILE                          **
//* CREATED BY CA SUPPORT ONLINE AND CREATE A SMPNTS             **
//* INSTALLABLE PACKAGE.                                                               **
//*-----------------------------------------------------------------------------**
//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/userid/mnt190) -
ZIPFILE(scart0.zip) -
JAVAPATH(/usr/lpp/java/J8.0)
/*
//
 
Now files are ready for the SMP/E RECEIVE but first you have to download and RECEIVE the HOLDDATA data set from
Support Online, you can work with same JCL when Database Management for Db2 for z/OS base was installed.
 
To run the SMP/E RECEIVE you can run the following JCL.

//RECEIVE EXEC PGM=GIMSMP,PARM='PROCESS=WAIT',DYNAMNBR=120,REGION=0M
//SMPCSI DD DISP=SHR,DSN=hlq.CSI
//SMPOUT DD SYSOUT=*
//SMPRPT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SMPJHOME DD PATHDISP=KEEP,
// PATH='/usr/lpp/java/J8.0/'
//SMPNTS DD PATHDISP=KEEP,
// PATH='/a/userid/mnt190/scart0/'
//SMPCNTL DD *
SET BOUNDARY(GLOBAL) .
RECEIVE FROMNTS(SMPNTS)
SYSMODS
HOLDDATA
DELETEPKG
.
/*

This sample JCL is generated in CAUNZIP Job output with the list of unzipped PTF's, review careful the CAUNZIP Job output to locate it and update it accordingly.

After the SMP/E RECEIVE has been run you can apply all the PTF just in one JCL. Do not forget to run first the APPLY CHECK.

//SMPCNTL DD *
SET BOUNDARY(CAIT0) .
APPLY PTFS
BYPASS(HOLDSYSTEM)
GROUPEXTEND
CHECK
.

When the APPLY CHECK has been run without problem then you can remove the CHECK clause and run the SMP/E APPLY.

The first time you download all PTFs since a base release was published you may get a large file with hundreds of PTF's.
Review the ++HOLD statements for any actions you have to perform before or after the SMP/E APPLY, this is important
to avoid further problems before or after the SMP/E APPLY has been run. Make certain the Post-Install tasks are run as they
are reported in the ++HOLD statements.