Sysview for DB2 (IDB2) encounters DUPLICATE KEY for the SUBSYS_STORAGE_AS_DETAIL TABLE
book
Article ID: 186307
calendar_today
Updated On:
Products
Bind Analyzer for DB2 for z/OSSQL-Ease for DB2 for z/OSSYSVIEW Performance Management Option for DB2 for z/OSPlan Analyzer for DB2 for z/OSSubsystem Analyzer for DB2 for z/OSDatabase Management for DB2 for z/OS - Performance SuiteDatabase Management for DB2 for z/OS - SQL Performance SuiteInsight 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.