ELECTRONIC_SERVICE_AGENT_INFO view
The ELECTRONIC_SERVICE_AGENT_INFO view returns detailed information about the Electronic Service Agent (ESA) connections.
The Electronic Service Agent must be configured and activated before this view can successfully return results. See Electronic Service Agent for information about ESA.
The values returned for the columns in the view are closely related to the detail generated by the VFYSRVAGT TYPE(*DETAIL) CL command.
When the ESA_CONNECTION column contains the null value, there is no connectivity. RESULT_BY_IP_ADDRESS and RESULT_BY_HOSTNAME will both return a value of FAILURE, and partial information will be returned in the other columns.
Authorization: The caller must have *ALLOBJ special authority.
The following table describes the columns in the view. The system name is ESA_INFO. The schema is QSYS2.
Column Name | System Column Name | Data Type | Description |
---|---|---|---|
ESA_STATUS | STATUS | VARCHAR(9) | The ESA status.
|
ESA_CONNECTION | CONNECTION | VARCHAR(18) Nullable
|
The type of connection between the IBM® i and IBM support servers.
Contains the null value if the type of connection is not available. |
PROXY_HOST_OR_IP | PROXY_HOST | VARCHAR(256) Nullable
|
The proxy hostname or proxy IP address, depending on the
configuration. Contains the null value if ESA_CONNECTION is DIRECT LAN CONNECT. |
PROXY_PORT | PROXY_PORT | INTEGER Nullable
|
The proxy port. Contains the null value if ESA_CONNECTIVITY is DIRECT LAN CONNECT. |
PROXY_ID | PROXY_ID | VARCHAR(16) Nullable
|
The proxy user ID. Contains the null value if the HTTP proxy is a non-authenticated HTTP proxy, if the proxy ID is not configured, or if ESA_CONNECTIVITY is DIRECT LAN CONNECT. |
RESULT_BY_IP_ADDRESS | RESULT_IP | VARCHAR(7) | Connection status using IP address.
|
RESULT_BY_HOSTNAME | RESULT_HST | VARCHAR(7) | Connection status using hostname.
|
SERVER_TYPE | SERV_TYPE | VARCHAR(25) | The type of IBM support server. The following values are returned when using traditional path (Non-Edge) support. If using simplified path (Edge), the values are prefixed with EDGE. For example, EDGE BULK DATA. Appended at the end of the value is a blank followed by a number to make the value unique.
|
SERVER_HOSTNAME | SERV_HOST | VARCHAR(30) | The hostname of the server. When using Edge, SERVER_HOSTNAME will be ESUPPORT.IBM.COM. |
SERVER_IP_ADDRESS | SERV_IP | VARCHAR(45) | The IP address of the server. |
SERVER_PORT | SERV_PORT | INTEGER | The port of the server. The default port is 443. |
Example
- Return the connection information for the Electronic Service
Agent.
SELECT * FROM QSYS2.ELECTRONIC_SERVICE_AGENT_INFO;