A fix is available
APAR status
Closed as program error.
Error description
Customer did a DDL with GEN on a PRE VERSION 12 FL500 tablespace and underlying OBJECTS. They then used that ddl as source and did a compare against the CATALOG, which generated unnecessary alters on tablespaces and indexes. After applying APAR number PH49601, the process worked for all the fields, except the SECQTYI in SYSINDEXES.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: Object Compare generates unnecessary * * ALTER statements for INDEX SECQTY when * * comparing objects that were created * * after version 12 with migrated objects * * that were created prior to version 12. * **************************************************************** After running GEN on migrated objects that were created prior to version 12 and comparing the resulting DDL against the catalog, Object Compare reports that the INDEX SECQTY attribute changed from NULL to <VALUE> when no change exists. Keywords: SECQTY, NULL
Problem conclusion
The problem has been resolved. Compare will now properly consider the SECQTY of the migrated objects when determining the change.
Temporary fix
Comments
APAR Information
APAR number
PH51895
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
2023-01-12
Closed date
2023-03-20
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:
UI90946 UI90957
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:
03 April 2023