IBM Support

PH68593: DB2 CLONING TOOL MIGHT GENERATE DDL WITH INCORRECT OBJECT OWNER

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • In some cases, the application cloning DDL generator and the
    subsystem cloning DB2SCHEMA-UPDATE command might omit required
    SET SQLID statements. This can result in database objects being
    created with an incorrect owner.
    

Local fix

  • You can execute DB2SCHEMA-UPDATE with EXECUTE-CREATE-DDL(N).
    Then CURRENT SCHEMA should be replaced manually to SET CURRENT
    SQLID + SET CURRENT SCHEMA statements in CREATE-DDL-DDN.
    Then manually execute DDL from the edited data set.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS.          *
    ****************************************************************
    * PROBLEM DESCRIPTION: In some cases, the application cloning  *
    *                      DDL generator and the subsystem cloning *
    *                      DB2SCHEMA-UPDATE command might omit     *
    *                      required SET SQLID statements. This can *
    *                      result in database objects being        *
    *                      created with an incorrect owner.        *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF.                               *
    ****************************************************************
     In some cases, the application cloning DDL generator and the
    subsystem cloning DB2SCHEMA-UPDATE command might omit required
    SET SQLID statements. This can result in database objects being
    created with an incorrect owner.
    

Problem conclusion

  • Apply the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH68593

  • 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-10-20

  • Closed date

    2025-11-24

  • Last modified date

    2025-11-30

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

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

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$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
    CKZ3MEPI CKZ3MEPL CKZ@CAF  CKZ@CAFA CKZ@CAFW CKZ@TOK  CKZAPOST
    CKZBLNKT CKZCAPST CKZCOMAT CKZDAREA CKZDYNAL CKZFCD02 CKZFTRT
    CKZHEXT  CKZHLI2  CKZIENQS CKZLGRD  CKZLINKL CKZLVALT CKZMMGR
    CKZMSRT  CKZNBLKT CKZNNUMT CKZPARET CKZPERIT CKZPPPSV CKZS99
    CKZSRT64 CKZSV26R CKZSVC26 CKZTOKEN 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 UO05939

       UP25/11/26 P F511

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:
30 November 2025