15.10 - QryLogTDWMSumV - 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)

TDWMSummaryLog.ProcID (Composite NUPI)

CollectTimeStamp

TIMESTAMP(6)

NOT NULL

YYYY-MM-DDBHH:MI:SS

TDWMSummaryLog.BufferTS (Composite NUPI)

WDID

INTEGER

NOT NULL

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

TDWMSummaryLog.WDID

OpEnvID

INTEGER

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

TDWMSummaryLog.OpEnvID

SysConID

INTEGER

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

TDWMSummaryLog.SysConID

StartColTime

TIMESTAMP(6)

NOT NULL

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

TDWMSummaryLog.StartColTime

Arrivals

INTEGER

NOT NULL

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

TDWMSummaryLog.Arrivals

ActiveCount

INTEGER

NOT NULL

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

TDWMSummaryLog.ActiveCount

Completions

INTEGER

NOT NULL

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

TDWMSummaryLog.Completions

MinRespTime

FLOAT

NOT NULL

ZZZZZZ.99

TDWMSummaryLog.MinRespTime

MaxRespTime

FLOAT

NOT NULL

ZZZZZZ.99

TDWMSummaryLog.MaxRespTime

AvgRespTime

FLOAT

NOT NULL

ZZZZZZ.99

TDWMSummaryLog.AvgRespTime

MinCPUTime

FLOAT

NOT NULL

ZZZZZZ.99

TDWMSummaryLog.MinCPUTime

MaxCPUTime

FLOAT

NOT NULL

ZZZZZZ.99

TDWMSummaryLog.MaxCPUTime

AvgCPUTime

FLOAT

NOT NULL

ZZZZZZ.99

TDWMSummaryLog.AvgCPUTime

DelayedCount

INTEGER

NOT NULL

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

TDWMSummaryLog.DelayedCount

AvgDelayTime

FLOAT

NOT NULL

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

TDWMSummaryLog.AvgDelayTime

ExceptionAbCount

INTEGER

NOT NULL

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

TDWMSummaryLog.ExceptionAbCount

ExceptionMvCount

INTEGER

NOT NULL

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

TDWMSummaryLog.ExceptionMvCount

ExceptionCoCount

INTEGER

NOT NULL

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

TDWMSummaryLog.ExceptionCoCount

ExceptionCount

INTEGER

-(10)9

TDWMSummaryLog.ExceptionAbCount,

TDWMSummaryLog.ExceptionMvCount,

TDWMSummaryLog.ExceptionCoCount

MetSLGCount

INTEGER

NOT NULL

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

TDWMSummaryLog.MetSLGCount

AbortCount

INTEGER

NOT NULL

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

TDWMSummaryLog.AbortCount

ErrorCount

INTEGER

NOT NULL

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

TDWMSummaryLog.ErrorCount

RejectedCount

INTEGER

NOT NULL

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

TDWMSummaryLog.RejectedCount

MovedInCount

INTEGER

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

TDWMSummaryLog.MovedInCount

IntervalDelayCnt

INTEGER

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

TDWMSummaryLog.IntervalDelayCnt

DelayedQueries

INTEGER

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

TDWMSummaryLog.DelayedQueries

OtherCount

FLOAT

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

TDWMSummaryLog.OtherCount

VirtualPartNum

INTEGER

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

TDWMSummaryLog.VirtualPartNum

AvgIOWaitTime

FLOAT

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

TDWMSummaryLog.AvgIOWaitTime

MaxIOWaitTime

FLOAT

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

TDWMSummaryLog.MaxIOWaitTime

AvgOtherWaitTime

FLOAT

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

TDWMSummaryLog.AvgOtherWaitTime

MaxOtherWaitTime

FLOAT

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

TDWMSummaryLog.MaxOtherWaitTime

AvgCPURunDelay

FLOAT

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

TDWMSummaryLog.AvgCPURunDelay

MaxCPURunDelay

FLOAT

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

TDWMSummaryLog.MaxCPURunDelay

AvgSeqRespTime

FLOAT

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

TDWMSummaryLog.AvgSeqRespTime

MaxSeqRespTime

FLOAT

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

TDWMSummaryLog.MaxSeqRespTime

AvgLogicalIO

FLOAT

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

TDWMSummaryLog.AvgLogicalIO

MaxLogicalIO

FLOAT

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

TDWMSummaryLog.MaxLogicalIO

AvgLogicalKBs

FLOAT

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

TDWMSummaryLog.AvgLogicalKBs

MaxLogicalKBs

FLOAT

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

TDWMSummaryLog.MaxLogicalKBs

AvgPhysicalIO

FLOAT

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

TDWMSummaryLog.AvgPhysicalIO

MaxPhysicalIO

FLOAT

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

TDWMSummaryLog.MaxPhysicalIO

AvgPhysicalKBs

FLOAT

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

TDWMSummaryLog.AvgPhysicalKBs

MaxPhysicalKBs

FLOAT

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

TDWMSummaryLog.MaxPhysicalKBs

ThrottleBypassed

INTEGER

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

TDWMSummaryLog.ThrottleBypassed

This view contains a historical record of WD activity.

Abort, Completions, and ErrorCount

For these columns, dashboard interval is used for the API data and logging interval is used for logging data to the disk.

MetSLGCount

For this column, queries completing in a WD that do not have a declared Response Time Service Level Goal (SLG) are also counted as meeting the SLG.

The following SELECT statement retrieves the QryLogTDWMSum view:

SELECT * from DBC.QryLogTDWMSum;

The query returns the following result:

          ProcID           30718
CollectTimeStamp  2013-12-16 16:52:33
            WDID              12
         OpEnvID               1
        SysConID               1
    StartColTime  2013-12-16 16:52:33.130000
        Arrivals               4
     ActiveCount               0
     Completions               4
     MinRespTime             .01
     MaxRespTime             .13
     AvgRespTime             .05
      MinCPUTime             .27
      MaxCPUTime            4.04
      AvgCPUTime            1.61
    DelayedCount               0
    AvgDelayTime               0
ExceptionAbCount               0
ExceptionMvCount               0
ExceptionCoCount               0
  ExceptionCount               0
     MetSLGCount               4
      AbortCount               0
      ErrorCount               0
   RejectedCount               0
    MovedInCount               0
IntervalDelayCnt               0
  DelayedQueries               0
      OtherCount               0
  VirtualPartNum               1
   AvgIOWaitTime               0
   MaxIOWaitTime               0
AvgOtherWaitTime               1
MaxOtherWaitTime               3
  AvgCPURunDelay               0
  MaxCPURunDelay               0
  AvgSeqRespTime               0
  MaxSeqRespTime               0
    AvgLogicalIO             125
    MaxLogicalIO             259
   AvgLogicalKBs           5,705
   MaxLogicalKBs          12,640
   AvgPhysicalIO               2
   MaxPhysicalIO               6
  AvgPhysicalKBs              62
  MaxPhysicalKBs             248
ThrottleBypassed               0