Column ENDUSR_WORKSTATION CHAR 18 in Sysview for Db2 archive tables

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Noticed the data in column ENDUSR_WORKSTATION, which is in various Sysview Performance Management Option for Db2 for z/OS (IDB2) tables,
is defined as CHAR length 18. CHAR 18 is not large enough to hold the entire value. Is this value being truncated in the SMF records or in the
column due to definition. If the column definition is too small does IDB2 have plans to increase the length. 

Resolution

Searched IDB2 ARCDDL for tables with column ENDUSR_WORKSTATION and found 2 tables:
INSIGHT.APPL_DDF_DETAIL and INSIGHT.APPLICATION_DETAIL

Both tables have definition of: ENDUSR_WORKSTATION VARCHAR(128)

Either this column was modified in the user tables or site using obsolete ARCDDL definitions as the default DDL
provided with the product is different than what is defined in site environment.