PH42967: CLONING TOOL 3.2 JANUARY PTF

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This release contains the following bug fixes:
  1. DDL statements generated by application cloning end with
  SQLCODE = -678 because of an incorrect Limit Key
  2. When generating DDL, application cloning DDL generator or
  subsystem cloning DB2SCHEMA-UPDATE commands add prefixes to the
  wrong type of objects
  3. Application cloning source job with DDL generation enabled
  ends with CKZ54710W/CKZ54774E messages for XML table spaces
  4. Application cloning target job issues CKZPG004W/CKZPG005W
  warnings for indexes with clones
  5. Application cloning target job issues CKZ99094W for XML table
  space data sets
  6. Application cloning target job might damage the contents of
  the PGSBID field in target XML table space data sets
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS           *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. DDL statements generated by          *
  *                      application cloning end with SQLCODE =  *
  *                      -678 because of an incorrect Limit Key  *
  *                      2. When generating DDL, application     *
  *                      cloning DDL generator or subsystem      *
  *                      cloning DB2SCHEMA-UPDATE commands add   *
  *                      prefixes to the wrong type of objects   *
  *                      3. Application cloning source job with  *
  *                      DDL generation enabled ends with        *
  *                      CKZ54710W/CKZ54774E messages for XML    *
  *                      table spaces                            *
  *                      4. Application cloning target job       *
  *                      issues CKZPG004W/CKZPG005W warnings for *
  *                      indexes with clones                     *
  *                      5. Application cloning target job       *
  *                      issues CKZ99094W for XML table space    *
  *                      data sets                               *
  *                      6. Application cloning target job might *
  *                      damage the contents of the PGSBID field *
  *                      in target XML table space data sets     *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  1. DDL statements generated by application cloning end with
  SQLCODE = -678 because of an incorrect Limit Key
  2. When generating DDL, application cloning DDL generator or
  subsystem cloning DB2SCHEMA-UPDATE commands add prefixes to
  the wrong type of objects
  3. Application cloning source job with DDL generation enabled
  ends with CKZ54710W/CKZ54774E messages for XML table spaces
  4. Application cloning target job issues CKZPG004W/CKZPG005W
  warnings for indexes with clones
  5. Application cloning target job issues CKZ99094W for XML table
  space data sets
  6. Application cloning target job might damage the contents of
  the PGSBID field in target XML table space data sets
  

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:

  UI79061

Modules/Macros

• CKZ00501 CKZ00547 CKZ00722 CKZ00992 CKZCAL9C CKZCALNC CKZCAQ1C
  CKZCAQNC CKZCAT01 CKZCATM  CKZCATMO CKZCCT9C CKZCCTNC CKZCDB9C
  CKZCDPNC CKZCDT0C CKZCDT1C CKZCDT9C CKZCDTNC CKZCFN0C CKZCFN9C
  CKZCFNNC CKZCHECK CKZCIX0C CKZCIX2C CKZCIX9C CKZCIXNC CKZCMT0C
  CKZCMTNC CKZCPK0C CKZCPK1C CKZCPK9C CKZCPKNC CKZCPL0C CKZCPL1C
  CKZCPL9C CKZCPLNC CKZCRL2C CKZCRL9C CKZCRO9C CKZCRTNC CKZCSG9C
  CKZCSN9C CKZCSNNC CKZCSP9C CKZCSPNC CKZCSQ1C CKZCSQ9C CKZCSQNC
  CKZCTB0C CKZCTB1C CKZCTB2C CKZCTB9C CKZCTBNC CKZCTC0C CKZCTR0C
  CKZCTR9C CKZCTRNC CKZCTS0C CKZCTS2C CKZCTS9C CKZCTSNC CKZCVA1C
  CKZCVANC CKZCVT0C CKZCVT9C CKZCVTNC CKZCXANC CKZCXT9C CKZFATTR
  CKZFCD02 CKZFCEXP CKZFCFTC CKZFGNAL CKZFGNAQ CKZFGNCL CKZFGNCT
  CKZFGNDB CKZFGNDT CKZFGNIX CKZFGNPK CKZFGNPL CKZFGNRL CKZFGNRO
  CKZFGNRT CKZFGNSG CKZFGNSN CKZFGNSQ CKZFGNTB CKZFGNTC CKZFGNTR
  CKZFGNTS CKZFGNVA CKZFGNVT CKZFGNXT CKZFNORM CKZFPSDP CKZPPPG
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI79061

     UP22/01/28 P F201

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.