Database: td_metric_svc
Each row stores information about one completed load and export or Data Stream Architecture job.
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 log entry was generated. |
UtilityName | VARCHAR(30) UNICODE NOT CASESPECIFIC | X(30) | Returns the name of the utility. |
FastExportNoSpool | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | For utilities implementing FastExport protocol, 'Y' indicates No Spool mode 'N' indicates Spool mode. |
ExtendedMLoad | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | 'Y' indicates MLOADX being used 'N' indicates MLOADX not being used. |
DSAOperation | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | 'D' indicates DUMP operation 'R' indicates RESTORE operation. |
UtilityRequest | VARCHAR(2048) UNICODE NOT CASESPECIFIC | X(2048) | The main utility SQL request for the job. It contains the target database and table names. The possible statements are: BEGIN LOADING (FastLoad), BEGIN MLOAD (MLOAD/MLOADX), SELECT (FastExport), DUMP/RESTORE (DSA). |
JobName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | DSA job name. Not used for other utilities at this time. |
JobInstance | INTEGER | --,---,---,--9 | DSA job execution ID. Not used for other utilities at this time. |
LSN | INTEGER | --,---,---,--9 | Logon Sequence Number used by the utility job. |
UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Name of the user who ran the utility job. |
SessionID | INTEGER NOT NULL | --,---,---,--9 | Session ID of the control SQL session. |
LogicalHostID | SMALLINT NOT NULL | -(5)9 | Logical Host ID of the control SQL session. |
LogonDateTime | TIMESTAMP(6) NOT NULL | YYYY-MM-DDBHH:MI:SS.S(6) | Date (YYYY-MM-DD) and Time (HH:MM:SS) of the control SQL session logon. |
WDID | INTEGER | --,---,---,--9 | Workload definition assigned to the main utility work. |
FinalWDID | INTEGER | --,---,---,--9 | Workload definition under which the main utility work completed. |
SessionWDID | INTEGER | --,---,---,--9 | Workload definition used for query parsing. |
TDWMRuleID | INTEGER | --,---,---,--9 | RuleId of the TDWM rule that caused a delay. |
CPUDecayLevel | SMALLINT | ---,--9 | Contains most severe decay level reached for CPU usage. |
IODecayLevel | SMALLINT | ---,--9 | Contains most severe decay level reached for I/O usage. |
UserID | BYTE(4) NOT NULL | X(8) | Identifier of the user who submitted the utility job. |
ZoneID | BYTE(4) NOT NULL | X(8) | Zone ID of the user who submitted the utility job. |
AcctString | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Unexpanded Account String of the user who submitted the utility job. |
ExpandAcctString | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | If account expansion was invoked, account string in expanded format. |
AcctStringTime | FLOAT | 99:99:99 | Time (HH:MM:SS) if account string contains $T. |
AcctStringHour | SMALLINT | -(5)9 | Hour (HH) if account string contains $H. |
AcctStringDate | DATE | YY/MM/DD | Date (YY/MM/DD) if account string contains $D. |
LogonSource | CHAR(128) LATIN NOT CASESPECIFIC | X(128) | Identification of the place from where the user accessed the system. |
AppID | CHAR(30) UNICODE NOT CASESPECIFIC | X(30) | Application ID of the utility job. |
ClientID | CHAR(30) UNICODE NOT CASESPECIFIC | X(30) | Client ID of the utility job. |
ClientAddr | CHAR(45) LATIN NOT CASESPECIFIC | X(45) | Client address of the utility job. |
QueryBand | VARCHAR(12304) UNICODE NOT CASESPECIFIC | X(12304) | Query band used in the utility job. |
ProfileID | BYTE(4) | X(8) | Profile ID used for the utility job. |
ProxyUser | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Proxy user used for the utility job. |
ProxyRole | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Proxy role used for the utility job. |
OpEnvID | INTEGER | --,---,---,--9 | Operational Environment ID in which the utility job was executed. |
SysConID | INTEGER | --,---,---,--9 | System Condition ID in which the utility job was executed. |
NoClassification | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Reserved for future use. |
WDOverride | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Reserved for future use. |
ResponseTimeMet | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Reserved for future use. |
DelayTime | FLOAT | ----,---,---,---,--9.999 | Number of seconds the utility job was delayed by TDWM. |
WDDelayTime | INTEGER | --,---,---,--9 | Reserved for future use. |
JobStartTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Job start time. |
JobEndTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Job end time. |
RowsInserted | FLOAT | ----,---,---,---,--9 | Number of rows inserted by the utility job. |
RowsUpdated | FLOAT | ----,---,---,---,--9 | Number of rows updated by the utility job. |
RowsDeleted | FLOAT | ----,---,---,---,--9 | Number of rows deleted by the utility job. |
RowsExported | FLOAT | ----,---,---,---,--9 | Number of rows exported by the utility job. |
NumSesOrBuildProc | SMALLINT | -(5)9 | Number of sessions used. For DSA, number of build processes used. |
MaxDataWaitTime | FLOAT | ----,---,---,---,--9 | The highest wait time in seconds from external source for input data or output requests. |
MaxDataWaitTimeID | INTEGER | --,---,---,--9 | ID associated with the highest wait time. |
Phase0StartTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Returns phase 0 start date and time of the utility job. |
Phase0EndTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Returns phase 0 end date and time of the utility job. |
Phase0TotalCPUTime | FLOAT | ----,---,---,---,--9.999 | Phase 0 total CPU Time in seconds. |
Phase0TotalCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Phase 0 total normalized CPU Time in seconds. |
Phase0ParserCPUTime | FLOAT | ----,---,---,---,--9.999 | Phase 0 Parser and Dispatcher CPU time in seconds. |
Phase0ParserCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Phase 0 normalized Parser and Dispatcher CPU time in seconds. |
Phase0TotalIO | FLOAT | ----,---,---,---,--9 | Phase 0 logical I/O count. |
Phase0IOKB | FLOAT | ----,---,---,---,--9.999 | Phase 0 logical I/O in KB. |
Phase0PhysIO | FLOAT | ----,---,---,---,--9.999 | Returns the number of physical I/Os in phase 0 of the utility job. |
Phase0PhsyIOKB | FLOAT | ----,---,---,---,--9.999 | Returns total physical I/O usage in kilobytes in phase 0 of the utility job. |
Phase0UsedIota | FLOAT | ----,---,---,---,--9.999 | Returns used IOTAs in phase 0 of the utility job. |
Phase1StartTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Returns phase 1 start date and time of the utility job. |
Phase1EndTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Returns phase 1 end date and time of the utility job. |
Phase1TotalCPUTime | FLOAT | ----,---,---,---,--9.999 | Phase 1 total CPU Time in seconds. |
Phase1TotalCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Phase 1 total normalized CPU Time in seconds. |
Phase1MaxCPUTime | FLOAT | ----,---,---,---,--9.999 | Phase 1 highest AMP CPU time in seconds. |
Phase1MaxCPUAmpNumber | INTEGER | --,---,---,--9 | Phase 1 - ID of AMP with highest CPU time. |
Phase1MaxCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Phase 1 highest normalized AMP CPU time in seconds. |
Phase1MaxCPUAmpNumberNorm | INTEGER | --,---,---,--9 | Phase 1 - ID of AMP with highest normalized CPU time. |
Phase1ParserCPUTime | FLOAT | ----,---,---,---,--9.999 | Phase 1 Parser and Dispatcher CPU time in seconds. |
Phase1ParserCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Phase 1 normalized Parser and Dispatcher CPU time in seconds. |
Phase1RSGCPUTime | FLOAT | ----,---,---,---,--9.999 | Phase 1 RSG CPU time in seconds. |
Phase1RSGCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Phase 1 normalized RSG CPU time in seconds. |
Phase1TotalIO | FLOAT | ----,---,---,---,--9 | Phase 1 logical I/O count. |
Phase1MaxIO | FLOAT | ----,---,---,---,--9 | Phase 1 highest logical I/O count. |
Phase1MaxIOAmpNumber | INTEGER | --,---,---,--9 | Phase 1 - ID of AMP with highest logical I/O count. |
Phase1IOKB | FLOAT | ----,---,---,---,--9.999 | Phase 1 logical I/O in KB. |
Phase1PhysIO | FLOAT | ----,---,---,---,--9.999 | Returns the number of physical I/Os in phase 1 of the utility job. |
Phase1PhsyIOKB | FLOAT | ----,---,---,---,--9.999 | Returns total physical I/O usage in kilobytes in phase 1 of the utility job. |
Phase1MaxAWTUsage | BYTEINT | -(3)9 | Phase 1 highest AWT usage. |
Phase1MaxAMPMemoryUsage | FLOAT | ----,---,---,---,--9 | Phase 1 highest AMP memory usage in MBs. |
Phase1MaxRSGMemoryUsage | FLOAT | ----,---,---,---,--9 | Phase 1 highest RSG memory usage in MBs. |
Phase1RowCount | FLOAT | ----,---,---,---,--9 | Phase 1 row count. |
Phase1BlockCount | FLOAT | ----,---,---,---,--9 | Phase 1 block count. |
Phase1ByteCount | FLOAT | ----,---,---,---,--9 | Phase 1 byte count. |
Phase1UsedIota | FLOAT | ----,---,---,---,--9.999 | Returns used IOTAs in phase 1 of the utility job. |
Phase2StartTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Returns phase 2 start date and time of the utility job. |
Phase2EndTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Returns phase 2 end date and time of the utility job. |
Phase2TotalCPUTime | FLOAT | ----,---,---,---,--9.999 | Phase 2 total CPU Time in seconds. |
Phase2TotalCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Phase 2 total normalized CPU Time in seconds. |
Phase2MaxCPUTime | FLOAT | ----,---,---,---,--9.999 | Phase 2 highest AMP CPU time in seconds. |
Phase2MaxCPUAmpNumber | INTEGER | ---,--9 | Phase 2 - ID of AMP with highest CPU time. |
Phase2MaxCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Phase 2 highest normalized AMP CPU time in seconds. |
Phase2MaxCPUAmpNumberNorm | FLOAT | ----,---,---,---,--9.999 | Phase 2 - ID of AMP with highest normalized CPU time. |
Phase2ParserCPUTime | FLOAT | ----,---,---,---,--9.999 | Phase 2 Parser and Dispatcher CPU time in seconds. |
Phase2ParserCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Phase 2 normalized Parser and Dispatcher CPU time in seconds. |
Phase2RSGCPUTime | FLOAT | ----,---,---,---,--9.999 | Phase 2 RSG CPU time in seconds. |
Phase2RSGCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Phase 2 normalized RSG CPU time in seconds. |
Phase2TotalIO | FLOAT | ----,---,---,---,--9 | Phase 2 logical I/O count. |
Phase2MaxIO | FLOAT | ----,---,---,---,--9 | Phase 2 highest logical I/O count. |
Phase2MaxIOAmpNumber | INTEGER | --,---,---,--9 | Phase 2 - ID of AMP with highest logical I/O count. |
Phase2IOKB | FLOAT | ----,---,---,---,--9.999 | Phase 2 logical I/O in KB. |
Phase2PhysIO | FLOAT | ----,---,---,---,--9.999 | Returns the number of physical I/Os in phase 2 of the utility job. |
Phase2PhsyIOKB | FLOAT | ----,---,---,---,--9.999 | Returns total physical I/O usage in kilobytes in phase 2 of the utility job. |
Phase2MaxAWTUsage | BYTEINT | -(3)9 | Phase 2 highest AWT usage. |
Phase2MaxAMPMemoryUsage | FLOAT | ----,---,---,---,--9 | Phase 2 highest AMP memory usage in MBs. |
Phase2MaxRSGMemoryUsage | FLOAT | ----,---,---,---,--9 | Phase 2 highest RSG memory usage in MBs. |
Phase2RowCount | FLOAT | ----,---,---,---,--9 | Phase 2 row count. |
Phase2BlockCount | FLOAT | ----,---,---,---,--9 | Phase 2 block count. |
Phase2ByteCount | FLOAT | ----,---,---,---,--9 | Phase 2 byte count. |
Phase2UsedIota | FLOAT | ----,---,---,---,--9.999 | Returns used IOTAs in phase 2 of the utility job. |
Phase3StartTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Returns phase 3 start date and time of the utility job. |
Phase3EndTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Returns phase 3 end date and time of the utility job. |
Phase3TotalCPUTime | FLOAT | ----,---,---,---,--9.999 | Phase 3 total CPU Time in seconds. |
Phase3TotalCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Phase 3 total normalized CPU Time in seconds. |
Phase3ParserCPUTime | FLOAT | ----,---,---,---,--9.999 | Phase 3 Parser and Dispatcher CPU time in seconds. |
Phase3ParserCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Phase 3 normalized Parser and Dispatcher CPU time in seconds. |
Phase3RSGCPUTime | FLOAT | ----,---,---,---,--9.999 | Phase 3 RSG CPU time in seconds. |
Phase3RSGCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Phase 3 normalized RSG CPU time in seconds. |
Phase3TotalIO | FLOAT | ----,---,---,---,--9 | Phase 3 logical I/O count. |
Phase3IOKB | FLOAT | ----,---,---,---,--9.999 | Phase 3 logical I/O in KB. |
Phase3PhysIO | FLOAT | ----,---,---,---,--9.999 | Returns the number of physical I/Os in phase 3 of the utility job. |
Phase3PhsyIOKB | FLOAT | ----,---,---,---,--9.999 | Returns total physical I/O usage in kilobytes in phase 3 of the utility job. |
Phase3MaxAWTUsage | BYTEINT | -(3)9 | Phase 3 highest AWT usage. |
Phase3MaxAMPMemoryUsage | FLOAT | ----,---,---,---,--9 | Phase 3 highest AMP memory usage in MBs. |
Phase3MaxRSGMemoryUsage | FLOAT | ----,---,---,---,--9 | Phase 3 highest RSG memory usage in MBs. |
Phase3UsedIota | FLOAT | ----,---,---,---,--9.999 | Returns used IOTAs in phase 3 of the utility job. |
Phase4StartTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Returns phase 4 start date and time of the utility job. |
Phase4EndTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Returns phase 4 end date and time of the utility job. |
Phase4TotalCPUTime | FLOAT | ----,---,---,---,--9.999 | Phase 4 total CPU Time in seconds. |
Phase4CPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Phase 4 total normalized CPU Time in seconds. |
Phase4ParserCPUTime | FLOAT | ----,---,---,---,--9.999 | Phase 4 Parser and Dispatcher CPU time in seconds. |
Phase4ParserCPUTimeNorm | FLOAT | ----,---,---,---,--9.999 | Phase 4 normalized Parser and Dispatcher CPU time in seconds. |
Phase4TotalIO | FLOAT | ----,---,---,---,--9 | Phase 4 logical I/O count. |
Phase4IOKB | FLOAT | ----,---,---,---,--9.999 | Phase 4 logical I/O in KB. |
Phase4PhysIO | FLOAT | ----,---,---,---,--9.999 | Returns the number of physical I/Os in phase 4 of the utility job. |
Phase4PhysIOKB | FLOAT | ----,---,---,---,--9.999 | Returns total physical I/O usage in kilobytes in phase 4 of the utility job. |
Phase4UsedIota | FLOAT | ----,---,---,---,--9.999 | Returns used IOTAs in phase 4 of the utility job. |
Stream_Metrics | VARBYTE(256) | X(512) | Reserved for future use. |
ReservedField1 | VARBYTE(10000) | X(20000) | Reserved for future use. |
ReservedField2 | VARBYTE(10000) | X(20000) | Reserved for future use. |
ProfileName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the profile, if any, under which the user submitted the utility job. |
WDName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the workload definition (WD) name assigned to the utility job. |
FinalWDName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the workload definition name in which the utility job completed execution. |
SessionWDName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns workload definition name associated with the session. |
OpEnvName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the operating environment activated by the Teradata dynamic workload management software. |
SysConName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the system condition activated by the Teradata dynamic workload management software. |
DeferTime | FLOAT | ----,---,---,---,--9.999 | The number of seconds a query was deferred by workload management due to an ARM. This is the number of seconds from the time the dispatcher gets the query (after parsing) until it is moved to the Delay Queue, or rejected, or allowed to run. |
DeferRuleID | INTEGER | --,---,---,--9 | TDWM Rule ID of one of the ARM rules which caused this request to be deferred. |
TDWMAdmissionTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | The time when a request is admitted into the system by workload management (i.e., after ARM processing). |