DB00501E - Return Code 51(002) when running DBUTLTY EXTRACT

Products

• Datacom/DB
• DATACOM - AD

Issue/Introduction

Datacom utility DBUTLTY EXTRACT SEQ=NATIVE fails with DB00501E and Return Code 51(002)  during batch execution. This error indicates an invalid mix of jobs where the utility cannot gain the exclusive access required for database operations because the database is currently in use by another process.

Environment

Z/OS

Datacom 15.1 

Cause

DBUTLTY EXTRACT SEQ=NATIVE requires exclusive access to the database (DBID). If a User Requirements Table (URT) is open or if the database is actively being used by another process, such as a CICS region or another batch job , DBUTLTY fails.

Resolution

1. Identify and close all open URTs associated with the target DBID.
2. Verify if the DBID is used in a CICS region; if so, close the URT in CICS.
3. Close the database (DBID) in the Multi-User Facility (MUF) before initiating the native extract job.
4. Resubmit the DBUTLTY job after verifying that no other processes hold the database open