The IDB2 Archive Process encounters discarded rows when loading to APPL_DDF_DETAIL and APPLICATION_DETAIL tables

book

Article ID: 143165

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS CA Database Management for DB2 for z/OS - Performance Suite CA Database Management for DB2 for z/OS - SQL Performance Suite CA Detector for DB2 for z/OS CA-Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

Attempts to load data into SYSVIEW for DB2's Insight database tables encounters discarded rows.  They are discarded from the  APPL_DDF_DETAIL and APPLICATION_DETAIL tables.

 

Cause

The cause of the discarded rows is due to the Enduser_Workstation value being greater than the predefined 128 bytes.
This is a bug.

Environment

Release : 20.0

Component : CA Insight Database Performance Monitor for DB for z/OS

Resolution

PTF SO11977 https://support.broadcom.com/download-center/solution-detail.html?aparNo=SO11977&os=z%2FOS has been developed to correct this condition.