QUSRBRM.ENTERPRISE_NODE_INFO View

Owned by Peter Lafler
Sept 14, 2022
2 min read

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:

  • NO

  • YES

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_
OUTPUT_ QUEUEU_LIBRARY
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.