17.10 - QryLogEventsV - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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) (Prime Key) Time and date when the TDWM event cache was written.
SessionID INTEGER --,---,---,--9 Returns the session identifier.
LogicalHostID SMALLINT -(5)9 Returns a unique identifier of the logon source for the logged query. A value of zero indicates an internal session.
WDID INTEGER --,---,---,--9 Returns the workload definition under which the query was classified.
OpEnvID INTEGER --,---,---,--9 Returns the ID of the operational environment currently activated by TDWM.
SysConID INTEGER --,---,---,--9 Returns the ID of the system condition currently activated by TDWM.
EventTime TIMESTAMP(6) NOT NULL YYYY-MM-DDBHH:MI:SS.S(6) Identifies the time when the event occurred.
EventCode INTEGER NOT NULL --,---,---,--9 Returns a Teradata error code.
EventSubCode INTEGER --,---,---,--9 This field is reserved for future use. The value will be 0.
EventInfo VARCHAR(200) UNICODE NOT CASESPECIFIC X(200) Returns information about the event that occurred.
FlexThrottleID DECIMAL(18,0) -(18)9 A time ordered representation of an invocation of the Flex Expression
FlexThrottleSeqNo SMALLINT -(5)9 An ordering of distinct invocations of a single Flex Expression