16.20 - Example: Using QryLogEventHisV to Show Flex Throttle Events - 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

The following is an example SQL statement that demonstrates how data can be extracted from the QryLogEventHisV view to show Flex Throttle events.

sel entryts,
    substr(entrykind,1,10) "kind",
    substr(entryname,1,20) "name",
    cast (eventvalue as float format '999.9999')  "evt value",
    cast (lastvalue as float format '999.9999') "last value",
    spare2  "spare Int",
    substr(activity,1,10) "activity id",
    substr(activityname,1,20) "act name", seqno, flexthrottleid, flexthrottleseqno from dbc.tdwmeventhistory order by entryts, seqno;

The query returns the following result:

                   EntryTS  kind        name                  evt value  last value  spare Int activity id act name  SeqNo  FlexThrottleID  FlexThrottleSeqNo
--------------------------  ----------  --------------------  ---------  ----------  --------- ----------- --------- ------ --------------- -----------------
2016-04-25 14:37:02.710000  OPENV       Always                        ?           ?          ?  ACTIVE       ?          1               ?                  ?
2016-04-25 14:37:27.850000  EVENT       FLEX-CPU               000.1308    000.0828          ?  ACTIVE       ?          1               ?                  ?
2016-04-25 14:38:03.020000  EVENT       FLEX-AWT               004.0000    004.0000          ?  ACTIVE       ?          1               ?                  ?
2016-04-25 14:38:03.030000  EXPRESSION  FLEX-EXPR                     ?           ?          ?  ACTIVE       ?          1   307186992487951003             1
2016-04-25 14:38:03.030000  EVENT       FLEX-CPU               000.0951           ?          ?  EXPRESSION   FLEX-EXPR  2   307186992487951003             1
2016-04-25 14:38:03.030000  EVENT       FLEX-AWT               004.0000           ?          ?  EXPRESSION   FLEX-EXPR  3   307186992487951003             1
2016-04-25 14:38:23.540000  EVENT       FlexUDEEvent                  ?           ?          ?  ACTIVE       ?          1               ?                  ?