Using TDWMThrottleStatistics to Request Query Throttle Statistics
select * from table (TDWM.TDWMThrottleStatistics('Q')) AS t1;
*** Query completed. 4 rows found. 8 columns returned.
*** Total elapsed time was 1 second.
ObjectType RuleId RuleName ObjectName Subname Active ThrottleLimit Delayed
---------- ------ -------- ---------- ------- ------ ------------- -------
User 1 test2 LUMBER 2 2 1
Use 2 test4 LUMBER 1 1 0
Table 3 table test LUMBER ORDERS 1 1 0
Macro 4 macro test LUMBER VENDMACRO 0 1 1
Using TDWMThrottleStatistics to Request Session Throttle Statistics
select * from table (TDWM.TDWMThrottleStatistics('S')) AS t1;
*** Query completed. 2 rows found. 8 columns returned.
*** Total elapsed time was 1 second.
ObjectType RuleId RuleName ObjectName Subname Active ThrottleLimit Delayed
---------- ------ -------- ---------- ------- ------ ------------- -------
User 1 test2 LUMBER 2 4 0
User 2 test4 LUMBER 2 2 0
Using TDWMThrottleStatistics to Request Workload Throttle Statistics
select * from table (TDWM.TDWMThrottleStatistics('W')) AS t1;
*** Query completed. 2 rows found. 8 columns returned.
*** Total elapsed time was 1 second.
ObjectType RuleId RuleName ObjectName Subname Active ThrottleLimit Delayed
---------- ------ ----------- ---------- ------- ------ ------------- -------
Workload 0 -1 0 1
Workload 2 WD-ConsoleR 0 -1 0
Workload 3 WD-ConsoleH 0 -1 0
Workload 4 WD-ConsoleM 0 -1 0
Workload 5 WD-ConsoleL 0 -1 0
Workload 1 WD-Default 0 -1 0
Workload 6 test-wd 0 0 2
Using TDWMThrottleStatistics to Request All Throttle Statistics
SELECT ObjectType(FORMAT 'x(10)'), rulename(FORMAT 'x(17)'),
ObjectName(FORMAT 'x(13)'), active(FORMAT 'Z9'),
throttlelimit as ThrLimit, delayed(FORMAT 'Z9'), throttletype as ThrType
FROM TABLE (TDWM.TDWMTHROTTLESTATISTICS('A')) AS t1
ORDER BY 1,2;
*** Query completed. 10 rows found. 7 columns returned.
*** Total elapsed time was 1 second.
ObjectType RuleName ObjectName Active ThrLimit Delayed ThrType
---------- ----------------- ------------ ------ -------- ------- -------
Table t900throttlerule7 T9TESTUSER 1 1 6 Q
User session919rule T900APIUSER4 4 5 0 S
Workload WD-Default 0 -1 0 W
Workload WD1 0 -1 0 W
Workload WD3 1 1 0 W
Workload WD345678901234567 1 1 3 W
Workload WD4 0 1 0 W
Workload WD5 0 -1 0 W
Workload WD6 0 -1 0 W
Workload WD7 0 -1 0 W