DatacomDATACOM - ADCISCOMMON SERVICES FOR Z/OS90S SERVICESDATABASE MANAGEMENT SOLUTIONS FOR DB2 FOR Z/OSCOMMON PRODUCT SERVICES COMPONENTCommon ServicesCA ECOMETER SERVER COMPONENT FOCEasytrieve Report Generator for Common ServicesINFOCAI MAINTENANCEIPCUNICENTER JCLCHECK COMMON COMPONENTMainframe VM Product ManagerCHORUS SOFTWARE MANAGERCA ON DEMAND PORTALCA Service Desk Manager - Unified Self ServicePAM CLIENT FOR LINUX ON MAINFRAMEMAINFRAME CONNECTOR FOR LINUX ON MAINFRAMEGRAPHICAL MANAGEMENT INTERFACEWEB ADMINISTRATOR FOR TOP SECRETXpertware
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.