RELCURHL—Release locks for cursor
Use the Modify Release Locks for Cursor panel or the RELCURHL command to enable or disable the bypassing of lock promotion of data locks for CURSOR WITH HOLD. Lock promotion holds a lock across a commit until the next commit. Bypassing lock promotion releases a lock at the current commit.
Reducing the duration of held locks in applications that use CURSOR WITH HOLD can reduce lock contention that leads to threads timing out.
Modify Release Locks for Cursor panel
Command ===> _________________________________________________________________
Command: CURRENT
Description . . . . . . . . : RELEASE LOCKS FOR CURSOR
Type the new Release Locks for Cursor Indicator you wish to change to. Then press Enter.
Bypass Release Locks for Cursor
Enabled . . . . . . . . . . _ ( Y or N )
Command syntax and parameters
Value | Description |
|---|---|
DB2ssid | Db2 subsystem ID or the name of the Db2 data sharing group to which the command applies. |
opertuneID | OPERTUNE system profile name (if OPERTUNE is running as a started task) or the batch job name (if OPERTUNE is running as a batch job). |
Y | Bypass lock promotion (page/row locks will be released for cursors held at commit). |
N | Do not bypass lock promotion (page or row locks will not be released for cursors held at commit). |
NORESET | The changes you request remain in effect until the Db2 subsystem is cycled. |