PM58081: NEW COPY COMMAND TARGET-JOB-INDEX-REBUILD-DDN

Obtain the fix for this APAR.

APAR status

• Closed as new function.

Error description

• TARGET-JOB-INDEX-REBUILD-DDN is a new source job COPY command
  that allows all indexes in the target job affected by data
  masking or log apply page changes to be rebuilt.  Two
  JOB-TEMPLATE DDs must be added to the target job JCL. When the
  target job completes, submit the output from JOB-TEMPLATEs to
  rebuild all affected indexes. Any table that has a page changed
  using data masking or log apply will be in the object set that
  must have its index(es) rebuilt. Two rebuild commands are
  supported:
  
   REBUILD INDEX (ALL) TABLESPACE &&DATABASE.&&TABLESP
   REBUILD INDEXSPACE ( &&DATABASE.&&INDEXSP )
  long form:  TARGET-JOB-INDEX-REBUILD-DDN(ddname)
  short form: TRGIR
  default: none
  
  How to specify the template for the target rebuild index...
  #1. in the source job add this COPY command:
  TARGET-JOB-INDEX-REBUILD-DDN(ddname)
  Note that ddname is 7 chars max. FTR will search the trg job
  for ddname followed by an I and an O
  #2. add two DDs to the target job. The I DD is the template
  input and the O DD is the template output
  //CKZTIRI    DD   DISP=SHR,DSN=&hlq.CKZTIRI(mbr)
  //CKZTIRO    DD   DISP=OLD,DSN=&hlq.CKZTIRO(mbr)
  
  TEMPLATE-VARIABLES entered with SET commands in the source job
  are not passed to the target job and cannot be used in the
  target templates.
  This new command is not used to rebuild all indexes using
  JOB-TEMPLATEs. This is done using source job JOB-TEMPLATEs.
  

Local fix

• Manually build and submit the rebuild job.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Cloning Tool.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: TARGET-JOB-INDEX-REBUILD-DDN is a new   *
  *                      source job COPY command that allows     *
  *                      all indexes in the target job affected  *
  *                      by data masking or log apply page       *
  *                      changes to be rebuilt.  Two             *
  *                      JOB-TEMPLATE DDs must be added to the   *
  *                      target job JCL. When the target job     *
  *                      completes, submit the output from       *
  *                      JOB-TEMPLATEs to rebuild all affected   *
  *                      indexes. Any table that has a page      *
  *                      changed using data masking or log       *
  *                      apply will be in the object set that    *
  *                      must have its index(es) rebuilt. Two    *
  *                      rebuild commands are supported:         *
  *                       REBUILD INDEX (ALL) TABLESPACE         *
  *                       &&DATABASE.&&TABLESP                   *
  *                       REBUILD INDEXSPACE (                   *
  *                       &&DATABASE.&&INDEXSP )                 *
  *                      long form:                              *
  *                      TARGET-JOB-INDEX-REBUILD-DDN(ddname)    *
  *                      short form: TRGIR                       *
  *                      default: none                           *
  *                      How to specify the template for the     *
  *                      target rebuild index...                 *
  *                      #1. in the source job add this COPY     *
  *                      command:                                *
  *                      TARGET-JOB-INDEX-REBUILD-DDN(ddname)    *
  *                      Note that ddname is 7 chars max. FTR    *
  *                      will search the trg job for ddname      *
  *                      followed by an I and an O               *
  *                      #2. add two DDs to the target job. The  *
  *                      I DD is the template input and the O    *
  *                      DD is the template output               *
  *                      //CKZTIRI    DD   DISP=SHR,             *
  *                       DSN=&hlq.CKZTIRI(mbr)                  *
  *                      //CKZTIRO    DD   DISP=OLD,             *
  *                       DSN=&hlq.CKZTIRO(mbr)                  *
  *                      TEMPLATE-VARIABLES entered with SET     *
  *                      commands in the source job are not      *
  *                      passed to the target job and cannot be  *
  *                      used in the target templates. This new  *
  *                      command is not used to rebuild all      *
  *                      indexes using JOB-TEMPLATEs. This is    *
  *                      done using source job JOB-TEMPLATEs.    *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

Temporary fix

Comments

• APPLY the PTF.
  

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

  UK77132

Modules/Macros

•    CKZ00501 CKZ00510 CKZ00535 CKZ00536 CKZ00537
  CKZ00544 CKZ00545 CKZ00546 CKZ00547 CKZ00562 CKZ00711 CKZ00762
  CKZ00763 CKZ00764 CKZ00769 CKZ00781
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R310 PSY UK77132

     UP12/03/21 P F203

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.