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” on page 380. |
|
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. Note: 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. |
|
XMLRowNo |
Sequence number for XML plans that span more than one row. |
|
XMLTextInfo |
Lock plan represented as an XML document. |