16.10 - XML Lock Log Table: DBQLXMLLockTbl - 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)

This table is populated if the WITH LOCK option is requested in addition to the default information row. Each row stores a subset of the XML document recording lock delays. The table has no primary index (NoPI) and no fallback.

DBC.DBQLXMLLOCKTbl field Description
CollectTimeStamp Date and time when the lock contention is recorded. This is different from the time when the contention first occurs. A field inside XMLTextInfo represents the start time of the contention.

The lock contention may be recorded minutes after it begins, depending on when the information is flushed to the AMP. The default AMP flush rate is 10 minutes. To find when the lock was finally granted, add the lock delay duration to the start time.

For more information on CollectTimeStamp, see Comparing CollectTimeStamp Value Between Tables.

ProcID Unique processor ID of the AMP vproc that processed the request.
QueryID Internally generated identifier of the query and the foreign key to other DBQL tables.
QueryID is a system-wide unique field. You can use QueryID to join DBQL tables or join the DBC.TdwmExceptionLog table with DBQL tables without needing ProcID as an additional join field.
XMLTextInfo Lock plan represented as an XML document.