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.

Table 1. ELECTRONIC_SERVICE_AGENT_INFO view
Column Name	System Column Name	Data Type	Description
ESA_STATUS	STATUS	VARCHAR(9)	The ESA status. ACTIVATED ESA has been activated on this system INACTIVE ESA has not been activated
ESA_CONNECTION	CONNECTION	VARCHAR(18) Nullable	The type of connection between the IBM® i and IBM support servers. DIRECT LAN CONNECT A direct LAN connection is configured HTTP PROXY A connection through an HTTP/HTTPS proxy is configured 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. SUCCESS Returned successful status FAILURE Returned failure status UNKNOWN No response If either RESULT_BY_IP_ADDRESS or RESULT_BY_HOSTNAME has a value of SUCCESS, ESA has a working connection.
RESULT_BY_HOSTNAME	RESULT_HST	VARCHAR(7)	Connection status using hostname. SUCCESS Returned successful status FAILURE Returned failure status UNKNOWN No response If either RESULT_BY_IP_ADDRESS or RESULT_BY_HOSTNAME has a value of SUCCESS, ESA has a working connection.
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. BULK DATA Handles bulk data requests CONFIGURATION Handles service provider configuration requests FIX REPOSITORY Handles fix requests GATEWAY Distributes requests to the corresponding servers INVENTORY REPORT Handles inventory report requests PROBLEM REPORT Handles problem call home requests PROFILE Handles profile create/edit/delete requests STATUS REPORT Handles status requests UPDATE ORDER Handles PTF download requests
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;
```