A fix is available
APAR status
Closed as program error.
Error description
This release includes the following bug fixes: 1. Db2 application cloning target job can finish with 0C4 abend during parsing SYNCDB2 2. Db2 application cloning does not generate SYNCDB2 commands if EMCAPI ends with RC=4 3. Implicit LOB table space/index matching errors occur in Db2 application cloning if the base table space is a PBG table space and the source table space has more partitions than the target table space 4. Db2 application cloning generates incorrect DDL for objects with active versioning 5. Db2 application cloning does not switch APPLCOMPAT to V12R1M503 for materialized query tables based on tables in non-universal table spaces or synonyms in generated DDL 6. The call of the ISPF UI from Db2 Admin Tool does not work with the new ISPF UI 7. In the new ISPF UI, Db2 load libraries are not added to the STEPLIB in cloning JCL jobs for non-data sharing Db2 subsystems 8. Db2 application cloning does not exclude from the cloning objects that are incompatible with recreation when RECREATE-OBJECTS is set to M 9. CKZ04779E 'Incorrect size of data in VVDS' can occur when RENAME with SAFE is used in Db2 subsystem cloning 10. CKZ54706E error occurs when CATALOG-PREFETCH is enabled and multiple OBJECT-TRANSLATE rules for DATABASE are specified in Db2 application cloning 11. Uncommitted unit of recoveries are left on Db2 catalog tables if DDL finishes with error in target TCP/IP server job of Db2 application cloning 12. Command line 'P - Properties' does not work in the new ISPF UI when the 'Access Source through SSID (DDF)' field is empty 13. In the new ISPF UI, source Db2 load libraries are not added to the STEPLIB in the target job when log apply is enabled and the remote connect type is not TCPIP 14. U4038 abend occurs when trying to use 'R' command on CKZ1TSET panel in classic ISPF UI
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: Db2 application cloning target job can * * finish with 0C4 abend during parsing * * SYNCDB2 * * * * Db2 application cloning does not * * generate SYNCDB2 commands if EMCAPI * * ends with RC=4 * * * * Db2 application cloning generates * * incorrect DDL for objects with active * * versioning * * * * Db2 application cloning does not switch * * APPLCOMPAT to V12R1M503 for * * materialized query tables based on * * tables in non-universal table spaces or * * synonyms in generated DDL * * * * The call of the ISPF UI from Db2 Admin * * Tool does not work with the new ISPF UI * * * * In the new ISPF UI, Db2 load libraries * * are not added to the STEPLIB in cloning * * JCL jobs for non-data sharing Db2 * * subsystems * * * * Db2 application cloning does not * * exclude from the cloning objects that * * are incompatible with recreation when * * RECREATE-OBJECTS is set to M * * * * CKZ04779E 'Incorrect size of data in * * VVDS' can occur when RENAME with SAFE * * is used in Db2 subsystem cloning * * * * CKZ54706E error occurs when * * CATALOG-PREFETCH is enabled and * * multiple OBJECT-TRANSLATE rules for * * DATABASE are specified in Db2 * * application cloning * * * * Uncommitted unit of recoveries are left * * on Db2 catalog tables if DDL finishes * * with error in target TCP/IP server job * * of Db2 application cloning * * * * Command line 'P - Properties' does not * * work in the new ISPF UI when the * * 'Access Source through SSID (DDF)' * * field is empty * * * * In the new ISPF UI, source Db2 load * * libraries are not added to the STEPLIB * * in the target job when log apply is * * enabled and the remote connect type is * * not TCPIP * * * * U4038 abend occurs when trying to use * * 'R' command on CKZ1TSET panel in * * classic ISPF UI * **************************************************************** * RECOMMENDATION: Apply the PTF. * **************************************************************** .
Problem conclusion
Apply the PTF.
Temporary fix
Comments
APAR Information
APAR number
PH25706
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
2020-05-26
Closed date
2020-06-19
Last modified date
2020-07-06
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI70142
Modules/Macros
CKZ00047 CKZ00110 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 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 CKZ00992 CKZ00993 CKZ00996 CKZ2SRSV CKZCAL9C CKZCALNC CKZCAQ1C CKZCAQNC CKZCAT01 CKZCATM CKZCATMO CKZCCT9C CKZCCTNC CKZCD002 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 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 CKZDDLAL CKZDDLAQ CKZDDLCL CKZDDLCT CKZDDLDB CKZDDLDT CKZDDLIX CKZDDLPK CKZDDLPL CKZDDLRL CKZDDLRO CKZDDLRT CKZDDLSG CKZDDLSN CKZDDLSQ CKZDDLTB CKZDDLTR CKZDDLTS CKZDDLVA CKZDDLVT CKZDDLXT CKZDOCID CKZF2STR CKZFATTR CKZFBASE CKZFCD02 CKZFCEXP CKZFCFTC CKZFCONN CKZFCSTL CKZFDBGP CKZFDIBI CKZFDIBP 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 CKZFLOG3 CKZFLST2 CKZFMETL CKZFNORM CKZFOBJT CKZFOBJZ CKZFPDBG CKZFRTSI CKZFRTSM CKZFRTST CKZFSQLE CKZFUTIL CKZGCSTL CKZGDBGP CKZGDIBI
Fix information
Fixed component name
DB2 CLONING TOO
Fixed component ID
5655N1000
Applicable component levels
R320 PSY UI70142
UP20/06/22 P F006
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.
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021