Example: Using QryLogEventHisV to Show Flex Throttle Events - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

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;

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               ?                  ?