Datacom MASSADD DB13037E INPUT RECORD NOT ADDED , KEY ALREADY EXISTS

Products

• Datacom/DB
• Datacom
• Datacom/AD

Issue/Introduction

Running Datacom utility DBUTLTY  MASSADD and getting report output like this:

                   RECORD **22512000 SUCCESSFULLY ADDED

                   RECORD **22513000 SUCCESSFULLY ADDED

DB13037E - INPUT RECORD (22513226) NOT ADDED, KEY ALREADY EXISTS

                                 ADDED

                   PRD      22,513,225

                   DB10045E - ABNORMAL TERMINATION DUE TO ERROR(S)

Was a transaction backout done? 

Environment

Datacom/DB all versions

Resolution

No transaction backout is done for this DBUTLTY MASSADD job. When a duplicate record is found ,  the record is not added and DBUTLTY stops processing . 

The DB13037E message indicates what input record number is the duplicate . In this case it's number 22513226.

As mentioned in the error message action, restart the DBUTLTY MASSADD using the STARTAFT parameter . So restart the MASSADD using STARTAFT= 22513226 .

Additional Information

For documentation on DBUTLTY MASSADD , see MASSADD (Add Records to Table).