IBM Support

PH23774: DB2 CLONING TOOL - 3.2 APRIL PTF

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • This release includes the following bug fixes:
    1. The Db2 subsystem cloning RENAME-MASK keyword of the
    COPY-BY-DS command cannot rename more than the high level
    qualifier of data sets
    2. The Db2 application cloning target job hangs when RTS copy is
    enabled and all objects are processed by UNLOAD/LOAD utilities
    3. Db2 application cloning can incorrectly match indexes after
    the creation of non-existent target indexes by DDL generation
    4. The classic ISPF UI generates an incomplete source TCP/IP job
    when the list of cloning comments is empty
    5. The Db2 application cloning has a multitasking issue in
    DSNUTILV detection code
    6. The Db2 subsystem cloning COPY-BY-DS command does not use the
    SPACE_MANAGEMENT value from PARMLIB for migrated volsers
    7. The CKZ06522E error message can occur in the COPY-BY-DS
    command when exclude masks exclude many data sets
    8. The S0C4 abend can occur in the COPY-BY-DS command in
    simulate mode when there are many migrated data sets
    9. The CKZ06556E error message can occur in the COPY-BY-DS
    command
    10. In Db2 application cloning, when log apply is used, an
    infinite loop might occur if the DATA-SHARING-MEMBERS keyword is
    not specified
    11. Db2 application cloning does not start an object in RW
    status if an object is in RO status and it will be processed
    with LOAD or REBUILD utility
    12. Db2 application cloning PARMLIB Y/N options can be
    overridden by product defaults
    13. Db2 application cloning generates DDL for tables created in
    implicit table spaces when RECREATE-OBJECTS(M) is specified but
    target and source objects do not have mismatches
    14. Classic ISPF interface does not handle some options for
    generating the cloning JCL jobs if the data set name is enclosed
    in quotes
    15. Warning message such as 'CKZ76604W Subtask 01, CKZPG005W No
    translation rule for HPG1OBID X'0006' on page X'00000000'' can
    occur when processing Db2 clone objects
    16. Update logic for remote connect type verification in ISPF
    interface and export/import batch utility
    17. Replace CKZ54629W warning message with CKZ54629I
    informational message in Db2 application cloning
    18. An implicitly created source table space can be paired to an
    incorrect target table space with the same name
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS           *
    ****************************************************************
    * PROBLEM DESCRIPTION: The Db2 subsystem cloning RENAME-MASK   *
    *                      keyword of the COPY-BY-DS command       *
    *                      cannot rename more than the high level  *
    *                      qualifier of data sets                  *
    *                                                              *
    *                      The Db2 application cloning target job  *
    *                      hangs when RTS copy is enabled and all  *
    *                      objects are processed by UNLOAD/LOAD    *
    *                      utilities                               *
    *                                                              *
    *                      Db2 application cloning can incorrectly *
    *                      match indexes after the creation of     *
    *                      non-existent target indexes by DDL      *
    *                      generation                              *
    *                                                              *
    *                      The classic ISPF UI generates an        *
    *                      incomplete source TCP/IP job when the   *
    *                      list of cloning comments is empty       *
    *                                                              *
    *                      The Db2 application cloning has a       *
    *                      multitasking issue in DSNUTILV          *
    *                      detection code                          *
    *                                                              *
    *                      The Db2 subsystem cloning COPY-BY-DS    *
    *                      command does not use the                *
    *                      SPACE_MANAGEMENT value from PARMLIB     *
    *                      for migrated volsers                    *
    *                                                              *
    *                      The CKZ06522E error message can occur   *
    *                      in the COPY-BY-DS command when exclude  *
    *                      masks exclude many data sets            *
    *                                                              *
    *                      The S0C4 abend can occur in the         *
    *                      COPY-BY-DS command in simulate mode     *
    *                      when there are many migrated data sets  *
    *                                                              *
    *                      The CKZ06556E error message can occur   *
    *                      in the COPY-BY-DS command               *
    *                                                              *
    *                      In Db2 application cloning, when log    *
    *                      apply is used, an infinite loop might   *
    *                      occur if the DATA-SHARING-MEMBERS       *
    *                      keyword is not specified                *
    *                                                              *
    *                      Db2 application cloning does not start  *
    *                      an object in RW status if an object is  *
    *                      in RO status and it will be processed   *
    *                      with LOAD or REBUILD utility            *
    *                                                              *
    *                      Db2 application cloning PARMLIB Y/N     *
    *                      options can be overridden by product    *
    *                      defaults                                *
    *                                                              *
    *                      Db2 application cloning generates DDL   *
    *                      for tables created in implicit table    *
    *                      spaces when RECREATE-OBJECTS(M) is      *
    *                      specified but target and source objects *
    *                      do not have mismatches                  *
    *                                                              *
    *                      Classic ISPF interface does not handle  *
    *                      some options for generating the cloning *
    *                      JCL jobs if the data set name is        *
    *                      enclosed in quotes                      *
    *                                                              *
    *                      Warning message such as 'CKZ76604W      *
    *                      Subtask 01, CKZPG005W No translation    *
    *                      rule for HPG1OBID X'0006' on page       *
    *                      X'00000000'' can occur when             *
    *                      processing Db2 clone objects            *
    *                                                              *
    *                      Update logic for remote connect type    *
    *                      verification in ISPF interface and      *
    *                      export/import batch utility             *
    *                                                              *
    *                      Replace CKZ54629W warning message with  *
    *                      CKZ54629I informational message in Db2  *
    *                      application cloning                     *
    *                                                              *
    *                      An implicitly created source table      *
    *                      space can be paired to an incorrect     *
    *                      target table space with the same name   *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF.                               *
    ****************************************************************
    .
    

Problem conclusion

  • Apply the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH23774

  • 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

    2020-03-26

  • Closed date

    2020-04-24

  • Last modified date

    2020-05-02

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

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

    UI69181

Modules/Macros

  • CKZ00046 CKZ00065 CKZ00066 CKZ00221 CKZ00480 CKZ00500 CKZ00501
    CKZ00505 CKZ00506 CKZ00510 CKZ00520 CKZ00525 CKZ00526 CKZ00527
    CKZ00528 CKZ00529 CKZ00530 CKZ00532 CKZ00533 CKZ00534 CKZ00535
    CKZ00536 CKZ00537 CKZ00538 CKZ00539 CKZ00540 CKZ00541 CKZ00542
    CKZ00543 CKZ00544 CKZ00545 CKZ00546 CKZ00547 CKZ00548 CKZ00549
    CKZ00550 CKZ00551 CKZ00552 CKZ00553 CKZ00554 CKZ00555 CKZ00556
    CKZ00560 CKZ00561 CKZ00562 CKZ00563 CKZ00564 CKZ00565 CKZ00566
    CKZ00567 CKZ00569 CKZ00573 CKZ00574 CKZ00575 CKZ00600 CKZ00602
    CKZ00610 CKZ00611 CKZ00612 CKZ00613 CKZ00619 CKZ00620 CKZ00621
    CKZ00622 CKZ00624 CKZ00631 CKZ00640 CKZ00669 CKZ00670 CKZ00671
    CKZ00672 CKZ00674 CKZ00677 CKZ00680 CKZ00708 CKZ00709 CKZ00710
    CKZ00711 CKZ00713 CKZ00714 CKZ00715 CKZ00716 CKZ00717 CKZ00718
    CKZ00720 CKZ00721 CKZ00722 CKZ00723 CKZ00760 CKZ00761 CKZ00764
    CKZ00765 CKZ00766 CKZ00768 CKZ00769 CKZ00780 CKZ00781 CKZ00782
    CKZ00980 CKZ00981 CKZ00984 CKZ00995 CKZ2CLCM CKZ2CMPN CKZ2COCP
    CKZ2CTCP CKZ2CULC CKZ2DCCC CKZ2DRFD CKZ2DSCJ CKZ2EDAC CKZ2EDDF
    CKZ2ESCP CKZ2ETCP CKZ2GFSJ CKZ2PLAP CKZ2PLDC CKZ2PRFL CKZ2SJCL
    CKZ2SJTV CKZ2SSLB CKZ2STSS CKZ2TCOP CKZ2TJCL CKZ2TSCI CKZ2TSET
    CKZ2VRFY CKZ50    CKZH500I CKZHACCO CKZHSETC CKZJOBT1 CKZJOBT3
    CKZJOBT6 CKZJOBT7 CKZJOBT8 CKZPPMM  CKZPPMSG CKZPPPG  CKZPPPSV
    CKZWACCO CKZWACSP CKZWBLAC CKZWCLCM CKZWCMPN CKZWDACD CKZWDB2
    CKZWDDFA CKZWEDDS CKZWJTVR CKZWLAOP CKZWMCLP CKZWMDDF CKZWPDBL
    CKZWPRIM CKZWTJCL CKZWTSCI CKZWVRFY
    

Fix information

  • Fixed component name

    DB2 CLONING TOO

  • Fixed component ID

    5655N1000

Applicable component levels

  • R320 PSY UI69181

       UP20/04/25 P F004

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:
30 March 2021