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

TDWMEventLog.ProcID (Composite NUPI)

CollectTimeStamp

TIMESTAMP(6)

NOT NULL

YYYY-MM-DDBHH:MI:SS

TDWMEventLog.BufferTS (Composite NUPI)

SessionID

INTEGER

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

TDWMEventLog.SessionID

LogicalHostID

SMALLINT

ZZZ9 (explicit)

TDWMEventLog.LogicalHostID

WDID

INTEGER

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

TDWMEventLog.WDID

OpEnvID

INTEGER

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

TDWMEventLog.OpEnvID

SysConID

INTEGER

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

TDWMEventLog.SysConID

EventTime

TIMESTAMP(6)

NOT NULL

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

TDWMEventLog.EventTime

EventCode

INTEGER

NOT NULL

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

TDWMEventLog.EventCode

EventSubCode

INTEGER

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

TDWMEventLog.EventSubCode

EventInfo

VARCHAR(200)

UNICODE

NOT CASESPECIFIC

X(200)

TDWMEventLog.EventInfo

These events may include a Teradata dynamic workload management software rule update or errors encountered during a Teradata dynamic workload management software rule activate or deactivate.

The following statement retrieves rows from the QryLogEventsV view:

SELECT * from DBC.QryLogEventsV;

The query returns the following result:

          ProcID 16383
CollectTimeStamp 2004-06-22 14:51:32
       SessionID ?
   LogicalHostID ?
            WDID ?
         OpEnvID ?
SysConID ?
       EventTime 2004-06-22 14:43:32.58
       EventCode 3,158
    EventSubCode ?
EventInfo TDWM rules have been updated