IBM Support

PH41578: DDL EXECUTION FAILS ON POSITIVE SQL CODES

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When executing the generated DDL, some (if not all) positive SQL
    codes need to be ignored.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS           *
    ****************************************************************
    * PROBLEM DESCRIPTION: Application cloning PROCESS-DDL option  *
    *                      and subsystem cloning DB2SCHEMA-UPDATE  *
    *                      command fail on positive SQL codes      *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    Application cloning PROCESS-DDL option and subsystem cloning
    DB2SCHEMA-UPDATE command fail on positive SQL codes
    

Problem conclusion

  • Apply the PTF
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH41578

  • 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

    2021-10-26

  • Closed date

    2022-03-15

  • Last modified date

    2022-04-01

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

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

Modules/Macros

  • CKZ$$PRM CKZ00047 CKZ00100 CKZ00110 CKZ00111 CKZ00112 CKZ00113
    CKZ00114 CKZ00115 CKZ00116 CKZ00117 CKZ00130 CKZ00135 CKZ00136
    CKZ00140 CKZ00141 CKZ00143 CKZ00150 CKZ00151 CKZ00280 CKZ00281
    CKZ00282 CKZ00283 CKZ00400 CKZ00500 CKZ00501 CKZ00502 CKZ00505
    CKZ00506 CKZ00510 CKZ00520 CKZ00524 CKZ00525 CKZ00526 CKZ00527
    CKZ00528 CKZ00529 CKZ00530 CKZ00532 CKZ00533 CKZ00534 CKZ00535
    CKZ00536 CKZ00537 CKZ00538 CKZ00539 CKZ00540 CKZ00541 CKZ00542
    CKZ00543 CKZ00544 CKZ00545 CKZ00546 CKZ00547 CKZ00548 CKZ00549
    CKZ00550 CKZ00551 CKZ00552 CKZ00553 CKZ00554 CKZ00555 CKZ00556
    CKZ00560 CKZ00561 CKZ00562 CKZ00563 CKZ00564 CKZ00565 CKZ00566
    CKZ00567 CKZ00569 CKZ00573 CKZ00574 CKZ00575 CKZ00600 CKZ00602
    CKZ00610 CKZ00611 CKZ00612 CKZ00613 CKZ00619 CKZ00620 CKZ00621
    CKZ00622 CKZ00624 CKZ00631 CKZ00640 CKZ00669 CKZ00670 CKZ00671
    CKZ00672 CKZ00674 CKZ00677 CKZ00680 CKZ00708 CKZ00709 CKZ00710
    CKZ00711 CKZ00713 CKZ00714 CKZ00715 CKZ00716 CKZ00717 CKZ00718
    CKZ00720 CKZ00721 CKZ00722 CKZ00723 CKZ00760 CKZ00761 CKZ00764
    CKZ00765 CKZ00766 CKZ00768 CKZ00769 CKZ00780 CKZ00781 CKZ00782
    CKZ00965 CKZ00980 CKZ00981 CKZ00984 CKZ00985 CKZ1ACAI CKZ1ACAO
    CKZ1ACAU CKZ1ACAW CKZ1ACSO CKZ1SETC CKZ1SSSC CKZ1SSSS CKZ1TSET
    CKZ2ADRD CKZ2BCLC CKZ2BDCJ CKZ2BLSJ CKZ2CLCM CKZ2CLON CKZ2CMND
    CKZ2CMPN CKZ2COCP CKZ2COMM CKZ2CTCP CKZ2CULC CKZ2DAPS CKZ2DB2A
    CKZ2DBSS CKZ2DCCC CKZ2DCCH CKZ2DCRN CKZ2DDAT CKZ2DEFD CKZ2DFIX
    CKZ2DREN CKZ2DRFD CKZ2DSAP CKZ2DSCJ CKZ2DSCL CKZ2DSCN CKZ2DSCP
    CKZ2DSCS CKZ2DSQL CKZ2DSTP CKZ2DTCP CKZ2DTCS CKZ2EDAC CKZ2EDCV
    CKZ2EDDF CKZ2EDDL CKZ2EDDS CKZ2ELDC CKZ2EMCS CKZ2EMDC CKZ2ESCP
    CKZ2ETCP CKZ2FPXX CKZ2FTSJ CKZ2GFSJ CKZ2GVAR CKZ2IVPL CKZ2JSKL
    CKZ2LACR CKZ2LAOP CKZ2LSTS CKZ2MAIN CKZ2MEPL CKZ2MSTF CKZ2MTMB
    CKZ2NPPR CKZ2OMRC CKZ2PDAC CKZ2PDBL CKZ2PJCI CKZ2PLAP CKZ2PLDC
    CKZ2PMDC CKZ2PRDM CKZ2PRFL CKZ2PRIM CKZ2PRME CKZ2PZPI CKZ2RTSC
    CKZ2SASV CKZ2SBCI CKZ2SCLT CKZ2SFRJ CKZ2SFSJ CKZ2SFTJ CKZ2SIDL
    CKZ2SJCI CKZ2SJCL CKZ2SJTS CKZ2SJTV CKZ2SKL  CKZ2SOMT CKZ2SOPR
    CKZ2SPCC CKZ2SPRF CKZ2SRNM CKZ2SRSV CKZ2SSCP CKZ2SSDS CKZ2SSID
    CKZ2SSLB CKZ2SSMC CKZ2SSSC CKZ2SSSJ CKZ2SSTM CKZ2SSTN CKZ2SSTS
    CKZ2SSTT CKZ2SSTV CKZ2STSS CKZ2TCOP CKZ2TDDC CKZ2TDDF CKZ2TDSP
    CKZ2TJCL CKZ2TRCF CKZ2TSCI CKZ2TSCP CKZ2TSET CKZ2TTRN CKZ2ULCL
    

Fix information

  • Fixed component name

    DB2 CLONING TOO

  • Fixed component ID

    5655N1000

Applicable component levels

  • R320 PSY UI79745

       UP22/03/16 P F203

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.

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

Document Information

Modified date:
02 April 2022