Provides information pertaining to the most recent deadlocks that have occurred in Adaptive Server. You can tune the maximum number of messages returned with deadlock pipe max messages. Requires the enable monitoring, deadlock pipe max messages, and deadlock pipe active configuration parameters to be enabled.
Name |
Datatype |
Attributes |
Description |
|---|---|---|---|
DeadLockID |
int |
Unique identifier for the deadlock |
|
VictimKPID |
int |
KPID of the victim process for the deadlock |
|
ResolveTime |
datetime |
Time at which the deadlock was resolved |
|
ObjectDBID |
int |
Unique database identifier for database where the object resides |
|
PageNumber |
int |
Page number for which the lock was requested, if applicable |
|
RowNumber |
int |
Row number for which the lock was requested, if applicable |
|
HeldFamilyId |
smallint |
SPID of the parent process of the process holding the lock |
|
HeldSPID |
smallint |
SPID of process holding the lock |
|
HeldKPID |
int |
KPID of process holding the lock |
|
HeldProcDBID |
int |
Unique identifier for the database where the stored procedure that caused the lock to be held resides, if applicable |
|
HeldProcedureID |
int |
Unique object identifier for the stored procedure that caused the lock to be held, if applicable |
|
HeldBatchID |
int |
Unique batch identifier for the SQL code being executed by the process holding the lock when it was blocked by another process (not when it acquired the lock) |
|
HeldContextID |
int |
Unique context identifier for the process holding the lock when it was blocked by another process (not when it acquired the lock) |
|
HeldLineNumber |
int |
Line number within the batch of the statement being executed by the process holding the lock when it was blocked by another process (not when it acquired the lock) |
|
WaitFamilyId |
smallint |
SPID of the parent process of the process waiting for the lock |
|
WaitSPID |
smallint |
SPID of the process waiting for the lock |
|
WaitKPID |
int |
KPID of the process waiting for the lock |
|
WaitTime |
int |
Amount of time in milliseconds that the waiting process was blocked before the deadlock was resolved |
|
ObjectName |
varchar(30) |
null |
Name of the object |
HeldUserName |
varchar(30) |
null |
Name of the user for whom the lock is being held |
HeldApplName |
varchar(30) |
null |
Name of the application holding the lock |
HeldTranName |
varchar(255) |
null |
The name of the transaction in which the lock was acquired |
HeldLockType |
varchar(20) |
null |
The type of lock being held |
HeldCommand |
varchar(30) |
The command being executed that caused the lock to be held |
|
WaitUserName |
varchar(30) |
null |
Name of the user for whom the lock is being requested |
WaitLockType |
varchar(20) |
null |
The type of lock requested |
