IBM Support

PH58159: SEVERAL INTERNAL BUGS ARE FIXED.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • 1.Application cloning target job might end with RC=8 and
    SQLCODE = -803 when writing RTS
    2.Application cloning DDL generator creates statements that
      result in SQLCODE=-4743 on Db2 subsystems with APPLCOMPAT
      V12R1M100 3. Application cloning
    3.Application cloning target job does not start spaces that had
      warnings during page processing.
    4.Subsystem cloning DB2UPDATE command might issue CKZ22153W
      when the source Db2 has been converted from data sharing
      to non-data sharing
    5.When application cloning source job with
      USE-RUNTIME-REPOSITORY(Y) schedules several parts of an
      index for REBUILD, the target job might with CKZ55105E error
    6.When a blank value is specified for the application cloning
      keyword IGNORE-SQL-WARNINGS, an empty list of SQL warning
      codes is used instead of the default list of SQL warnings
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS           *
    ****************************************************************
    * PROBLEM DESCRIPTION: The following internal bugs were fixed: *
    *                      1. Application cloning target job might *
    *                      end with RC=8 and SQLCODE = -803 when   *
    *                      writing RTS                             *
    *                      2. Application cloning DDL generator    *
    *                      creates statements that result in       *
    *                      SQLCODE=-4743 on Db2 subsystems with    *
    *                      APPLCOMPAT V12R1M100                    *
    *                      3. Application cloning target job does  *
    *                      not start spaces that had warnings      *
    *                      during page processing                  *
    *                      4. Subsystem cloning DB2UPDATE command  *
    *                      might issue CKZ22153W when the source   *
    *                      Db2 has been converted from data        *
    *                      sharing to non-data sharing             *
    *                      5. When application cloning source job  *
    *                      with USE-RUNTIME-REPOSITORY(Y)          *
    *                      schedules several parts of an index for *
    *                      REBUILD, the target job might end with  *
    *                      CKZ55105E error                         *
    *                      6. When a blank value is specified for  *
    *                      the application cloning keyword         *
    *                      IGNORE-SQL-WARNINGS, an empty list of   *
    *                      SQL warning codes is used instead of    *
    *                      the default list of SQL warnings        *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    1. Application cloning target job might end with RC=8 and
    SQLCODE = -803 when writing RTS
    2. Application cloning DDL generator creates statements that
    result in SQLCODE=-4743 on Db2 subsystems with APPLCOMPAT
    V12R1M100
    3. Application cloning target job does not start spaces that had
    warnings during page processing
    4. Subsystem cloning DB2UPDATE command might issue CKZ22153W
    when the source Db2 has been converted from data sharing to
    non-data sharing
    5. When application cloning source job with
    USE-RUNTIME-REPOSITORY(Y) schedules several parts of an index
    for REBUILD, the target job might end with CKZ55105E error
    6. When a blank value is specified for the application cloning
    keyword IGNORE-SQL-WARNINGS, an empty list of SQL warning codes
    is used instead of the default list of SQL warnings
    

Problem conclusion

  • Apply the PTF
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH58159

  • 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

    2023-11-13

  • Closed date

    2023-11-16

  • Last modified date

    2023-12-02

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

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

Modules/Macros

  • CKZ00215 CKZ00221 CKZ00241 CKZ00249 CKZ00271 CKZ00501 CKZ00535
    CKZ00544 CKZ00551 CKZ00760 CKZ00992 CKZ00993 CKZ00996 CKZCAL9C
    CKZCALNC CKZCAQ1C CKZCAQNC CKZCAT01 CKZCATM  CKZCATMO CKZCCT9C
    CKZCCTNC CKZCDB9C CKZCDPNC CKZCDT0C CKZCDT1C CKZCDT9C CKZCDTNC
    CKZCFN0C CKZCFN9C CKZCFNNC CKZCHECK CKZCIX0C CKZCIX2C CKZCIX9C
    CKZCIXNC CKZCMT0C CKZCMTNC CKZCPK0C CKZCPK1C CKZCPK9C CKZCPKNC
    CKZCPL0C CKZCPL1C CKZCPL9C CKZCPLNC CKZCRL2C CKZCRL9C CKZCRO9C
    CKZCRTNC CKZCSG9C CKZCSGVA CKZCSN9C CKZCSNNC CKZCSP9C CKZCSPNC
    CKZCSQ1C CKZCSQ9C CKZCSQNC CKZCTB0C CKZCTB1C CKZCTB2C CKZCTB9C
    CKZCTBNC CKZCTC0C CKZCTR0C CKZCTR2C CKZCTR9C CKZCTRNC CKZCTS0C
    CKZCTS2C CKZCTS9C CKZCTSNC CKZCVA1C CKZCVANC CKZCVT0C CKZCVT9C
    CKZCVTNC CKZCXANC CKZCXT9C CKZDOCID CKZF2STR CKZFATTR CKZFBASE
    CKZFCD02 CKZFCEXP CKZFCFTC CKZFCLCT CKZFCONN CKZFCSTL CKZFDBGP
    CKZFEXPR CKZFFDCM CKZFFLST CKZFGNAL CKZFGNAQ CKZFGNCL CKZFGNCT
    CKZFGNDB CKZFGNDT CKZFGNIX CKZFGNPK CKZFGNPL CKZFGNRL CKZFGNRO
    CKZFGNRT CKZFGNSG CKZFGNSN CKZFGNSQ CKZFGNTB CKZFGNTC CKZFGNTR
    CKZFGNTS CKZFGNVA CKZFGNVT CKZFGNXT CKZFLOG2 CKZFLST2 CKZFMETL
    CKZFNORM CKZFOBJT CKZFOBJZ CKZFPDBG CKZFRTSI CKZFRTSM CKZFRTST
    CKZFSQLE CKZFUTIL CKZGSIX2 CKZGSIX3 CKZGSIXN CKZGSLSN CKZGSSGN
    CKZGSTBN CKZGSTS1 CKZGSTS2 CKZGSTS3 CKZGSTSN CKZINCID CKZMSSG
    CKZPSIX2 CKZPSIX3 CKZPSIXN CKZPSLSN CKZPSSGN CKZPSTBN CKZPSTS1
    CKZPSTS2 CKZPSTS3 CKZPSTSN CKZUTIL
    

Fix information

  • Fixed component name

    DB2 CLONING TOO

  • Fixed component ID

    5655N1000

Applicable component levels

  • R320 PSY UI94515

       UP23/11/18 P F311

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":"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","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
04 December 2023