Bind options for locks

Certain BIND options determine when an application process acquires and releases its locks and how it isolates its actions from effects of concurrent processes.

Choosing a RELEASE option
The RELEASE bind option controls when an application releases locks that it acquires on objects such as partitions, tables, or table spaces that it accesses. It applies only to partition, table, and table space locks.
Choosing an ISOLATION option
Various isolation levels offer less or more concurrency at the cost of more or less protection from other application processes.
Choosing a CURRENTDATA option
The CURRENTDATA option of an application specifies whether data currency is required for read-only and ambiguous cursors when the ISOLATION(CS) option is used. This option enables a trade-off between the improved ability of multiple applications to access the same data concurrently and the risk that non-current data might be returned to the application.
Conflicting plan and package bind options
A plan bound with one set of options can include packages in its package list that were bound with different sets of options.

Parent topic: Programming for concurrency