Category: Query
Database: DBC
| View Column | Data Type | Format | Comment |
|---|---|---|---|
| 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/or table name(s). 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. |
| JobInstanceID | 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. |
| 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 | ZZ,ZZZ,ZZ9.999 | Phase 0 total CPU Time in seconds. |
| Phase0TotalCPUTimeNorm | FLOAT | ZZ,ZZZ,ZZ9.999 | Phase 0 total normalized CPU Time in seconds. |
| Phase0ParserCPUTime | FLOAT | ZZ,ZZZ,ZZ9.999 | Phase 0 Parser and Dispatcher CPU time in seconds. |
| Phase0ParserCPUTimeNorm | FLOAT | ZZ,ZZZ,ZZ9.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. |
| Phase0PhysIOKB | FLOAT | ----,---,---,---,--9.999 | Returns total physical I/O usage in kilobytes 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 | ZZ,ZZZ,ZZ9.999 | Phase 1 total CPU Time in seconds. |
| Phase1TotalCPUTimeNorm | FLOAT | ZZ,ZZZ,ZZ9.999 | Phase 1 total normalized CPU Time in seconds. |
| Phase1MaxCPUTime | FLOAT | ZZ,ZZZ,ZZ9.999 | Phase 1 highest AMP CPU time in seconds. |
| Phase1MaxCPUAmpNumber | INTEGER | --,---,---,--9 | Phase 1 - ID of AMP with highest CPU time. |
| Phase1MaxCPUTimeNorm | FLOAT | ZZ,ZZZ,ZZ9.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 | ZZ,ZZZ,ZZ9.999 | Phase 1 Parser and Dispatcher CPU time in seconds. |
| Phase1ParserCPUTimeNorm | FLOAT | ZZ,ZZZ,ZZ9.999 | Phase 1 normalized Parser and Dispatcher CPU time in seconds. |
| Phase1RSGCPUTime | FLOAT | ZZ,ZZZ,ZZ9.999 | Phase 1 RSG CPU time in seconds. |
| Phase1RSGCPUTimeNorm | FLOAT | ZZ,ZZZ,ZZ9.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. |
| Phase1PhysIOKB | 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. |
| 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 | ZZ,ZZZ,ZZ9.999 | Phase 2 total CPU Time in seconds . |
| Phase2TotalCPUTimeNorm | FLOAT | ZZ,ZZZ,ZZ9.999 | Phase 2 total normalized CPU Time in seconds. |
| Phase2MaxCPUTime | FLOAT | ZZ,ZZZ,ZZ9.999 | Phase 2 highest AMP CPU time in seconds. |
| Phase2MaxCPUAmpNumber | INTEGER | ZZ,ZZZ,ZZ9.999 | Phase 2 - ID of AMP with highest CPU time. |
| Phase2MaxCPUTimeNorm | FLOAT | ZZ,ZZZ,ZZ9.999 | Phase 2 highest normalized AMP CPU time in seconds. |
| Phase2MaxCPUAmpNumberNorm | INTEGER | --,---,---,--9 | Phase 2 - ID of AMP with highest normalized CPU time. |
| Phase2ParserCPUTime | FLOAT | ZZ,ZZZ,ZZ9.999 | Phase 2 Parser and Dispatcher CPU time in seconds. |
| Phase2ParserCPUTimeNorm | FLOAT | ZZ,ZZZ,ZZ9.999 | Phase 2 normalized Parser and Dispatcher CPU time in seconds. |
| Phase2RSGCPUTime | FLOAT | ZZ,ZZZ,ZZ9.999 | Phase 2 RSG CPU time in seconds. |
| Phase2RSGCPUTimeNorm | FLOAT | ZZ,ZZZ,ZZ9.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. |
| Phase2PhysIOKB | 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. |
| 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 | ZZ,ZZZ,ZZ9.999 | Phase 3 total CPU Time in seconds. |
| Phase3TotalCPUTimeNorm | FLOAT | ZZ,ZZZ,ZZ9.999 | Phase 3 total normalized CPU Time in seconds. |
| Phase3ParserCPUTime | FLOAT | ZZ,ZZZ,ZZ9.999 | Phase 3 Parser and Dispatcher CPU time in seconds. |
| Phase3ParserCPUTimeNorm | FLOAT | ZZ,ZZZ,ZZ9.999 | Phase 3 normalized Parser and Dispatcher CPU time in seconds. |
| Phase3RSGCPUTime | FLOAT | ZZ,ZZZ,ZZ9.999 | Phase 3 RSG CPU time in seconds. |
| Phase3RSGCPUTimeNorm | FLOAT | ZZ,ZZZ,ZZ9.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. |
| Phase3PhysIOKB | 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. |
| 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 | ZZ,ZZZ,ZZ9.999 | Phase 4 total CPU Time in seconds. |
| Phase4TotalCPUTimeNorm | FLOAT | ZZ,ZZZ,ZZ9.999 | Phase 4 total normalized CPU Time in seconds. |
| Phase4ParserCPUTime | FLOAT | ZZ,ZZZ,ZZ9.999 | Phase 4 Parser and Dispatcher CPU time in seconds. |
| Phase4ParserCPUTimeNorm | FLOAT | ZZ,ZZZ,ZZ9.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. |
| Phase0UsedIota | FLOAT | ----,---,---,---,--9.999 | Returns used IOTAs in phase 0 of the utility job. |
| Phase1UsedIota | FLOAT | ----,---,---,---,--9.999 | Returns used IOTAs in phase 1 of the utility job. |
| Phase2UsedIota | FLOAT | ----,---,---,---,--9.999 | Returns used IOTAs in phase 2 of the utility job. |
| Phase3UsedIota | FLOAT | ----,---,---,---,--9.999 | Returns used IOTAs in phase 3 of the utility job. |
| Phase4UsedIota | FLOAT | ----,---,---,---,--9.999 | Returns used IOTAs in phase 4 of the utility job. |
| 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 currently activated by the Teradata dynamic workload management software. |
| SysConName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Returns the name of the system condition currently activated by the Teradata dynamic workload management software. |
| DeferTime | FLOAT | ZZ,ZZZ,ZZ9.999 | The number of seconds a query was deferred by workload management due to ARM rules. |
| 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). |