PH50391: APPLICATION CLONING REPORTS IX_UNIQUERULE MISMATCH AFTER CREATING A PRIMARY KEY ON A TABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• When application cloning DDL generator adds a primary key to an
  existing target table, it rebuilds target indexes due to a
  IX_UNIQUERULE mismatch, even though adding the primary key fixed
  the mismatch
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS           *
  ****************************************************************
  * PROBLEM DESCRIPTION: Application cloning reports             *
  *                      IX_UNIQUERULE mismatch after creating a *
  *                      primary key on a table                  *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  Application cloning reports IX_UNIQUERULE mismatch after
  creating a primary key on a table
  

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

• CKZ#A001 CKZ#ACIR CKZ#ACIW CKZ#ACON CKZ#ACRD CKZ#ACUP CKZ#ADIS
  CKZ#ADSC CKZ#AEXT CKZ#AFMT CKZ#AFRR CKZ#ALLO CKZ#AMIN CKZ#ASYS
  CKZ#AUMX CKZ#AUTO CKZ#BIND CKZ#CARD CKZ#CHKR CKZ#CL   CKZ#CL64
  CKZ#CL7  CKZ#CL8  CKZ#CLLS CKZ#CMTS CKZ#CN64 CKZ#CNTL CKZ#CNVT
  CKZ#CPM  CKZ#CPNT CKZ#CPOL CKZ#DB2V CKZ#DSAF CKZ#DSPL CKZ#DSQL
  CKZ#DYNL CKZ#ENCR CKZ#ENQS CKZ#ENVF CKZ#EPRI CKZ#FCPY CKZ#ICAI
  CKZ#ICAL CKZ#ICCC CKZ#ICCI CKZ#IDCF CKZ#IDSA CKZ#IERR CKZ#IHSA
  CKZ#IKPL CKZ#IKPN CKZ#ILGP CKZ#ILRA CKZ#ILRS CKZ#ILSA CKZ#INIT
  CKZ#IOPF CKZ#IPIE CKZ#IPPB CKZ#IPPC CKZ#IPPD CKZ#IPPH CKZ#IPPL
  CKZ#IPPN CKZ#IPPS CKZ#IRPL CKZ#ISNA CKZ#JPRI CKZ#JU64 CKZ#JUST
  CKZ#LGAA CKZ#LGAC CKZ#LGAF CKZ#LGAI CKZ#LGAP CKZ#LOGR CKZ#LRD6
  CKZ#MAIN CKZ#MDRV CKZ#MLOG CKZ#MMGR CKZ#MPRI CKZ#MREP CKZ#MTIO
  CKZ#NREC CKZ#OPRI CKZ#OS   CKZ#PRNG CKZ#QSAM CKZ#RANG CKZ#RESM
  CKZ#RH   CKZ#RH10 CKZ#RM24 CKZ#RPRP CKZ#RUNT CKZ#SQL2 CKZ#SQLC
  CKZ#STAT CKZ#STCK CKZ#STMT CKZ#SUBD CKZ#SUBS CKZ#SUBX CKZ#SYSC
  CKZ#TB   CKZ#TB7  CKZ#TB8  CKZ#TP   CKZ#TP10 CKZ#TSS  CKZ#TSSA
  CKZ#TUTL CKZ#UPRI CKZ#UTLB CKZ#UTLC CKZ#UTLS CKZ#UTOP CKZ#VERS
  CKZ#VSM  CKZ#WRIT CKZ#XMLI CKZ#XMLJ CKZ#XMLS CKZ$ACCS CKZ$BDSN
  CKZ$BMSG CKZ$BOOT CKZ$BUTJ CKZ$CAF  CKZ$CAFA CKZ$CALL CKZ$CTCM
  CKZ$DCMD CKZ$DCVT CKZ$ESTA CKZ$INFO CKZ$PRFD CKZ$PRFR CKZ$SMSG
  CKZ$SPRM CKZ$SQL2 CKZ$SQLC CKZ$SSCT CKZ$TOK  CKZ$TSOC CKZ$ZPAR
  CKZ00020 CKZ00021 CKZ00022 CKZ00023 CKZ00024 CKZ00030 CKZ00031
  CKZ00055 CKZ00056 CKZ00057 CKZ00060 CKZ00065 CKZ00067 CKZ00070
  CKZ00071 CKZ00072 CKZ00073 CKZ00100 CKZ00110 CKZ00111 CKZ00112
  CKZ00113 CKZ00114 CKZ00115 CKZ00116 CKZ00130 CKZ00135 CKZ00136
  CKZ00140 CKZ00141 CKZ00143 CKZ00150 CKZ00151 CKZ00215 CKZ00220
  CKZ00221 CKZ00222 CKZ00223 CKZ00224 CKZ00240 CKZ00241 CKZ00245
  CKZ00250 CKZ00252 CKZ00260 CKZ00270 CKZ00271 CKZ00280 CKZ00400
  CKZ00420 CKZ00421 CKZ00422 CKZ00430 CKZ00440 CKZ00450 CKZ00460
  CKZ00480 CKZ00543 CKZ00547 CKZ00992 CKZ3MEPI CKZ3MEPL CKZ@CAF
  CKZ@CAFA CKZ@CAFW CKZ@DSQL CKZ@LOGR CKZ@ROLB CKZ@SMSG CKZ@SQLD
  CKZ@TOK  CKZALLZT CKZAPOST CKZBLNKT CKZCAPST CKZCHART CKZCOMAT
  CKZDAREA CKZDOTT  CKZDSNXT CKZDYNAL CKZFTRT  CKZHEXT  CKZHLI
  CKZHLI2  CKZIENQS CKZLGRD  CKZLINKL CKZLVALT CKZMMGR  CKZMSRT
  CKZNBLKT CKZNNUMT CKZPARET CKZPERIT CKZRPART CKZS99   CKZSRT64
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI83097

     UP22/11/04 P F211

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.