A fix is available
APAR status
Closed as new function.
Error description
GOC - 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
Problem have been resolved.
Temporary fix
Comments
APAR Information
APAR number
PH24976
Reported component name
DB2 OBJECT COMP
Reported component ID
5697G6400
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:
UI69452
Modules/Macros
GOCGCMP
Fix information
Fixed component name
DB2 OBJECT COMP
Fixed component ID
5697G6400
Applicable component levels
RC10 PSY UI69452
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