DB13001E DUPLICATE MASTER KEY ERROR - Datacom/AD CA11

Products

• Datacom/AD
• Workload Automation Restart Option for z/OS Schedulers (CA 11)

Issue/Introduction

When performing an upgrade of Datacom/AD for CA11 to version 15.1, the job CAL7LD1 (DBUTLTY LOAD) fails with the following error:

DB13001E - UNEXPECTED RETURN CODE 10 (39) DUPLICATE MASTER KEY ERROR
DB10045E - ABNORMAL TERMINATION DUE TO ERROR(S)

Environment

Z/OS

Datacom/AD upgrade to 15.1 

CA11 (Workload Automation Restart Option for z/OS Schedulers) 11.0 

Cause

The physical backup of the DBID (e.g., DBID 601) was taken while the database was still open in the Multi-User Facility (MUF) or while CA11 was still active. This results in an inconsistent backup that triggers duplicate key errors during the LOAD phase.

Resolution

To resolve this issue, perform the following steps in order:

1. Stop the CA11 instance associated with the database.
2. Close the database in the MUF to ensure all buffers are flushed and the state is consistent.
3. Re-run the physical backup of the CA11 database 
4. Re-run the CA11 upgrade jobs (CAL7AD1, CAL7AD2, and CAL7LD1).

Note: If technical requirements necessitate loading duplicate keys (not recommended for standard CA11 upgrades), you can add LOADDUPS=YES to the DBUTLTY LOAD control card.