A fix is available
APAR status
Closed as new function.
Error description
Eliminate unnecessary REORGs when running changes.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * * and Db2 Object Comparison Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: When Object Compare adds new partitions * * to the table in a partition-by-range * * (PBR) table space, the generated work * * statement list (WSL) might not have * * optimal apply statements if the new * * partition is added between existing * * logical partitions. * * When Object Compare adds new partition * * between existing logical partitions, * * partition-level attributes might be * * applied from the wrong logical * * partition. * **************************************************************** This APAR improves Object Compare processing of partitions in a PBR table space and reduces the number of generated ALTER TABLE and REORG statements when new partitions are added.
Problem conclusion
The enhancement has been delivered.
Temporary fix
Comments
APAR Information
APAR number
PH52639
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
YesSpecatt / New Function / Xsystem
Submitted date
2023-02-15
Closed date
2023-03-01
Last modified date
2023-04-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI90810 UI90811
Modules/Macros
ADB2CME ADB2CMR ADB2CMT ADB2IGN ADB2REG ADBCCMM ADBCDTS
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
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":"12.1.0","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
03 April 2023