The QUSRBRM.NETWORK_INFO view shows the systems and settings for the BRMS network.

Authorization:

The authorization ID of the statement must include the following privileges:

*OBJOPR and *READ authority to the QUSRBRM/BRMNET_INF file.

Result Table

The following table describes the columns in the view. The system name is BRMNET_INF. The schema is QUSRBRM.

Column Name	System Column Name	Data Type	Description
SYSTEM_NAME	SYSTEM	VARCHAR(17)	The system name included in the enterprise network. Note: The system format is nnnnnnnn.ssssssss where nnnnnnnn is the network identifier and ssssssss is the local location name.
RELATIONAL_DATABASE_NAME	RDBNAME	VARCHAR(18)	The relational database name of the enterprise node.
SYSTEM_STATUS	SYSSTATUS	VARCHAR(7) Nullable	Indicates the system status of the network system relative to the local system. The status is updated with each attempt by the local system to communicate with the network system. The possible values are: OFFLINE ONLINE Contains the null value if the system status has not been set.
COMMUNICATION_STATUS	COMSTATUS	VARCHAR(8) Nullable	Indicates the communication status of the network system relative to the local system. The status is updated with each attempt by the local system to communicate with the network system. The possible values are: ACTIVE INACTIVE Contains the null value if the system communication status has not been set.
LOCAL_RECEIVES_HISTORY	LCLRCVHST	VARCHAR(3) Nullable	Indicates whether history information will be received by the current system from the specified remote system. The possible values are: NO YES Contains the null value if the local receives history has not been set.
REMOTE_RECEIVES_HISTORY	RMTRCVHST	VARCHAR(3) Nullable	Indicates whether the remote system is to receive history information from the current system. The possible values are: NO YES Contains the null value if the remote receives history has not been set.

Examples

Example 1: Report the system status for system name APPN.SYSTEM1

SELECT SYSTEM_NAME, SYSTEM_STATUS, COMMUNICATION_STATUS FROM QUSRBRM.NETWORK_INFO WHERE SYSTEM_NAME = 'APPN.SYSTEM1'

Example output:

SYSTEM_NAME	SYSTEM_STATUS	COMMUNICATION_STATUS
APPN.SYSTEM1	ONLINE	ACTIVE

Example 2: Report the systems which are OFFLINE

SELECT SYSTEM_NAME, SYSTEM_STATUS FROM QUSRBRM.NETWORK_INFO WHERE SYSTEM_STATUS = 'OFFLINE'

Example output:

SYSTEM_NAME	SYSTEM_STATUS
APPN.SYSTEM3	OFFLINE
APPN.SYSTEM4	OFFLINE
APPN.SYSTEM9	OFFLINE

IBM Partnership

QUSRBRM.NETWORK_INFO View

Examples

Example 1: Report the system status for system name APPN.SYSTEM1

Example 2: Report the systems which are OFFLINE