SERVICE_TOOLS_SERVER_INFO view

The SERVICE_TOOLS_SERVER_INFO view returns one row containing the service tools server configuration information.

The information is similar to what can be changed with the Configure Service Tools Server LAN Adapter through the Start System Service Tools (STRSST) and DST interfaces.

Authorization: The caller must have *IOSYSCFG special authority and must be linked to a service tools user ID with the service tool server privilege Display/Alter/Dump.

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

Table 1. SERVICE_TOOLS_SERVER_INFO view
Column Name System Column Name Data Type Description
SERVER_ENABLED ENABLED VARCHAR(3) Whether the service tools server is enabled.
NO
The server is disabled.
YES
The server is enabled.
SERVER_START_ON_IPL START_IPL VARCHAR(3) Whether the service tools server is configured to start on an IPL.
NO
The server will not be started on an IPL.
YES
The server will be started on an IPL.
RESOURCE_NAME RESOURCE VARCHAR(10) The resource name of the communication device used by the service tools server.
SERVER_NAME SERVER VARCHAR(12)
Nullable
 The name assigned to the service tools server as seen from the network.

Contains the null value if a name is not assigned for the server.
TYPE TYPE VARCHAR(4) The type of adapter.
SERIAL_NUMBER SERIAL VARCHAR(10) The serial number of the adapter.
IP_VERSION IP_VERSION CHAR(4) The service tools server active IP versions.
BOTH
Both IPv4 and IPv6 addresses are active for the service tools server.
IPV4
Only the IPv4 address is active for the service tools server.
IPV6
Only the IPv6 address is active for the service tools server.
IPV4_ADDRESS IPV4 VARCHAR(15)
Nullable
 The IPv4 address of the service tools server.

Contains the null value if IPv4 is not configured for the server.
GATEWAY_ADDRESS GATEWAY VARCHAR(15)
Nullable
 The IPv4 gateway server internet address used for the connection.

Contains the null value if a gateway address is not configured for the server.
SUBNET_MASK SUBNET VARCHAR(15)
Nullable
 The subnet mask in dotted-decimal notation for the IPv4 interface.

Contains the null value if a subnet mask is not configured for the server or if GATEWAY_ADDRESS is null.
IPV6_ADDRESS IPV6 VARCHAR(45)
Nullable
 The IPv6 address, in colon-separated hexadecimal notation, of the service tools server.

Contains the null value if IPv6 is not configured for the server.
VIRTUAL_LAN_ID LAN_ID INTEGER
Nullable
 The virtual LAN ID associated with the IPv6 interface.

Contains the null value if IPv6 is not configured for the server.
INTERFACE_ID INTERFACE CHAR(16) The IPv6 interface ID. This value is used to generate stateless auto-configured IPv6 addresses.
DUPLEX DUPLEX VARCHAR(4) The duplex setting for the service tools server. This specifies whether the hardware can send and receive data simultaneously.
AUTO
The duplex value will be determined by the hardware using auto-negotiation.
FULL
The line communicates using full duplex mode. This means that one cable is dedicated to send data and another cable is dedicated to receive data.
HALF
The line communicates using half duplex mode. This means that the hardware must alternate between sending data and receiving data.
NETWORK_SPEED SPEED VARCHAR(4) The network line speed in bits per second (bps).
AUTO
The line speed value will be determined by the hardware using auto-negotiation.
10
The network speed is 10 million bits per second. This is only used for Ethernet adapter.
100
The network speed is 100 million bits per second. This is only used for Ethernet adapter.
1000
The network speed is 1 giga bits per second. This is only used for Ethernet adapter.
10G
The network speed is 10 giga bits per second. This is only used for Ethernet adapter.
25G
The network speed is 25 giga bits per second. This is only used for Ethernet adapter.
100G
The network speed is 100 giga bits per second. This is only used for Ethernet adapter.

Example

  • Show information about the service tools server configuration.
    
SELECT * FROM QSYS2.SERVICE_TOOLS_SERVER_INFO;