Troubleshooting Datacom DB02841W 'WAIT DELAY OTHER LOCKV MVR' during DBUTLTY LOAD

Products

• Datacom
• Datacom/DB

Issue/Introduction

Users may encounter a hang or excessive wait times during Datacom utility jobs (like LOAD or EXTRACT), accompanied by the following message in the MUF log:

DB02841W - WAIT DELAY 'OTHER LOCKV MVR' MIN:SEC-[TIME] [JOBNAME] [ID] LOCKV[AREA] [DBID]

Querying SYSADM.MUF_LOCKS_VALUE shows active locks for the DBID and Area, such as:

• DBSMVR [DBID] [AREA] E (Exclusive lock held by a MOVER process)

 

Cause

This issue occurs under two primary conditions:

1. Orphaned Locks: A previous utility job (like a failed MOVE or LOAD) may have crashed or been cancelled without releasing the exclusive lock on the database area.
   
   
2. Incorrect Command Sequencing: Attempting to run a DBUTLTY LOAD while an explicit LOCK OPTION=MOVER is active. The LOAD function requires exclusive access to the database; if a LOCK is already active, the MUF sees the database as 'in use' and prevents the utility from proceeding.

Resolution

1. Clear Existing Locks

If a lock was left behind by a previous failed job, run the UNLOCK function to reset the status for the affected DBID and Area:

UNLOCK OPTION=MOVER,DBID=[DBID],AREA=[AREA]

2. Correct Procedure for DBUTLTY LOAD

Do not use the LOCK command when performing a LOAD. Instead, follow this sequence to ensure the database is properly offline and accessible only to the utility:

1. Close Database in CICS: Ensure the database is closed in any active CICS regions.
   
   
2. Turn Off Access: Prevent new MUF connections to the database:
   

   DBUTLTY ACCESS DBID=[DBID],STATUS=OFF,USERS=FAIL

3. Close MUF Connections: Close the database in the MUF:
   

   DBUTLTY CLOSE DBID=[DBID]

4. Execute LOAD: Run your DBUTLTY LOAD function without a LOCK card.
   
   
5. Restore Access: Re-enable access for applications:
   

   DBUTLTY ACCESS DBID=[DBID],STATUS=WRITE

6. Open Database in CICS: Reopen the database on any active CICS regions.

Additional Information

To check for current active locks within the MUF, run the following SQL query:

SELECT * FROM SYSADM.MUF_LOCKS_VALUE;