16.10 - View of the XML Lock Log Table: QryLockLogXML[V] - 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)

The QryLockLogXML[V] view of DBQLXMLLOCKTbl 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.

QryLockLogXML[V] 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.
XMLTextInfo Lock plan represented as an XML document.