PH29381: DB2 CLONING TOOL - 3.2 OCTOBER PTF

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This release includes the following bug fixes:
  1. Db2 application cloning source job can end with RC=8 and
  message CKZ64007E when cloned objects include indexes with
  different target databases and keywords RECREATE-OBJECTS(A)
  and AUTO-INDEXSPACE-TRANSLATE(N) are specified.
  2. Incorrect processing of BDE structures during cross-LPAR
  cloning with log apply when there are more than 1000 BDE
  structures in one log apply group.
  3. Db2 application cloning target job with log apply ends with
  abend when return code of CKZ00669 module is greater than 4.
  4. Error with SQLCODE=-802 can occur in the Db2 application
  cloning target job during update statistics.
  5. DDL generation module displays message CKZB290W for existing
  target databases.
  6. DDL generation module does not use CREATE OR REPLACE syntax
  for target stored procedures when source stored procedures use
  this syntax.
  7. Db2 application cloning target job might hang when trying to
  sort XML strings during cross-LPAR cloning.
  8. The value of CKZINI PARMLIB keyword TCPIP_STC_NAME is ignored
  in Db2 application cloning source TCP/IP server job.
  9. The Db2 subsystem cloning stored procedure does not check for
  the existence of the data set that is specified in the
  SOURCE-BACKINFO-DSN value in the CPARM member.
  10. Objects after ALTER TABLE DROP CLONE are excluded from Db2
  application cloning with message CKZ54402W if instance 2 is used
  in the name of data set.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Incorrect processing of BDE structures  *
  *                      during cross-LPAR cloning with log      *
  *                      apply when there are more than 1000     *
  *                      BDE structures in one log apply group.  *
  *                                                              *
  *                      Db2 application cloning target job with *
  *                      log apply ends with abend when return   *
  *                      code of CKZ00669 module is greater      *
  *                      than 4.                                 *
  *                                                              *
  *                      DDL generation module displays message  *
  *                      CKZB290W for existing target databases. *
  *                                                              *
  *                      DDL generation module does not use      *
  *                      CREATE OR REPLACE syntax for target     *
  *                      stored procedures when source stored    *
  *                      procedures use this syntax.             *
  *                                                              *
  *                      Db2 application cloning target job      *
  *                      might hang when trying to sort XML      *
  *                      strings during cross-LPAR cloning.      *
  *                                                              *
  *                      The value of the CKZINI PARMLIB keyword *
  *                      TCPIP_STC_NAME is ignored in Db2        *
  *                      application cloning source TCP/IP       *
  *                      server job.                             *
  *                                                              *
  *                      The Db2 subsystem cloning stored        *
  *                      procedure does not check for the        *
  *                      existence of the data set that          *
  *                      specified in the SOURCE-BACKINFO-DSN    *
  *                      value in the CPARM member.              *
  *                                                              *
  *                      Objects after ALTER TABLE DROP CLONE    *
  *                      are excluded from Db2 application       *
  *                      cloning with message CKZ54402W if       *
  *                      instance 2 is used in the name of data  *
  *                      set.                                    *
  ****************************************************************
  .
  

Problem conclusion

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:

  UI71969

Modules/Macros

• CKZ00530 CKZ00544 CKZ00640 CKZ00669 CKZ00674 CKZ1PARM CKZFCD02
  CKZPSIXN CKZPSTBN
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI71969

     UP20/10/08 P F010

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.