17.00 - QryLogEventHisV - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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) Returns a timestamp unique to each buffer cache.
EntryTS TIMESTAMP(6) NOT NULL YYYY-MM-DDBHH:MI:SS.S(F)Z The timestamp when the event was detected.
EntryKind CHAR(10) LATIN NOT CASESPECIFIC X(10) Indicates what kind of event-related construct caused something to happen.
EntryID INTEGER --,---,---,--9 Returns the internal ID of the causing construct.
EntryType VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) For EntryKind of EVENT this represents the Entry Type from Events table
EntryName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the causing construct.
EventValue FLOAT ----,---,---,---,--9 Returns the current (latest) value of the primary event criterion, such as number of AMP Worker Tasks (AWTs).
LastValue FLOAT ----,---,---,---,--9 Returns the value collected over the last interval for this event.
Activity CHAR(10) LATIN NOT CASESPECIFIC X(10) Returns the activity being logged.
ActivityId INTEGER --,---,---,--9 Returns the internal ID of the construct made active when Activity is EXPRESSION, SYSCON, or OPENV; otherwise, it is set to zero.
ActivityName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Returns the name of the construct made active when Activity is EXPRESSION, SYSCON, or OPENV; otherwise, the field is null.
ConfigId INTEGER --,---,---,--9 The configuration this event was created in.
SeqNo SMALLINT -(5)9 Returns a sequence number used to help the user understand the sequence of events, expression, syscon, and openv changes that have occurred.
Spare1 VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Spare char field.
Spare2 INTEGER --,---,---,--9 Spare int field.
Spare3 FLOAT ----,---,---,---,--9 Spare float field.
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