Category: Query
Database: DBC
| View Column | Data Type | Format | Comment |
|---|---|---|---|
| ProcID | DECIMAL(5,0) NOT NULL | -(5)9 | Unique processor ID of the AMP vproc that processed the request. |
| CollectTimeStamp | TIMESTAMP(6) NOT NULL | YYYY-MM-DDBHH:MI:SS.S(6) | 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. |
| QueryID | DECIMAL(18,0) NOT NULL | --Z(17)9 | (Internally generated identifier of the query and the foreign key to other DBQL tables. |
| XMLTextInfo | CLOB(1048576) UNICODE NOT CASESPECIFIC NOT NULL | X(32000) | Returns the XML text describing the lock contention of each AMP involved in lock. |