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.
For subsystem routing information for some IBM i servers, see SERVER_SBS_CONFIGURATION view.
The QSYS2.SET_SERVER_SBS_ROUTING procedure can be used to modify the values shown in this view.
Authorization: The caller must have *OBJOPR and *READ authorities to the *USRPRF.
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. |
QZDASSINIT_SUBSYSTEM | ZDASBS_SEC | VARCHAR(10) Nullable
|
The subsystem name that incoming database server secure
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. |
QPWFSERVSS_SUBSYSTEM | PWFSBS_SEC | VARCHAR(10) Nullable
|
The subsystem name that incoming file server secure connections
will be rerouted to. Contains the null value when an alternate subsystem for this server has not been configured for this user. |
QDBMSRVR_SUBSYSTEM | DBMSBS | VARCHAR(10) Nullable
|
The 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. |
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.
|
QZDASSINIT_ROLLOVER | ZDA_RO_SEC | VARCHAR(3) | Indicates how incoming database server secure 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.
|
QPWFSERVSS_ROLLOVER | PWF_RO_SEC | VARCHAR(3) | Indicates how incoming file server secure connection requests are
handled if the specified subsystem cannot be used.
|
QDBMSRVR_ROLLOVER | DBM_RO | VARCHAR(3) | Indicates how incoming database
mirror 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 |
Database server secure | QZDASSINIT |
Data queue server | QZHQSSRV |
Db2® Mirror server | QDBMSRVR |
DDM | QRWTSRVR |
DRDA | QRWTSRVR |
File server | QPWFSERVSO |
File server secure | QPWFSERVSS |
Network print server | QNPSERVS |
Remote command server | QZRCSRVS |
Example
Query subsystem routing information for all user profiles:
SELECT * FROM QSYS2.SERVER_SBS_ROUTING