Inconsistent Column Definition In IDB2 Archive Tables

Products

• SYSVIEW Performance Management Option for DB2 for z/OS
• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

These two Columns are defined as ENDUSR_TRANSACTION   VARCHAR(255) and ENDUSR_WORKSTATION   VARCHAR(255) in tables APPLICATION_DETAIL and APPL_DDF_DETAIL 

but they are defined as ENDUSR_TRANSACTION VARCHAR(128) and ENDUSR_WORKSTATION VARCHAR(128) in the these Tables: AUDIT_AUTHFAIL_DETAIL, AUDIT_DDL_DETAIL, AUDIT_DML_DETAIL, AUDIT_DCL_DETAIL, AUDIT_ADMIN_AUTH_DETAIL, AUDIT_UTILITY_DETAIL, AUDIT_DML_BIND_DETAIL, AUDIT_TRACE_DETAIL, AUDIT_AUTH_CHANGES_DETAIL, AUDIT_TRUSTED_CON_DETAIL, AUDIT_COMMAND_DETAIL and APPL_SQL_INCOMPAT_DETAIL 
Is there any valid reason for this difference?

Environment

Release : 20.0

Component : SYSVIEW Performance Management Option for DB2 for z/OS

Resolution

All of the AUDIT archive tables have a known issue that does not allow to update them using the migration utility. Because of that these two columns were not updated in any of them. There is a feature in Sustaining Engineer backlog to address this issue but there is no ETA for it yet.