Datacom DBUTLTY LOCK/UNLOCK affect ADDIT or DELET

Products

• Datacom
• DATACOM - AD
• Datacom/DB
• Datacom/AD

Issue/Introduction

The Datacom DBUTLTY LOCK/UNLOCK functions are used for preventing records from moving around within a compressed area however will it prevent an Add (ADDIT) or Delete (DELET) from occurring?

Environment

Release: All releases

 

Resolution

The DBUTLTY function LOCK with OPTION=MOVER only does what is documented in section LOCK (Lock a Data Area):

The LOCK function allows you to back up a data area, specifically a compressed data area, while the MUF is running. By granting this request, DBUTLTY inhibits an update that moves data records until the UNLOCK function is issued. 

Any Index Area and data area buffers with pending writes are written to DASD for the specified area when this function is executed.

A lock, when granted, remains in effect until an unlock is done or the MUF is terminated.

To clarify, the LOCK function:

• flushes the pipeline buffers for both compressed or uncompressed areas
  
  
• only prevents an UPDAT command that attempts to move a row in a compressed area. 
  
  
• If the data area is not compressed, it will NOT prevent the updating of the data
  
  
• it does not have any effect on ADDITs or DELETs in compressed or uncompressed areas. 

 

Additional Information

See the Datacom documentation on the LOCK (Lock a Data Area).