PH51489: APPLICATION CLONING GENERATES DDL FOR AN EXISTING TARGET PRIMARYKEY

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When application cloning source or target tables were created on
  Db2 version 7 or earlier or when OBJECT-TRANSLATE rules for
  table spaces are specified incorrectly, DDL generator might
  produce DDL for a primary key that already exists on the target
  Db2.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS           *
  ****************************************************************
  * PROBLEM DESCRIPTION: When application cloning source or      *
  *                      target tables were created on Db2       *
  *                      version 7 or earlier or when            *
  *                      OBJECT-TRANSLATE rules for table spaces *
  *                      are specified incorrectly, the DDL      *
  *                      generator might produce DDL for a       *
  *                      primary key that already exists on the  *
  *                      target Db2                              *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  When application cloning source or target tables were created on
  Db2 version 7 or earlier or when OBJECT-TRANSLATE rules for
  table spaces are specified incorrectly, the DDL generator might
  produce DDL for a primary key that already exists on the target
  Db2
  

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:

  UI83802

Modules/Macros

• CKZ00535 CKZ00543 CKZ00600 CKZ00709 CKZ00780 CKZ00992 CKZFATTR
  CKZPPPG
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI83802

     UP22/12/22 P F212

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.