Blocking Transaction Shredded_TransTbl Target Table | Teradata Vantage - 17.00 - 17.05 - Shredded_TransTbl: Blocked Transaction Lock Shredding Target Table - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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)