PH03681: DB2 CLONING TOOL

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This release includes the following fixes:
  1. Reduce memory usage when copying statistics during table
  space cloning (PH02819)
  2. Always generate ALTER SEQUENCE RESTART WITH SQL for
  user-defined sequences (PH03043)
  3. CHECK-DATASET-COMPATIBILITY fails during IDCAMS LISTCAT
  processing when source has more partitions than target (PH03044)
  4. Source job ends with S378 ABEND during target catalog
  prefetch processing if CAF or DDF connection is used and
  target prefetch database list is not specified (PH03091)
  5. DDL can be generated with the wrong values for decimal
  data type on a Db2 subsystem with
  BIF_COMPATIBILITY=V9_DECIMAL_VARCHAR (PH03262)
  6. Partitioned table spaces are not started in the target
  job if SUBTASK-DATASET-EXTENSION(Y) is specified with
  AUTO-START-TARGET-SPACE(Y) (PH03377)
  7. Db2 Cloning Tool installation verification process
  (PH03430)
  8. The bind scripts for Db2 version 12 must include the DBRM
  modules for both Db2 version 12 and version 11 (PH03611)
  9. Fix behavior of ALTER ADD PARTITION for partition-by-growth
  table spaces
  10. SQLCODE = -010 for generated XML pattern
  11. Getting 0C4 abend while copying on the same
  SSID with RCTYP=T/D
  12. Target job output should provide more information about
  JCLs, generated for XML DOCID updates
  13. Possible CKZ24621E SQL EXEC IMM FAILED, SQLCODE: -204
  when procedure has low case characters in its attributes
  14. Issue a warning message during simulation run if there
  are tables with identity columns and PROCESS-DDL-DDN is not
  specified
  15. Print more information if DSNUTILB cannot be attached
  16. Miscellaneous fixes for Log Apply component
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Cloning Tool z/OS.          *
  ****************************************************************
  * PROBLEM DESCRIPTION: This release includes the following     *
  *                      fixes:                                  *
  *                      1. Reduce memory usage when copying     *
  *                      statistics during table space cloning   *
  *                      (PH02819)                               *
  *                      2. Always generate ALTER SEQUENCE       *
  *                      RESTART WITH SQL for user-defined       *
  *                      sequences (PH03043)                     *
  *                      3. CHECK-DATASET-COMPATIBILITY fails    *
  *                      during IDCAMS LISTCAT processing when   *
  *                      source has more partitions than target  *
  *                      (PH03044)                               *
  *                      4. Source job ends with S378 ABEND      *
  *                      during target catalog prefetch          *
  *                      processing if CAF or DDF connection is  *
  *                      used and target prefetch database list  *
  *                      is not specified (PH03091)              *
  *                      5. DDL can be generated with the wrong  *
  *                      values for decimal data type on a Db2   *
  *                      subsystem with                          *
  *                      BIF_COMPATIBILITY=V9_DECIMAL_VARCHAR    *
  *                      (PH03262)                               *
  *                      6. Partitioned table spaces are not     *
  *                      started in the target job if            *
  *                      SUBTASK-DATASET-EXTENSION(Y) is         *
  *                      specified with                          *
  *                      AUTO-START-TARGET-SPACE(Y) (PH03377)    *
  *                      7. Db2 Cloning Tool installation        *
  *                      verification process (PH03430)          *
  *                      8. The bind scripts for Db2 version 12  *
  *                      must include the DBRM modules for both  *
  *                      Db2 version 12 and version 11 (PH03611) *
  *                      9. Fix behavior of ALTER ADD PARTITION  *
  *                      for partition-by-growth table spaces    *
  *                      10. SQLCODE = -010 for generated XML    *
  *                      pattern                                 *
  *                      11. Getting 0C4 abend while copying on  *
  *                      the same SSID with RCTYP=T/D            *
  *                      12. Target job output should provide    *
  *                      more information about JCLs, generated  *
  *                      for XML DOCID updates                   *
  *                      13. Possible CKZ24621E SQL EXEC IMM     *
  *                      FAILED, SQLCODE: -204 when procedure    *
  *                      has low case characters in its          *
  *                      attributes                              *
  *                      14. Issue a warning message during      *
  *                      simulation run if there are tables      *
  *                      with identity columns and               *
  *                      PROCESS-DDL-DDN is not specified        *
  *                      15. Print more information if DSNUTILB  *
  *                      cannot be attached                      *
  *                      16. Miscellaneous fixes for Log Apply   *
  *                      component                               *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

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

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

  UI59086

Modules/Macros

•    CKZ$$PRM CKZ$$SEQ CKZ$BDSN CKZ#AMIN CKZ#ASYS
  CKZ#CARD CKZ#CHKR CKZ#CNTL CKZ#DSPL CKZ#ENQS CKZ#FCPY CKZ#ICAL
  CKZ#IKPL CKZ#IPPB CKZ#IPPH CKZ#IPPN CKZ#IRPL CKZ#LGAA CKZ#LGAC
  CKZ#LGAF CKZ#LGAI CKZ#LGAP CKZ#LOGR CKZ#LRDR CKZ#LRD6 CKZ#MAIN
  CKZ#MLOG CKZ#RANG CKZ#RPRP CKZ#RUNT CKZ#SUBD CKZ#SYSC CKZ#WRIT
  CKZ#XMLS CKZ@SCRL CKZBCKS  CKZBCKT  CKZBSS   CKZBTD   CKZBTS
  CKZCALNC CKZCAL9C CKZCAQNC CKZCAQ1C CKZCATM  CKZCATMO CKZCAT01
  CKZCCTNC CKZCCT9C CKZCDB9C CKZCDPNC CKZCDTNC CKZCDT0C CKZCDT1C
  CKZCDT9C CKZCFNNC CKZCFN0C CKZCFN9C CKZCHECK CKZCIXNC CKZCIX0C
  CKZCIX2C CKZCIX9C CKZCMTNC CKZCMT0C CKZCPKNC CKZCPK0C CKZCPK1C
  CKZ00560 CKZ00561 CKZ00562 CKZ00563 CKZ00564 CKZ00565 CKZ00566
  CKZ00567 CKZ00569 CKZ00573 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 CKZ00717 CKZ00718
  CKZ00720 CKZ00721 CKZ00722 CKZ00723 CKZ00760 CKZ00761 CKZ00764
  CKZ00765 CKZ00768 CKZ00769 CKZ00780 CKZ00781 CKZ00782 CKZ00960
  CKZ00980 CKZ00981 CKZ00984 CKZ00992 CKZ00996 CKZ3MEPI CKZ3MEPL
  HCKZ320
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI59086

     UP18/10/16 P F810

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.