Name
http_pending_req — return array describing running VSP threads
Synopsis
http_pending_req
(
|
); |
Description
This function requires dba privileges.
http_pending_req
returns an array of arrays of data
on running VSP requests. Each array contains the Client IP Address, URL,
and Process Request ID. These values can be used
with the http_kill()
function.
Return Types
An array of 3-part-arrays. Each 3-part-array consists of client_IP_address (string), URL (string), and process request ID (number).
The request ID's can be used to terminate requests with http_kill.
Errors
Table 24.42. Errors signalled by
http_pending_req
| SQLState | Error Code | Error Text | Description |
|---|---|---|---|
| 42000 | SR159 | Function http_pending_req restricted to dba group |
Examples
Example 24.173. Retrieving a list of VSP processes
declare ps any;
ps := http_pending_req ();
-- the ps value is (('127.0.0.1', '/long.vsp', 1234567), ('192.168.1.1', '/long.vsp', 345678))