A fix is available
APAR status
Closed as program error.
Error description
1. When application cloning with target log apply is used to clone tables with identity columns, subsequent inserts to target tables might fail with SQLCODE -803 2. Several typos were found in messages text 3. When application cloning is used to clone compressed table spaces, subsequent access to the cloned table space might fail with reason code 00C9007F 4. When the LISTDEF for application cloning includes both an entire partitioned index and its individual partitions, the source job ends with various error messages 5. When application cloning uses UNLOAD/LOAD to process nonpartitioned or partitioned-by-growth table spaces, if the runtime repository is enabled and the target job fails to load data into one of those table spaces, subsequent reruns of the target job might fail with message CKZ55103E 6. When application cloning keyword TARGET-JOB-REBUILD-DDN is specified and points to a template with "REBUILD INDEX (ALL) TABLESPACE" syntax and the cloned objects include table spaces that require a REBUILD for all of their indexes, the REBUILD INDEX JCL is not generated 7. When the ISPF UI is launched for the first time or when DD settings for an existing profile are reset, the product library HLQ might be set to a blank value and invalid data set names are generated to the cloning JCL 8. When a large number of messages are issued during page processing in the application cloning target job, the job might end with S878 abend 9. A minor error in CKZ1REBD panel is fixed 10. DATA-MOVER PGM SRCVSCPY is no longer supported 11. When application cloning with DATA-MOVER PGM SRCIMCPY and REUSE(Y) is used to clone an object that has different PQTY/SQTY values between the source and the target, the source job might end with RC=8 and CKZG4611E messages
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: 1. When application cloning with target * * log apply is used to clone tables with * * identity columns, subsequent inserts to * * target tables might fail with SQLCODE * * -803 * * 2. Several typos were found in * * messages text * * 3. When application cloning is used to * * clone compressed table spaces, * * subsequent access to the cloned * * table space might fail with reason code * * 00C9007F * * 4. When the LISTDEF for application * * cloning includes both an entire * * partitioned index and its individual * * partitions, the source job ends with * * various error messages * * 5. When application cloning uses * * UNLOAD/LOAD to process nonpartitioned * * or partitioned-by-growth table spaces, * * if the runtime repository is enabled * * and the target job fails to load data * * into one of those table spaces, * * subsequent reruns of the target job * * might fail with message CKZ55103E * * 6. When application cloning keyword * * TARGET-JOB-REBUILD-DDN is specified and * * points to a template with "REBUILD * * INDEX (ALL) TABLESPACE" syntax and the * * cloned objects include table spaces * * that require a REBUILD for all of their * * indexes, the REBUILD INDEX JCL is not * * generated * * 7. When the ISPF UI is launched for the * * first time or when DD settings for an * * existing profile are reset, the product * * library HLQ might be set to a blank * * value and invalid data set names are * * generated to the cloning JCL * * 8. When a large number of messages are * * issued during page processing in * * the application cloning target job, the * * job might end with S878 abend * * 9. A minor error in CKZ1REBD panel is * * fixed * * 10. DATA-MOVER PGM SRCVSCPY is no * * longer supported * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** 1. When application cloning with target log apply is used to clone tables with identity columns, subsequent inserts to target tables might fail with SQLCODE -803 2. Several typos were found in messages text 3. When application cloning is used to clone compressed table spaces, subsequent access to the cloned table space might fail with reason code 00C9007F 4. When the LISTDEF for application cloning includes both an entire partitioned index and its individual partitions, the source job ends with various error messages 5. When application cloning uses UNLOAD/LOAD to process non-partitioned or partitioned-by-growth table spaces, if the- runtime repository is enabled and the target job fails to load data into one of those table spaces, subsequent reruns of the target job might fail with message CKZ55103E 6. When application cloning keyword TARGET-JOB-REBUILD-DDN is specified and points to a template with "REBUILD INDEX (ALL) TABLESPACE" syntax and the cloned objects include table spaces that require a REBUILD for all of their indexes, the REBUILD INDEX JCL is not generated 7. When the ISPF UI is launched for the first time or when DD settings for an existing profile are reset, the product library HLQ might be set to a blank value and invalid data set names are generated to the cloning JCL 8. When a large number of messages are issued during page processing in the application cloning target job, the job might end with S878 abend 9. A minor error in CKZ1REBD panel is fixed 10. DATA-MOVER PGM SRCVSCPY is no longer supported
Problem conclusion
Apply the PTF
Temporary fix
Comments
APAR Information
APAR number
PH38909
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
2021-07-13
Closed date
2021-08-26
Last modified date
2021-09-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI76916
Modules/Macros
CKZ#A001 CKZ#ACIR CKZ#ACIW CKZ#ACON CKZ#ACRD CKZ#ACUP CKZ#ADIS CKZ#ADSC CKZ#AEXT CKZ#AFMT CKZ#AFRR CKZ#ALLO CKZ#AMIN CKZ#ASYS CKZ#AUMX CKZ#AUTO CKZ#BIND CKZ#CARD CKZ#CHKR CKZ#CL CKZ#CL64 CKZ#CL7 CKZ#CL8 CKZ#CLLS CKZ#CMTS CKZ#CN64 CKZ#CNTL CKZ#CNVT CKZ#CPM CKZ#CPNT CKZ#CPOL CKZ#DB2V CKZ#DSAF CKZ#DSPL CKZ#DSQL CKZ#DYNL CKZ#ENCR CKZ#ENQS CKZ#ENVF CKZ#EPRI CKZ#FCPY CKZ#ICAI CKZ#ICAL CKZ#ICCC CKZ#ICCI CKZ#IDCF CKZ#IDSA CKZ#IERR CKZ#IHSA CKZ#IKPL CKZ#IKPN CKZ#ILGP CKZ#ILRA CKZ#ILRS CKZ#ILSA CKZ#INIT CKZ#IOPF CKZ#IPIE CKZ#IPPB CKZ#IPPC CKZ#IPPD CKZ#IPPH CKZ#IPPL CKZ#IPPN CKZ#IPPS CKZ#IRPL CKZ#ISNA CKZ#JPRI CKZ#JU64 CKZ#JUST CKZ#LGAA CKZ#LGAC CKZ#LGAF CKZ#LGAI CKZ#LGAP CKZ#LOGR CKZ#LRD6 CKZ#MAIN CKZ#MDRV CKZ#MLOG CKZ#MMGR CKZ#MPRI CKZ#MREP CKZ#MTIO CKZ#NREC CKZ#OPRI CKZ#OS CKZ#PRF5 CKZ#PRNG CKZ#QSAM CKZ#RANG CKZ#RESM CKZ#RH CKZ#RH10 CKZ#RM24 CKZ#RPRP CKZ#RUNT CKZ#SQL2 CKZ#SQLC CKZ#STAT CKZ#STCK CKZ#STMT CKZ#SUBD CKZ#SUBS CKZ#SUBX CKZ#SYSC CKZ#TB CKZ#TB7 CKZ#TB8 CKZ#TP CKZ#TP10 CKZ#TSS CKZ#TSSA CKZ#TUTL CKZ#UPRI CKZ#URDT CKZ#UTLB CKZ#UTLC CKZ#UTLS CKZ#UTOP CKZ#VERS CKZ#VSM CKZ#WRIT CKZ#XMLD CKZ#XMLJ CKZ#XMLS CKZ$ACCS CKZ$BDSN CKZ$BMSG CKZ$BOOT CKZ$BUTJ CKZ$CAF CKZ$CAFA CKZ$CALL CKZ$CTCM CKZ$DCMD CKZ$DCVT CKZ$DS CKZ$DSN CKZ$ESTA CKZ$INFO CKZ$PRFD CKZ$PRFR CKZ$SMSG CKZ$SPRM CKZ$SQL2 CKZ$SQLC CKZ$SSCT CKZ$TOK CKZ$TSOC CKZ$URDT CKZ$ZPAR CKZ00021 CKZ00065 CKZ00067 CKZ00070 CKZ00072 CKZ00141 CKZ00253 CKZ00400 CKZ00500 CKZ00501 CKZ00502 CKZ00505 CKZ00506 CKZ00510 CKZ00520 CKZ00524 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
Fix information
Fixed component name
DB2 CLONING TOO
Fixed component ID
5655N1000
Applicable component levels
R320 PSY UI76916
UP21/08/28 P F108
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.2.0"}]
Document Information
Modified date:
02 September 2021