BLOCKING option

Function

Controls the behavior in response to locking conflicts.

Allowed values

OFF

Scope

Can be set for an individual connection or the PUBLIC group. Takes effect immediately.

Default

OFF

Description

When BLOCKING is OFF, a transaction receives an error when it attempts a write operation and it is blocked by another transaction's read lock.