ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Inconsistent Column Definition In IDB2 Archive Tables

book

Article ID: 238177

calendar_today

Updated On:

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.