HTTP_SERVER_INFO view

The HTTP_SERVER_INFO view returns information for HTTP Server for IBM® i (powered by Apache). Only information for enabled and active functions is returned.

The values returned for the result columns of the table function are similar to the values shown by Real Time Server Statistics in the IBM Web Administration for i GUI.

Authorization: None required.

The following table describes the columns in the view. The system name is HTTP_SRVR. The schema is QSYS2.

Table 1. HTTP_SERVER_INFO view
Column Name	System Column Name	Data Type	Description
SERVER_NAME	SERVER	VARCHAR(10)	The name of the HTTP server instance.
JOB_NAME	JOB_NAME	VARCHAR(28)	Qualified job name for the server.
SERVER_START_TIME	START_T	TIMESTAMP(0)	Time the server was started.
SERVER_RESTART_TIME	RESTART_T	TIMESTAMP(0) Nullable	Time the server was restarted. Contains the null value if the server has never been restarted.
SERVER_CURRENT_TIME	CURRENT_T	TIMESTAMP(0)	Current time.
SERVER_NORMAL_CONNECTIONS	NORM_CONN	BIGINT	Total number of normal (non-secure) connections to the server.
SERVER_SSL_CONNECTIONS	SSL_CONN	BIGINT	Total number of SSL (secure) connections to the server.
SERVER_ACTIVE_THREADS	ACT_THRD	INTEGER	Number of active threads.
SERVER_IDLE_THREADS	IDLE_THRD	INTEGER	Number of idle threads.
SERVER_TOTAL_REQUESTS	TOT_REQ	BIGINT	Total number of requests to the server since the server was started.
SERVER_TOTAL_REQUESTS_REJECTED	TOT_REQREJ	BIGINT	Total number of rejected requests issued by the server since the server was started.
SERVER_TOTAL_RESPONSES	TOT_RESP	BIGINT	Total number of responses from the server since the server was started.
HTTP_FUNCTION	HTTP_FUNC	VARCHAR(20)	HTTP server function or associated server for the remaining statistical information columns. A row is only returned for a function if the function is enabled. CGI Common Gateway Interface (CGI) CUSTOMER MODULE A customer or third-party module FRCA PROXY Fast Response Cache Accelerator (FRCA) proxy FRCA STATS Fast Response Cache Accelerator (FRCA) PROXY Proxy SERVER HANDLED Server transactions. This includes static HTML pages, HTML pages containing Server Side Includes (SSI), and images. SSL Secure Sockets Layer (SSL) WEBSPHERE WebSphere® Application Server
REQUESTS	REQUESTS	BIGINT	Number of requests received.
RESPONSES	RESPONSES	BIGINT	Number of responses sent.
ERROR_RESPONSES	ERR_RESP	BIGINT	Number of error responses.
NONCACHE_RESPONSES	NC_RESP	BIGINT	Number of responses that did not come from cache.
BYTES_RECEIVED	BYTES_RCV	BIGINT	Total number of bytes received for all requests.
BYTES_SENT	BYTES_SENT	BIGINT	Total number of bytes sent for all requests.
NONCACHE_PROCESSING_TIME	NC_TIME	DECIMAL(20,3)	Processing time for non-cached requests, in seconds.
CACHE_PROCESSING_TIME	C_TIME	DECIMAL(20,3)	Processing time for cached requests, in seconds.

Example

Examine information about the server functions associated with the ADMIN server.
```
SELECT * FROM QSYS2.HTTP_SERVER_INFO
  WHERE SERVER_NAME = 'ADMIN';
```