PI78638: DETECT AND REBUILD TARGET-ONLY ("UNMATCHED") INDEXES

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Enable detection of indexes in the target subsystem that are not
  in the source subsystem. Currently only target indexes that are
  mapped from source indexes are processed. If one or more indexes
  are added to the target they will be ignored when the target
  job runs.
  Can request "processing" and, optionally, "rebuild", in the SET
  command using keywords PROCESS-UNMATCHED-TARGET-INDEXES and
  REBUILD-UNMATCHED-TARGET-INDEXES, respectively. Processing
  means unmatched Target-only indexes will cause message
  CKZ61901I to appear in CKZPRINT in the Target job to identify
  each unmatched index. Rebuild means those indexes will be
  rebuilt with REBUILD-INDEXES-EXECUTE ( Y ) in the Target job.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM DB2 Cloning Tool z/OS.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: Enable detection of indexes in the      *
  *                      target subsystem that are not in the    *
  *                      source subsystem. Currently only        *
  *                      target indexes that are mapped from     *
  *                      source indexes are processed. If one    *
  *                      or more indexes are added to the        *
  *                      target they will be ignored when the    *
  *                      target job runs.                        *
  *                      Can request "processing" and,           *
  *                      optionally, "rebuild", in the SET       *
  *                      command using keywords                  *
  *                      PROCESS-UNMATCHED-TARGET-INDEXES and    *
  *                      REBUILD-UNMATCHED-TARGET-INDEXES,       *
  *                      respectively. Processing means          *
  *                      unmatched Target-only indexes will      *
  *                      cause message                           *
  *                      CKZ61901I to appear in CKZPRINT in the  *
  *                      Target job to identify each unmatched   *
  *                      index. Rebuild means those indexes      *
  *                      will be rebuilt with                    *
  *                      REBUILD-INDEXES-EXECUTE ( Y ) in the    *
  *                      Target job.                             *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

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

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

Modules/Macros

•    CKZ2MAIN
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI46483

     UP17/04/24 P F704

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.