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) The user profile that has an alternate subsystem configuration.
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.

Start of changeQDBMSRVR_SUBSYSTEMEnd of change Start of changeDBMSBSEnd of change Start of changeVARCHAR(10)
Nullable
End of change
Start of changeThe subsystem name that incoming database mirror connections will be rerouted to.

Contains the null value when an alternate subsystem for this server has not been configured for this user.

End of change
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.
Start of changeQDBMSRVR_ROLLOVEREnd of change Start of changeDBM_ROEnd of change Start of changeVARCHAR(3)End of change Start of changeIndicates how incoming database mirror 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.
End of change

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
Start of changeDb2 Mirror serverEnd of change Start of changeQDBMSRVREnd of change
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