Range of the SET LOCKMODE Statement
With the SET LOCKMODE statement, you can:
• Set locking parameters for a particular table. For example:
set lockmode on emp where readlock = nolock;
• Set locking parameters for the duration of a session. For example:
set lockmode session where readlock = nolock;
If multiple SET LOCKMODE statements are issued for the same session or table, the most recent statement is the one in effect. Setting a locking parameter on a specific table has precedence over the session setting. Any lockmode settings issued during a session end when that session ends.