IBM Support

PI50046: ROLL UP APAR FOR TABLE SPACE CLONING POST GA

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • This roll up APAR resolves the following issues:
    1. EXTEND-TARGET-PBG-TABLESPACE copies to an F0001 dataset.
    2. Target job issues CKZ00123E and return code 4 when
       processing XML pages.
    3. ABEND S04E in Target Job Log Apply processing.
    4. DDL error when there is no entry in SYSTABCONST catalog
       table for a primary key.
    6. DDL timestamp may be due to improperly formatted limitkey.
    7. DDL created for indexes on MQT tables without tables being
       created
    8. LOBs are incorrectly identified as simple table spaces in
       warning messages.
    9. Invalid START-TIME for target log apply when running in V11
       ENFM or V11 CM environments.
    10. Panel CKZ1GFSJ displays an erroneous message when
        REBUILD-INDEX-EXECUTE "YES" is specified.
    11. CKZ410I - DATA-MOVER PGM was changed to "SRCIMCPY".
        Therefore the following values of keywords were set:
        LA-ENABLE(Y), FUZZY-COPY(Y), DATA-MASKING(N), SIM(N),
        SUBTASK-DATASET-EXTENSIONS(N), USE-RUNTIME-REPOSITORY(N).
    12. ISPF UI: add more details to a prompt description.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Cloning Tool z/OS.              *
    ****************************************************************
    * PROBLEM DESCRIPTION: This roll up APAR resolves the          *
    *                      following issues:                       *
    *                      1. EXTEND-TARGET-PBG-TABLESPACE copies  *
    *                       to an F0001 dataset.                   *
    *                      2. Target job issues CKZ00123E and      *
    *                       return code 4 when processing XML      *
    *                       pages.                                 *
    *                      3. ABEND S04E in Target Job.            *
    *                      4. DDL error when there is no entry in  *
    *                       SYSTABCONST catalog table for a        *
    *                       primary key.                           *
    *                      5. target DDL failed with SQLCODE =     *
    *                       -104 when the DECIMAL POINT is         *
    *                       different between source and target.   *
    *                      5. DDL not found when specifying        *
    *                       prefetch and PROCESS-TYPE(A).          *
    *                      7. DB2 V11 Exploitation Support -       *
    *                       outstanding testing issues.            *
    *                      8. Support needed for partitioned       *
    *                       cloned tables.                         *
    *                      9. DDL: SQLCODE = -204, ERROR:          *
    *                       AATRGD.XFHST1IH IS AN UNDEFINED NAME.  *
    *                      10. DDL: SQLCODE = -904, ERROR:         *
    *                       UNSUCCESSFUL EXECUTION CAUSED BY       *
    *                       ANUNAVAILABLE.                         *
    *                      11. CKZ54437W Index                     *
    *                       BASRC1.XFHASPAB_#_ZVE in List          *
    *                       TESTLIST.01 has Specified a PARTLEVEL  *
    *                       3 that Exceeds the Number of           *
    *                       Partitions.                            *
    *                      12. CKZ78101E Input Template DD         *
    *                       CKIDD003, Unknown Variable Detected,   *
    *                       &&VARNAME0.                            *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI50046

  • Reported component name

    DB2 CLONING TOO

  • Reported component ID

    5655N1000

  • Reported release

    320

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2015-10-06

  • Closed date

    2015-12-11

  • Last modified date

    2016-01-04

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

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

    UI33738

Modules/Macros

  •    CKZ$ACES CKZ$BDSN CKZ$BMSG CKZ$BOOT CKZ$BUTJ
    CKZ$CAF  CKZ$CAFA CKZ$CALL CKZ$CTCM CKZ$DCMD CKZ$DCVT CKZ$ERR
    CKZ$ESTA CKZ$GSKB CKZ$INFO CKZ$LOG  CKZ$PRFD CKZ$PRFR CKZ$SMSG
    CKZ$SPRM CKZ$SQLC CKZ$SQL2 CKZ$TOK  CKZ$TSOC CKZ$ZPAR CKZ#AMIN
    CKZ#ASYS CKZ#CARD CKZ#CHKR CKZ#CL   CKZ#CL64 CKZ#CL7  CKZ#CL8
    CKZ#CMET CKZ#CNTL CKZ#CNVT CKZ#CN64 CKZ#CPM  CKZ#CPNT CKZ#CPOL
    CKZ#DB2V CKZ#DCAT CKZ#DSAF CKZ#DSPL CKZ#DSQL CKZ#ENQS CKZ#ENVF
    CKZ#EPRI CKZ#FCPY CKZ#HTAB 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#IOPF CKZ#IPIE CKZ#IPPB CKZ#IPPC
    CKZ#IPPD CKZ#IPPH CKZ#IPPL CKZ#IPPN CKZ#IPPS CKZ#IRPL CKZ#ISNA
    CKZ#JPRI CKZ#JUST CKZ#JU64 CKZ#LGAA CKZ#LGAC CKZ#LGAF CKZ#LGAI
    CKZ#LGAP CKZ#LGRN CKZ#LIKE CKZ#LOGR CKZ#LRDR CKZ#LRD6 CKZ#MAIN
    CKZ#MLOG CKZ#MPRI CKZ#MREP CKZ#OPRI CKZ#OUT2 CKZ#PARS CKZ#PRNG
    CKZ#QCAT CKZ#RANG CKZ#RCAT CKZ#REPO CKZ#RESM CKZ#RM24 CKZ#RPRP
    CKZ#RUNT CKZ#SQLC CKZ#SQL2 CKZ#STAT CKZ#STCK CKZ#STMT CKZ#SUBD
    CKZ#SUBS CKZ#SUBX CKZ#SYSC CKZ#TB   CKZ#TB7  CKZ#TB8  CKZ#TSS
    CKZ#TSSA CKZ#UCBS CKZ#UPRI CKZ#UTLB CKZ#UTLC CKZ#UTOP CKZ#VSAM
    CKZ#VSA1 CKZ#VSA2 CKZ#WRIT CKZ#XMLD CKZ#XMLS CKZ@CAF  CKZ@CAFA
    CKZ@CAFW CKZ@CNUM CKZ@COLS CKZ@CSCR CKZ@DBC  CKZ@DSN  CKZ@DSQL
    CKZ@EXP1 CKZ@FIX1 CKZ@FORM CKZ@LOGR CKZ@ORD1 CKZ@REM1 CKZ@RES1
    CKZ@ROLB CKZ@SCCM CKZ@SCGT CKZ@SCIT CKZ@SCPT CKZ@SCRL CKZ@SCR1
    CKZ@SFND CKZ@SIZ1 CKZ@SMSG CKZ@SQLD CKZ@SRT1 CKZ@SSET CKZ@SSRT
    CKZ@TOK  CKZ@USRT CKZALLZT CKZAPOST CKZASML  CKZBLNKT CKZCAPST
    CKZCD002 CKZCHART CKZCNVTP CKZCOMAT CKZDAREA CKZDBC   CKZDBCA
    CKZDBCH  CKZDBCX  CKZDBHP  CKZDDLAL CKZDDLAQ CKZDDLCT CKZDDLDB
    CKZDDLDT CKZDDLIX CKZDDLPK CKZDDLPL CKZDDLRL CKZDDLRO CKZDDLRT
    CKZDDLSG CKZDDLSN CKZDDLSQ CKZDDLTB CKZDDLTR CKZDDLTS CKZDDLVA
    CKZDDLVT CKZDDLXT CKZDGRP  CKZDGRPS CKZDOTT  CKZDYNAL CKZFASM
    CKZFCOMM CKZFDB2  CKZFILTR CKZFLOG  CKZFMASK CKZFOBJX CKZFPIN
    CKZFPMIB CKZFPSDP CKZFPTRN CKZFRAND CKZFTRT  CKZGDBGP CKZGDIBI
    CKZGDIBP CKZGFDCM CKZGFLST CKZGLOG2 CKZGLOG3 CKZGLST2 CKZGMETL
    CKZGOBJT CKZGOBJZ CKZGPDBG CKZGUTIL CKZHCOPC CKZHEXT  CKZHLI
    CKZHLI2  CKZHSETC CKZHSSSC CKZHSSSS CKZHTCOP CKZHTSET CKZHVOBT
    CKZH410I CKZH432E CKZIALI  CKZIDB2C CKZIDCAM CKZIENQS CKZIEXCP
    CKZIGIDX CKZIGRS  CKZIHFP  CKZIHLI2 CKZIICW2 CKZIIDPH CKZIIKS
    CKZIIKSA CKZILOCK CKZIMAIN CKZIMSGS CKZIMUTX CKZINCRD CKZIPAGE
    CKZIPROT CKZIPSRW CKZIRBLT CKZIROWK CKZISMPR CKZISORT CKZISOR1
    CKZISOR2 CKZISOR3 CKZISOR5 CKZISTDB CKZISYSP CKZITHRD CKZIUCB
    CKZIUTLB CKZIVSAD CKZIVSAM CKZIVSAS CKZIXCON CKZIXDEC CKZIXIND
    CKZIXMAT CKZIXMLR CKZIXNOD CKZIXREC CKZLINKL CKZLOGR  CKZLVALT
    CKZMMIF  CKZMSRT  CKZNBLKT CKZNNUMT CKZNORMT CKZPARET CKZPERIT
    CKZRDPDS CKZRPART CKZSLIP  CKZSLST  CKZSRT64 CKZSVC26 CKZS99
    CKZTOKEN CKZUNICN CKZUNIGT CKZZCOMM CKZZDB2  CKZZLOG  CKZZMASK
    CKZZOBJX CKZZPEXT CKZZPIN  CKZZPTRN CKZZRAND CKZ00500 CKZ00501
    CKZ00510 CKZ00527 CKZ00535 CKZ00536 CKZ00540 CKZ00541 CKZ00544
    CKZ00545 CKZ00546 CKZ00547 CKZ00549 CKZ00554 CKZ00560 CKZ00562
    CKZ00600 CKZ00611 CKZ00612 CKZ00635 CKZ00638 CKZ00644 CKZ00645
    CKZ00646 CKZ00647 CKZ00648 CKZ00669 CKZ00671 CKZ00674 CKZ00710
    CKZ00712 CKZ00714 CKZ00715 CKZ00717 CKZ00735 CKZ00738 CKZ00745
    CKZ00746 CKZ00747 CKZ00748 CKZ00760 CKZ00763 CKZ00764 CKZ00765
    CKZ00767 CKZ00768 CKZ00769 CKZ00780 CKZ00782 CKZ00980 CKZ00982
    CKZ00990 CKZ00991 CKZ00992 CKZ1COPC CKZ1DCCH CKZ1DCHC CKZ1DFIX
    CKZ1DSTP CKZ1PFIX CKZ1PSTP CKZ1PSTT CKZ1SETC CKZ1SSSC CKZ1SSSS
    CKZ1SSTT CKZ1TCOP CKZ1TSET CKZ1VOBT CKZ10CMD CKZ2ADRD CKZ2BCLC
    CKZ2BDCJ CKZ2CLON CKZ2CMND CKZ2CMPN CKZ2COCP CKZ2COMM CKZ2CRDS
    CKZ2CTCP CKZ2DALV CKZ2DAPS CKZ2DBSS CKZ2DB2A CKZ2DCCC CKZ2DCCH
    CKZ2DCRN CKZ2DDAT CKZ2DEFD CKZ2DFIX CKZ2DREN CKZ2DRFD CKZ2DSAP
    CKZ2DSCJ CKZ2DSCL CKZ2DSCN CKZ2DSCP CKZ2DSCR CKZ2DSCS CKZ2DSQL
    CKZ2DSTP CKZ2DTCP CKZ2DTCS CKZ2EDAC CKZ2EDCV CKZ2EDDF CKZ2EDDL
    CKZ2EDDS CKZ2ELDC CKZ2EMCS CKZ2EMDC CKZ2ESCP CKZ2ETCP CKZ2FTSJ
    CKZ2GFSJ CKZ2GVAR CKZ2IVPL CKZ2JSKL CKZ2LAOP CKZ2LSTS CKZ2MAIN
    CKZ2MEPL CKZ2MRVR CKZ2MSTF CKZ2MTMB CKZ2OMRC CKZ2PDAC CKZ2PDBL
    CKZ2PJCI CKZ2PLAP CKZ2PLDC CKZ2PMDC CKZ2PRDM CKZ2PRFL CKZ2PRIM
    CKZ2PZPI 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 CKZ2TSCP CKZ2TSET CKZ2TTRN CKZ2ULCL
    CKZ2USET CKZ2XMOD CKZ4AREP CKZ4ASYS CKZ4PROF CKZ4RDLL CKZ4TPRF
    CKZ41    CKZ43    CKZ7CMD  CKZ8CMD  CKZ9CMD  HCKZ320
    

Fix information

  • Fixed component name

    DB2 CLONING TOO

  • Fixed component ID

    5655N1000

Applicable component levels

  • R320 PSY UI33738

       UP15/12/31 P F512

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

Document Information

Modified date:
12 February 2021