16.20 - QryLogEventHisV - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantageā„¢ Data Dictionary

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-03
dita:mapPath
zzu1512081120577.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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