PH35776: DB2 CLONING TOOL - 3.2 APRIL PTF

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Release Goals / Success Criteria:
  Goal 1
      Goal 2
      Goal N...
  3. Application cloning does not generate CREATE DDL for MQTs in
  implicit table spaces after they were dropped during
  RECREATE-OBJECTS processing
  4. The simplified ISPF interface generates source jobs that end
  with CKZB426E errors when individual partitions are included in
  LISTDEF
  5. Sample subsystem cloning BIND JCL for Db2 v12 in the CKZDBNDC
  member of the SCKZJCL library contains JCL comments that
  prematurely terminate the contents of SYSTSIN DD
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS           *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Subsystem cloning DB2SCHEMA-UPDATE   *
  *                      processing might truncate text of SQL   *
  *                      stored procedures                       *
  *                      2. Application cloning might generate   *
  *                      CREATE DDL statements for dependent     *
  *                      stored procedures in the incorrect      *
  *                      order                                   *
  *                      3. Application cloning does not         *
  *                      generate CREATE DDL for MQTs in         *
  *                      implicit table spaces after they were   *
  *                      dropped during RECREATE-OBJECTS         *
  *                      processing                              *
  *                      4. The simplified ISPF interface        *
  *                      generates source jobs that end with     *
  *                      CKZB426E errors when individual         *
  *                      partitions are included in LISTDEF      *
  *                      5. Sample subsystem cloning BIND JCL    *
  *                      for Db2 v12 in the CKZDBNDC member      *
  *                      of the SCKZJCL library contains JCL     *
  *                      comments that prematurely terminate     *
  *                      the contents of SYSTSIN DD              *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  1. Subsystem cloning DB2SCHEMA-UPDATE processing might truncate
  text of SQL stored procedures
  2. Application cloning might generate CREATE DDL statements for
  dependent stored procedures in the incorrect order
  3. Application cloning does not generate CREATE DDL for MQTs in
  implicit table spaces after they were dropped during
  RECREATE-OBJECTS processing
  4. The simplified ISPF interface generates source jobs that end
  with CKZB426E errors when individual partitions are included in
  LISTDEF
  5. Sample subsystem cloning BIND JCL for Db2 v12 in the CKZDBNDC
  member of the SCKZJCL library contains JCL comments that
  prematurely terminate the contents of SYSTSIN DD
  

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:

  UI75063

Modules/Macros

• CKZ00    CKZ00671 CKZ00992 CKZ1ACTI CKZ1COPC CKZ1PLDC CKZ1SOBJ
  CKZ1TCOP CKZ2BDCJ CKZ2ETCP CKZ2FTSJ CKZ2PLDC CKZ2SJCL CKZ2SSTS
  CKZ2TCOP CKZ2TJCL CKZ2TSCP CKZ2TSET CKZ43    CKZ59    CKZ6ADLL
  CKZ6LDLS CKZ6MAIN CKZCAL9C CKZCALNC CKZCAQ1C CKZCAQNC CKZCAT01
  CKZCATM  CKZCATMO CKZCCT9C CKZCCTNC CKZCDB9C CKZCDPNC CKZCDT0C
  CKZCDT1C CKZCDT9C CKZCDTNC CKZCFN0C CKZCFN9C CKZCFNNC CKZCHECK
  CKZCIX0C CKZCIX2C CKZCIX9C CKZCIXNC CKZCMT0C CKZCMTNC CKZCPK0C
  CKZCPK1C CKZCPK9C CKZCPKNC CKZCPL0C CKZCPL1C CKZCPL9C CKZCPLNC
  CKZCRL2C CKZCRL9C CKZCRO9C CKZCRTNC CKZCSG9C CKZCSN9C CKZCSNNC
  CKZCSP9C CKZCSPNC CKZCSQ1C CKZCSQ9C CKZCSQNC CKZCTB0C CKZCTB1C
  CKZCTB2C CKZCTB9C CKZCTBNC CKZCTC0C CKZCTR0C CKZCTR9C CKZCTRNC
  CKZCTS0C CKZCTS2C CKZCTS9C CKZCTSNC CKZCVA1C CKZCVANC CKZCVT0C
  CKZCVT9C CKZCVTNC CKZCXANC CKZCXT9C CKZDBNDC CKZDOCID CKZEADLL
  CKZEMAIN CKZETS2O CKZETSCP CKZF2STR CKZFATTR CKZFBASE CKZFCD02
  CKZFCEXP CKZFCFTC CKZFGNAL CKZFGNAQ CKZFGNCL CKZFGNCT CKZFGNDB
  CKZFGNDT CKZFGNIX CKZFGNPK CKZFGNPL CKZFGNRL CKZFGNRO CKZFGNRT
  CKZFGNSG CKZFGNSN CKZFGNSQ CKZFGNTB CKZFGNTC CKZFGNTR CKZFGNTS
  CKZFGNVA CKZFGNVT CKZFGNXT CKZFNORM CKZFOBJT CKZFOBJZ CKZFPDBG
  CKZH437I CKZH504I CKZH571I CKZH594I CKZHACTI CKZHCOPC CKZHPLDC
  CKZHSOBJ CKZHTCOP CKZINCID CKZWACAO CKZWACPR CKZWACSP CKZWACTI
  CKZWBLAC CKZWDB2  CKZWMSID CKZWPRAL CKZWSOBJ CKZWSTTM
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI75063

     UP21/04/27 P F104

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.