How to use TEMPLATE function during a Rapid Reorg job to create dynamically allocated Quick Copy Image copy datasets

Products

• Rapid Reorg for DB2 for z/OS
• Quick Copy for DB2 for z/OS

Issue/Introduction

When a Rapid Reorg for Db2 for z/OS (PRR) job is executed, the ability to create an image copy during the job is provided via a call to Quick Copy for Db2 for z/OS (PQC)
using the QUICKCOPY keyword. If dynamic allocation of the image copy dataset is required Quick Copy does this via the hlq.CDBAPARM(PQC) member which contains
dataset mask templates for creating the required datasets. If the user does not wish to use the standard templates in hlq.CDBAPARM(PQC) there is a TEMPLATE function
which can be used in the individual PRR JCL that will override the hlq.CDBAPARM(PQC).

Resolution

To override the standard hlq.CDBAPARM(PQC) dynamic allocation parms using the TEMPLATE function change the JCL accordingly.

Add in a SYSTEMPL DD card, define a number of different named templates. In this example one for large size tablespaces(BIGTS) and one for small size(SMALLTS).

Various variables can be used to make up the dataset pattern as can be done in PQC in order to make them unique.

//SYSTEMPL DD *

TEMPLATE BIGTS DSN HLQ.2LQ.B.&TS..P&PART..T&TIME. DISP (NEW,CATLG,CATLG) UNIT CART RETPD 15 GDGLIMIT 10 STACK YES

TEMPLATE SMALLTS DSN HLQ.&DB..&SN..P&PA..SMALLTS DISP (NEW,CATLG,CATLG) UNIT DISK SPACE (10,10) CYL LIMIT(100 CYL, BIGTS)

In order to reference this structure in the PRR parms the QUICKCOPY parm is used.

QUICKCOPY COPYnn (Y|N,[ddname|templatename],[exitname,][icbackup,][devtype])

In this example instead of referring to a ddname in the JCL one of the templatenames is referenced.
PQC will recognize this as a template and not a ddname.

QUICKCOPY COPY01(Y,SMALLTS,,LP)

This will reference the SMALLTS Template in this example.

In the job output this will be seen when this template is used.

COPY DATA PROCESS STARTING

COPY001 - FULL IMAGECOPY DATASET: authid.database.tablespace.P00001.SMALLTS

VOLUMES: SMS SYSCOPY UPDATE: ICTYPE=F STYPE= DSNUM=000 ICBACKUP= REAL TIME STATISTICS TABLES UPDATE COMPLETED

COPY DATA PROCESS ENDING . . .

PQC0260I DATASET ALLOCATED: DDNAME SYS00082 USING TEMPLATE SMALLTS DSN authid.database.tablespace.P00001.SMALLTS

Additional Information

Documentation regarding the use of the QUICKCOPY parm and TEMPLATE functions can be found in the Rapid Reorg for DB2 for z/OS User Guide.