A fix is available
APAR status
Closed as new function.
Error description
Partition related fixes
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of the Db2 Administration Tool * * and Db2 Object Comparison Tool for z/OS. * **************************************************************** * PROBLEM DESCRIPTION: This APAR provides fixes related to * * classic partitioned table spaces, * * tables and indexes. * * * * The following areas are changed: * * * * 1. Alter (ALT) * * 2. Merge * * 3. Compare * **************************************************************** This APAR provides fixes related to classic partitioned table spaces, tables and indexes. The following areas are changed: 1. Alter (ALT): Currently, insert partition is allowed for partitioned by range (PBR) as well as classic partitioned (non UTS) tables, via INS line command on panel ADB27CPV 'Alter Partitioned Table'. Admin tool will now restrict insert partition operation on a table in a classic partitioned tablespace, in line with Db2 behavior. Below error message will be issued: ADB33AE INSERT PARTITION operation is not allowed for table >table name< which is in a non-universal tablespace. 2. Merge: In classic partitioned tablespaces, when you call an ALT on a table to add a partition in the end, it ends up with error: ADB7955E ADBC024E - Unexpected catalog row on source file. Expected:RA found:TP 3. Compare: In classic partitioned tablespaces, when there is increase in partitions from source to target and has associated index-based partition with increase in partitions on source, generated changes file in CMDELTA mode has missing tablespace definition with increased partitions. When such change is registered and analyzed results in compare failure : ADB7955E ADB2CMR Unable to drop partitioning index because related tablespace definition was not found'. Compare has been fixed to generate tablespace definition with increased partitions in generated CMDELTA changes file.
Problem conclusion
Problems have been resolved.
Temporary fix
Comments
APAR Information
APAR number
PH24975
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
C10
Status
CLOSED PER
PE
YesPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function / Xsystem
Submitted date
2020-04-30
Closed date
2020-05-12
Last modified date
2020-06-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI69451
Modules/Macros
ADB0 ADB21II1 ADB21TA ADB21TAV ADB21XAS ADB27AC ADB27AP ADB27C ADB27CPC ADB27CPV ADB27PAS ADB27PTR ADB28MC ADB2CDC ADB2CID ADB2CM1 ADB2CM2 ADB2CM3 ADB2CME ADB2CMF ADB2CML ADB2CMO ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2CMU ADB2DEP ADB2FMT ADB2GDP ADB2IGN ADB2MSK ADB2MSQ ADB2PA ADB2PA4 ADB2PA6 ADB2PA7 ADB2PRP ADB2RE ADB2REE ADB2REG ADB2REH ADB2REM ADB2REP ADB2RER ADB2RES ADB2RET ADB2REU ADB2REY ADB2REZ ADB2RGC ADB2RPT ADB2RS ADB2WCL ADB2WIN ADB2WVL ADB7000 ADB8000 ADBALT ADBCCM ADBCCME ADBCCMM ADBCDTS ADBCEST ADBCEXP ADBCP ADBCRCM ADBCRCR ADBCVC ADBCVCP ADBCVCT ADBCVEX ADBCVEY ADBCVEZ ADBCVIC ADBCVOC ADBDK ADBH1TA ADBH1TAV ADBH7CPV ADBLI ADBMAIN ADBNSPB ADBPA ADBPPDCI ADBTCML ADBTEP2 ADBTEPI ADBTEPU ADBV99 ADBVFC ADBVFCA ADBVFCF ADBVVFG
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RC10 PSY UI69451
UP20/05/14 P F005 A
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"}],"Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021