Blocking Transaction Shredded_TransTbl Target Table | VantageCloud Lake - Shredded_TransTbl: Blocked Transaction Lock Shredding Target Table - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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_LockTbl 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)
LockObjectRequested The type of object on which the blocked request needs a lock
Possible values include the following:
  • D (database)
  • D (table)
  • R (row hash)
  • RK (row hash in one partition)
  • RN (row key range)
  • RP(row hash in partition range)
  • TP (table partition range)