PI45510: DDL FOR XML TABLES NOT CREATED CORRECTLY IF COLUMNS ARE SUBSEQUENTLY ADDED WITH ALTER

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• DDL for XML or lob tables may not be created correctly if
  columns are subsequently added to the table via ALTER.  This can
  cause warning message during data-transfer:
  "CKZ54772W TABLE COLUMN Mismatch"
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Cloning Tool z/OS.              *
  ****************************************************************
  * PROBLEM DESCRIPTION: DDL for XML or lob tables may not be    *
  *                      created correctly if columns are        *
  *                      subsequently added to the table via     *
  *                      ALTER.  This can cause warning message  *
  *                      during data-transfer:                   *
  *                      "CKZ54772W TABLE COLUMN Mismatch"       *
  ****************************************************************
  * 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:

  UI36778

Modules/Macros

•    CKZGASM2 CKZGOBJZ CKZGPDIB CKZHCOPC CKZHTCOP
  CKZ00500 CKZ00501 CKZ00535 CKZ00536 CKZ00540 CKZ00541 CKZ00545
  CKZ00547 CKZ00610 CKZ00992 CKZ1COPC CKZ1TCOP CKZ2ADFN CKZ2ADRD
  CKZ2BCLC CKZ2BDCJ CKZ2CCDM CKZ2CLON CKZ2CMPN CKZ2COMM CKZ2CRDS
  CKZ2DAAC CKZ2DAPO CKZ2DAPS CKZ2DBSS CKZ2DB2A CKZ2DCCC CKZ2DCCH
  CKZ2DCHC CKZ2DCMS CKZ2DCRN CKZ2DDAT CKZ2DEFD CKZ2DFIX CKZ2DREN
  CKZ2DRFD CKZ2DSCC CKZ2DSCJ CKZ2DSCL CKZ2DSCN CKZ2DSCR CKZ2DSCS
  CKZ2DSQL CKZ2DSTP CKZ2DTCS CKZ2EDAC CKZ2EDCV CKZ2EDDL CKZ2EDDN
  CKZ2EDDS CKZ2ELDC CKZ2EMDC CKZ2ESCP CKZ2ETCP CKZ2EXMS CKZ2FTSJ
  CKZ2GFSJ CKZ2GRPJ CKZ2GSTJ CKZ2GTSJ CKZ2GVAR CKZ2HLQS CKZ2IVPL
  CKZ2MAIN CKZ2MGMS CKZ2MRVR CKZ2MSTF CKZ2MTMB CKZ2OMRC CKZ2OPTS
  CKZ2OUPT CKZ2PARM CKZ2PDAC CKZ2PDBL CKZ2PJCI CKZ2PLAP CKZ2PLDC
  CKZ2PMDC CKZ2PMLG CKZ2PRDM CKZ2PRFS CKZ2PRFT CKZ2PRIM CKZ2PROF
  CKZ2PSRT CKZ2PWRK CKZ2PZPI CKZ2RDDC CKZ2RFDT CKZ2RNMS CKZ2SASV
  CKZ2SBCI CKZ2SCLT CKZ2SCNV CKZ2SDDC CKZ2SFRJ CKZ2SFSJ CKZ2SFTJ
  CKZ2SJCI CKZ2SJTS CKZ2SJTV CKZ2SKL  CKZ2SMSV CKZ2SOMT CKZ2SOPR
  CKZ2SPRF CKZ2SRNM CKZ2SRSV CKZ2SSDC CKZ2SSDS CKZ2SSID CKZ2SSLB
  CKZ2SSMC CKZ2SSSC CKZ2SSSJ CKZ2SSSS CKZ2SSTC CKZ2SSTM CKZ2SSTN
  CKZ2SSTS CKZ2SSTT CKZ2SSTV CKZ2STDM CKZ2STDS CKZ2STMB CKZ2STMS
  CKZ2STRG CKZ2STSS CKZ2STVP CKZ2TCOP CKZ2TDDC CKZ2TDDF CKZ2TDSP
  CKZ2TJCL CKZ2TSCI CKZ2TSET CKZ2TTRN CKZ2TYPS CKZ2ULCL CKZ2USET
  CKZ2WLEM CKZ2XMOD CKZ4AREP CKZ4ASYS CKZ4PROF CKZ4RDLL CKZ4REPT
  CKZ4TPRF
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R310 PSY UI36778

     UP16/04/12 P F604

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.