26.3 Examples

This example executes the adbls -d lock command to display the status of each locked resource.

Explanation of the output items

RESOURCETYPE

Displays the type of locked resources for which an allocation request is issued by the application program or command. One of the following is displayed:

• SINGLE_CONNECTION: Single connection

• DATABASE_ACCESS: Database access

• DICTIONARY: Dictionary

• DBAREA: DB area

  This is a data DB area, dictionary DB area, or a system-table DB area.

• TABLE: Table

  This is a table to be processed, a system table, or a dictionary table.

• PREPARE_TABLE: This is a pre-processing table.

RESOURCEID

Displays the ID of each locked resource for which an allocation request was issued by an application program or a command.

• If the type of locked resource is single connection, database access, or dictionary

  Asterisk (*) is displayed.

• If the type of locked resource is DB area

  The DB area's ID is displayed.

• If the type of locked resource is table or pre-processing table

  The table's ID is displayed.

  If a locked resource allocation request has been issued for a dictionary table, the table ID of the dictionary table (base table) is displayed. If a locked resource allocation request has been issued for a system table, the table ID of the system table (base table) is displayed.

LOCK_MODE

Displays the lock mode. One of the following is displayed:

• EXCLUSIVE: Exclusive mode (EXCLUSIVE) (EX)

• PRTCT_UPD: Protected update mode (PROTECTED UPDATE) (PU)

• SHARE_UPD: Shared update mode (SHARED UPDATE) (SU)

• SHARE: Shared retrieval mode (SHARED RETRIEVE) (SR)

NODE_NO

When the multi-node function is being used, displays the node number of the node that issued the locked resource allocation request.

When the multi-node function is not being used, nothing is displayed.

CID

Displays the connection ID of the connection that issued the locked resource allocation request.

If the maintenance processing of the updated-row columnizing facility issues a locked resource allocation request, "SYSTEM" is displayed.

STATUS

Displays the status of the locked resource allocation request. One of the following is displayed:

• WAITING: Waiting for allocation of the locked resource

• LOCKING: Allocating the locked resource

• ESCALAT: Waiting for the transition of the lock mode

• SYSWAIT: Waiting until the resource locked previously by the maintenance processing of the updated-row columnizing facility is unlocked

COUNT

Displays the number of times the locked resource has been allocated by the same transaction.

If the locked resource has never been allocated, nothing is displayed.

LOCK_TIME

Displays the first time a locked resource allocation request was issued.

ESCALAT_MODE

If ESCALAT is output to the STATUS column, the lock mode that is applied after transition from the current lock mode is displayed.

If a value other than ESCALAT is output to the STATUS column, nothing is displayed.

• EXCLUSIVE: Exclusive mode (EXCLUSIVE) (EX)

• PRTCT_UPD: Protected update mode (PROTECTED UPDATE) (PU)

• SHARE_UPD: Shared update mode (SHARED UPDATE) (SU)

• SHARE: Shared retrieval mode (SHARED RETRIEVE) (SR)

Note

For details about locked resources and the lock mode, see the topic Locking in Architecture in the HADB Setup and Operation Guide.

To Page Top