OBJECT_LOCK_INFO view
The OBJECT_LOCK_INFO view returns one row for every lock held for every object on the partition in *SYSBAS and in the current thread's ASP group.
The values returned for the columns in the view are closely related to the values returned by Retrieve Lock Information API and Retrieve Lock Request Information API. Refer to the APIs for more detailed information.
When querying this view, you should use a WHERE clause to restrict the result set to avoid excessive use of system resources.
The following table describes the columns in the view. The schema is QSYS2.
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
OBJECT_SCHEMA | OSCHEMA | VARCHAR(128) | The name of the schema containing the object. |
OBJECT_NAME | NAME | VARCHAR(128) | The name of the object. |
SYSTEM_OBJECT_SCHEMA | SYS_DNAME | VARCHAR(10) | The system library name of the object. |
SYSTEM_OBJECT_NAME | SYS_ONAME | VARCHAR(10) | The system name of the object |
SYSTEM_TABLE_MEMBER | SYS_MNAME | VARCHAR(10) Nullable
|
The name of the member that is
locked in the file. Contains the null value if the lock information is not for a member. |
OBJECT_TYPE | OBJTYPE | VARCHAR(8) | The system object type of the locked object. |
SQL_OBJECT_TYPE | SQLTYPE | VARCHAR(9) Nullable
|
The SQL type of the object. Values
are:
Contains the null value if the object is not an SQL object. |
ASP_NUMBER | ASPNUM | INTEGER | The numeric identifier of the ASP containing the object that is locked. |
ASPGRP | ASPGRP | VARCHAR(10) | The name of the ASP device containing the object that is locked. Can contain the special value of *SYSBAS. |
MEMBER_LOCK_TYPE | LOCK_TYPE | VARCHAR(10) Nullable
|
The type of lock that is held.
Contains the null value if the lock information is not for a member. |
LOCK_STATE | LOCK_STATE | VARCHAR(7) | The lock condition for the object
or member.
|
LOCK_STATUS | STATUS | VARCHAR(9) | The status of the lock.
|
LOCK_SCOPE | LOCK_SCOPE | VARCHAR(10) | The scope of the lock. Values
are:
|
JOB_NAME | JOB_NAME | VARCHAR(28) | The qualified job name. |
THREAD_ID | THREAD_ID | BIGINT Nullable
|
The thread that is associated with
the lock.
|
LOCK_SPACE_ID | LOCKID | BINARY(20) Nullable
|
When the LOCK_SCOPE column value
is LOCK SPACE and the lock is being waited
on by a thread, contains the lock space ID value for which the lock
is being waited on. Otherwise, contains the null value. |
LOCK_COUNT | LOCK_COUNT | INTEGER | The number of identical locks held. |
PROGRAM_LIBRARY_NAME | PROGLIB | VARCHAR(10) Nullable
|
The name of the library containing
the program or service program. Contains the null value if the lock holder information is not available. |
PROGRAM_NAME | PROGNAME | VARCHAR(10) Nullable
|
The name of the program holding
the lock. This can be any type of program object, including objects
of type *PGM and *SRVPGM. Contains the null value if the lock holder information is not available. |
MODULE_LIBRARY | MODLIB | VARCHAR(10) Nullable
|
The library containing the module. Contains the null value if the lock holder information is not available or if the program is not an ILE program. |
MODULE_NAME | MODNAME | VARCHAR(10) Nullable
|
The module containing the ILE procedure. Contains the null value if the lock holder information is not available or if the program is not an ILE program. |
PROCEDURE_NAME | PROCNAME | VARCHAR(10) Nullable
|
The name of the procedure. Contains the null value if the lock holder information is not available. |
STATEMENT_ID | STMTID | CHAR(10) Nullable
|
The high-level language statement
identifier. For a character representation of a number, the number
is right-adjusted and padded on the left with zeros (for example,
'0000000246'). Contains the null value if the lock holder information is not available. |
MACHINE_INSTRUCTION | INSTRUCT | INTEGER Nullable
|
The current machine instruction
number in the program. Contains the null value if the lock holder information is not available or if it is an ILE procedure. |
Example
Find all the jobs holding object locks over the SALES table:
SELECT * FROM QSYS2.OBJECT_LOCK_INFO
WHERE SYSTEM_OBJECT_NAME = 'SALES'