IBM Support

PI60503: PROVIDE USER OPTION TO NOT GENERATE RI IN GENERATED DDL

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Provide user option to NOT create referential constraints in
    generated DDL. They cause an unnecessary need for CHECK DATA.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Cloning Tool z/OS.              *
    ****************************************************************
    * PROBLEM DESCRIPTION: Provide user option to NOT create       *
    *                      referential constraints in generated    *
    *                      DDL. They cause an unnecessary need     *
    *                      for CHECK DATA.                         *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI60503

  • Reported component name

    DB2 CLONING TOO

  • Reported component ID

    5655N1000

  • Reported release

    310

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-04-08

  • Closed date

    2016-04-26

  • Last modified date

    2016-06-16

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

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

    UI37330

Modules/Macros

  •    CKZHCOPC CKZHTCOP CKZ1COPC CKZ1TCOP CKZ2ADFN
    CKZ2ADRD CKZ2BCLC CKZ2BDCJ CKZ2CCDM CKZ2CLON CKZ2CMPN CKZ2COMM
    CKZ2CRDS CKZ2DAAC CKZ2DAPO CKZ2DAPS CKZ2DBSS CKZ2DB2A CKZ2DCCC
    CKZ2DCCH CKZ2DCHC CKZ2DCMS CKZ2DCRN CKZ2DDAT CKZ2DEFD CKZ2DFIX
    CKZ2DREN CKZ2DRFD CKZ2DSCC CKZ2DSCJ CKZ2DSCL CKZ2DSCN CKZ2DSCR
    CKZ2DSCS CKZ2DSQL CKZ2DSTP CKZ2DTCS CKZ2EDAC CKZ2EDCV CKZ2EDDL
    CKZ2EDDN CKZ2EDDS CKZ2ELDC CKZ2EMDC CKZ2ESCP CKZ2ETCP CKZ2EXMS
    CKZ2FTSJ CKZ2GFSJ CKZ2GRPJ CKZ2GSTJ CKZ2GTSJ CKZ2GVAR CKZ2HLQS
    CKZ2IVPL CKZ2MAIN CKZ2MGMS CKZ2MRVR CKZ2MSTF CKZ2MTMB CKZ2OMRC
    CKZ2OPTS CKZ2OUPT CKZ2PARM CKZ2PDAC CKZ2PDBL CKZ2PJCI CKZ2PLAP
    CKZ2PLDC CKZ2PMDC CKZ2PMLG CKZ2PRDM CKZ2PRFS CKZ2PRFT CKZ2PRIM
    CKZ2PROF CKZ2PSRT CKZ2PWRK CKZ2PZPI CKZ2RDDC CKZ2RFDT CKZ2RNMS
    CKZ2SASV CKZ2SBCI CKZ2SCLT CKZ2SCNV CKZ2SDDC CKZ2SFRJ CKZ2SFSJ
    CKZ2SFTJ CKZ2SJCI CKZ2SJTS CKZ2SJTV CKZ2SKL  CKZ2SMSV CKZ2SOMT
    CKZ2SOPR CKZ2SPRF CKZ2SRNM CKZ2SRSV CKZ2SSDC CKZ2SSDS CKZ2SSID
    CKZ2SSLB CKZ2SSMC CKZ2SSSC CKZ2SSSJ CKZ2SSSS CKZ2SSTC CKZ2SSTM
    CKZ2SSTN CKZ2SSTS CKZ2SSTT CKZ2SSTV CKZ2STDM CKZ2STDS CKZ2STMB
    CKZ2STMS CKZ2STRG CKZ2STSS CKZ2STVP CKZ2TCOP CKZ2TDDC CKZ2TDDF
    CKZ2TDSP CKZ2TJCL CKZ2TSCI CKZ2TSET CKZ2TTRN CKZ2TYPS CKZ2ULCL
    CKZ2USET CKZ2WLEM CKZ2XMOD CKZ4AREP CKZ4ASYS CKZ4PROF CKZ4RDLL
    CKZ4REPT CKZ4TPRF
    

Fix information

  • Fixed component name

    DB2 CLONING TOO

  • Fixed component ID

    5655N1000

Applicable component levels

  • R310 PSY UI37330

       UP16/05/04 P F605

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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAUUE","label":"IBM Db2 Cloning Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.1.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
12 February 2021