PH38335: DB2 CLONING TOOL - 3.2 JULY PTF

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This release contains the following bug fixes:
  1. Application cloning DDL generation and the subsystem cloning
  DB2SCHEMA-UPDATE command generate incorrect SET CURRENT SCHEMA
  statements for SQL objects that reference unqualified objects in
  their SQL
  2. Application cloning DDL generation does not generate the
  COMPRESS keyword for tables in implicit table spaces
  3. Various errors in application cloning and the subsystem
  cloning DB2SCHEMA-UPDATE command due to incorrect handling of
  variant characters in object names and SQL when a Db2 subsystem
  has a non-USA code set specified as the default EBCDIC CCSID in
  the application default parameters module
  4. Application cloning source and target jobs do not print
  CKZB259I messages with real-time statistics copy module
  parameters during RTS processing
  5. When an SQL error occurs during the subsystem cloning
  DB2SCHEMA-UPDATE processing, the job might end with S0C4 abend
  when printing diagnostic information
  6. The classic ISPF interface does not replace &CKZJOBN with an
  auto-generated job name when generating JCL for table space
  cloning jobs
  7. Application cloning DDL generation and subsystem cloning
  DB2SCHEMA-UPDATE command do not translate the contents of the
  QUALIFIER attribute for stored procedures
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS           *
  ****************************************************************
  * PROBLEM DESCRIPTION: 1. Application cloning DDL generation   *
  *                      and the subsystem cloning               *
  *                      DB2SCHEMA-UPDATE command generate       *
  *                      incorrect SET CURRENT SCHEMA statements *
  *                      for SQL objects that reference          *
  *                      unqualified objects in their SQL        *
  *                      2. Application cloning DDL generation   *
  *                      does not generate the COMPRESS keyword  *
  *                      for tables in implicit table spaces     *
  *                      3. Various errors in application        *
  *                      cloning and the subsystem cloning       *
  *                      DB2SCHEMA-UPDATE command due to         *
  *                      incorrect handling of variant           *
  *                      characters in object names and SQL      *
  *                      when a Db2 subsystem has a non-USA code *
  *                      set specified as the default EBCDIC     *
  *                      CCSID in the application default        *
  *                      parameters module                       *
  *                      4. Application cloning source and       *
  *                      target jobs do not print CKZB259I       *
  *                      messages with real-time statistics copy *
  *                      module parameters during RTS processing *
  *                      5. When an SQL error occurs during the  *
  *                      subsystem cloning DB2SCHEMA-UPDATE      *
  *                      processing, the job might end with S0C4 *
  *                      abend when printing diagnostic          *
  *                      information                             *
  *                      6. The classic ISPF interface does not  *
  *                      replace &CKZJOBN with an auto-generated *
  *                      job name when generating JCL for table  *
  *                      space cloning jobs                      *
  *                      7. Application cloning DDL generation   *
  *                      and subsystem cloning DB2SCHEMA-UPDATE  *
  *                      command do not translate the            *
  *                      contents of the QUALIFIER attribute for *
  *                      stored procedures                       *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF                                *
  ****************************************************************
  1. Application cloning DDL generation and the subsystem cloning
  DB2SCHEMA-UPDATE command generate incorrect SET CURRENT SCHEMA
  statements for SQL objects that reference unqualified objects in
  their SQL
  2. Application cloning DDL generation does not generate the
  COMPRESS keyword for tables in implicit table spaces
  3. Various errors in application cloning and the subsystem
  cloning DB2SCHEMA-UPDATE command due to incorrect handling of
  variant characters in object names and SQL when a Db2 subsystem
  has a non-USA code set specified as the default EBCDIC CCSID in
  the application default parameters module
  4. Application cloning source and target jobs do not print
  CKZB259I messages with real-time statistics copy module
  parameters during RTS processing
  5. When an SQL error occurs during the subsystem cloning
  DB2SCHEMA-UPDATE processing, the job might end with S0C4 abend
  when printing diagnostic information
  6. The classic ISPF interface does not replace &CKZJOBN with
  an auto-generated job name when generating JCL for table space
  cloning jobs
  7. Application cloning DDL generation and subsystem cloning
  DB2SCHEMA-UPDATE command do not translate the contents of the
  QUALIFIER attribute for stored procedures
  

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:

  UI76344

Modules/Macros

• CKZ$$PRM CKZ00283 CKZ00992 CKZ00993 CKZ00996 CKZ1CLON CKZ1HNDL
  CKZ1JCLG CKZ1JPRT CKZ1PARM CKZ1PPRF CKZ2TJCL CKZBAKS  CKZBAKT
  CKZBALS  CKZBALT  CKZBBKS  CKZBBKT  CKZBBLS  CKZBBLT  CKZBCKS
  CKZBCKT  CKZBCLS  CKZBCLT  CKZBPT   CKZBSP   CKZBSS   CKZBTS
  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 CKZCPARM CKZCPK0C CKZCPK1C
  CKZCPK9C CKZCPKNC CKZCPL0C CKZCPL1C CKZCPL9C CKZCPLNC CKZCRL2C
  CKZCRL9C CKZCRO9C CKZCRTNC CKZCSG9C CKZCSGVA 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 CKZDBIND CKZDBNDA CKZDBNDB
  CKZDBNDC CKZDBNDI CKZDOCID CKZF2STR CKZFATTR CKZFBASE CKZFCD02
  CKZFCEXP CKZFCFTC CKZFCONN CKZFCSTL CKZFDBGP CKZFEXPR CKZFFDCM
  CKZFFLST CKZFGNAL CKZFGNAQ CKZFGNCL CKZFGNCT CKZFGNDB CKZFGNDT
  CKZFGNIX CKZFGNPK CKZFGNPL CKZFGNRL CKZFGNRO CKZFGNRT CKZFGNSG
  CKZFGNSN CKZFGNSQ CKZFGNTB CKZFGNTC CKZFGNTR CKZFGNTS CKZFGNVA
  CKZFGNVT CKZFGNXT CKZFLOG2 CKZFLST2 CKZFMETL CKZFNORM CKZFOBJT
  CKZFOBJZ CKZFPDBG CKZFRTSI CKZFRTSM CKZFRTST CKZFSQLE CKZFUTIL
  CKZGSIX2 CKZGSIXN CKZGSLSN CKZGSSGN CKZGSTBN CKZGSTS1 CKZGSTS2
  CKZGSTSN CKZINCID CKZMSSG  CKZPF5   CKZPSIX2 CKZPSIXN CKZPSLSN
  CKZPSSGN CKZPSTBN CKZPSTS1 CKZPSTS2 CKZPSTSN CKZUTIL
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI76344

     UP21/07/19 P F107

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.