The QUSRBRM.ADD_ENTERPRISE_NODE procedure adds a new system to BRMS enterprise as a node.
Parameters
|
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. |
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. |
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') |
|---|
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' ) |
|---|
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. |
U9999 | Illegal execution. |