SERVER_SBS_CONFIGURATION view

The SERVER_SBS_CONFIGURATION view returns subsystem routing information for some IBM i servers. When a client attempts to use TCP/IP to form a connection to a server listed in this view, an attempt is made to attach to a prestart job in the subsystem configured for that server.

The information returned by this view is similar to the information shown by IBM Navigator for i in Network > Servers. For information about users who have alternate subsystem configurations for some IBM i servers, see SERVER_SBS_ROUTING view.

The QSYS2.SET_SERVER_SBS_ROUTING procedure can be used to modify entries shown in this view.

Authorization: None required.

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

Table 1. SERVER_SBS_CONFIGURATION view
Column Name	System Column Name	Data Type	Description
SERVER_NAME	SERVER	VARCHAR(10)	The server name for this entry.
SERVER_SEARCH_ORDER	SEARCH_ORD	INTEGER Nullable	The search order for selecting this subsystem routing entry. The order starts with one for each SERVER_NAME value. Contains the null value for the default entry for each server. This is the entry that will be selected if no other specific entry is selected.
SUBSYSTEM	SUBSYSTEM	VARCHAR(10)	The subsystem name that incoming connections for this server will be rerouted to when this entry is selected.
ALLOW_ROLLOVER	ROLLOVER	VARCHAR(3)	Indicates how incoming connection requests are handled if the subsystem is not active. NO Incoming connections will be rejected. YES Incoming connections will be routed to a batch immediate job in the subsystem where the server daemon job is active.
IP_ADDRESS_TYPE	ADDR_TYPE	CHAR(4) Nullable	The type of IP address for IP_ADDRESS_START and IP_ADDRESS_END. IPV4 The addresses are IPv4 addresses. IPV6 The addresses are IPv6 addresses. Contains the null value if no IP addresses are used for defining this row.
IP_ADDRESS_START	IP_START	VARCHAR(45) Nullable	The IP address for alternate routing or the starting IP address for a range of IP addresses. Contains the null value if no IP addresses are used for defining this row.
IP_ADDRESS_END	IP_END	VARCHAR(45) Nullable	The ending IP address for a range of IP addresses. Contains the null value if this row is not for a range of IP addresses.
SUBNET_MASK	SUBNET	VARCHAR(15) Nullable	The actual value of the subnet mask in dotted-decimal notation. Contains the null value if IP_ADDRESS_START is null, there is no subnet mask, or this is an IPv6 address.
PREFIX_LENGTH	PREFIX	INTEGER Nullable	The prefix length defines how many of the left-most bits of the IPv6 address make up the prefix. Contains the null value if IP_ADDRESS_START is null or an IPv4 address.
TEXT_DESCRIPTION	TEXT	VARCHAR(50) Nullable	Descriptive text for this entry. Contains the null value if there is no descriptive text.

Example

List all the servers that have alternate subsystems defined.

SELECT * FROM QSYS2.SERVER_SBS_CONFIGURATION
  ORDER BY SERVER_NAME, SERVER_SEARCH_ORDER;