Example: Using QryLogEventHisV to Show Flex Throttle Events - Teradata VantageCloud Lake

Lake - Database Reference
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
ohi1683672393549.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
ohi1683672393549

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