A fix is available
APAR status
Closed as program error.
Error description
Before applying this fix, DDL generation module generates PARTITION BY RANGE clause for an index that is specified with BUSINESS_TIME WITHOUT OVERLAPS clause that leads to error during execution generated DDL 'SQLCODE = -20522 INVALID SPECIFICATION OF WITHOUT OVERLAPS OR PERIOD CLAUSE. REASON CODE 7.' After applying this fix, DDL generation module does not generate 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 generator generates * * PARTITION BY RANGE clause for an index * * that is specified with * * BUSINESS_TIME WITHOUT OVERLAPS clause. * **************************************************************** * RECOMMENDATION: Apply the PTF. * **************************************************************** .
Problem conclusion
Apply the PTF.
Temporary fix
Comments
APAR Information
APAR number
PH28689
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-08-20
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:
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