Locks

Use this page to view the current resource locks on this server.

Owner Process ID
The process ID (PID) of a process that has issued a lock or wishes to issue a lock.
Owner Process TID
The thread/task ID that owns the process.
Owner Lock Info
The Job No and Job Step of the lock owner.
ID
The resource ID allocated to the locked resource for the purposes of linking the information in the Lock Ownership part of the table with the information in the Resource Details part of the table.
Type
The type of lock.
State
The state of the lock. Possible states are:
Controlled
The requester has control of the resource.
Waiting
The requester is waiting to gain control of the resource (synchronous request).
Pending
The requester has issued the request but has continued with other asynchronous request.
Persistence
Displays how long the lock lasts. Possible values are:
LUW
The lock lasts until the logical unit of work ends.
Task
The lock lasts until the task ends.
Lock Manager
There is no implicit release of the lock.
Process
The lock lasts until the process ends.
Sequence
The order in which requesters are to be handled.