17.00 - Example: Using QryLogEventsV to Query Flex Throttle Columns - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

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