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:

For additional information on the use of the SET statement to customize the query environment, see the System Administrator Guide.