Shredded_TransTbl: Blocked Transaction Lock Shredding Target Table - Teradata Database

Teradata Database Administration
Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

Shredded_TransTbl: Blocked Transaction Lock Shredding Target Table

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 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

    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)
    		•