Category: Query
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| ProcID | DECIMAL(5,0) NOT NULL | -(5)9 | 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 SQL cache was written. |
| QueryID | DECIMAL(18,0) NOT NULL | --Z(17)9 | System-wide unique ID to identify the query. |
| SqlRowNo | INTEGER NOT NULL | --,---,---,--9 | The row number in the case of multiple rows are used for the SQL. |
| SqlTextInfo | VARCHAR(31000) UNICODE NOT CASESPECIFIC NOT NULL | X(31000) | A full SQL text segment, a string of up to approximately 31,000 characters |
| ParentReqStartTime | TIMESTAMP(6) | YYYY-MMDDBHH:MI:SS.S(6) | The time when the parent request was submitted. |
| ParentQueryID | DECIMAL(18,0) | --Z(17)9 | The parent system generated query id for this query. |