Sysview for Db2 encounters DUPLICATE KEY for the SUBSYS_STORAGE_AS_DETAIL TABLE

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

The Sysview Performance Management Option for Db2 for z/OS (IDB2) archive process encounters DUPLICATE KEY
when loading to the SUBSYS_STORAGE_AS_DETAIL table.

Cause

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

Sysview for Db2 r20 PTF SO12078 has been developed to address this problem condition.