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

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.