QUSRBRM.ADD_NETWORK_SYSTEM Procedure

The QUSRBRM.ADD_NETWORK_SYSTEM procedure adds a new system to the BRMS network.

 

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.

Initial setup requirements:

  • Establish Network Connectivity

    • BRMS Enterprise communications use TCP/IP communications and relational database (RDB) entries for all of its network operations which must be configured by your site security administrator. BRMS does not set up communication or create the necessary systems configuration. BRMS expects that the communication setup has been done by the site security administrator.

    • BRMS connectivity can be checked by running the Initialize BRMS (INZBRM) command with *VFYSYS, *VFYNET specified for the Option (OPTION) parameter. For more information reference Verify BRMS Network and BRMS Enterprise Network Connections

Parameters

QUSRBRM.ADD_NETWORK_SYSTEM (SYSTEM_NAME=> system-name, RELATIONAL_DATABASE_NAME=> relational-database-name, LOCAL_RECEIVES_HISTORY => local-receives-history, REMOTE_RECEIVES_HISTORY=> remote-receives-history)

system-name (Required)

Specifies the remote system name to be added to the BRMS network.

Possible values are:

system-name

The system name to be added to the BRMS network.

Note: 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 remote system being added to the network.

Possible values are:

relational-database-name

The relational database name of the remote system being added to the network.

 

local-receives-history (Required)

Specifies whether media content information will be received by the local system from the specified remote system being added to the network.

Possible values are:

NO

Specifies that media history information will not be received from the remote system on the local system.

YES

Specifies that media history information will be received from the remote system on the local system. The information will include library level information only.

 

remote-receives-history (Required)

Specifies whether media content information will be received by the remote system from the local systems when after it has been added to the network.

Possible values are:

NO

Specifies that media history information will not be received on the remote system from the local system.

YES

Specifies that media history information will be received on the remote system from the local system. The information will include library level information only.

Examples:

To add a new remote system named APPN.PROD1 with relational database name PROD1RDB with local receives history YES and remote receives history NO:

call QUSRBRM.ADD_NETWORK_SYSTEM(

     SYSTEM_NAME=> 'APPN.PROD1', 

     RELATIONAL_DATABASE_NAME=> 'PROD1RDB',

     LOCAL_RECEIVES_HISTORY=> 'YES',

     REMOTE_RECEIVES_HISTORY=>'NO')

call QUSRBRM.ADD_NETWORK_SYSTEM(

     SYSTEM_NAME=> 'APPN.PROD1', 

     RELATIONAL_DATABASE_NAME=> 'PROD1RDB',

     LOCAL_RECEIVES_HISTORY=> 'YES',

     REMOTE_RECEIVES_HISTORY=>'NO')

Error Messages

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

U0001

System name is not valid.

U0002

System name already exists.

U0003

Relational database required.

U0004

Relational database entry not found.

U0005

Local receives history not valid. Must be NO or YES.

U0006

Remote receives history not valid. Must be NO or YES.

U0007

Add Network System failed.

U9997

Functional authority to BRMS Enterprise QIBM_Q1A_SYS required.

U9998

BRMS Network Functions features required.

U9999

Illegal execution.

 

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.