Blocking Transaction Shredded_TransTbl Target Table | Teradata Vantage - Shredded_TransTbl: Blocked Transaction Lock Shredding Target Table - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

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)