Is there a way to find out whether any requests are still running over a specific session ID (e.g. 3300059)?

Is there a way to find out whether any requests are still running over a specific session ID (e.g. 3300059)?

book

Article ID: KB0081210

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization v 7.0.0 and higher

Description

You can run a query on the SYS_REQUESTS table, as shown below:

SELECT 
    description, status, session_id, request_id, total_duration, server_duration
FROM 
    /services/databases/system/SYS_REQUESTS requests
WHERE
    requests.SESSION_ID = '3300059'
 
SAMPLE OUTPUT 
 description         :  SELECT count(*) from ViewOrder
 status                 :  READY
 session_id          :  3300059
 request_id          :  5200141
 total_duration     :  1406683
 server_duration  :  0

The STATUS is the request's status, and can have the following values:

   'STARTED' - The request is in the process of starting.  This status is usually very brief.
   'WAITING' - The request is waiting for enough system resources in order to start running.
   'RUNNING' - The request is currently executing.
   'READY' - The request has completed execution and results are available.
   'CLOSING' - The request is in the process of closing.  This status is usually very brief.
   'SUCCESS' - The request was completed successfully.
   'FAILED' - The request failed.
   'TERMINATED' - The request was terminated.

Issue/Introduction

Is there a way to find out whether any requests are still running over a specific session ID (e.g. 3300059)?