Using TDWMGetDelayedQueries to Get the System Query or System Session Delay Queue
This example shows how to get the system query or system session delay queue.
SELECT * FROM TABLE (TDWM.TDWMGetDelayedQueries('O')) AS t1;
where 'O' is for system query or system session delay queue.
*** Query completed. One row found. 9 columns returned. *** Total elapsed time was 1 second. Username LUMBER HostId 1 SessionNo 1010 RequestNo 3 WDName test2 WDId 1 TimeHeld 6676 OverRidable Y BlockingCnt 0
Using TDWMGetDelayedQueries to Get the Workload Delay Queue
This example shows how to get the workload delay queue.
SELECT * FROM TABLE (TDWM.TDWMGetDelayedQueries('W')) AS t1;
where 'W' is for workload delay queue.
*** Query completed. 2 rows found. 9 columns returned. *** Total elapsed time was 1 second. Username LUMBER HostId 1 SessionNo 1008 RequestNo 3 WDName test-wd WDId 6 TimeHeld 7131 OverRidable Y BlockingCnt 0 Username LUMBER HostId 1 SessionNo 1009 RequestNo 3 WDName test-wd WDId 6 TimeHeld 7114 OverRidable Y BlockingCnt 0
Using TDWMGetDelayedQueries to Get All Delay Queues
This example shows how to get all the delay queues.
SELECT * FROM TABLE (TDWM.TDWMGetDelayedQueries('A')) AS t1;
where 'A' or null is for all delay queues.
*** Query completed. 3 rows found. 9 columns returned. *** Total elapsed time was 1 second. Username HostId SessionNo RequestNo WDName WDId TimeHeld OverRidable -------- ------ --------- --------- ------ ---- -------- ----------- LUMBER 1 1010 3 test2 1 7717 Y LUMBER 1 1008 3 test 6 7748 Y LUMBER 1 1009 3 test 6 7731 Y