QUSRBRM.ENTERPRISE_NETWORK_INFO View
The QUSRBRM.ENTERPRISE_NETWORK_INFO view shows the systems and status information for each system in the BRMS enterprise network.
Authorization:
The authorization ID of the statement must include the following privileges:
*OBJOPR and *READ authority to the QUSRBRM/NET_INFO object.
Result Table
The following table describes the columns in the view. The system name is NET_INFO. 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. |
INSTALLED_BRMS_RELEASE | RELEASE | VARCHAR(6) Nullable | The BRMS installed release on the system. Contains the null value if the initial system connection has not been established. |
LATEST_BRMS_PTF_ID | BRMSPTFID | VARCHAR(7) Nullable | The BRMS PTF ID applied on the system. Contains the null value if the initial system connection has not been established. |
COMMUNICATION_ACTIVE | COMM_ACT | VARCHAR(3) Nullable | The system active communication status in the network. Reports if the latest attempt to communicate with the system was successful. The possible values are:
Contains the null value if the initial system connection has not been established. |
TRANSACTIONS_BEHIND | T_BEHIND | BIGINT | The number of BRMS database network updates that have not been synchronized to the other systems in the traditional BRMS network. |
TOTAL_REPORTS | TOTALRPT | INTEGER | The number of reports defined to be run on the system. |
SUCCESS_REPORTS | SUCCESSRPT | INTEGER | The number of reports which ran successfully. |
FAILED_REPORTS | FAILEDRPT | INTEGER | The number of reports which failed. |
NOT_RUN_REPORTS | NOTRUNRPT | INTEGER | The number of reports which are defined but have not been run yet. |
BACKUPS_FAILED_LAST_RUN | BKUFAILLR | INTEGER | The number of backups that failed the last time they ran. |
BACKUPS_FAILED_CURRENT_DAY | BKUFAILCD | INTEGER | The number of backups that failed on the current day. |
BACKUPS_FAILED_PREVIOUS_DAY | BKUFAILPD | INTEGER | The number of backups that failed on the previous day. |
BACKUPS_FAILED_PAST_WEEK | BKUFAILWK | INTEGER | The number of backups that failed in the past 7 days. |
Examples
Example 1: Report systems in the network which are not active
SELECT SYSTEM_NAME, INSTALLED_BRMS_RELEASE, COMMUNICATION_ACTIVE FROM QUSRBRM.ENTERPRISE_NETWORK_INFO WHERE COMMUNICATION_ACTIVE= 'NO'
Example output:
SYSTEM_NAME | INSTALLED_BRMS_RELEASE | COMMUNICATION_ACTIVE |
APPN.SYSTEM1 | V7R4M0 | NO |
APPN.SYSTEM4 | V7R4M0 | NO |
APPN.SYSTEM9 | V7R3M0 | NO |
Example 2: Report systems in the network which are behind on network transactions
SELECT SYSTEM_NAME, INSTALLED_BRMS_RELEASE, COMMUNICATION_ACTIVE, TRANSACTIONS_BEHIND FROM QUSRBRM.ENTERPRISE_NETWORK_INFO WHERE TRANSACTIONS_BEHIND > 0
Example output:
SYSTEM_NAME | INSTALLED_BRMS_RELEASE | COMMUNICATION_ACTIVE
| TRANSACTIONS_BEHIND |
APPN.SYSTEM1 | V7R4M0 | NO | 324782 |
APPN.SYSTEM4 | V7R4M0 | NO | 2489 |
APPN.SYSTEM9 | V7R3M0 | NO | 1525 |
Example 3: Report systems that failed backups the last time they ran
SELECT SYSTEM_NAME, INSTALLED_BRMS_RELEASE, LATEST_BRMS_PTF_ID, BACKUPS_FAILED_LAST_RUN FROM QUSRBRM.ENTERPRISE_NETWORK_INFO WHERE BACKUPS_FAILED_LAST_RUN > 0
Example output:
SYSTEM_NAME | INSTALLED_BRMS_RELEASE | LATEST_BRMS_PTF_ID
| BACKUPS_FAILED_LAST_RUN |
APPN.SYSTEM2 | V7R5M0 | SI80273 | 1 |
APPN.SYSTEM3 | V7R3M0 | SI80271 | 21 |
APPN.SYSTEM8 | V7R4M0 | SI80272 | 14 |
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.