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.
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.
|
IP_ADDRESS_TYPE | ADDR_TYPE | CHAR(4) Nullable
|
The type of IP address for IP_ADDRESS_START and IP_ADDRESS_END.
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;