Question & Answer
Question
What is causing the duplicate key errors that result in an excessive number of DSNU345I messages when I run the generated CICS Performance Analyzer for z/OS (CICS PA) JCL to export my statistics HDB to DB2?
I get thousands of the following message:
DSNU345I ddd hh:mm:ss.hh DSNURBXD - UNIQUE INDEX KEY DUPLICATES KEY FROM INPUT RECORD
'156006' LOADED AT RID X'000024970D',
INDEX = schema.CPA_HST042A_IX,
TABLE = schema.CPA_HST042A,
RECNO = 156008,
RID = X'000024970F'
Answer
Remove the UNIQUE parameter from the DDL for the CPA_HST042A_IX index to allow duplicates for transient data.
The duplicates are related to extrapartition transient data queues (TDQs). The duplicates occur as the USS stats are written in the same second. CICS Transaction Server for z/OS (CICS TS) module DFHTDOC for Transient Data OPEN or CLOSE will issue a DFHSTSTM macro to write a statistics record when the TDQ is closed.
I used transaction CETR to turn on ST and TD 1-2 tracing and opened and closed an extrapartition TDQ and formatted a snap dump with command verbx dfhpd700 'tr=3,trs=<typetr=(ap34a4,st0003-12)>' to see the statistics record being written from DFHTDOC iproc DFHTDOC ?tdoc_record_uss_stats.
If your TDQs are being opened and closed by automation in the same second, then the USS stats could be written in the same second resulting in duplicates.
Removing the UNIQUE option for the CPA_HST042A_IX for this reason should be okay.
Product Synonym
CICSPA CICS PA;CICS/TS CICSTS CICS TS CICS Transaction Server
Was this topic helpful?
Document Information
Modified date:
25 August 2016
UID
dwa1297120