A fix is available
APAR status
Closed as program error.
Error description
This release includes the following bug fixes: 1. When an auxiliary table and its related table space and index are created explicitly for the first partition of a partition-by-growth table space but implicitly for other partitions, the DDL generator produces DDL that implicitly creates LOB objects for all partitions of the partition-by-growth table space, but still tries to add explicit LOB objects for the first partition. 2. An infinite loop occurs in Db2 application cloning if a table space has more than one materialized query table. 3. DDL generation does not generate RI relationships for tables in implicit table spaces. 4. Miscellaneous fixes in Db2 application cloning page processing code. 5. SIMULATE(A) does not work correctly with Db2 application cloning target log apply. 6. Fix the appearance of the CKZ503I message in the classic ISPF interface. 7. Miscellaneous fixes in the new ISPF interface. 8. Db2 application cloning uses incorrect IPREFIX values during the cloning of DEFINE NO target objects. 9. Db2 application cloning might rebuild a partitioned index by partitions instead of rebuilding the entire index. 10. Db2 application cloning does not re-create an implicitly dropped materialized query table if the object upon which the materialized query table is dependent has a mismatch that can be fixed by re-creation. 11. Fix typographical errors in Db2 subsystem cloning messages CKZ27152I, CKZ27152W, and CKZ27152E. 12. New ISPF interface generates duplicates of Db2 load libraries in STEPLIB of the source JCL job. 13. DDL generator does not translate creator of table in SQL statement of view when view references to table name in lower case and object translation is specified for creator of table. 14. DDL generator generates PARTITION BY RANGE clause for an index that is specified with BUSINESS_TIME WITHOUT OVERLAPS clause.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: DDL generation does not generate RI * * relationships for tables in implicit * * table spaces. * * * * Miscellaneous fixes in Db2 application * * cloning page processing code. * * * * SIMULATE(A) does not work correctly * * with Db2 application cloning target log * * apply. * * * * Fix the appearance of the CKZ503I * * message in the classic ISPF interface. * * * * Miscellaneous fixes in the new ISPF * * interface. * * * * Db2 application cloning uses incorrect * * IPREFIX values during the cloning of * * DEFINE NO target objects. * * * * Db2 application cloning might rebuild a * * partitioned index by partitions instead * * of rebuilding the entire index. * * * * Db2 application cloning does not * * re-create an implicitly dropped * * materialized query table if the object * * upon which the materialized query table * * is dependent has a mismatch that can be * * fixed by re-creation. * * * * Db2 subsystem cloning messages * * CKZ27152I, CKZ27152W, and CKZ27152E * * have typographical errors. * * * * New ISPF interface generates duplicates * * of Db2 load libraries in STEPLIB of the * * source JCL job. * * * * DDL generator does not translate * * creator of table in SQL statement of * * view when view references to table name * * in lower case and object translation is * * specified for creator of table. * **************************************************************** * RECOMMENDATION: Apply the PTF. * **************************************************************** .
Problem conclusion
Apply the PTF.
Temporary fix
Comments
APAR Information
APAR number
PH27289
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-07-08
Closed date
2020-08-28
Last modified date
2020-09-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI71304
Modules/Macros
CKZ00270 CKZ00271 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 CKZ00995 CKZ00996 CKZ10 CKZ1ACAI CKZ1ACAO CKZ1ACAU CKZ1ACAW CKZ1CMJT CKZ1COPC CKZ1HDSP CKZ1NSV# CKZ1NSVO CKZ1SETC CKZ1SIMC CKZ1TCOP CKZ1TSET CKZ2ADRD CKZ2BDCJ CKZ2BLSJ CKZ2CLCM CKZ2CLON CKZ2CMPN CKZ2COCP CKZ2COMM CKZ2CRDS CKZ2CTCP CKZ2CULC CKZ2DAPS CKZ2DB2A CKZ2DBSS CKZ2DCCC CKZ2DCCH CKZ2DDAT CKZ2DFIX CKZ2DREN CKZ2DRFD CKZ2DSAP CKZ2DSCJ CKZ2DSCL CKZ2DSCN CKZ2DSCP CKZ2DSCR CKZ2DSCS CKZ2DSQL CKZ2DSTP CKZ2DTCP CKZ2DTCS CKZ2EDAC CKZ2EDDF CKZ2EDDL CKZ2EDDS CKZ2ELDC CKZ2EMDC CKZ2ESCP CKZ2ETCP CKZ2FTSJ CKZ2GFSJ CKZ2LAOP CKZ2MAIN CKZ2MEPL CKZ2MRVR CKZ2MSTF CKZ2OMRC CKZ2PDAC CKZ2PDBL CKZ2PLAP CKZ2PLDC CKZ2PMDC CKZ2PRDM CKZ2PRIM CKZ2RTSC CKZ2SASV CKZ2SBCI CKZ2SJCL CKZ2SJTS CKZ2SJTV CKZ2SOMT CKZ2SOPR CKZ2SPCC CKZ2SPRF CKZ2SRSV CKZ2SSDS CKZ2SSLB CKZ2SSMC CKZ2SSTM CKZ2SSTN CKZ2SSTS CKZ2SSTT CKZ2SSTV CKZ2STSS CKZ2TCOP CKZ2TDDC CKZ2TDDF CKZ2TDSP CKZ2TJCL CKZ2TSCI CKZ2TSCP CKZ2TSET CKZ2TTRN CKZ2ULCL CKZ39 CKZ42 CKZ50 CKZ57 CKZ58 CKZ6ADLL CKZ6MAIN CKZ6TPRM CKZ7ADLL CKZ7MSGS 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
Fix information
Fixed component name
DB2 CLONING TOO
Fixed component ID
5655N1000
Applicable component levels
R320 PSY UI71304
UP20/08/29 P F008
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