QUSRBRM.ENTERPRISE_NODE_INFO View
- Peter Lafler
The QUSRBRM.ENTERPRISE_NODE_INFO view shows the settings for an enterprise node.
Authorization:
The authorization ID of the statement must include the following privileges:
*OBJOPR and *READ authority to the QUSRBRM/NODE_INFO object.
Result Table
The following table describes the columns in the view. The system name is NODE_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. |
RELATIONAL_DATABASE_NAME | RDBNAME | VARCHAR(18) | The relational database name of the enterprise node. |
PRIMARY_CONTACT | PRIMARY | VARCHAR(10) Nullable | The primary contact name of the enterprise node. Contains the null value if the primary contact name is not set. |
SECONDARY_CONTACT | SECONDARY | VARCHAR(10) Nullable | The secondary contact name of the enterprise node. Contains the null value if the secondary contact name is not set. |
HUB_OUTPUT_QUEUE_LIBRARY | HUBOUTQL | VARCHAR(10) | The output queue library name where reports are stored on the BRMS enterprise hub system. |
HUB_OUTPUT_QUEUE | HUBOUTQ | VARCHAR(10) | The output queue name where reports are stored on the BRMS enterprise hub system. |
STORE_REPORTS_ON_NODE | STORE_NODE | VARCHAR(3) | Indicate if the reports are additionally stored on the node where the report ran. The possible values are:
|
NODE_OUTPUT_QUEUE_LIBRARY | NODEOUTQL | VARCHAR(10) Nullable | The output queue library name where reports are stored on the node. Contains the null value if reports are not stored on the node. |
NODE_OUTPUT_QUEUE | NODEOUTQ | VARCHAR(10) Nullable | The output queue name where reports are stored on the node. Contains the null value if reports are not stored on the node. |
TEXT_DESCRIPTION | TEXT | VARGRAPHIC(128) CCSID 1200 Nullable | The text description of the enterprise node. Contains the null value if the text description is not set. |
Examples
Example 1: Report the output queues being used to store reports for system name APPN.SYSTEM1
SELECT SYSTEM_NAME, HUB_OUTPUT_QUEUE_LIBRARY, HUB_OUTPUT_QUEUE, STORE_REPORTS_ON_NODE, NODE_OUTPUT_QUEUE_LIBRARY, NODE_OUTPUT_QUEUE FROM QUSRBRM.ENTERPRISE_NODE_INFO WHERE SYSTEM_NAME = 'APPN.SYSTEM1'
Example output:
SYSTEM_NAME | HUB_OUTPUT_QUEUE_LIBRARY | HUB_OUTPUT_QUEUE | STORE_REPORTS_ON_NODE | NODE_ | NODE_OUTPUT_QUEUE |
APPN.SYSTEM1 | QUSRBRM | QENTRPT | NO | - | - |
Example 2: Report the contacts being used for system name APPN.SYSTEM5
SELECT SYSTEM_NAME, PRIMARY_CONTACT, SECONDARY_CONTACT FROM QUSRBRM.ENTERPRISE_NODE_INFO WHERE SYSTEM_NAME = 'APPN.SYSTEM5'
Example output:
SYSTEM_NAME | PRIMARY_CONTACT | SECONDARY_CONTACT |
APPN.SYSTEM5 | ADMIN | BACKUP |
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.