A fix is available
APAR status
Closed as program error.
Error description
Change Management ANALYZE reporting incorrect PAGENUM during alter of PBR.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Db2 Administration Tool for z/OS 13.1 users * * who use the Analyze function in Change * * Management * **************************************************************** * PROBLEM DESCRIPTION: Change Management Analyze incorrectly * * reports that the Compare source has * * PAGENUM ABSOLUTE when the source has * * PAGENUM RELATIVE. * **************************************************************** * RECOMMENDATION: ............................................ * **************************************************************** Change Management Analyze incorrectly reports that the Compare source has PAGENUM ABSOLUTE. This incorrect Analyze report is generated when the following conditions are met: - The target table is changed from PBG to PBR based on the Compare source. - The source table space has relative page numbers (PAGENUM RELATIVE). - The target table cannot be converted from PBG to PBR by using an ALTER TABLE <table name> ALTER PARTITIONING statement. The change requires the table space to be dropped and recreated. The incorrect Analyze report contains the following text: (I)ALTER to PBR not possible, because the source has PAGENUM ABSOLUTE After this APAR is applied, this erroneous information is not reported in the Analyze report. Keywords: PBG to PBR, PAGENUM ABSOLUTE
Problem conclusion
Problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PH60368
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
D10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2024-03-14
Closed date
2024-03-25
Last modified date
2024-04-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI96229
Modules/Macros
ADB2CMT ADB2PA6
Fix information
Fixed component name
DB2 ADMIN TOOL
Fixed component ID
568851500
Applicable component levels
RD10 PSY UI96229
UP24/03/27 P F403
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":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
04 April 2024