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