以下はSQL文の例であり、Flex Throttleイベントを示すため、QryLogEventHisVビューからデータをどのように抽出できるかを示しています。
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;
この問合わせは以下の結果を返します。
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 ? ?