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” on page 380. |
|
ProcID |
Unique processor ID of the AMP vproc that processed the request. |
|
QueryID |
Internally generated identifier of the query. |
|
XMLRowNo |
Sequence number for XML plans that span more than one row. |
|
XMLTextInfo |
Lock plan represented as an XML document. |
Usage Notes
You cannot shred the contents of the XMLTextInfo column in QryLockLogXML[V]. To shred this column, you must use the underlying table, DBQLXMLockTbl. For details, see “Shredding the Lock Plan Information in the XMLTextInfo Column” on page 348.