QryLogEventHisV - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.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) 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