PI98778: CLONING FROM DB2 V12 WITH DDL GENERATION ENABLED ENDS WITH RC=8 AND MESSAGE CKZB209E IS ISSUED FOR SQLCODE=-305 IN CKZCIX2C.C

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When table space cloning with DDL processing enabled is run on a
  source Db2 V12 subsystem, the source job might end with RC=8,
  and the job log contains message CKZB209E that describes an SQL
  error in ckzcix2c.c with SQLCODE=-305. This error occurs when
  cloned objects include indexes that were created in previous
  versions of Db2.
  .
  After applying this fix, DDL is successfully generated for
  indexes that were created in previous versions of Db2.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Cloning Tool z/OS.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: When table space cloning with DDL       *
  *                      processing enabled is run on a source   *
  *                      Db2 V12 subsystem, the source job       *
  *                      might end with RC=8, and the job log    *
  *                      contains message CKZB209E that          *
  *                      describes an SQL error in ckzcix2c.c    *
  *                      with SQLCODE=-305. This error occurs    *
  *                      when cloned objects include indexes     *
  *                      that were created in previous versions  *
  *                      of Db2.                                 *
  *                      After applying this fix, DDL is         *
  *                      successfully generated for indexes      *
  *                      that were created in previous versions  *
  *                      of Db2.                                 *
  ****************************************************************
  * 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

•    CKZHCOPC
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI57180

     UP18/07/13 P F807

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.