IBM Support

PI83216: ENHANCED HANDLING FOR DOCID WHILE CLONING XML TABLES - GENERATE A NEW, UNUSED DOCID FOR THE TARGET ENVIRONMENT

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The following functions are available when working with XML
    objects:
    1) When DB2 Cloning Tool can connect to the target SSID, it
    updates the sequence number used for
    DB2_GENERATED_DOCID_FOR_XML.
    2) When DB2 Cloning Tool is unable to connect to the target
    SSID, it generates JCL that must be run to update the sequence
    number used for DB2_GENERATED_DOCID_FOR_XML.
    This feature ensures the target sequence number is greater than
    or equal to the source number of rows. This is necessary when
    translating XML objects from one table space to another.
    Additionally XML Log Apply support has been added to DB2 Cloning
    Tool.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of IBM DB2 Cloning Tool z/OS.          *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following functions are available   *
    *                      when working with XML objects:          *
    *                      1. When DB2 Cloning Tool can connect    *
    *                      to the target SSID, it updates the      *
    *                      sequence number used for                *
    *                      DB2_GENERATED_DOCID_FOR_XML.            *
    *                      2. When DB2 Cloning Tool is unable to   *
    *                      connect to the target SSID, it          *
    *                      generates JCL that must be run to       *
    *                      update the sequence number used for     *
    *                      DB2_GENERATED_DOCID_FOR_XML.            *
    *                      This feature ensures the target         *
    *                      sequence number is greater than         *
    *                      or equal to the source number of rows.  *
    *                      This is necessary when translating XML  *
    *                      objects from one table space to         *
    *                      another. Additionally XML Log Apply     *
    *                      support has been added to DB2 Cloning   *
    *                      Tool.                                   *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI83216

  • 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

    2017-06-16

  • Closed date

    2017-11-03

  • Last modified date

    2017-12-02

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

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

    UI51684

Modules/Macros

  •    CKZ#LGAP CKZADRSP CKZARGSZ CKZBAKS  CKZBAKT
    CKZBBKS  CKZBBKT  CKZBCKS  CKZBCKT  CKZBTD   CKZBTS   CKZCD002
    CKZDDLAL CKZDDLAQ CKZDDLCL CKZDDLCT CKZDDLDB CKZDDLDT CKZDDLIX
    CKZDDLPK CKZDDLPL CKZDDLRL CKZDDLRO CKZDDLRT CKZDDLSG CKZDDLSN
    CKZDDLSQ CKZDDLTB CKZDDLTR CKZDDLTS CKZDDLVA CKZDDLVT CKZDDLXT
    CKZDOCID CKZFASM  CKZFATTR CKZFBASE CKZFCOMM CKZFCONN CKZFCSTL
    CKZFDBGP CKZFDB2  CKZFDIBI CKZFDIBP CKZFFDCM CKZFFLST CKZFLOG
    CKZFLOG2 CKZFLOG3 CKZFLST2 CKZFMASK CKZFMETL CKZFOBJT CKZFOBJX
    CKZFOBJZ CKZFPDBG CKZFPIN  CKZFPMIB CKZFPSDP CKZFPTRN CKZFRAND
    CKZFRTSI CKZFRTSM CKZFRTST CKZFSQLE CKZFUTIL CKZF2STR CKZGCSTL
    CKZGDBGP CKZGDIBI CKZGDIBP CKZGFDCM CKZGFLST CKZGLOG2 CKZGLOG3
    CKZGLST2 CKZGMETL CKZGOBJT CKZGOBJZ CKZGPDBG CKZGRTSI CKZGRTSM
    CKZGRTST CKZGSIXN CKZGSIX2 CKZGSLSN CKZGSQLE CKZGSSGN CKZGSTBN
    CKZGSTSN CKZGSTS1 CKZGSTS2 CKZGUTIL CKZHSETC CKZHTSET CKZINCID
    CKZISPF  CKZJOBT4 CKZJOBT5 CKZNORMT CKZPANEL CKZPCONF CKZPROC
    CKZPSIXN CKZPSIX2 CKZPSLSN CKZPSSGN CKZPSTBN CKZPSTSN CKZPSTS1
    CKZPSTS2 CKZRPT   CKZZCOMM CKZZDB2  CKZZLOG  CKZZMASK CKZZOBJX
    CKZZPIN  CKZZPTRN CKZZRAND CKZ00500 CKZ00501 CKZ00502 CKZ00505
    CKZ00506 CKZ00510 CKZ00520 CKZ00526 CKZ00527 CKZ00528 CKZ00529
    CKZ00530 CKZ00532 CKZ00533 CKZ00534 CKZ00535 CKZ00536 CKZ00537
    CKZ00538 CKZ00539 CKZ00540 CKZ00541 CKZ00542 CKZ00544 CKZ00545
    CKZ00546 CKZ00547 CKZ00548 CKZ00549 CKZ00550 CKZ00551 CKZ00552
    CKZ00553 CKZ00554 CKZ00555 CKZ00556 CKZ00560 CKZ00561 CKZ00562
    CKZ00563 CKZ00564 CKZ00565 CKZ00566 CKZ00569 CKZ00573 CKZ00600
    CKZ00602 CKZ00610 CKZ00611 CKZ00612 CKZ00613 CKZ00616 CKZ00619
    CKZ00624 CKZ00625 CKZ00626 CKZ00633 CKZ00634 CKZ00635 CKZ00636
    CKZ00637 CKZ00638 CKZ00643 CKZ00647 CKZ00648 CKZ00650 CKZ00651
    CKZ00656 CKZ00657 CKZ00658 CKZ00659 CKZ00669 CKZ00670 CKZ00671
    CKZ00672 CKZ00673 CKZ00674 CKZ00675 CKZ00676 CKZ00677 CKZ00680
    CKZ00709 CKZ00710 CKZ00711 CKZ00712 CKZ00713 CKZ00714 CKZ00715
    CKZ00716 CKZ00717 CKZ00718 CKZ00719 CKZ00720 CKZ00721 CKZ00724
    CKZ00725 CKZ00726 CKZ00733 CKZ00734 CKZ00735 CKZ00736 CKZ00737
    CKZ00738 CKZ00743 CKZ00747 CKZ00748 CKZ00750 CKZ00751 CKZ00756
    CKZ00757 CKZ00758 CKZ00759 CKZ00760 CKZ00761 CKZ00764 CKZ00765
    CKZ00767 CKZ00768 CKZ00769 CKZ00770 CKZ00773 CKZ00775 CKZ00776
    CKZ00777 CKZ00780 CKZ00781 CKZ00782 CKZ00960 CKZ00980 CKZ00981
    CKZ00982 CKZ00990 CKZ00991 CKZ00992 CKZ00993 CKZ1SETC CKZ1TSET
    CKZ2ADFN CKZ2ADRD CKZ2ASMB CKZ2BCLC CKZ2BDCJ CKZ2BLSJ CKZ2CLON
    CKZ2CMND CKZ2CMPN CKZ2COCP CKZ2COMM CKZ2CRDS CKZ2CTCP CKZ2CULC
    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 CKZ2LMIF CKZ2LSTS CKZ2MAIN
    CKZ2MEPL CKZ2MIFN CKZ2MRVR CKZ2MSTF CKZ2MTMB CKZ2NPPR CKZ2OMRC
    CKZ2OPTS CKZ2PDAC CKZ2PDBL CKZ2PJCI CKZ2PLAP CKZ2PLDC CKZ2PMDC
    CKZ2PRDM CKZ2PRFL CKZ2PRIM CKZ2PRML CKZ2PROF CKZ2PZPI CKZ2RTSC
    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 CKZ2SUTL 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
    CKZ5ABUF CKZ5ACUR CKZ5AEXS CKZ5AFLE CKZ5AREC CKZ5AREP CKZ5ASYS
    CKZ5BBIN CKZ5BINT CKZ5BLOG CKZ5BPST CKZ5BVCH CKZ5CLSR CKZ5CMAP
    CKZ5CONT CKZ5RDLL CKZ5STMP CKZ5TIME CKZ5TIMP CKZ5UTIL CKZ6ADLL
    CKZ6BCPR CKZ6BLST CKZ6BOCL CKZ6BPDD CKZ6BPRM CKZ6BSSC CKZ6BSSP
    CKZ6BTCL CKZ6BTSS CKZ6CCF  CKZ6DACL CKZ6DDFL CKZ6DMLS CKZ6EMLS
    CKZ6FIXC CKZ6GRPR CKZ6HLLS CKZ6HLQS CKZ6ICFL CKZ6IGNR CKZ6IPRM
    CKZ6JBCD CKZ6JTLS CKZ6LDLS CKZ6MAIN CKZ6MDLS CKZ6OMRC CKZ6OPDD
    CKZ6OTLS CKZ6PAPI CKZ6PDLS CKZ6RENM CKZ6RPDD CKZ6SCPR CKZ6SMSL
    CKZ6SPDD CKZ6SPRM CKZ6SQLC CKZ6SSMS CKZ6SSPL CKZ6SSPR CKZ6STGL
    CKZ6STPC CKZ6STRT CKZ6TCPR CKZ6TPDD CKZ6TPRM CKZ6TVLS CKZ6UDDS
    CKZ6UPDC CKZ6UXCL CKZ6VALF CKZ6VPLS CKZ6VRFY CKZ6WEMS CKZ7ADLL
    CKZ7DBCF CKZ7LAPI CKZ7MAIN CKZ7MSGS CKZ7PRMF CKZ7REV  CKZ7STRU
    CKZ7SYSU CKZ8CFCR CKZ8CMDB CKZ8CMDE CKZ8CMDI CKZ8EXCB CKZ8LOGS
    CKZ8MAIN CKZ8PRSR CKZ8TOOL CKZ8UTIL HCKZ320
    

Fix information

  • Fixed component name

    DB2 CLONING TOO

  • Fixed component ID

    5655N1000

Applicable component levels

  • R320 PSY UI51684

       UP17/11/09 P F711

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:
02 December 2017