QUSRBRM.NETWORK_INFO View
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:
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:
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:
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:
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 |
Privacy Policy | Cookie Policy | Impressum
From time to time, this website may contain technical inaccuracies and we do not warrant the accuracy of any posted information.
Copyright © Fortra, LLC and its group of companies. All trademarks and registered trademarks are the property of their respective owners.