Database: td_metric_svc
Stores information on the target objects of the query being logged. One row is logged for each object referenced by the query.
| 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. |
| ObjectDatabaseName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Name of the database that owns the target object. |
| ObjectTableName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of table or view. |
| ObjectColumnName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the column. |
| ObjectID | BYTE(4) NOT NULL | X(8) | Returns the internal ID of the object. |
| ObjectNum | INTEGER | --,---,---,--9 | Returns the number of the index in the table. |
| ObjectType | CHAR(3) LATIN NOT CASESPECIFIC NOT NULL | X(3) | Returns a character code indicating the type of object targeted. D is for database level, T for table level, Q for Backup or restore of selected partitions or J for journal. |
| FreqofUse | INTEGER | --,---,---,--9 | Returns the number of times the object was accessed, as determined by the Optimizer, to process the query. |
| TypeofUse | BYTEINT | -(3)9 | Returns the use of the object. |
The view also contains ExtraFieldX columns that are reserved for future use.
Example: dbqlobjV - SELECT
The following SELECT statement retrieves the object information of a query:
SELECT QueryID, ObjectDatabaseName (Named ObjDBName), ObjectTableName (Named ObjTblName), ObjectColumnName (Named ObjColName), ObjectID (Named ObjId), ObjectNum (Named ObjNum), ObjectType (Named ObjType), FreqofUse FROM td_metric_svc.dbqlobjV where queryid = 201205134619838031;
Result:
QueryID ObjDBName ObjTblName ObjColName ObjID ObjNum ObjType FreqofUse ------------------ ----------- ---------- ---------- -------- ------- -------- ------ 201205134619838031 D_PERSONNEL ? ? 00001604 0 DB 1 201205134619838031 D_PERSONNEL DEPARTMENT ? 00009005 0 Tab 1 201205134619838031 D_PERSONNEL DEPARTMENT DeptNo 00009005 1,025 Col 2 201205134619838031 D_PERSONNEL DEPARTMENT DeptName 00009005 1,026 Col 1 201205134619838031 D_PERSONNEL DEPARTMENT EmpCount 00009005 1,027 Col 1 201205134619838031 D_PERSONNEL DEPARTMENT Loc 00009005 1,028 Col 1