16.10 - Shredded_TransTbl: Blocked Transaction Lock Shredding Target Table - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
16.10
Release Date
April 2018
Content Type
Administration
Publication ID
B035-1093-161K
Language
English (United States)

The TargetDBName.Shredded_TransTbl stores additional shredded data for all blocked transactions involved in a lock contention. This table joins with the related table Shredded_LockTbl. The exact name of the target table is specified by the call to the stored procedure LockLogShredder.SP_CreateTable.

Shredded_TransTbl field Description
QueryID Unique query ID for joining with Shredded_LockTbl or other DBQL tables
TransactionOrder Sequence order of the blocked transaction
DatabaseName The database containing the object on which the blocked request is waiting for a lock
TableName The table on which the blocked request is waiting for a lock
RequestID_1 Byte 1 of the ID of the blocked request
RequestID_2 Byte 2 of the ID of the blocked request
unique_1 Part 1 of the transaction ID of the blocked request
unique_2 Part 2 of the transaction ID of the blocked request
PEVproc PE vproc of the blocked request
TransactionState Transaction state of the blocked request
Possible values include the following:
  • Inactive
  • Active
  • DontAbort
  • Aborting
  • PKAborted
TransactionStartTime Start time of the blocked transaction
StepNum_1 Part 1 of the step number of the blocked request
StepNum_2 Part 2 of the step number of the blocked request
SessionID_1 Part 1 of the Session ID of the blocked request
SessionID_2 Part 2 of the Session ID of the blocked request
SessionID_Combined Combined session ID of the blocked request, as recorded in SessionTbl
LockStatus Lock status of the blocked transaction
Possible values include the following:
  • Waiting
  • Granted
LockTypeRequested Type of lock requested by the blocked request
Possible values include the following:
  • Access
  • Read
  • Write
  • Exclusive
  • IAccess (intentional access)
  • IRead (intentional read)
  • IWrite (intentional write)
  • IExclusive (intentional exclusive))
  • Read4X (read for exclusive)
  • IRead4X (intentional read for exclusive)
  • Read4W (read for write)
  • ReadHL (read host utility lock)
  • IReadHL (intentional read host utility lock)
LockObjectRequested The type of object on which the blocked request needs a lock
Possible values include the following:
  • D (database)
  • T (table)
  • R (row hash)
  • RK (row hash in one partition)
  • RN (row key range)
  • RP (row hash in partition range)
  • TP (table partition range)