The TargetDBName.Shredded_LockTbl stores shredded lock contention data for the blocking transaction and the first transaction that is blocked by it. The exact name of the target table is specified by the call to the stored procedure LockLogShredder.SP_CreateTable.
| Shredded_LockTbl field | Description |
|---|---|
| DatabaseName | The database containing the object locked by the blocker |
| TableName | The table locked by the blocker |
| RequestID_1 | Byte 1 of the request ID of the blocker |
| RequestID_2 | Byte 2 of the request ID of the blocker |
| unique_1 | Part 1 of the transaction ID of the blocker |
| unique_2 | Part 2 of the transaction ID of the blocker |
| PEVproc | PE vproc of the blocker |
| TransactionState | Transaction state of the blocker Possible values include the following:
|
| TransactionStartTime | Transaction start time of the blocker |
| StepLevel | The dispatcher recorded step level of the blocker |
| StepNum_1 | Part 1 of the step number of the blocker |
| StepNum_2 | Part 2 of the step number of the blocker |
| StatementNo | The statement number of the blocker |
| SessionID_1 | Part 1 of the session ID of the blocker |
| SessionID_2 | Part 2 of the session ID of the blocker |
| SessionID_Combined | Combined session ID of blocker, as recorded in SessionTbl |
| UserName | User name of the blocker |
| AccountName | Account name of the blocker |
| ExpReqProc | Originating vproc of the internal express request lock of the blocker |
| seq_1 | Part 1 of the logon sequence number of a HUT lock blocker |
| seq_2 | Part 2 of the logon sequence number of a HUT lock blocker |
| LogicalHostId | Logical host ID of the blocker |
| ZoneId | Secure zone ID of the blocker |
| MessageClass | Internal AMP message class ID of the blocker |
| MessageKind | Internal AMP message kind ID of the blocker |
| MessageClassName | Internal AMP message class name of
the blocker Possible values include the
following:
|
| MessageKindName | Internal AMP message kind name of the blocker |
| WorkLevel | Operation work level number of the blocker |
| OperationType | Type of SQL operation being performed by the blocker |
| JobType | Job types Possible values include the following:
|
| SQLType | Type of SQL performed in the operation of the blocker |
| LockTypeRequested | Type of lock requested by the
blocker Possible values include the
following:
|
| LockObjectRequested | Type of object on which the blocker
requested a lock Possible values include the
following:
|
| LockKindRequested | The kind of lock requested by the
blocker Possible values include the
following:
|
| BlkedDatabaseName | The database containing the object on which the blocked request is waiting for a lock |
| BlkedTableName | The table on which the blocked request is waiting for a lock |
| BlkedRequestID_1 | Byte 1 of the ID of the blocked request |
| BlkedRequestID_2 | Byte 2 of the ID of the blocked request |
| Blkedunique_1 | Part 1 of the transaction ID of the blocked request |
| Blkedunique_2 | Part 2 of the transaction ID of the blocked request |
| BlkedPEVproc | PE vproc of the blocked request |
| BlkedTransactionState | Transaction state of the blocked
request Possible values include the
following:
|
| BlkedTransactionStartTime | Start time of the blocked transaction |
| BlkedStepNum_1 | Part 1 of the step number of the blocked request |
| BlkedStepNum_2 | Part 2 of the step number of the blocked request |
| BlockedSessionID_1 | Part 1 of the Session ID of the blocked request |
| BlockedSessionID_2 | Part 2 of the session ID of the blocked request |
| BlockedSessionID_Combined | Combined session ID of the blocked request as recorded in SessionTbl |
| BlockedUserName | User name for the blocked request |
| BlockedAccountName | Account name for the blocked request |
| BlockedExpReqProc | Originating vproc of the internal express request lock of the blocked request |
| Blockedseq_1 | Part 1 of the logon sequence number for the blocked request |
| Blockedseq_2 | Part 2 of the logon sequence number for the blocked request |
| BlockedLogicalHostId | Logical host ID of the blocked request |
| BlockedStartPartition | Starting partition number for the partition-level lock of the blocked request |
| BlockedStartRowhashInt | Starting row hash number for the partition-level lock of the blocked request |
| BlockedEndPartition | Ending partition number for the partition-level lock of the blocked request |
| BlockedEndRowHashInt | Ending row hash number for the partition-level lock of the blocked request |
| BlockedLockTypeRequested | Type of lock requested by the
blocked request Possible values include the
following:
|
| BlockedLockObjectRequested | The type of object on which the
blocked request needs a lock Possible values
include the following:
|
| BlockedLockKindRequested | The kind of lock requested by the
blocked request Possible values include the
following:
|
| LockDelay | Delay time of the blocked request in centiseconds |
| LocalDeadLock | True if a local deadlock is detected, otherwise false |
| GlobalDeadLock | True if a global deadlock is detected, otherwise false |
| MultipleBlocker | True if there are multiple blocked requests, otherwise false |
| AmpVproc | AMP number where the lock contention occurred |
| QueryID | Unique query ID for joining with related lock shredded tables or other DBQL tables |
| CollectTimeStamp | Timestamp of when the lock contention was recorded |
| DelayStartTime | Timestamp of when the lock delay began |
| ErrorText | Error text associated with the lock contention, if any |
| AbortFlag | True if the lock contention has resulted in an abort |
| ErrorCode | Error code associated with the lock contention, if any |
| TransactionCount | Number of additional blocked transactions |