Sysview for Db2 encounters DUPLICATE KEY for the SUBSYS_STORAGE_AS_DETAIL TABLE
search cancel

Sysview for Db2 encounters DUPLICATE KEY for the SUBSYS_STORAGE_AS_DETAIL TABLE

book

Article ID: 186307

calendar_today

Updated On:

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.