The QUSRBRM.ENTERPRISE_HUB_INFO view shows the settings for the hub system which defines the enterprise network.

Authorization:

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

Result Table

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

Column Name	System Column Name	Data Type	Description
PRIMARY_CONTACT	PRIMARY	VARCHAR(10) Nullable	The primary contact for the hub system. Contains the null value if the primary contact name is not set.
SEND_ERROR_EMAIL	SENDERROR	VARCHAR(10) Nullable	Send an email notification to the primary hub contact when errors occur in the network. The possible values are: NO YES *REPORTDFN (Use the value specified on the Report Definition) Contains the null value if the email notification field is not set.
SEND_REPORT_EMAIL	SENDREPORT	VARCHAR(10) Nullable	Send an email notification to the primary hub contact with the reports generated in the network. The possible values are: NO YES *REPORTDFN (Use the value specified on the Report Definition) Contains the null value if the email notification field is not set.
REFRESH_RATE	REFRESH	INTEGER	The refresh frequency that enterprise node communication will be verified for the systems defined in the enterprise network. The refresh frequency represent minutes and must be 0 or between the range 15 to 16,666 minutes. The value 0 indicates that no refresh action will be performed.

Examples

Example 1: Report the primary hub contact and refresh rate

SELECT PRIMARY_CONTACT, REFRESH_RATE FROM QUSRBRM.ENTERPRISE_HUB_INFO

Example output:

PRIMARY_CONTACT	REFRESH_RATE
ADMIN	0