Database: td_metric_svc
Stores the full SQL text of the query. One query string may require more than one row.
| View Column | Data Type | Format | Comment |
|---|---|---|---|
| Location | VARCHAR(2048) UNICODE CASESPECIFIC | X(2048) | Path to metric data objects. |
| path_component_id | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | Operational group (primary cluster or compute cluster) ID. |
| path_collecttimestamp | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | Timestamp of when collected the given metrics. |
| path_year | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The year in which the data was recorded in the table. |
| path_month | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The month in which the data was recorded in the table. |
| path_day | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The date on which the data was recorded in the table. |
| path_hour | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The hour at which the data was recorded in the table. |
| path_minute | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The minute at which the data was recorded in the table. |
| path_ver | VARCHAR(8000) UNICODE CASESPECIFIC | X(8000) | The version of Vantage software that was running on the operational group. |
| 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) | Returns the time that the query log was generated. |
| ParentReqStartTime | TIMESTAMP | YYYY-MM-DDBHH:MI:SS.S(6) | Returns the time when the parent request was submitted. |
| QueryID | DECIMAL(18,0) NOT NULL | -(18)9 | Returns the QueryId column contains the generated query id for the given query. |
| ParentQueryID | DECIMAL | -(18)9 | Returns the parent system generated query id for this query. |
| ZoneID | BYTE(4) NOT NULL | X(8) | Returns the zone ID. |
| SqlRowNo | INTEGER NOT NULL | --,---,---,--9 | Returns 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. |
The view also contains ExtraFieldX columns that are reserved for future use.
Example: dbqlsqlV - SELECT
The following SELECT statement retrieves the SQL text information of a query.
SELECT QueryID, SqlRowNo, SqlTextInfo from td_metric_svc.dbqlsqlV
WHERE QueryId=201205134619838024;
Result:
QueryID SqlRowNo SqlTextInfo ------------------ -------- ---------------------------- 201205134619838024 1 CREATE TABLE table1A, FALLBACK, NO BEFORE JOURNAL, NO AFTER JOURNAL (i INTEGER, i2 INTEGER) PRIMARY INDEX( i );
The SQL text is not edited to remove any blanks; it is stored the same way you entered it.