IBM Support

PH35552: DB2 CLONING TOOL - 3.2 MARCH PTF

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Release Goals / Success Criteria:
    Goal 1
        Goal 2
        Goal N...
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS           *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1. Application cloning source job and   *
    *                         subsystem cloning DB2SCHEMA-UPDATE   *
    *                         command generate incorrect DDL when  *
    *                         run on a Db2 subsystem that has a    *
    *                         non-USA code set specified as the    *
    *                         default EBCDIC CCSID in the          *
    *                         application default parameters       *
    *                         module                               *
    *                      2. Application cloning source or target *
    *                         job terminates when UNLOAD/LOAD call *
    *                         ends with RC=4 regardless of         *
    *                         MAX-COPY-RC setting                  *
    *                      3. Application cloning excludes from    *
    *                         the cloning stopped target spaces in *
    *                         AREO* status when DDL processing is  *
    *                         enabled                              *
    *                      4. Application cloning should not allow *
    *                         UNLOAD/LOAD processing for objects   *
    *                         with system-period data versioning   *
    *                      5. When application cloning excludes a  *
    *                         table a in multi-table table space   *
    *                         from the cloning due to a mismatch,  *
    *                         it does not exclude objects related  *
    *                         to other tables in the same table    *
    *                         space                                *
    *                      6. When application cloning COPY        *
    *                        keyword TARGET-PREFETCH-DATABASE-LIST *
    *                         contains more than 1000 entries, the *
    *                         source job might end with CKZ64001E  *
    *                         error                                *
    *                      7. Application cloning does not reset   *
    *                         LZDHBIGVERS in dictionary pages for  *
    *                         objects with extended RBA/LRSN       *
    *                         format                               *
    *                      8. In certain cases, the contents of    *
    *                         message CKZ71613E can be corrupted   *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    1. Application cloning source job and subsystem cloning
       DB2SCHEMA-UPDATE command generate incorrect DDL when run on a
       Db2 subsystem that has a non-USA code set specified as the
       default EBCDIC CCSID in the application default parameters
       module
    2. Application cloning source or target job terminates when
       UNLOAD/LOAD call ends with RC=4 regardless of MAX-COPY-RC
       setting
    3. Application cloning excludes from the cloning stopped target
       spaces in AREO* status when DDL processing is enabled
    4. Application cloning should not allow UNLOAD/LOAD processing
       for objects with system-period data versioning
    5. When application cloning excludes a table in a multi-table
       Table space from the cloning due to a mismatch, it does not
       exclude objects related to other tables in the same table
       space
    6. When application cloning COPY keyword
       TARGET-PREFETCH-DATABASE-LIST contains more than 1000
       entries, the source job might end with CKZ64001E error
    7. Application cloning does not reset LZDHBIGVERS in dictionary
       pages for objects with extended RBA/LRSN format
    8. In certain cases, the contents of message CKZ71613E can be
       corrupted
    

Problem conclusion

  • Apply the PTF
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH35552

  • 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

    2021-03-19

  • Closed date

    2021-03-31

  • Last modified date

    2021-05-03

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

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

    UI74696

Modules/Macros

  • CKZ00501 CKZ00510 CKZ00520 CKZ00537 CKZ00540 CKZ00541 CKZ00542
    CKZ00543 CKZ00544 CKZ00545 CKZ00546 CKZ00547 CKZ00548 CKZ00549
    CKZ00550 CKZ00551 CKZ00553 CKZ00554 CKZ00555 CKZ00556 CKZ00560
    CKZ00562 CKZ00564 CKZ00569 CKZ00575 CKZ00600 CKZ00611 CKZ00612
    CKZ00613 CKZ00619 CKZ00620 CKZ00621 CKZ00622 CKZ00624 CKZ00631
    CKZ00640 CKZ00670 CKZ00671 CKZ00674 CKZ00677 CKZ00708 CKZ00709
    CKZ00711 CKZ00713 CKZ00714 CKZ00715 CKZ00716 CKZ00717 CKZ00718
    CKZ00720 CKZ00721 CKZ00722 CKZ00723 CKZ00760 CKZ00761 CKZ00764
    CKZ00765 CKZ00766 CKZ00769 CKZ00780 CKZ00781 CKZ00782 CKZ00984
    CKZ00995 CKZ1JCLG CKZ1JPRT CKZBAKS  CKZBAKT  CKZBALS  CKZBALT
    CKZBBKS  CKZBBKT  CKZBBLS  CKZBBLT  CKZBCKS  CKZBCKT  CKZBCLS
    CKZBCLT  CKZBPT   CKZBSP   CKZBSS   CKZBTS   CKZDBIND CKZDBNDA
    CKZDBNDB CKZDBNDC CKZDBNDI CKZDEFSP CKZPF5   CKZPPMM  CKZPPMSG
    CKZPPPG  CKZPPPSV
    

Fix information

  • Fixed component name

    DB2 CLONING TOO

  • Fixed component ID

    5655N1000

Applicable component levels

  • R320 PSY UI74696

       UP21/04/02 P F104

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.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2.0"}]

Document Information

Modified date:
04 May 2021