A fix is available
APAR status
Closed as program error.
Error description
Application cloning DDL generator creates DDL statements that result in SQLERROR = -20525 with reason code 7 when a source history table resides in a table space with rotated partitions.
Local fix
BYPASS/CIRCUMVENTION: NA
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Cloning Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: Application cloning DDL generator * * creates DDL statements that result in * * SQLERROR = -20525 with reason code 7 * * when a source history table resides in * * a table space with rotated partitions. * **************************************************************** * RECOMMENDATION: Apply the PTF * **************************************************************** Application cloning DDL generator creates DDL statements that result in SQLERROR = -20525 with reason code 7 when a source history table resides in a table space with rotated partitions.
Problem conclusion
Apply the PTF
Temporary fix
Comments
APAR Information
APAR number
PH56550
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-08-25
Closed date
2023-10-04
Last modified date
2023-11-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
CKZ00246 CKZ00249 CKZ00500 CKZ00501 CKZ00502 CKZ00505 CKZ00506 CKZ00510 CKZ00520 CKZ00524 CKZ00525 CKZ00526 CKZ00527 CKZ00528 CKZ00529 CKZ00530 CKZ00531 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 CKZ00799 CKZ00950 CKZ00951 CKZ00952 CKZ00980 CKZ00981 CKZ00984 CKZ00985 CKZ00992 CKZ00993 CKZ00996 CKZBCKS CKZBCKT CKZBDKS CKZBDKT CKZBSS CKZBTS 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 CKZCRL2C CKZCRL9C CKZCRO9C CKZCRTNC CKZCSG9C CKZCSGVA CKZCSN9C CKZCSNNC CKZCSP9C CKZCSPNC CKZCSQ1C CKZCSQ9C CKZCSQNC CKZCTB0C CKZCTB1C CKZCTB2C CKZCTB9C CKZCTBNC CKZCTC0C CKZCTR0C CKZCTR2C CKZCTR9C CKZCTRNC CKZCTS0C CKZCTS2C CKZCTS9C CKZCTSNC CKZCVA1C CKZCVANC CKZCVT0C CKZCVT9C CKZCVTNC CKZCXANC CKZCXT9C CKZDBNDC CKZDBNDD CKZDOCID CKZF2STR CKZFATTR CKZFBASE CKZFCD02 CKZFCEXP CKZFCFTC CKZFCLCT CKZFCONN CKZFCSTL CKZFDBGP CKZFEXPR CKZFFDCM CKZFFLST CKZFGNAL CKZFGNAQ CKZFGNCL CKZFGNCT CKZFGNDB CKZFGNDT CKZFGNIX CKZFGNPK CKZFGNPL CKZFGNRL CKZFGNRO CKZFGNRT CKZFGNSG CKZFGNSN CKZFGNSQ CKZFGNTB CKZFGNTC CKZFGNTR CKZFGNTS CKZFGNVA CKZFGNVT CKZFGNXT CKZFLOG2 CKZFLST2 CKZFMETL CKZFNORM CKZFOBJT CKZFOBJZ CKZFPDBG CKZFRTSI CKZFRTSM CKZFRTST CKZFSQLE CKZFUTIL CKZGSIX2 CKZGSIX3 CKZGSIXN CKZGSLSN CKZGSSGN CKZGSTBN CKZGSTS1 CKZGSTS2 CKZGSTS3 CKZGSTSN CKZINCID CKZMSSG CKZPSIX2
Fix information
Fixed component name
DB2 CLONING TOO
Fixed component ID
5655N1000
Applicable component levels
R320 PSY UI93876
UP23/10/05 P F310
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":"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","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
02 November 2023