A fix is available
APAR status
Closed as program error.
Error description
Db2 Admin Tool missing support for IGNORE for field CREATEDTS in SYSIBM.SYSKEYS DESCRIPTION: CREATEDTS is a new field in v12 for the SYSIBM.SYSKEYS catalog table. The Db2 Admin tool is missing IGNORE support for this field. For example If an IGNORE is created for SYSIBM.SYSKEYS column CREATEDTS. The compare fails with ADBC007E - Invalid field name in IGNORES file record 4
Local fix
na
Problem summary
**************************************************************** * USERS AFFECTED: Users of Db2 Administration Tool for z/OS * * and Db2 Object Comparison Tool for z/OS * **************************************************************** * PROBLEM DESCRIPTION: The ignore feature in Db2 Object * * Compare does not support the * * SYSIBM.SYSKEYS CREATEDTS field. * **************************************************************** When an ignore file includes the field CREATEDTS for SYSKEYS, the compare process fails with the following error: ADBC007E - Invalid field name in IGNORES file record >line_number< Keyword: ADBC007E
Problem conclusion
The problem has been resolved.
Temporary fix
Comments
APAR Information
APAR number
PH46599
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-05-19
Closed date
2022-09-12
Last modified date
2022-10-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI82372 UI82378
Modules/Macros
ADB0 ADB2CDC ADB2CM3 ADB2CME ADB2CMF ADB2CMO ADB2CMP ADB2CMR ADB2CMS ADB2CMT ADB2CMU ADB2IGN ADB2MSK ADB2REC ADB2REG ADB2REM ADB2REP ADB2REU ADB2RGC ADB2RPT ADBCCMM ADBCDTS ADBCVCT ADBDT
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 October 2022