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.
Authorization: You must have *OBJOPR and *READ authority to a *USRPRF or it will not be returned.
The QSYS2.SET_SERVER_SBS_ROUTING procedure can be used to change the values shown in this view.
The following table describes the columns in the view. The system name is SRVR_RTG. The schema is QSYS2.
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. |
QRWTSRVR_ROLLOVER | DRDA_RO | VARCHAR(3) | Indicates how incoming DRDA or
DDM connection requests are handled if the specified subsystem cannot
be used.
|
QZDASOINIT_ROLLOVER | ZDA_RO | VARCHAR(3) | Indicates how incoming database
server connection requests are handled if the specified subsystem
cannot be used.
|
QZRCSRVS_ROLLOVER | ZRC_RO | VARCHAR(3) | Indicates how incoming remote command
connection requests are handled if the specified subsystem cannot
be used.
|
QZHQSSRV_ROLLOVER | ZHQ_RO | VARCHAR(3) | Indicates how incoming data queue
server connection requests are handled if the specified subsystem
cannot be used.
|
QZSCSRVS_ROLLOVER | ZSC_RO | VARCHAR(3) | Indicates how incoming central
server connection requests are handled if the specified subsystem
cannot be used.
|
QNPSERVS_ROLLOVER | NPS_RO | VARCHAR(3) | Indicates how incoming network
print server connection requests are handled if the specified subsystem
cannot be used.
|
QPWFSERVSO_ROLLOVER | PWF_RO | VARCHAR(3) | Indicates how incoming file server
connection requests are handled if the specified subsystem cannot
be used.
|
The following table shows the servers that can have alternate subsystem configurations.
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