The Sysview for Db2 archive process encounters discarded rows when loading to APPL_DDF_DETAIL and APPLICATION_DETAIL tables
search cancel

The Sysview for Db2 archive process encounters discarded rows when loading to APPL_DDF_DETAIL and APPLICATION_DETAIL tables

book

Article ID: 143165

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

Attempts to load data into the Sysview Performance Management Option for Db2 for z/OS (IDB2) history database tables encounters discarded rows. 
Rows are discarded from the  APPL_DDF_DETAIL and APPLICATION_DETAIL tables.

DSNURCON - RECORD (nnnnn) WILL BE DISCARDED DUE TO INVALID               
'ENDUSR_WORKSTATION' COLUMN SPECIFICATION FOR INSIGHT.APPLICATION_DETAIL

Cause

The cause of the discarded rows is due to the ENDUSR_WORKSTATION value being greater than the predefined 128 bytes.

Resolution

IDB2 r20 PTF SO11977 has been developed to correct this condition.