Category: Query
Database: DBC
| View Column | Data Type | Format | Comment |
|---|---|---|---|
| ProcID | DECIMAL(5,0) NOT NULL | -(5)9 | Returns the process ID of the dispatcher. |
| CollectTimeStamp | TIMESTAMP(6) NOT NULL | YYYY-MM-DDBHH:MI:SS.S(6) | (Prime Key) Time and date when the DBQL Explain cache was written. |
| QueryID | DECIMAL(18,0) NOT NULL | --Z(17)9 | Returns a system-wide unique ID to identify the query. |
| ExpRowNo | INTEGER NOT NULL | --,---,---,--9 | Needed in case multiple rows are used for Explain text. If the additional Explain text uses more than 31000 characters, the system generates multiple rows. |
| ExplainText | VARCHAR(31000) UNICODE NOT CASESPECIFIC NOT NULL | X(31000) | Returns a full Explain Text segment. |