CA Datacom DBUTLTY LOCK/UNLOCK affect ADDIT or DELET?

book

Article ID: 15350

calendar_today

Updated On:

Products

CA Datacom CA Datacom - AD CA Datacom/AD CA Datacom/DB

Issue/Introduction

The CA 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

Component: CA Datacom/Ad or DB

Resolution

The DBUTLTY function LOCK with OPTION=MOVER only does what is documented in the manual:

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.

 

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 CA Datacom documentation on the LOCK function.