16.20 - 例: QryLogEventsVを使用したFlex Throttle列のクエリー - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ データ ディクショナリ

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
2019年3月
Content Type
ユーザー ガイド
管理
Publication ID
B035-1092-162K-JPN
Language
日本語 (日本)

以下の文は、QryLogEventsVビューからFlex Throttle関連の列を取得します。

SELECT FlexThrottleID, FlexThrottleSeqNo, EventInfo from DBC.QryLogEventsV order by 1,2;

この問合わせは以下の結果を返します。

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