Category: Query
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| ProcID | DECIMAL(5,0) NOT NULL | -(5)9 | The process ID of the dispatcher. |
| CollectTimeStamp | TIMESTAMP(6) NOT NULL | YYYY-MM-DDBHH:MI:SS.S(6) | (Prime Key) Date and time when cache was written. |
| QueryID | DECIMAL(18,0) NOT NULL | --Z(17)9 | A system-wide unique ID to identify the query. |
| XMLRowNo | INTEGER NOT NULL | --,---,---,--9 | Indicates the row number for multiple rows used to capture the XML query plan. If the XML text is greater than 31000 characters, the system generates multiple rows. |
| XMLTextInfo | VARCHAR(31000) UNICODE NOT CASESPECIFIC NOT NULL | X(31000) | The query plan represented as an XML document. |
| XMLDocType | INTEGER | --,---,---,--9 | Identifies the query logging options whose associated data is included in column XMLTextInfo. |
| XMLPlanEnabled | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | XMLPlanEnabled = Y if XMLPLAN query logging option is enabled else N. |
| StatsUsageEnabled | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | StatsUsageEnabled = Y if STATSUSAGE query logging option is enabled else N. |
| VerboseEnabled | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | VerboseEnabled = Y if VERBOSE query logging option is enabled else N. |
| DetailedStatsEnabled | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | DetailedStatsEnabled = Y if DETAILED query logging option is enabled else N |
| HasXMLPlanData | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | HasXMLPlanData = Y if XMLPLAN option data is contained in XMLTextInfo else N. |
| HasStatsUsageData | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | HasStatsUsageData = Y if STATSUSAGE option data is contained in XMLTextInfo else N. |
| HasVerboseData | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | HasVerboseData = Y if VERBOSE option data is contained in XMLTextInfo else N. |
| HasDetailedStatsData | VARCHAR(1) UNICODE NOT CASESPECIFIC | X(1) | HasDetailedStatsData = Y if DETAILED option data is contained in XMLTextInfo else N. |
| 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. |