IBM Support

PH15193: DB2 CLONING TOOL - 3.2 SEPTEMBER 2019 PTF

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • This release includes the following bug fixes:
    1. TCP/IP connection issue
    2. Error during the cloning of PBG table spaces using
    UNLOAD/LOAD when the target has more partitions than the source
    3. Performance improvements for UTS processing in the target job
    4. Error during UNLOAD/LOAD processing of MQTs
    5. Error in the process that excludes incompatible objects
    6. Error in the UNLOAD/LOAD report
    7. Incorrect target catalog name when
    TARGET-UCATS-ON-TARGET-VOLUMES(Y) is used
    8. RECORD X'00' of the target catalog residing on target volume
    can have incorrect length after cloning
    9 Hash-organized target objects are unavailable after cloning
    10. ISPF UI should use DISP=SHR for the allocation DD during
    generation of LISTDEF and JCL jobs
    11. Cursor should not jump to the next field after filling out
    the SSID on the CKZ1CRDS ISPF panel
    12. Miscellaneous Log Apply bug fixes
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS           *
    ****************************************************************
    * PROBLEM DESCRIPTION: Abend S522 in source job can occur if   *
    *                      more than one client job has connection *
    *                      with TCP/IP server job/started task.    *
    *                                                              *
    *                      Using commands on partitions that do    *
    *                      not exist at the target during the      *
    *                      cloning partition-by-growth table       *
    *                      spaces using UNLOAD/LOAD when target    *
    *                      has more partitions than source.        *
    *                                                              *
    *                      Performance improvements for page sets  *
    *                      processing in target job.               *
    *                                                              *
    *                      Error during UNLOAD/LOAD processing of  *
    *                      MQT.                                    *
    *                                                              *
    *                      Error in exclude process of             *
    *                      incompatible objects when UNLOAD/LOAD   *
    *                      is enabled.                             *
    *                                                              *
    *                      Errors in LOAD subtasks cause end of    *
    *                      Db2 Cloning Tool without LOAD status    *
    *                      report.                                 *
    *                                                              *
    *                      Incorrect target catalog name when      *
    *                      TARGET-UCATS-ON-TARGET-VOLUMES(Y) is    *
    *                      used and the source catalog name on     *
    *                      source volume is shorter than paired    *
    *                      target catalog name on target volume.   *
    *                                                              *
    *                      Record X'00' of the target catalog      *
    *                      residing on target volume can have      *
    *                      incorrect length when                   *
    *                      TARGET-UCATS-ON-TARGET-VOLUMES(Y) is    *
    *                      used.                                   *
    *                                                              *
    *                      Access to hash-organized target objects *
    *                      after Application cloning may end with  *
    *                      S04E abend and reason code 00C90101.    *
    *                                                              *
    *                      If the source job is running and ISPF   *
    *                      interface generates LISTDEF or JCL job  *
    *                      in the same data set then CKZ325E error *
    *                      occurs.                                 *
    *                                                              *
    *                      Cursor should not jump to the next      *
    *                      field after filling out the Db2 SSID in *
    *                      the CKZ1CRDS panel.                     *
    *                                                              *
    *                      Wrong END_POINT is set for quiesced     *
    *                      member of data sharing group which Db2  *
    *                      version is differs from active members  *
    *                      version, that may cause S878 abend      *
    *                      during log reading execution.           *
    ****************************************************************
    * RECOMMENDATION: Apply the PTF                                *
    ****************************************************************
    .
    

Problem conclusion

  • Apply the PTF
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH15193

  • 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

    2019-08-01

  • Closed date

    2019-09-26

  • Last modified date

    2019-10-01

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

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

    UI65536

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#AUTO CKZ#BIND CKZ#CARD CKZ#CHKR CKZ#CL   CKZ#CL64
    CKZ#CL7  CKZ#CL8  CKZ#CLLS CKZ#CMTS CKZ#CN64 CKZ#CNTL CKZ#CNVT
    CKZ#CPM  CKZ#CPNT CKZ#CPOL CKZ#DB2V CKZ#DCAT CKZ#DSAF CKZ#DSPL
    CKZ#DSQL CKZ#DYNL 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#INIT 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#JU64
    CKZ#JUST CKZ#LGAA CKZ#LGAC CKZ#LGAF CKZ#LGAI CKZ#LGAP CKZ#LGRN
    CKZ#LIKE CKZ#LOGR CKZ#LRD6 CKZ#MAIN CKZ#MDRV CKZ#MLOG CKZ#MMGR
    CKZ#MPRI CKZ#MREP CKZ#MTIO CKZ#OPRI CKZ#OS   CKZ#OUT2 CKZ#PARS
    CKZ#PRNG CKZ#QCAT CKZ#QSAM CKZ#RANG CKZ#RCAT CKZ#REPO CKZ#RESM
    CKZ#RH   CKZ#RH10 CKZ#RM24 CKZ#RPRP CKZ#RUNT CKZ#SQL2 CKZ#SQLC
    CKZ#STAT CKZ#STCK CKZ#STMT CKZ#SUBD CKZ#SUBS CKZ#SUBX CKZ#SYSC
    CKZ#TB   CKZ#TB7  CKZ#TB8  CKZ#TP   CKZ#TP10 CKZ#TSS  CKZ#TSSA
    CKZ#TUTL CKZ#UCBS CKZ#UPRI CKZ#UTLB CKZ#UTLC CKZ#UTLS CKZ#UTOP
    CKZ#VERS CKZ#VSA1 CKZ#VSA2 CKZ#VSAM CKZ#WRIT CKZ#XMLD CKZ#XMLJ
    CKZ#XMLS CKZ$ACCS 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$MEPL CKZ$PRFD CKZ$PRFR
    CKZ$SMSG CKZ$SPRM CKZ$SQL2 CKZ$SQLC CKZ$SSCT CKZ$TOK  CKZ$TSOC
    CKZ$ZPAR CKZ00111 CKZ00112 CKZ00113 CKZ00143 CKZ00500 CKZ00501
    CKZ00502 CKZ00505 CKZ00506 CKZ00510 CKZ00520 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 CKZ00616 CKZ00619
    CKZ00620 CKZ00621 CKZ00622 CKZ00624 CKZ00631 CKZ00640 CKZ00669
    CKZ00670 CKZ00671 CKZ00672 CKZ00674 CKZ00677 CKZ00680 CKZ00708
    CKZ00709 CKZ00710 CKZ00711 CKZ00713 CKZ00714 CKZ00715 CKZ00716
    

Fix information

  • Fixed component name

    DB2 CLONING TOO

  • Fixed component ID

    5655N1000

Applicable component levels

  • R320 PSY UI65536

       UP19/09/28 P F909

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:
30 March 2021