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

Article Id: 143165
Status: Published
Updated On: 11-03-2020 13:32
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.