15.10 - QryLogTDWMV - 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

DECIMAL(5,0)

NOT NULL

-(5)9 (explicit)

DBQLogTbl.ProcID (Composite NUPI)

CollectTimeStamp

TIMESTAMP(6)

NOT NULL

YYYY-MM-DDBHH:MI:SS

DBQLogTbl.CollectTimeStamp (Composite NUPI)

QueryID

DECIMAL(18,0)

NOT NULL

--Z(17)9

DBQLogTbl.QueryID

UserID

BYTE(4)

NOT NULL

X(8)

DBQLogTbl.UserID

UserName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

DBQLogTbl.UserName

DefaultDatabase

VARCHAR(128)

UNICODE

X(128)

DBQLogTbl.DefaultDatabase

AcctString

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

DBQLogTbl.AcctString

SessionId

INTEGER

NOT NULL

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

DBQLogTbl.SessionId

LogicalHostId

SMALLINT

NOT NULL

ZZZ9

DBQLogTbl.LogicalHostId

RequestNum

INTEGER

NOT NULL

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

DBQLogTbl.RequestNum

InternalRequestNum

INTEGER

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

DBQLogTbl.InternalRequestNum

LastStateChange

TIMESTAMP(6)

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

DBQLogTbl.LastStateChange

DelayTime

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLogTbl.DelayTime

WDID

INTEGER

--,---,---,--9 (explicit)

DBQLogTbl.WDID

OpEnvID

INTEGER

--,---,---,--9 (explicit)

DBQLogTbl.OpEnvID

SysConID

INTEGER

--,---,---,--9 (explicit)

DBQLogTbl.SysConID

LSN

INTEGER

--,---,---,--9 (explicit)

DBQLogTbl.LSN

NoClassification

CHAR(1) LATIN

NOT CASESPECIFIC

X(1)

DBQLogTbl.NoClassification

WDOverride

CHAR(1) LATIN

NOT CASESPECIFIC

X(1)

DBQLogTbl.WDOverride

ResponseTimeMet

CHAR(1) LATIN

NOT CASESPECIFIC

X(1)

DBQLogTbl.ResponseTimeMet

ExceptionValue

INTEGER

--,---,---,--9 (explicit)

DBQLogTbl.ExceptionValue

FinalWDID

INTEGER

--,---,---,--9 (explicit)

DBQLogTbl.FinalWDID

TDWMEstMaxRows

FLOAT

----,---,---,---,--9 (explicit)

DBQLogTbl.TDWMEstMaxRows

TDWMEstLastRows

FLOAT

----,---,---,---,--9 (explicit)

DBQLogTbl.TDWMEstLastRows

TDWMEstTotalTime

FLOAT

ZZZZ9.999999

DBQLogTbl.TDWMEstTotalTime

TDWMEstMemUsage

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLogTbl.TDWMEstMemoryUsage

TDWMAllAmpFlag

CHAR(1) LATIN

NOT CASESPECIFIC

X(1)

DBQLogTbl.TDWMAllAmpFlag

TDWMConfLevelUsed

CHAR(1) LATIN

NOT CASESPECIFIC

X(1)

DBQLogTbl.TDWMConfLevelUsed

TDWMRuleID

INTEGER

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

DBQLogTbl.TDWMRuleID

StatementGroup

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

DBQLogTbl.StatementGroup

SessionWDID

INTEGER

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

DBQLogTbl.SessionWDID

MinRespHoldTime

FLOAT

Z,ZZ9.9

DBQLogTbl.ExtraField22

TotalFirstRespTime

FLOAT

ZZ,ZZZ,ZZ9.999

DBQLogTbl.ExtraField23

The nonunique primary index for the underlying table is a combination of the ProcID and the CollectTimeStamp fields. This combination causes each dispatcher to write its DBQL cache entries to a single AMP. This is important for database efficiency.

For information about the possible values for the ExceptionValue column, see Appendix A: “View Column Values.”

TDWMEstMemUsage

This column returns the estimated memory (in MB) used to classify a query into a workload definition.

Possible Values for StatementGroup

 

Value

Description

UCAbort

An unconditional abort from the session or Gateway vproc or Teradata Director Program kill between requests. This may reflect the abort of an open transaction. If an UCAbort occurs, the value is zero.

AsynchAbort

An asynchronous abort from the session or Gateway vproc or Teradata Director Program kill.

Note: If the AsynchAbort occurs when the request is in the dispatcher, the StatementGroup column values are the usual values for the request, and an error is generated.

The following SELECT statement retrieves the QryLogTDWMV view:

SELECT * from QryLogTDWMV;

The query returns the following result:

ProcID  30718
  CollectTimeStamp 2013-12-16 16:35:27
           QueryID   307188518253277390
            UserID 00000104
          UserName TEST1
   DefaultDatabase TEST1
        AcctString SALES
         SessionID          1,007
     LogicalHostID    1
        RequestNum              5
InternalRequestNum              5
   LastStateChange 2013-12-16 08:50:32.960000
         DelayTime              ?
              WDID             12
           OpEnvID              1
          SysConID              1
               LSN              ?
  NoClassification
        WDOverride
   ResponseTimeMet
    ExceptionValue              ?
         FinalWDID             12
    TDWMEstMaxRows        1,170,869,760
   TDWMEstLastRows                    1
  TDWMEstTotalTime  2331.764361
   TDWMEstMemUsage                    4.375
    TDWMAllAmpFlag T
TDWMConfLevelUsed N
        TDWMRuleID              ?
    StatementGroup Select
       SessionWDID             12