A fix is available
APAR status
Closed as program error.
Error description
When running compare with SYSTABLESPACE, TRACKMOD ignored the lack of SYSTABLEPART ignore for TRACKMOD. This results in implicit LOB tablespaces being compared. The SYSTABLESPACE TRACKMOD ignore should be extended to prevent the implicit LOB tablespace from being compared. The generated ADMIN ALTER fails with SQLCODE - 109 due to a Db2 restriction for altering TRACKMOD for implicit LOB Tablespaces.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * * who also use Object Comparison Tool * **************************************************************** * PROBLEM DESCRIPTION: When running compare with SYSTABLESPACE * * TRACKMOD ignored, the lack of an * * ignore for SYSTABLEPART TRACKMOD * * results in implicit LOB table spaces * * being compared. * **************************************************************** When a user runs compare with SYSTABLESPACE TRACKMOD ignored, and the SYSTABLEPART TRACKMOD is not also ignored, implicit LOB table spaces are still compared. To fix this, the TRACKMOD ignore for SYSTABLESPACE has been expanded to also include SYSTABLEPART so any implicit LOB table spaces also get included in the ignore. Keywords: TRACKMOD IGNORE SYSTABLESPACE SYSTABLEPART COMPARE
Problem conclusion
The problem has been solved.
Temporary fix
Comments
APAR Information
APAR number
PH51314
Reported component name
DB2 ADMIN TOOL
Reported component ID
568851500
Reported release
C10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2022-12-06
Closed date
2023-02-27
Last modified date
2023-03-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ADB2CME
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:
02 March 2023