A fix is available
APAR status
Closed as program error.
Error description
In current versions of Db2, schema definition about version 0 of object is not stored in page set, which causes problems when cloning from object with zero version to object with non-zero objects. IBM resolves this issue in Db2 Epic 37738. The following needs to be done to exploit this Epic: # Correctly identify situations when zero version pages are present in page set. This will require changes in DB2DAM component (to return some kind of indicator that no system pages were found, instead of returning zero version) and TS cloning to support changes in DB2DAM. # Provide template for REPAIR INSERTVERSIONPAGES, so customer can use JOB-TEMPLATE to generate JCL to ensure that all cloned table spaces have full versioning information # Update messages and User's guide accordingly.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM Db2 Cloning Tool z/OS. * **************************************************************** * PROBLEM DESCRIPTION: In current versions of Db2, schema * * definition about version 0 of object * * is not stored in page set, which * * causes problems when cloning from * * object with zero version to object * * with non-zero objects. IBM resolves * * this issue in Db2 Epic 37738. The * * following needs to be done to exploit * * this Epic: * * # Correctly identify situations when * * zero version pages are present in page * * set. This will require changes in * * DB2DAM component (to return some kind * * of indicator that no system pages * * were found, instead of returning zero * * version) and TS cloning to support * * changes in DB2DAM. * * # Provide template for REPAIR * * INSERTVERSIONPAGES, so customer * * can use JOB-TEMPLATE to generate JCL * * to ensure that all cloned table spaces * * have full versioning information * * # Update messages and User's guide * * accordingly. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PI93478
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
2018-02-07
Closed date
2018-03-16
Last modified date
2018-04-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI54552
Modules/Macros
CKZ$ACCS CKZ$ACES CKZ$BDSN CKZ$BMSG CKZ$BOOT CKZ$BUTJ CKZ$CAF CKZ$CAFA CKZ$CALL CKZ$CTCM CKZ$DCMD CKZ$DCVT CKZ$ERR CKZ$ESTA CKZ$GSKB CKZ$INFO CKZ$LOG CKZ$MEPL CKZ$PRFD CKZ$PRFR CKZ$SMSG CKZ$SPRM CKZ$SQLC CKZ$SQL2 CKZ$SSCT CKZ$TOK CKZ$TSOC CKZ$ZPAR CKZ#AMIN CKZ#ASYS CKZ#AUTO CKZ#BIND CKZ#CARD CKZ#CHKR CKZ#CL CKZ#CL64 CKZ#CL7 CKZ#CL8 CKZ#CMTS CKZ#CNTL CKZ#CNVT CKZ#CN64 CKZ#CPM CKZ#CPNT CKZ#CPOL CKZ#DB2V CKZ#DCAT CKZ#DSAF CKZ#DSPL CKZ#DSQL CKZ#ENQS CKZ#ENVF CKZ#EPRI CKZ#FCPY CKZ#HTAB 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#IOPF CKZ#IPIE CKZ#IPPB CKZ#IPPC CKZ#IPPD CKZ#IPPH CKZ#IPPL CKZ#IPPN CKZ#IPPS CKZ#IRPL CKZ#ISNA CKZ#JPRI CKZ#JUST CKZ#JU64 CKZ#LGAA CKZ#LGAC CKZ#LGAF CKZ#LGAI CKZ#LGAP CKZ#LGRN CKZ#LIKE CKZ#LOGR CKZ#LRDR CKZ#LRD6 CKZ#MAIN CKZ#MLOG CKZ#MPRI CKZ#MREP CKZ#OPRI CKZ#OUT2 CKZ#PARS CKZ#PRNG CKZ#QCAT CKZ#RANG CKZ#RCAT CKZ#REPO CKZ#RESM CKZ#RH CKZ#RH10 CKZ#RM24 CKZ#RPRP CKZ#RUNT CKZ#SQLC CKZ#SQL2 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#UCBS CKZ#UPRI CKZ#UTLB CKZ#UTLC CKZ#UTOP CKZ#VSAM CKZ#VSA1 CKZ#VSA2 CKZ#WRIT CKZ#XMLD CKZ#XMLS CKZ@CAF CKZ@CAFA CKZ@CAFW CKZ@CNUM CKZ@COLS CKZ@CSCR CKZ@DBC CKZ@DSN CKZ@DSQL CKZ@EXP1 CKZ@FIX1 CKZ@FORM CKZ@LOGR CKZ@ORD1 CKZ@REM1 CKZ@RES1 CKZ@ROLB CKZ@SCCM CKZ@SCGT CKZ@SCIT CKZ@SCPT CKZ@SCRL CKZ@SCR1 CKZ@SFND CKZ@SIZ1 CKZ@SMSG CKZ@SQLD CKZ@SRT1 CKZ@SSET CKZ@SSRT CKZ@TOK CKZ@USRT CKZALLZT CKZAPOST CKZASML CKZBAKS CKZBAKT CKZBBKS CKZBBKT CKZBLNKT CKZBTS CKZCAPST CKZCHART CKZCNVTP CKZCOMAT CKZDAREA CKZDBC CKZDBCA CKZDBCH CKZDBCX CKZDBHP CKZDGRP CKZDGRPS CKZDOTT CKZDSNXT CKZDYNAL CKZFILTR CKZFTRT CKZHCOPC CKZHEXT CKZHLI CKZHLI2 CKZHSETC CKZHTCOP CKZHTSET CKZIALI CKZIDB2C CKZIDCAM CKZIENQS CKZIEXCP CKZIGIDX CKZIGRS CKZIHFP CKZIHLI2 CKZIICW2 CKZIIDPH CKZIIKS CKZIIKSA CKZILOCK CKZIMAIN CKZIMSGS CKZIMUTX CKZINCRD CKZINI# CKZIPAGE CKZIPROT CKZIPSRW CKZIRBLT CKZIROWK CKZISMPR CKZISORT CKZISOR1 CKZISOR2 CKZISOR3 CKZISOR5 CKZISTDB CKZISYSP CKZITHRD CKZIUCB CKZIUTLB CKZIVSAD CKZIVSAM CKZIVSAS CKZIXCON CKZIXDEC CKZIXIND CKZIXMAT CKZIXMLR CKZIXNOD CKZIXREC CKZJOBRV CKZLGRD CKZLINKL CKZLOGR CKZLVALT CKZMMGR CKZMMIF CKZMSRT CKZNBLKT CKZNNUMT CKZPARET CKZPERIT CKZPPARM CKZRDPDS CKZRPART CKZSLIP CKZSLST CKZSRT64 CKZSVC26 CKZSV26R CKZS99 CKZTOKEN CKZUNICN CKZUNIGT CKZXASMS CKZXASPR CKZXAS31 CKZXAS64 CKZXDD CKZXEXCP CKZXPDS CKZXUTLS CKZZPEXT CKZ00500 CKZ00501 CKZ00502 CKZ00505 CKZ00506 CKZ00510 CKZ00520 CKZ00526 CKZ00527 CKZ00528 CKZ00529 CKZ00530 CKZ00532 CKZ00533 CKZ00534 CKZ00535 CKZ00536 CKZ00537 CKZ00538 CKZ00539 CKZ00540 CKZ00541 CKZ00542 CKZ00544 CKZ00545 CKZ00546 CKZ00547 CKZ00548 CKZ00549 CKZ00550 CKZ00551 CKZ00552 CKZ00553 CKZ00554 CKZ00555 CKZ00556 CKZ00560 CKZ00561 CKZ00562 CKZ00563 CKZ00564 CKZ00565 CKZ00566 CKZ00567 CKZ00569 CKZ00573 CKZ00575 CKZ00600 CKZ00602 CKZ00610 CKZ00611 CKZ00612 CKZ00613 CKZ00616 CKZ00619 CKZ00624 CKZ00625 CKZ00626 CKZ00633 CKZ00634 CKZ00635 CKZ00636 CKZ00637 CKZ00638 CKZ00643 CKZ00647 CKZ00648 CKZ00650 CKZ00651 CKZ00656 CKZ00657 CKZ00658 CKZ00659 CKZ00669 CKZ00670 CKZ00671 CKZ00672 CKZ00673 CKZ00674 CKZ00675 CKZ00676 CKZ00677 CKZ00680 CKZ00708 CKZ00709 CKZ00710 CKZ00711 CKZ00712 CKZ00713 CKZ00714 CKZ00715 CKZ00716 CKZ00717 CKZ00718 CKZ00719 CKZ00720 CKZ00721 CKZ00724 CKZ00725 CKZ00726 CKZ00733 CKZ00734 CKZ00735 CKZ00736 CKZ00737 CKZ00738 CKZ00743 CKZ00747 CKZ00748 CKZ00750 CKZ00751 CKZ00756 CKZ00757 CKZ00758 CKZ00759 CKZ00760 CKZ00761 CKZ00764 CKZ00765 CKZ00767 CKZ00768 CKZ00769 CKZ00770 CKZ00773 CKZ00775 CKZ00776 CKZ00777 CKZ00780 CKZ00781 CKZ00782 CKZ00960 CKZ00980 CKZ00981 CKZ00982 CKZ00984 CKZ1COPC CKZ1TCOP CKZ10CMD CKZ2ADRD CKZ2BCLC CKZ2BDCJ CKZ2BLSJ CKZ2CLON CKZ2CMND CKZ2CMPN CKZ2COCP CKZ2COMM CKZ2CTCP CKZ2CULC CKZ2DALV CKZ2DAPS CKZ2DBSS CKZ2DB2A CKZ2DCCC CKZ2DCCH CKZ2DCRN CKZ2DDAT CKZ2DEFD CKZ2DFIX CKZ2DREN CKZ2DRFD CKZ2DSAP CKZ2DSCJ CKZ2DSCL CKZ2DSCN CKZ2DSCP CKZ2DSCS CKZ2DSQL CKZ2DSTP CKZ2DTCP CKZ2DTCS CKZ2EDAC CKZ2EDCV CKZ2EDDF CKZ2EDDL CKZ2EDDS CKZ2ELDC CKZ2EMCS CKZ2EMDC CKZ2ESCP CKZ2ETCP CKZ2FTSJ CKZ2GFSJ CKZ2GVAR CKZ2IVPL CKZ2JSKL CKZ2LACR CKZ2LAOP CKZ2LSTS CKZ2MAIN CKZ2MEPL CKZ2MSTF CKZ2MTMB CKZ2NPPR CKZ2OMRC CKZ2PDAC CKZ2PDBL CKZ2PJCI CKZ2PLAP CKZ2PLDC CKZ2PMDC CKZ2PRDM CKZ2PRFL CKZ2PRIM CKZ2PZPI CKZ2RTSC CKZ2SASV CKZ2SBCI CKZ2SCLT CKZ2SFRJ CKZ2SFSJ CKZ2SFTJ CKZ2SIDL CKZ2SJCI CKZ2SJCL CKZ2SJTS CKZ2SJTV CKZ2SKL CKZ2SOMT CKZ2SOPR CKZ2SPCC CKZ2SPRF CKZ2SRNM CKZ2SRSV CKZ2SSCP CKZ2SSDS CKZ2SSID CKZ2SSLB CKZ2SSMC CKZ2SSSC CKZ2SSSJ CKZ2SSTM CKZ2SSTN CKZ2SSTS CKZ2SSTT CKZ2SSTV CKZ2STSS CKZ2TCOP CKZ2TDDC CKZ2TDDF CKZ2TDSP CKZ2TJCL CKZ2TRCF CKZ2TSCP CKZ2TSET CKZ2TTRN CKZ2ULCL CKZ2USET CKZ3MEPI CKZ3MEPL CKZ3TYPS CKZ6ADLL CKZ6MAIN CKZ6OMRC CKZ6TCPR CKZ6TPRM CKZ7CMD CKZ8CMD CKZ9BSRS CKZ9CMD CKZ9DB2D CKZ9FMSG HCKZ320
Fix information
Fixed component name
DB2 CLONING TOO
Fixed component ID
5655N1000
Applicable component levels
R320 PSY UI54552
UP18/03/20 P F803
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:
31 March 2021