RRULOCK—Use U lock for repeatable reads
Use the Modify Use U Locks For Repeatable Reads panel or the RRULOCK command to specify whether repeatable read (RR) or read stability (RS) cursors will use the U (UPDATE) lock to access a table. If NO is specified, the lock mode for operations with RR or RS is S (SHARE).
If BMC AMI Ops Monitor for Db2 reports indicate that they are spending a lot of time waiting for update locks, you can set RRULOCK to access the tables using S locks, and increase the concurrency of the reports.
Modify Use U Locks For Repeatable Reads panel
Command ===> _________________________________________________________________
Command: CURRENT
Description . . . . . . . . : USE U LOCK FOR REPEATABLE READS
Type the new Use U Locks for Repeatable Reads you wish to change to. Then Press Enter.
Use U Locks For Repeatable Reads Indicator
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 | Use the U (UPDATE) lock to access a table |
N | Use the S (SHARE) lock to access a table |
NORESET | The changes you request remain in effect until the Db2 subsystem is cycled. |
Db2 parameter values
Field | Installation panel | CLIST parameter | ZPARM macro | ZPARM parameter |
|---|---|---|---|---|
Enabled | DSNTIPI | RRULOCK | DSN6SPRM | RRULOCK |