The following statement retrieves Flex Throttle related columns from the QryLogEventsV view:
SELECT FlexThrottleID, FlexThrottleSeqNo, EventInfo from DBC.QryLogEventsV order by 1,2;
The query returns the following result:
*** Query completed. 45 rows found. 3 columns returned. *** Total elapsed time was 1 second. FlexThrottleID FlexThrottleSeqNo EventInfo -------------- ----------------- --------------------------------------------------- ? ? For Rule Id 42, State 4 info duplicates default and is ignored ? ? For Rule Id 41, OpEnv 4 SLG info duplicates default and is ignored ? ? For Rule Id 44, OpEnv 4 SLG info duplicates default and is ignored ? ? For Rule Id 39, OpEnv 4 SLG info duplicates default and is ignored ? ? For Rule Id 46, OpEnv 4 SLG info duplicates default and is ignored ? ? For Rule Id 37, State 4 info duplicates default and is ignored ? ? Priority Scheduler settings updated successfully. ? ? Available AWT Event Triggering Algorithm 0 enabled ? ? Distributed rules changes for config 5000, state=3, openv=3, ... ? ? Avg Int: Event=FLEX-CPU, Threshold/EI = 0.800000, buckets=6, ... ? ? Event Monitoring enabled with interval of 5 seconds. ? ? Flex Throttle feature enabled ? ? Asynchronous Exception Monitoring enabled w/exception interval of 5s ? ? Ignoring unsolicited ChangeState msg for seq# 1, to same state 3, ... ? ? For Rule Id 43, OpEnv 4 SLG info duplicates default and is ignored ? ? Rules change completed - Read=0.32, WriteGDO=0.04, LastResp=0.01 ? ? For Rule Id 45, OpEnv 4 SLG info duplicates default and is ignored ? ? For Rule Id 42, OpEnv 4 SLG info duplicates default and is ignored ? ? Asynchronous Exception Monitoring disabled ? ? All static TDWM rules have been deactivated ? ? Error occurred. Rules change rejected due to error 3312 ... ? ? Received valid control request 1 for config 5000, cat1=1 ... ? ? For Rule Id 35, State 4 info duplicates default and is ignored ? ? For Rule Id 36, State 4 info duplicates default and is ignored ? ? For Rule Id 38, State 4 info duplicates default and is ignored ? ? For Rule Id 38, OpEnv 4 SLG info duplicates default and is ignored ? ? For Rule Id 40, OpEnv 4 SLG info duplicates default and is ignored ? ? State change processed for config 5000, state 4, openv 4, seq# 1 ? ? State change completed - Read=0.00, WriteGDO=0.02, LastResp=0.00 ? ? ConfigId=5000, StateId= 4 ? ? ConfigId=5000, StateId= 4 ? ? ConfigId=5000, StateId= 4 ? ? ConfigId=5000, StateId= 4 ? ? ConfigId=5000, StateId= 4 ? ? ConfigId=5000, StateId= 4 ? ? ConfigId=5000, StateId= 4 ? ? Rules change initiated for config id 5000 ? ? Priority Scheduler settings updated successfully. ? ? Received valid control request 2 for config 5000, cat1=0 cat2=0 ... 307186992487951003 1 Released 0 OF ALLOWABLE 1 WITH 0 FLEX CANDIDATES REMAIN IN DELAY QUEUE 307186992487951003 2 Released 1 OF ALLOWABLE 1 WITH 4 FLEX CANDIDATES REMAIN IN DELAY QUEUE 307186992487951003 3 Released 1 OF ALLOWABLE 1 WITH 3 FLEX CANDIDATES REMAIN IN DELAY QUEUE 307186992487951003 4 Released 1 OF ALLOWABLE 1 WITH 2 FLEX CANDIDATES REMAIN IN DELAY QUEUE 307186992487951003 5 Released 1 OF ALLOWABLE 1 WITH 1 FLEX CANDIDATES REMAIN IN DELAY QUEUE