QryLogEventsV - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
prb1610499325399.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

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