IBM Support

DSNU345I when running CICSPA JCL to export statistics HDB to DB2

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.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSPPU4","label":"CICS Performance Analyzer for z\/OS"},"Platform":[{"code":"PF035","label":"z\/OS"}],"Component":"","Version":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}},{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSGMGV","label":"CICS Transaction Server"},"Platform":[{"code":"PF035","label":"z\/OS"}],"Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Product Synonym

CICSPA CICS PA;CICS/TS CICSTS CICS TS CICS Transaction Server

Document Information

Modified date:
25 August 2016

UID

dwa1297120