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?
Release : 20.0
Component : SYSVIEW Performance Management Option for DB2 for z/OS
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.