DB2:getLockInfo

List all locks in the currently connected database.

Note: This method can be used IF-AND-ONLY-IF you have access and privileges to execute SYSPROC database objects.

Type

SYNC, IMPACT_INFO

Arguments

None.

Returns

Name

Type

Description

Lock Name

String

Lock Name

Member Id

Integer

Database member from which the data was retrieved for this row.

Lock Mode

String

Lock Mode is one of: G ==> Represents the mode that the application is currently holding the lock in, W or C ==>> Represents the mode that the application is currently waiting to acquire the lock in.

Lock status

String

Lock status.

Application handle

Big Integer

Application handle is one of: G ==> Represents the application that is currently holding the lock, W or C ==> Represents the application that is currently waiting to acquire the lock.

Table Space ID

Big Integer

Table Space ID.

Usage Notes

Invoking this method returns information about all locks that are currently active on the connected database.