SVC Dump RC13(014) Duplicate master key add

Products

• Datacom
• DATACOM - AD
• CIS
• COMMON SERVICES FOR Z/OS
• 90S SERVICES
• DATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OS
• COMMON PRODUCT SERVICES COMPONENT
• Common Services
• CA ECOMETER SERVER COMPONENT FOC
• Easytrieve Report Generator for Common Services
• INFOCAI MAINTENANCE
• IPC
• UNICENTER JCLCHECK COMMON COMPONENT
• Mainframe VM Product Manager
• CHORUS SOFTWARE MANAGER
• CA ON DEMAND PORTAL
• CA Service Desk Manager - Unified Self Service
• PAM CLIENT FOR LINUX ON MAINFRAME
• MAINFRAME CONNECTOR FOR LINUX ON MAINFRAME
• GRAPHICAL MANAGEMENT INTERFACE
• WEB ADMINISTRATOR FOR TOP SECRET
• 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.

Environment

z/os, CA Datacom/DB 15.1

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.

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.