A fix is available
APAR status
Closed as program error.
Error description
1)The Storage class field is incorrectly displayed on the Advanced cloning options panel in the simplified ISPF UI 2) In some cases, the DB2SQL command with the option WLM-ENV-ROUTINES-DDL does not change the WLM ENVIRONMENT 3) The cloning method is not displayed in the simplified ISPF UI 4) Invalid DDL is generated for non-deterministic generated expression columns 5) Objects with asingle quote in their schema or name cannot be dropped or created with DB2SCHEMA-UPDATE 6) The DB2SQL command with the WLM-ENV-ROUTINES-DDL option hangs when generated DDL ends with a SQL warning
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: The following internal bugs are fixed: * * 1. The Storage class field is * * incorrectly displayed on the Advanced * * cloning options panel in the simplified * * ISPF UI * * 2. In some cases, the DB2SQL command * * with the option WLM-ENV-ROUTINES-DDL * * does not change the WLM ENVIRONMENT in * * some cases * * 3. The cloning Clone method is not * * displayed in the simplified ISPF UI * * 4. Invalid DDL is generated for * * non-deterministic generated expression * * columns * * 5. Objects with a single quote in their * * schema or name cannot be dropped or * * created with DB2SCHEMA-UPDATE * * 6. The DB2SQL command with the * * WLM-ENV-ROUTINES-DDL option hangs when * * generated DDL ends with a SQL warning * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** The following internal bugs are fixed: 1. The Storage class field is incorrectly displayed on the Advanced cloning options panel in the simplified ISPF UI 2. In some cases, the DB2SQL command with the option WLM-ENV-ROUTINES-DDL does not change the WLM ENVIRONMENT in some cases 3. The cloning Clone method is not displayed in the simplified ISPF UI 4. Invalid DDL is generated for non-deterministic generated expression columns 5. Objects with a single quote in their schema or name cannot be dropped or created with DB2SCHEMA-UPDATE 6. The DB2SQL command with the WLM-ENV-ROUTINES-DDL option hangs when generated DDL ends with a SQL warning
Problem conclusion
Apply the PTF
Temporary fix
Comments
APAR Information
APAR number
PH55183
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
2023-06-14
Closed date
2023-06-26
Last modified date
2023-07-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
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#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#UTLB CKZ#UTLC CKZ#UTLS CKZ#UTOP CKZ#VERS CKZ#VSM CKZ#WRIT CKZ#XMLI 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$ESTA CKZ$INFO CKZ$PRFD CKZ$PRFR CKZ$SMSG CKZ$SPRM CKZ$SQL2 CKZ$SQLC CKZ$SSCT CKZ$TOK CKZ$TSOC CKZ$ZPAR CKZ00245 CKZ00246 CKZ00247 CKZ00248 CKZ00283 CKZ00510 CKZ00520 CKZ00537 CKZ00540 CKZ00541 CKZ00542 CKZ00543 CKZ00544 CKZ00545 CKZ00546 CKZ00547 CKZ00548 CKZ00549 CKZ00550 CKZ00551 CKZ00553 CKZ00554 CKZ00555 CKZ00556 CKZ00562 CKZ00564 CKZ00569 CKZ00575 CKZ00600 CKZ00611 CKZ00612 CKZ00613 CKZ00619 CKZ00640 CKZ00670 CKZ00671 CKZ00674 CKZ00708 CKZ00709 CKZ00711 CKZ00713 CKZ00714 CKZ00715 CKZ00716 CKZ00717 CKZ00718 CKZ00720 CKZ00721 CKZ00722 CKZ00723 CKZ00760 CKZ00761 CKZ00764 CKZ00765 CKZ00766 CKZ00769 CKZ00780 CKZ00781 CKZ00782 CKZ00984 CKZ1ACAI CKZ1ACAO CKZ3MEPI CKZ3MEPL CKZ9BSRS CKZ9DB2D CKZ@CAF CKZ@CAFA CKZ@CAFW CKZ@DSQL CKZ@LOGR CKZ@ROLB CKZ@SMSG CKZ@SQLD CKZ@TOK CKZALLZT CKZAPOST CKZBLNKT CKZCAPST CKZCFN0C CKZCFNNC CKZCHART CKZCOMAT CKZCPLNC CKZCSPNC CKZDAREA CKZDOTT CKZDSNXT CKZDYNAL CKZEADLL CKZFGNCL CKZFNORM CKZFOBJZ CKZFTRT CKZHEXT CKZHLI CKZHLI2 CKZIENQS
Fix information
Fixed component name
DB2 CLONING TOO
Fixed component ID
5655N1000
Applicable component levels
R320 PSY UI92456
UP23/06/27 P F306
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":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"3.2.0"}]
Document Information
Modified date:
03 July 2023