Top

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.43. 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))