IBM Support

PH53548: SUBSYSTEM CLONING IS NOT PROCESSED DEPENDENCIES ON INDEXES DURING DB2SCHEMA-UPDATE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Subsystem cloning is not processed dependencies on indexes
    during DB2SCHEMA-UPDATE Problem Description: When some objects
    (such as functions and procedures) depend on indexes that are to
    be renamed by DB2SCHEMA-UPDATE, but do not depend on any other
    objects that will have their schema updated, DROP and CREATE DDL
    are not generated for those objects.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS           *
    ****************************************************************
    * PROBLEM DESCRIPTION: When some objects (such as functions    *
    *                      and procedures) depend on indexes that  *
    *                      are to be renamed by DB2SCHEMA-UPDATE,  *
    *                      but do not depend on any other objects  *
    *                      that will have their schema updated,    *
    *                      DROP and CREATE DDL are not generated   *
    *                      for those objects                       *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    When some objects (such as functions and procedures) depend on
    indexes that are to be renamed by DB2SCHEMA-UPDATE, but do not
    depend on any other objects that will have their schema updated,
    DROP and CREATE DDL are not generated for those objects
    

Problem conclusion

  • Apply the PTF
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH53548

  • 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-03-28

  • Closed date

    2023-03-31

  • Last modified date

    2023-05-03

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

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

    UI91221

Modules/Macros

  • CKZ$$PRM CKZ00281 CKZ00992 CKZBDKS  CKZBDKT  CKZBSP   CKZBSS
    CKZBTS   CKZCAL9C CKZCALNC CKZCAQ1C CKZCAQNC 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 CKZCSN9C CKZCSNNC CKZCSP9C CKZCSPNC
    CKZCSQ1C CKZCSQ9C CKZCSQNC CKZCTB0C CKZCTB1C CKZCTB2C CKZCTB9C
    CKZCTBNC CKZCTC0C CKZCTR0C CKZCTR9C CKZCTRNC CKZCTS0C CKZCTS2C
    CKZCTS9C CKZCTSNC CKZCVA1C CKZCVANC CKZCVT0C CKZCVT9C CKZCVTNC
    CKZCXANC CKZCXT9C CKZDBIND CKZDBNDD CKZDBNDI CKZFCD02 CKZFCEXP
    CKZFCFTC CKZFGNAL CKZFGNAQ CKZFGNCL CKZFGNCT CKZFGNDB CKZFGNDT
    CKZFGNIX CKZFGNPK CKZFGNPL CKZFGNRL CKZFGNRO CKZFGNRT CKZFGNSG
    CKZFGNSN CKZFGNSQ CKZFGNTB CKZFGNTC CKZFGNTR CKZFGNTS CKZFGNVA
    CKZFGNVT CKZFGNXT CKZFNORM CKZFOBJT CKZPF5
    

Fix information

  • Fixed component name

    DB2 CLONING TOO

  • Fixed component ID

    5655N1000

Applicable component levels

  • R320 PSY UI91221

       UP23/04/04 P F304

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:
03 May 2023