Was this helpful?
Set Statements and Locking Strategy
There are a variety of SET statements you can use to manage your locking strategy.
Be sure you are using user-defined lockmodes and isolation levels to their fullest to avoid concurrency and deadlock. For assistance with strategy, see the chapter “Understanding the Locking System.” For command syntax, see your query language reference guide.
Pay particular attention to:
Deadlock
Lock_trace flag
Maxlocks
Readlock = nolock
Timeout
For additional information on the use of the SET statement to customize the query environment, see the System Administrator Guide.
Last modified date: 11/28/2023