ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
Sysview for DB2 (IDB2) encounters DUPLICATE KEY for the SUBSYS_STORAGE_AS_DETAIL TABLE
Article ID: 186307
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 SuiteDetector for DB2 for z/OSInsight Performance Monitor for DB2 UDB for z/OS
The Sysview for DB2 (IDB2) archive process encounters DUPLICATE KEY when loading to the SUBSYS_STORAGE_AS_DETAIL table.
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.
Release : 20.0
Component : CA Insight Database Performance Monitor for DB for z/OS
PTF SO12078 has been developed to address this problem condition.