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: NO YES 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

IBM Partnership

QUSRBRM.ENTERPRISE_NETWORK_INFO View

Examples

Example 1: Report systems in the network which are not active

Example 2: Report systems in the network which are behind on network transactions

Example 3: Report systems that failed backups the last time they ran