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

book

Article ID: 186307

calendar_today

Updated On:

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 Detector for DB2 for z/OS 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.

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.  

Environment

Release : 20.0

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

Resolution

PTF SO12078 has been developed to address this problem condition.