IBM Support

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

A fix is available

Subscribe

You can track all active APARs for this component.

 

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 IBM 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 number

    PI63601

  • Reported component name

    DB2 CLONING TOO

  • Reported component ID

    5655N1000

  • Reported release

    320

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-06-03

  • Closed date

    2016-08-31

  • Last modified date

    2016-10-03

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI40536

Modules/Macros

  •    CKZABSDS CKZARCHK CKZARGSZ CKZCD002 CKZDDLAL
    CKZDDLAQ CKZDDLCT CKZDDLDB CKZDDLDT CKZDDLIX CKZDDLPK CKZDDLPL
    CKZDDLRL CKZDDLRO CKZDDLRT CKZDDLSG CKZDDLSN CKZDDLSQ CKZDDLTB
    CKZDDLTR CKZDDLTS CKZDDLVA CKZDDLVT CKZDDLXT CKZGCSTL CKZGDBGP
    CKZGDIBI CKZGDIBP CKZGFDCM CKZGFLST CKZGLOG2 CKZGLOG3 CKZGLST2
    CKZGMETL CKZGOBJT CKZGOBJZ CKZGPDBG CKZGUTIL CKZHCOPC CKZHPDAC
    CKZHPMDC CKZHTCOP CKZHUDAC CKZHVDAC CKZH470E CKZH480E CKZISPF
    CKZNORMT CKZPANEL CKZPCONF CKZPROC  CKZRPT   CKZ00500 CKZ00501
    CKZ00510 CKZ00520 CKZ00535 CKZ00536 CKZ00537 CKZ00540 CKZ00541
    CKZ00542 CKZ00544 CKZ00545 CKZ00546 CKZ00547 CKZ00548 CKZ00549
    CKZ00550 CKZ00551 CKZ00553 CKZ00554 CKZ00555 CKZ00556 CKZ00560
    CKZ00561 CKZ00562 CKZ00563 CKZ00564 CKZ00565 CKZ00566 CKZ00569
    CKZ00600 CKZ00610 CKZ00611 CKZ00612 CKZ00613 CKZ00616 CKZ00624
    CKZ00625 CKZ00626 CKZ00627 CKZ00628 CKZ00629 CKZ00630 CKZ00631
    CKZ00632 CKZ00633 CKZ00634 CKZ00635 CKZ00636 CKZ00637 CKZ00638
    CKZ00644 CKZ00645 CKZ00646 CKZ00647 CKZ00648 CKZ00650 CKZ00651
    CKZ00652 CKZ00653 CKZ00654 CKZ00655 CKZ00656 CKZ00657 CKZ00658
    CKZ00659 CKZ00670 CKZ00671 CKZ00674 CKZ00675 CKZ00676 CKZ00677
    CKZ00678 CKZ00679 CKZ00711 CKZ00712 CKZ00713 CKZ00714 CKZ00715
    CKZ00717 CKZ00727 CKZ00728 CKZ00729 CKZ00730 CKZ00731 CKZ00732
    CKZ00733 CKZ00734 CKZ00735 CKZ00736 CKZ00737 CKZ00738 CKZ00745
    CKZ00746 CKZ00747 CKZ00748 CKZ00752 CKZ00753 CKZ00754 CKZ00755
    CKZ00756 CKZ00757 CKZ00758 CKZ00759 CKZ00760 CKZ00761 CKZ00762
    CKZ00763 CKZ00764 CKZ00765 CKZ00769 CKZ00770 CKZ00775 CKZ00776
    CKZ00778 CKZ00779 CKZ00780 CKZ00781 CKZ00782 CKZ00992 CKZ1COPC
    CKZ1TCOP CKZ2ADFN CKZ2ADRD CKZ2ASMB CKZ2BCLC CKZ2BDCJ CKZ2CLON
    CKZ2CMND CKZ2CMPN CKZ2COCP CKZ2COMM CKZ2CRDS CKZ2CTCP CKZ2DAAC
    CKZ2DALV CKZ2DAPO CKZ2DAPS CKZ2DBSS CKZ2DB2A CKZ2DCCC CKZ2DCCH
    CKZ2DCRN CKZ2DDAT CKZ2DDSP CKZ2DDST CKZ2DEFD CKZ2DFIX CKZ2DREN
    CKZ2DRFD CKZ2DSAP CKZ2DSCJ CKZ2DSCL CKZ2DSCN CKZ2DSCP CKZ2DSCR
    CKZ2DSCS CKZ2DSQL CKZ2DSTP CKZ2DTCP CKZ2DTCS CKZ2EDAC CKZ2EDCV
    CKZ2EDDF CKZ2EDDL CKZ2EDDS CKZ2ELDC CKZ2EMCS CKZ2EMDC CKZ2ESCP
    CKZ2ETCP CKZ2FTSJ CKZ2F991 CKZ2GFSJ CKZ2GVAR CKZ2IVPL CKZ2JCL
    CKZ2JSKL CKZ2LACR CKZ2LAOP CKZ2LSTS CKZ2MAIN CKZ2MEPL CKZ2MRVR
    CKZ2MSTF CKZ2MTMB CKZ2OMRC CKZ2OPTS CKZ2PDAC CKZ2PDBL CKZ2PJCI
    CKZ2PLAP CKZ2PLDC CKZ2PMDC CKZ2PRDM CKZ2PRFL CKZ2PRIM CKZ2PRML
    CKZ2PROF CKZ2PZPI CKZ2SASV CKZ2SBCI CKZ2SCLT CKZ2SCNV CKZ2SFRJ
    CKZ2SFSJ CKZ2SFTJ CKZ2SIDL CKZ2SJCI CKZ2SJCL CKZ2SJTS CKZ2SJTV
    CKZ2SKL  CKZ2SOMT CKZ2SOPR CKZ2SPCC CKZ2SPRF CKZ2SRNM CKZ2SRSV
    CKZ2SSCP CKZ2SSDS CKZ2SSID CKZ2SSLB CKZ2SSMC CKZ2SSSC CKZ2SSSJ
    CKZ2SSTM CKZ2SSTN CKZ2SSTS CKZ2SSTT CKZ2SSTV CKZ2STRU CKZ2STSS
    CKZ2TCOP CKZ2TDDC CKZ2TDDF CKZ2TDSP CKZ2TJCL CKZ2TRCF CKZ2TSCI
    CKZ2TSCP CKZ2TSET CKZ2TTRN CKZ2TYPS CKZ2ULCL CKZ2USET CKZ2VRFY
    CKZ2XMOD CKZ2ZD1M CKZ2ZD2M CKZ2ZD3M CKZ4ABUF CKZ4ACUR CKZ4AEXS
    CKZ4AFLE CKZ4AREC CKZ4AREP CKZ4ASYS CKZ4BBIN CKZ4BINT CKZ4BLOG
    CKZ4BPST CKZ4BVCH CKZ4CLSR CKZ4CMAP CKZ4FPST CKZ4PROF CKZ4RDLL
    CKZ4REPT CKZ4SPRF CKZ4STCK CKZ4STMP CKZ4TIME CKZ4TIMP CKZ4TPRF
    CKZ4UTIL CKZ47    CKZ48    CKZ5ABUF CKZ5ACUR CKZ5AEXS CKZ5AFLE
    CKZ5AREC CKZ5AREP CKZ5ASYS CKZ5BBIN CKZ5BINT CKZ5BLOG CKZ5BPST
    CKZ5BVCH CKZ5CLSR CKZ5CMAP CKZ5CONT CKZ5RDLL CKZ5STMP CKZ5TIME
    CKZ5TIMP CKZ5UTIL
    

Fix information

  • Fixed component name

    DB2 CLONING TOO

  • Fixed component ID

    5655N1000

Applicable component levels

  • R320 PSY UI40536

       UP16/09/07 P F609

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.

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAUUE","label":"IBM Db2 Cloning Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 February 2021