Products | Versions |
---|---|
TIBCO Data Virtualization | v 7.0.0 and higher |
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.