IBM Support

PH66368: APPLICATION CLONING DOES NOT GENERATE DDL FOR SOME UNIQUE WHERE NOT NULL INDEXES.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Application cloning does not generate CREATE DDL statements for
    indexes that are defined on tables in implicit table spaces.
    

Local fix

  • N/A
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS.          *
    ****************************************************************
    * PROBLEM DESCRIPTION: Application cloning does not generate   *
    *                      CREATE DDL statements for UNIQUE WHERE  *
    *                      NOT NULL indexes that are defined on    *
    *                      tables in implicit table spaces.        *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF.                               *
    ****************************************************************
    Application cloning does not generate CREATE DDL statements for
    UNIQUE WHERE NOT NULL indexes that are defined on tables in
    implicit table spaces.
    

Problem conclusion

  • Apply the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH66368

  • 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

    2025-05-01

  • Closed date

    2025-05-29

  • Last modified date

    2025-05-31

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

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

    UO03435

Modules/Macros

  • CKZ#A001 CKZ#ACIR CKZ#ACIW CKZ#ACON CKZ#ACRD CKZ#ACUP CKZ#ADIS
    CKZ#ADSC CKZ#AEXT CKZ#AFMT CKZ#AFRR CKZ#ALLO CKZ#AMIN CKZ#ASYS
    CKZ#AUMX CKZ#BIND CKZ#CARD CKZ#CHKR CKZ#CL64 CKZ#CLLS CKZ#CMTS
    CKZ#CN64 CKZ#CNTL CKZ#CNVT CKZ#CPNT CKZ#CPOL CKZ#DSAF CKZ#DSPL
    CKZ#DYNL CKZ#ENCR CKZ#ENQS CKZ#ENVF CKZ#FCPY CKZ#ICAI CKZ#ICAL
    CKZ#ICCC CKZ#ICCI CKZ#IDCF CKZ#IDSA CKZ#IERR CKZ#IHSA CKZ#IKPL
    CKZ#IKPN CKZ#ILGP CKZ#ILRA CKZ#ILRS CKZ#ILSA CKZ#INIT CKZ#IPIE
    CKZ#IPPB CKZ#IPPC CKZ#IPPD CKZ#IPPH CKZ#IPPL CKZ#IPPN CKZ#IPPS
    CKZ#IRPL CKZ#ISNA CKZ#JU64 CKZ#JUST CKZ#LGAA CKZ#LGAC CKZ#LGAF
    CKZ#LGAI CKZ#LGAP CKZ#LOGR CKZ#LRD6 CKZ#MAIN CKZ#MDRV CKZ#MLOG
    CKZ#MMGR CKZ#MREP CKZ#MTIO CKZ#NREC CKZ#OS   CKZ#PRNG CKZ#QSAM
    CKZ#RANG CKZ#RPRP CKZ#RUNT CKZ#SQL2 CKZ#SQLC CKZ#STAT CKZ#STCK
    CKZ#STMT CKZ#SUBD CKZ#SUBS CKZ#SUBX CKZ#SYSC CKZ#TUTL CKZ#UTLB
    CKZ#UTLC CKZ#UTLS CKZ#VERS CKZ#VSM  CKZ#WRIT CKZ#XMLI CKZ#XMLJ
    CKZ#XMLS CKZ$$PRM CKZ$ACCS CKZ$BOOT CKZ$CAF  CKZ$CAFA CKZ$ESTA
    CKZ$INFO CKZ$SPRM CKZ$SQL2 CKZ$SQLC CKZ$SSCT CKZ$TOK  CKZ$TSOC
    CKZ$ZPAR CKZ00136 CKZ00547 CKZ3MEPI CKZ3MEPL CKZ@CAF  CKZ@CAFA
    CKZ@CAFW CKZ@TOK  CKZAPOST CKZBDKS  CKZBDKT  CKZBLNKT CKZCAPST
    CKZCOMAT CKZDAREA CKZDBIND CKZDBNDD CKZDBNDI CKZDYNAL CKZFTRT
    CKZHEXT  CKZHLI2  CKZIENQS CKZLGRD  CKZLINKL CKZLVALT CKZMMGR
    CKZMSRT  CKZNBLKT CKZNNUMT CKZPARET CKZPERIT CKZS99   CKZSRT64
    CKZSV26R CKZSVC26 CKZTOKEN CKZWDB2  CKZXAS31 CKZXAS64 CKZXASMS
    CKZXASPR CKZXDDM  CKZXEXPM CKZXPDS  CKZXUTLS CKZZPEXT
    

Fix information

  • Fixed component name

    DB2 CLONING TOO

  • Fixed component ID

    5655N1000

Applicable component levels

  • R320 PSY UO03435

       UP25/05/31 I 1000

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:
31 May 2025