SERVER_SBS_ROUTING view

The SERVER_SBS_ROUTING view returns information about the users who have alternate subsystem configurations for some IBM i servers. When a user profile listed in this view attempts to use TCP/IP to form a connection to the server, an attempt is made to use the alternate subsystem instead of the default subsystem for that server.

Start of changeFor subsystem routing information for some IBM i servers, see SERVER_SBS_CONFIGURATION view.End of change

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

Authorization: You must have *OBJOPR and *READ authority to a *USRPRF or it will not be returned.

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

Table 1. SERVER_SBS_ROUTING view
Column Name System Column Name Data Type Description
AUTHORIZATION_NAME USER_NAME VARCHAR(128)
Nullable
 The user profile that has an alternate subsystem configuration. Contains the value *ALL is this entry is for all users of the subsystem.
QRWTSRVR_SUBSYSTEM DRDADDMSBS VARCHAR(10)
Nullable
 The subsystem name that incoming DRDA or DDM connections will be rerouted to.

Contains the null value when an alternate subsystem for this server has not been configured for this user.
QZDASOINIT_SUBSYSTEM ZDASBS VARCHAR(10)
Nullable
 The subsystem name that incoming database server connections will be rerouted to.

Contains the null value when an alternate subsystem for this server has not been configured for this user.
QZRCSRVS_SUBSYSTEM ZRCSBS VARCHAR(10)
Nullable
 The subsystem name that incoming remote command server connections will be rerouted to.

Contains the null value when an alternate subsystem for this server has not been configured for this user.
QZHQSSRV_SUBSYSTEM ZHQSBS VARCHAR(10)
Nullable
 The subsystem name that incoming data queue server connections will be rerouted to.

Contains the null value when an alternate subsystem for this server has not been configured for this user.
QZSCSRVS_SUBSYSTEM ZSCSBS VARCHAR(10)
Nullable
 The subsystem name that incoming central server connections will be rerouted to.

Contains the null value when an alternate subsystem for this server has not been configured for this user.
QNPSERVS_SUBSYSTEM NPSSBS VARCHAR(10)
Nullable
 The subsystem name that incoming network print server connections will be rerouted to.

Contains the null value when an alternate subsystem for this server has not been configured for this user.
QPWFSERVSO_SUBSYSTEM PWFSBS VARCHAR(10)
Nullable
 The subsystem name that incoming file server connections will be rerouted to.

Contains the null value when an alternate subsystem for this server has not been configured for this user.
QRWTSRVR_ROLLOVER DRDA_RO VARCHAR(3) Indicates how incoming DRDA or DDM connection requests are handled if the specified subsystem cannot be used.
NO
Incoming connections will be rejected.
YES
Incoming connections will be routed to the default subsystem. If an alternate subsystem is not configured for this server, YES is the default.
QZDASOINIT_ROLLOVER ZDA_RO VARCHAR(3) Indicates how incoming database server connection requests are handled if the specified subsystem cannot be used.
NO
Incoming connections will be rejected.
YES
Incoming connections will be routed to the default subsystem. If an alternate subsystem is not configured for this server, YES is the default.
QZRCSRVS_ROLLOVER ZRC_RO VARCHAR(3) Indicates how incoming remote command connection requests are handled if the specified subsystem cannot be used.
NO
Incoming connections will be rejected.
YES
Incoming connections will be routed to the default subsystem. If an alternate subsystem is not configured for this server, YES is the default.
QZHQSSRV_ROLLOVER ZHQ_RO VARCHAR(3) Indicates how incoming data queue server connection requests are handled if the specified subsystem cannot be used.
NO
Incoming connections will be rejected.
YES
Incoming connections will be routed to the default subsystem. If an alternate subsystem is not configured for this server, YES is the default.
QZSCSRVS_ROLLOVER ZSC_RO VARCHAR(3) Indicates how incoming central server connection requests are handled if the specified subsystem cannot be used.
NO
Incoming connections will be rejected.
YES
Incoming connections will be routed to the default subsystem. If an alternate subsystem is not configured for this server, YES is the default.
QNPSERVS_ROLLOVER NPS_RO VARCHAR(3) Indicates how incoming network print server connection requests are handled if the specified subsystem cannot be used.
NO
Incoming connections will be rejected.
YES
Incoming connections will be routed to the default subsystem. If an alternate subsystem is not configured for this server, YES is the default.
QPWFSERVSO_ROLLOVER PWF_RO VARCHAR(3) Indicates how incoming file server connection requests are handled if the specified subsystem cannot be used.
NO
Incoming connections will be rejected.
YES
Incoming connections will be routed to the default subsystem. If an alternate subsystem is not configured for this server, YES is the default.

The following table shows the servers that can have alternate subsystem configurations.

Table 2. Servers and server names
Server Description Server Name
Central server QZSCSRVS
Database server QZDASOINIT
Data queue server QZHQSSRV
DDM QRWTSRVR
DRDA QRWTSRVR
File server QPWFSERVSO
Network print server QNPSERVS
Remote command server QZRCSRVS

Example

Query subsystem routing information for all user profiles: 

SELECT * FROM QSYS2.SERVER_SBS_ROUTING