SVC Dump RC13(014) Duplicate master key add

book

Article ID: 131349

calendar_today

Updated On:

Products

CA Datacom - DB CA Datacom CA Datacom - AD CA Datacom - Server CA CIS CA Common Services for z/OS CA 90s Services CA Database Management Solutions for DB2 for z/OS CA Common Product Services Component CA Common Services CA Datacom/AD CA ecoMeter Server Component FOC CA Easytrieve Report Generator for Common Services CA Infocai Maintenance CA IPC Unicenter CA-JCLCheck Common Component CA Mainframe VM Product Manager CA Chorus Software Manager CA On Demand Portal CA Service Desk Manager - Unified Self Service CA PAM Client for Linux for zSeries CA Mainframe Connector for Linux on System z CA Graphical Management Interface CA Web Administrator for Top Secret CA CA- Xpertware

Issue/Introduction

PXX dump rc 13 (014) Duplicate Master Key produced at random.

Our MUF is still up but we would like to know why these dump are produced and how to correct it.

Cause

Timing issue.

Job was deleting Accounting rows but these rows were not committed yet.

At the same time, new rows were added by Accounting generating RC 13(014) - Duplicate Master Key Error.

Environment

z/os, CA Datacom/DB 15.1

Resolution

A way to prevent duplicate master keys on table A02 would be to close this table via accounting with console command ACCT CLOSE=A02 (or if more tables are involved with ACCT CLOSE=ALL) before you run the DELET job.
 
You would need to wait until accounting has cleared its buffers, i.e. until either message DB01103I or DB01101I has been issued, and then start the DELET job. The above accounting CLOSE commands can also be issued via DBUTLTY. 

Additional Information

 You may want to change operations to not Delete rows from table A02 at the same time as Accounting is Adding new rows with the same key values.