PH21115: DB2 CLONING TOOL - 3.2 FEBRUARY PTF

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This release includes the following bug fixes:
  1. DB2STOP should issue -STOP DB2 command after CKZ26521E for
  -DIS THD
  2. SYSTEM COMPLETION CODE=0C1 REASON CODE=00000001 NAME=CKZ00047
  3. SQL error occurred in ckzcix2c.c on line 980. SQLCODE = 100
  4. Objects with mismatches that can be fixed by DDL generated
  using PROCESS-TYPE(G) are not excluded from the cloning
  5. Message CKZ00037I sometimes does not specify the module name
  6. Create a dependency of RESTRICT-STATUS-VALUES keyword from
  QUIESCE-POINT keyword in the ISPF UI
  7. Remove trailing ';' from SQL text for triggers and views that
  were created in Db2 versions prior to version 10 during DDL
  generation
  8. Add validation of parameters in PPARM and CPARM files in
  stored procedure
  9. CKZ00044I displays incorrect number of page writes
  10. Fix issues with HPGPartNum/HPGCKPT fields during index page
  processing
  11. Always use the ISPF variables on the help panels of new ISPF
  UI
  12. Excluded and unmatched indexes are not started before
  calling REBUILD
  13. Error in DDL RECREATE-OBJECTS processing on DDF connection
  14. Target job with SIM(A) ends with RC=4 and CKZ99094W messages
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS           *
  ****************************************************************
  * PROBLEM DESCRIPTION: DB2STOP should issue -STOP DB2 command  *
  *                      after CKZ26521E for -DIS THD(*)         *
  *                                                              *
  *                      SQL error occurred in ckzcix2c.c on     *
  *                      line 980. SQLCODE = 100                 *
  *                                                              *
  *                      Objects with mismatches that can be     *
  *                      fixed by DDL generated using            *
  *                      PROCESS-TYPE(G) are not excluded from   *
  *                      the cloning                             *
  *                                                              *
  *                      Message CKZ00037I sometimes does not    *
  *                      specify the module name                 *
  *                                                              *
  *                      Create a dependency of                  *
  *                      RESTRICT-STATUS-VALUES keyword from     *
  *                      QUIESCE-POINT keyword in the ISPF UI    *
  *                                                              *
  *                      Remove trailing ';' from SQL text for   *
  *                      triggers and views that were created in *
  *                      Db2 versions prior to version 10 during *
  *                      DDL generation                          *
  *                                                              *
  *                      Add validation of parameters in PPARM   *
  *                      and CPARM files in stored procedure     *
  *                                                              *
  *                      CKZ00044I displays incorrect number of  *
  *                      page writes                             *
  *                                                              *
  *                      Fix issues with HPGPartNum/HPGCKPT      *
  *                      fields during index page processing     *
  *                                                              *
  *                      Always use the ISPF variables on the    *
  *                      help panels of new ISPF UI              *
  *                                                              *
  *                      Excluded and unmatched indexes are not  *
  *                      started before calling REBUILD          *
  *                                                              *
  *                      Error in DDL RECREATE-OBJECTS           *
  *                      processing on DDF connection            *
  *                                                              *
  *                      Target job with SIM(A) ends with RC=4   *
  *                      and CKZ99094W messages                  *
  ****************************************************************
  * RECOMMENDATION: Apply the PTF.                               *
  *                                                              *
  *                 Attention:                                   *
  *                 If the miscellaneous instruction extension   *
  *                 facility 2 is not available and 3.2 2019Q4   *
  *                 PTF UI67229 is installed on machine where    *
  *                 Db2 Cloning Tool is used then users must     *
  *                 apply this PTF to prevent 0C1 abend.         *
  ****************************************************************
  .
  

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:

  UI67958

Modules/Macros

• CKZ00047 CKZ00265 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 CKZ00717 CKZ00718 CKZ00720
  CKZ00721 CKZ00722 CKZ00723 CKZ00760 CKZ00761 CKZ00764 CKZ00765
  CKZ00766 CKZ00768 CKZ00769 CKZ00780 CKZ00781 CKZ00782 CKZ00960
  CKZ00980 CKZ00981 CKZ00984 CKZ00995 CKZ1ACAS CKZ1ACRS CKZ1ATSM
  CKZ1CFUN CKZ1CLOG CKZ1CLON CKZ1EXCP CKZ1HNDL CKZ1INI  CKZ1JCLG
  CKZ1JCLW CKZ1JPRT CKZ1PARM CKZ1PPRF CKZ1SPSS CKZ1STRP CKZ1VACA
  CKZ1VACR CKZ2DAPS CKZ2DSCL CKZ2DSCP CKZ2DTCP CKZ2PRFL CKZ2SRSV
  CKZ2SSCP CKZ2TJCL CKZ2TSCP CKZ4ASYS CKZ4PROF CKZ4RDLL CKZ4TPRF
  CKZ56    CKZ6ADLL CKZ6BCPR CKZ6BLST CKZ6BOCL CKZ6BPDD CKZ6BSSP
  CKZ6BTCL CKZ6BTSS CKZ6DDFL CKZ6FIXC CKZ6GRPR CKZ6HLLS CKZ6ICFL
  CKZ6IPRM CKZ6JBCD CKZ6JTLS CKZ6OMRC CKZ6OPDD CKZ6OTLS CKZ6RPDD
  CKZ6SCPR CKZ6SPDD CKZ6SPRM CKZ6SQLC CKZ6SSPL CKZ6SSPR CKZ6STPC
  CKZ6STRT CKZ6TCPR CKZ6TPDD CKZ6TPRM CKZ6UPDC CKZ6UXCL CKZCIX2C
  CKZCIXNC CKZEADLL CKZECNVR CKZEMAIN CKZESSCP CKZETS2O CKZETSCP
  CKZFNORM CKZH008E CKZH009E CKZH200E CKZH520E CKZH523E CKZH527E
  CKZH529I CKZH540E CKZH541E CKZH544E CKZH551E CKZH560W CKZH700E
  CKZH701E CKZH703S CKZH707E CKZH708E CKZH709E CKZH710E CKZH711E
  CKZH712E CKZH713E CKZH714E CKZH715S CKZH814E CKZH970E CKZH971E
  CKZH972E CKZH973E CKZH974E CKZH975E CKZHACAS CKZHACRS CKZPPMM
  CKZPPMSG CKZPPPG  CKZPPPSV CKZWACAO CKZWACCL CKZWACCO CKZWACMO
  CKZWACPG CKZWACPR CKZWACSC CKZWACSO CKZWACSP CKZWACSV CKZWACTI
  CKZWAPCL CKZWBLAC CKZWBLSJ CKZWCFMN CKZWCMPN CKZWCNST CKZWDACD
  CKZWDACS CKZWDB2  CKZWDBSS CKZWDDFA CKZWDDSP CKZWDSAP CKZWIVPL
  CKZWJBTM CKZWJCLB CKZWJTVR CKZWLADS CKZWLAOP CKZWLAZP CKZWMAIN
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R320 PSY UI67958

     UP20/02/19 P F002

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.