The QUSRBRM.ADD_ENTERPRISE_NODE procedure adds a new system to BRMS enterprise as a node.

Parameters

QUSRBRM.ADD_ENTERPRISE_NODE (SYSTEM_NAME=> system-name, RELATIONAL_DATABASE_NAME=> relational-database-name, ADD_NETWORK_SYSTEMS => add-network-systems, PRIMARY_CONTACT=> primary-contact, SECONDARY_CONTACT=> secondary-contact, HUB_OUTPUT_QUEUE_LIBRARY=> hub-output-queue-library, HUB_OUTPUT_QUEUE=> hub-output-queue, NODE_OUTPUT_QUEUE_LIBRARY=> node-output-queue-library, NODE_OUTPUT_QUEUE=> node-output-queue, DESCRIPTION=> description)

system-name (required)

Specifies the system name to be added to the enterprise network. Possible values are:

system-name

The name of the system to be added to the enterprise network.

The system format is nnnnnnnn.ssssssss where nnnnnnnn is the network identifier and ssssssss is the local location name.

relational-database-name (required)

Specifies the relational database name of the enterprise node. Possible values are:

relational-database-name

The name of the relational database of the enterprise node.

add-network-systems (Optional)

Specifies to add nodes for each system in the node's BRMS network when adding the current system name.

Possible values are:

NULL	The optional value has not been specified.
NO	Specifies to only add the single system name to the enterprise network. This is the default when the parameter is not specified.
YES	Specifies to add nodes for the system name and add nodes for each system in its BRMS network to the enterprise network.

primary-contact (optional)

Specifies the name of the primary contact for the enterprise node. Possible values are:

NULL	The optional value has not been specified.
primary-contact	The primary contact name for the enterprise node. The contact name can be up to 10 characters long and must exist in the Enterprise Contacts file.

secondary-contact (optional)

Specifies the name of the secondary contact for the enterprise node. Possible values are:

NULL	The optional value has not been specified.
secondary-contact	The secondary contact name for the enterprise node. The contact name can be up to 10 characters long and must exist in the Enterprise Contacts file.

hub-output-queue-library (optional)

Specifies the output queue library name where reports are stored on the BRMS enterprise hub system. Possible values are:

NULL	The optional value has not been specified.
hub-output-queue-library	The library name of the output queue where reports are stored on the BRMS enterprise hub system.

hub-output-queue (optional)

Specifies the output queue where reports are stored on the BRMS enterprise hub system. Possible values are:

NULL	The optional value has not been specified.
hub-output-queue	The name of the output queue where reports are stored on the BRMS enterprise hub system.

node-output-queue-library (optional)

Specifies the output queue library name where reports are stored on this BRMS enterprise node system. Possible values are:

NULL	The optional value has not been specified.
node-output-queue-library	The library name of the output queue where reports are stored on this BRMS enterprise node system.

node-output-queue (optional)

Specifies the output queue where reports are stored on this BRMS enterprise node system. Possible values are:

NULL	The optional value has not been specified.
node-output-queue	The output queue where reports are stored on this BRMS enterprise node system.

Setting a value other than NULL for NODE_OUTPUT_QUEUE_LIBRARY=> node-output-queue-library, NODE_OUTPUT_QUEUE=> node-output-queue will indicate the reports are additionally stored on the node and will explicitly set the field STORE_REPORTS_ON_NODE to YES on the QUSRBRM.ENTERPRISE_NODE_INFO View.

description (optional)

Specifies a description for the enterprise node. Possible values are:

NULL	The optional value has not been specified.
description	Specifies a description for the node. The description can be up to 128 characters long.

Authorization: The privileges held by the authorization ID of the statement must include the following:

*EXECUTE SQL privilege on this procedure

The BRMS Network feature is required. The schema is QUSRBRM.

Examples:

To add a new node system named SALES with relational database name SALESRDB:

call QUSRBRM.ADD_ENTERPRISE_NODE( SYSTEM_NAME=> 'SALES', RELATIONAL_DATABASE_NAME=> 'SALESRDB')

call QUSRBRM.ADD_ENTERPRISE_NODE( SYSTEM_NAME=> 'SALES', RELATIONAL_DATABASE_NAME=> 'SALESRDB')

To add a new node system named SALES with relational database name SALESRDB and include a description:

call QUSRBRM.ADD_ENTERPRISE_NODE( SYSTEM_NAME=> 'SALES', RELATIONAL_DATABASE_NAME=> 'SALESRDB'), DESCRIPTION=>'Sales IBM i' )

call QUSRBRM.ADD_ENTERPRISE_NODE( SYSTEM_NAME=> 'SALES', RELATIONAL_DATABASE_NAME=> 'SALESRDB'), DESCRIPTION=>'Sales IBM i' )

To add a new node system named SALES with relational database name SALESRDB and add all the systems currently defined in BRMS network for system SALES :

call QUSRBRM.ADD_ENTERPRISE_NODE( SYSTEM_NAME=> 'SALES', RELATIONAL_DATABASE_NAME=> 'SALESRDB' ADD_NETWORK_SYSTEMS => 'YES')

call QUSRBRM.ADD_ENTERPRISE_NODE( SYSTEM_NAME=> 'SALES', RELATIONAL_DATABASE_NAME=> 'SALESRDB' ADD_NETWORK_SYSTEMS => 'YES')

Error Messages

The following SQL States and error messages may be returned by this procedure.

U0001	Server is not valid.
U0002	Enterprise Node already exists.
U0004	Relational database required.
U0005	Relational database entry not found.
U0006	Primary Contact not found.
U0007	Secondary Contact not found.
U0008	Hub Output Queue required when Hub Output Queue Library is specified.
U0009	Hub Output Queue Library required when Hub Output Queue is specified.
U0010	Hub Output Queue and/or Hub Output Queue Library not valid.
U0011	Node Output Queue required when Node Output Queue Library is specified.
U0012	Node Output Queue Library required when Node Output Queue is specified.
U0013	Node Output Queue and/or Node Output Queue Library not valid.
U0015	Unable to add Enterprise Node.
U0024	Add network systems not valid. Must be NO or YES.
U9997	Functional authority to BRMS Enterprise QIBM_Q1A_ENT required.
U9998	BRMS Network and Advanced Functions features required.
U9999	Illegal execution.

IBM Partnership

QUSRBRM.ADD_ENTERPRISE_NODE Procedure

Parameters

Examples:

Error Messages