Field help (APROMODE)

Locking request method. This column corresponds to the locking method of the requestor and represents the method granted, the conversion method or the pending method.

Possible values:

0 = NULL. No access is accorded to the resource. Serves as reserved space.
1 = Sch-S (Stability of the structure). Guarantees that the element of a structure, such as a table or an index, is not deleted when a session containing a structure stability lock on the structure element.
2 = Sch-M (Modification of the structure). Must contained by all sessions destined to be modify the structure of the specified resource. Guarantee that no other session makes reference to the indicated object.
3 = S (Shared). The session maintaining the lock can have a shared access to the resource.
4 = U (Update). Indicates that an update lock has been set on the resources that can finally be updated. Used to avoid current blocking forms that arise when several sessions lock the resources for any potential update.
5 = X (Exclusive). The session maintaining the lock can have a exclusive access to the resource.
6 = IS (Shared intent). Indicates the intention to place the S lock on certain sub-ordinate resources in the locking hierarchy.
7 = IU (Update intent). Indicates the intention to place the U lock on certain sub-ordinate resources in the locking hierarchy.
8 = IX (Exclusive intent). Indicates the intention to place the X lock on certain sub-ordinate resources in the locking hierarchy.
9 = SIU (Update of the Shared intent locks). Signals the shared access to a resource with the goal of setting the update locks on the sub-ordinate resources in the locking hierarchy.
10 = SIX (Exclusive Share intent). Signals the shared access to a resource with the goal of setting the exclusive locks on the sub-ordinate resources in the locking hierarchy.
11 = UIX (Exclusive Update intent). Signals an update lock on a resource with the goal of setting exclusive locks on the sub-ordinate resources in the locking hierarchy.
12 = BU. Used by the operations by block.
13 = RangeS_S (shared keys lock and shared resource lock). Indicates an analysis by range.
14 = RangeS_U(shared keys lock and resource update lock). Indicates an update by range.
15 = RangeI_N (extended key insertion lock and NULL resource lock). Used to test the extensions before the insertion of a new key in an index.
16 = RangeI_S. Key conversion lock, created by a superposition of the RangeI_N and S locks.
17 = RangeI_U. Key conversion lock, created by a superposition of the RangeI_N and U locks.
18 = RangeI_X. Key conversion lock, created by a superposition of the RangeI_N and X locks.
18 = RangeX_S. Key conversion lock, created by a superposition of the RangeI_N and RangeS_S locks.
20 = RangeX_U. Key conversion lock, created by a superposition of the RangeI_N and RangeS_U locks.
21 = RangeX_X (Exclusive resource lock, exclusive extended). Conversion lock used when the update of a key is expected.