15.10 - QryLogUtilityV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Query

DBC

 

View Column

Data Type

Format

Source Table.Column

ProcID

(Composite NUPI)

DECIMAL(5,0)

NOT NULL

-(5)9

DBQLUtilityTbl.ProcID

CollectTimeStamp

(Composite NUPI)

TIMESTAMP(6)

NOT NULL

YYYY-MM-DDBHH:MI:SS.S(F)Z

DBQLUtilityTbl.CollectTimestamp

UtilityName

VARCHAR(30)

UNICODE

NOT CASE SPECIFIC

X(30)

DBQLUtilityTbl.UtilityName

FastExportNoSpool

CHAR(1) LATIN

NOT CASE SPECIFIC

X(1)

DBQLUtilityTbl.FastExportNoSpool

ExtendedMLoad

CHAR(1) LATIN

NOT CASE SPECIFIC

X(1)

DBQLUtilityTbl.ExtendedMLoad

DSAOperation

CHAR(1) LATIN

NOT CASE SPECIFIC

X(1)

DBQLUtilityTbl.DSAOperation

UtilityRequest

VARCHAR(2048)

UNICODE

NOT CASE SPECIFIC

X(2048)

DBQLUtilityTbl.UtilityRequest

JobName

VARCHAR(128)

UNICODE

NOT CASE SPECIFIC

X(128)

DBQLUtilityTbl.JobName

JobInstanceID

INTEGER

--,---,---,--9

DBQLUtilityTbl.JobInstanceID

LSN

INTEGER

--,---,---,--9

DBQLUtilityTbl.LSN

UserName

VARCHAR(128)

UNICODE

NOT CASE SPECIFIC

X(128)

DBQLUtilityTbl.UserName

SessionID

INTEGER

NOT NULL

--,---,---,--9

DBQLUtilityTbl.SessionID

LogicalHostID

SMALLINT

NOT NULL

ZZZ9

DBQLUtilityTbl.LogicalHostID

LogonDateTime

TIMESTAMP(6)

NOT NULL

YYYY-MM-DDBHH:MI:SS

DBQLUtilityTbl.LogonDateTime

WDID

INTEGER

--,---,---,--9

DBQLUtilityTbl.WDID

FinalWDID

INTEGER

--,---,---,--9

DBQLUtilityTbl.FinalWDID

SessionWDID

INTEGER

--,---,---,--9

DBQLUtilityTbl.SessionWDID

TDWMRuleID

INTEGER

--,---,---,--9

DBQLUtilityTbl.TDWMRuleID

CPUDecayLevel

SMALLINT

---,--9

DBQLUtilityTbl.CPUDecayLevel

IODecayLevel

SMALLINT

---,--9

DBQLUtilityTbl.IODecayLevel

UserID

BYTE(4)

NOT NULL

X(8)

DBQLUtilityTbl.UserID

AcctString

VARCHAR(128)

UNICODE

NOT CASE SPECIFIC

X(128)

DBQLUtilityTbl.AcctString

ExpandAcctString

VARCHAR(128)

UNICODE

NOT CASE SPECIFIC

X(128)

DBQLUtilityTbl.ExpandAcctString

AcctStringTime

TIME

99:99:99

DBQLUtilityTbl.AcctStringTime

AcctStringHour

SMALLINT

--9

DBQLUtilityTbl.AcctStringHour

AcctStringDate

DATE

YY/MM/DD

DBQLUtilityTbl.AcctStringDate

LogonSource

CHAR(128) LATIN

NOT CASE SPECIFIC

X(128)

DBQLUtilityTbl.LogonSource

AppID

CHAR(30)

UNICODE

NOT CASE SPECIFIC

X(30)

DBQLUtilityTbl.AppID

ClientID

CHAR(30)

UNICODE

NOT CASE SPECIFIC

X(30)

DBQLUtilityTbl.ClientID

ClientAddr

CHAR(45) LATIN

NOT CASE SPECIFIC

X(45)

DBQLUtilityTbl.ClientAddr

QueryBand

VARCHAR(6160)

UNICODE

NOT CASE SPECIFIC

X(6160)

DBQLUtilityTbl.QueryBand

ProfileID

BYTE(4)

X(8)

DBQLUtilityTbl.ProfileID

ProxyUser

VARCHAR(128)

UNICODE

NOT CASE SPECIFIC

X(128)

DBQLUtilityTbl.ProxyUser

ProxyRole

VARCHAR(128)

UNICODE

NOT CASE SPECIFIC

X(128)

DBQLUtilityTbl.ProxyRole

OpEnvID

INTEGER

--,---,---,--9

DBQLUtilityTbl.OpEnvID

SysConID

INTEGER

--,---,---,--9

DBQLUtilityTbl.SysConID

NoClassification

Note: This column is reserved for future use.

CHAR(1) LATIN

NOT CASE SPECIFIC

X(1)

DBQLUtilityTbl.NoClassification

WDOverride

Note: This column is reserved for future use.

CHAR(1) LATIN

NOT CASE SPECIFIC

X(1)

DBQLUtilityTbl.WDOverride

ResponseTimeMet

Note: This column is reserved for future use.

CHAR (1) LATIN

NOT CASE SPECIFIC

X(1)

DBQLUtilityTbl.ResponseTimeMet

DelayTime

FLOAT

----,---,---,---,--9.999

DBQLUtilityTbl.DelayTime

JobStartTime

TIMESTAMP(6)

YYYY-MM-DDBHH:MI:SS.S(F)Z

DBQLUtilityTbl.JobStartTime

JobEndTime

TIMESTAMP(6)

YYYY-MM-DDBHH:MI:SS.S(F)Z

DBQLUtilityTbl.JobEndTime

RowsInserted

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.RowsInserted

RowsUpdated

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.RowsUpdated

RowsDeleted

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.RowsDeleted

RowsExported

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.RowsExported

NumSesOrBuildProc

SMALLINT

ZZZZ9

DBQLUtilityTbl.NumSesOr
BuildProc

MaxDataWaitTime

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.MaxDataWaitTime

MaxDataWaitTimeID

INTEGER

--,---,---,--9

DBQLUtilityTbl.MaxDataWaitTime
ID

Phase0StartTime

TIMESTAMP(6)

YYYY-MM-DDBHH:MI:SS.S(F)Z

DBQLUtilityTbl.Phase0StartTime

Phase0EndTime

TIMESTAMP(6)

YYYY-MM-DDBHH:MI:SS.S(F)Z

DBQLUtilityTbl.Phase0EndTime

Phase0TotalCPUTime

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase0TotalCPU
Time

Phase0TotalCPUTimeNorm

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase0TotalCPU
TimeNorm

Phase0ParserCPUTime

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase0ParserCPU
Time

Phase0ParserCPUTimeNorm

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase0ParserCPU
TimeNorm

Phase0TotalIO

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase0TotalIO

Phase0IOKB

FLOAT

----,---,---,---,--9.999

DBQLUtilityTbl.Phase0IOKB

Phase0PhysIO

FLOAT

----,---,---,---,--9.999

DBQLUtilityTbl.Phase0PhysIO

Phase0PhysIOKB

FLOAT

----,---,---,---,--9.999

DBQLUtilityTbl.Phase0PhysIOKB

Phase1StartTime

TIMESTAMP(6)

YYYY-MM-DDBHH:MI:SS.S(F)Z

DBQLUtilityTbl.Phase1StartTime

Phase1EndTime

TIMESTAMP(6)

YYYY-MM-DDBHH:MI:SS.S(F)Z

DBQLUtilityTbl.Phase1EndTime

Phase1TotalCPUTime

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase1TotalCPU
Time

Phase1TotalCPUTimeNorm

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase1TotalCPU
TimeNorm

Phase1MaxCPUTime

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase1MaxCPU
Time

Phase1MaxCPUAmpNumber

SMALLINT

---,--9

DBQLUtilityTbl.Phase1MaxCPU
AmpNumber

Phase1MaxCPUTimeNorm

FLOAT

ZZ,ZZZ,ZZ9.999

DBQUtilityTbl.Phase1MaxCPU
TimeNorm

Phase1MaxCPUAmpNumber
Norm

SMALLINT

---,--9

DBQLUtilityTbl.Phase1MaxCPU
AmpNumberNorm

Phase1ParserCPUTime

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase1ParserCPU
Time

Phase1ParserCPUTimeNorm

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase1ParserCPU
TimeNorm

Phase1RSGCPUTime

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase1RSGCPU
Time

Phase1RSGCPUTimeNorm

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase1RSGCPU
TimeNorm

Phase1TotalIO

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase1TotalIO

Phase1MaxIO

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase1MaxIO

Phase1MaxIOAmpNumber

SMALLINT

---,--9

DBQLUtilityTbl.Phase1MaxIOAmp
Number

Phase1IOKB

FLOAT

----,---,---,---,--9.999

DBQLUtilityTbl.Phase1IOKB

Phase1PhysIO

FLOAT

----,---,---,---,--9.999

DBQLUtilityTbl.Phase1PhysIO

Phase1PhysIOKB

FLOAT

----,---,---,---,--9.999

DBQLUtilityTbl.Phase1PhysIOKB

Phase1MaxAWTUsage

BYTEINT

--9

DBQLUtilityTbl.Phase1MaxAWT
Usage

Phase1MaxAMPMemory
Usage

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase1MaxAMP
MemoryUsage

Phase1MaxRSGMemory
Usage

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase1MaxRSG
MemoryUsage

Phase1RowCount

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase1RowCount

Phase1BlockCount

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase1BlockCount

Phase1ByteCount

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase1ByteCount

Phase2StartTime

TIMESTAMP(6)

YYYY-MM-DDBHH:MI:SS.S(F)Z

DBQLUtilityTbl.Phase2StartTime

Phase2EndTime

TIMESTAMP(6)

YYYY-MM-DDBHH:MI:SS.S(F)Z

DBQLUtilityTbl.Phase2EndTime

Phase2TotalCPUTime

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase2TotalCPU
Time

Phase2TotalCPUTimeNorm

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase2TotalCPU
TimeNorm

Phase2MaxCPUTime

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase2MaxCPU
Time

Phase2MaxCPUAmpNumber

SMALLINT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase2MaxCPU
AmpNumber

Phase2MaxCPUTimeNorm

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase2MaxCPU
TimeNorm

Phase2MaxCPUAmpNumber
Norm

SMALLINT

---,--9

DBQLUtilityTbl.Phase2MaxCPU
AmpNumberNorm

Phase2ParserCPUTime

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase2ParserCPU
Time

Phase2ParserCPUTimeNorm

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase2ParserCPU
TimeNorm

Phase2RSGCPUTime

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase2RSGCPU
Time

Phase2RSGCPUTimeNorm

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase2RSGCPU
TimeNorm

Phase2TotalIO

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase2TotalIO

Phase2MaxIO

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase2MaxIO

Phase2MaxIOAmpNumber

SMALLINT

---,--9

DBQLUtilityTbl.Phase2MaxIOAmp
Number

Phase2IOKB

FLOAT

----,---,---,---,--9.999

DBQLUtilityTbl.Phase2IOKB

Phase2PhysIO

FLOAT

----,---,---,---,--9.999

DBQLUtilityTbl.Phase2PhysIO

Phase2PhysIOKB

FLOAT

----,---,---,---,--9.999

DBQLUtilityTbl.Phase2PhysIOKB

Phase2MaxAWTUsage

BYTEINT

--9

DBQLUtilityTbl.Phase2MaxAWT
Usage

Phase2MaxAMPMemory
Usage

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase2MaxAMP
MemoryUsage

Phase2MaxRSGMemory
Usage

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase2MaxRSG
MemoryUsage

Phase2RowCount

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase2RowCount

Phase2BlockCount

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase2BlockCount

Phase2ByteCount

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase2ByteCount

Phase3StartTime

TIMESTAMP(6)

YYYY-MM-DDBHH:MI:SS.S(F)Z

DBQLUtilityTbl.Phase3StartTime

Phase3EndTime

TIMESTAMPE(6)

YYYY-MM-DDBHH:MI:SS.S(F)Z

DBQLUtilityTbl.Phase3EndTime

Phase3TotalCPUTime

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase3TotalCPU
Time

Phase3TotalCPUTimeNorm

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase3TotalCPU
TimeNorm

Phase3ParserCPUTime

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase3ParserCPU
Time

Phase3ParserCPUTimeNorm

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase3ParserCPU
TimeNorm

Phase3RSGCPUTime

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase3RSGCPU
Time

Phase3RSGCPUTimeNorm

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase3RSGCPU
TimeNorm

Phase3TotalIO

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase3TotalIO

Phase3IOKB

FLOAT

----,---,---,---,--9.999

DBQLUtilityTbl.Phase3IOKB

Phase3PhysIO

FLOAT

----,---,---,---,--9.999

DBQLUtilityTbl.Phase3PhysIO

Phase3PhysIOKB

FLOAT

----,---,---,---,--9.999

DBQLUtilityTbl.Phase3PhysIOKB

Phase3MaxAWTUsage

BYTEINT

--9

DBQLUtilityTbl.Phase3MaxAWT
Usage

Phase3MaxAMPMemory
Usage

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase3MaxAMP
MemoryUsage

Phase3MaxRSGMemory
Usage

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase3MaxRSG
MemoryUsage

Phase4StartTime

TIMESTAMP(6)

YYYY-MM-DDBHH:MI:SS.S(F)Z

DBQLUtilityTbl.Phase4StartTime

Phase4EndTime

TIMESTAMP(6)

YYYY-MM-DDBHH:MI:SS.S(F)Z

DBQLUtilityTbl.Phase4EndTime

Phase4TotalCPUTime

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase4TotalCPU
Time

Phase4TotalCPUTimeNorm

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase4TotalCPU
TimeNorm

Phase4ParserCPUTime

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase4ParserCPU
Time

Phase4ParserCPUTimeNorm

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLUtilityTbl.Phase4ParserCPU
TimeNorm

Phase4TotalIO

FLOAT

----,---,---,---,--9

DBQLUtilityTbl.Phase4TotalIO

Phase4IOKB

FLOAT

----,---,---,---,--9.999

DBQLUtilityTbl.Phase4IOKB

Phase4PhysIO

FLOAT

----,---,---,---,--9.999

DBQLUtilityTbl.Phase4PhysIO

Phase4PhysIOKB

FLOAT

----,---,---,---,--9.999

DBQLUtilityTbl.Phase4PhysIOKB

Possible Values for FastExportNoSpool

 

Value

Description

Y

No spool mode.

N

Spool mode for FastExport utilities is used.

Possible Values for ExtendedMLoad

 

Value

Description

Y

Extended MultiLoad (MLOADX) protocol is used.

N

MLOADX protocol is not used.

Possible Values for DSAOperation

 

Value

Description

D

SQL DUMP request is issued.

R

SQL RESTORE request is issued.

The following SELECT statement retrieves the start time, end time, and row counts for FastLoad or TPT Load jobs submitted by USER1 since December 1, 2013:

SELECT UtilityName, LSN, JobStartTime, JobEndTime, RowsInserted
FROM   DBC.QryLogUtilityV
WHERE UserName = 'USER1'
 AND (UtilityName = 'FASTLOAD' OR
    UtilityName = 'TPTLOAD')
 AND JobStartTime > DATE '2013-12-01'
ORDER BY JobStartTime;

Result:

UtilityName   LSN    JobStartTime                  JobEndTime                           RowsInserted
-----------   -----  ----------------------------  ----------------------------         -------------
FASTLOAD      47     2013-12-02 09:19:22.150000    2013-12-02 09:30:59.670000           100,000
FASTLOAD      48     2013-12-02 09:19:24.250000    2013-12-02 09:30:44.820000           100,000
TPTLOAD       54     2013-12-02 10:07:41.700000    2013-12-02 10:07:48.940000            81,920

For information about how the DBQLUtilityTbl table and how it is populated, see Database Administration.