Sysview for DB2 (IDB2) encounters DUPLICATE KEY for the SUBSYS_STORAGE_AS_DETAIL TABLE

Products

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

Issue/Introduction

The Sysview for DB2 (IDB2) archive process encounters DUPLICATE KEY when loading to the SUBSYS_STORAGE_AS_DETAIL table.

Environment

Release : 20.0

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

Cause

The CA SYSVIEW Performance Management Option for DB2 for z/OS (IDB2) captures unexpected trace records IFCID 225 into the history file when a -MODIFY TRACE Db2 command is issued. This may lead to generation of duplicate keys in data to be loaded into the SUBSYS_STORAGE_AS_DETAIL archive table. The duplicate key records are discarded from loading.  

Resolution

PTF SO12078 has been developed to address this problem condition.