Table 9-3: Column descriptions for add *server*
Column	Description
Action	The name of the action
Result	The result of the execution

add server

Description

Adds a server to be monitored by the RMS.

Syntax

add {ASA | ASE | DirectConnect | IQ | Replication Agent | MRA |
Replication Server | RMS | Open Server | dbltm} server_name
              set username [to] user
              [set password [to] passwd]
              [set charset [to] charset]
              [set language [to] lang]
              [set rssd_username [to] rssd_user]
              [set rssd_password [to] rssd_passwd]
              [set rssd_charset [to] rssd_charset]
              [set rssd_language [to] rssd_lang]
              [set monitoring [to] {'true' | 'false'}]
              [set interval [to] interval]
              [set connection_ds [to] ds]
              [set connection_db [to] db]

Parameters

ASA, ASE, DirectConnect, IQ, Replication Agent, MRA, Replication Server, RMS, Open Server, dbltm: Specifies the type of server to add to the RMS. You can add a remote RMS to a controlling RMS.

server_name: Specifies the name of the server as listed in the RMS interfaces file or LDAP server.

user: Specifies the user name that the RMS uses when establishing a connection to the server. The user name must have the required permissions to allow the RMS to monitor the server.

passwd: Specifies the corresponding password that the RMS uses when establishing a connection.

charset: Specifies the character set that the RMS uses when establishing a connection to the server. If you do not specify charset, jConnect uses the server’s default character set.

lang: Specifies the language that the RMS uses when establishing a connection to the server. If you do not specify the language, jConnect uses the server’s default language.

rssd_user: Specifies the user name that the RMS uses when establishing a connection to the server that contains the RSSD. The user name must have the required permissions to allow the RMS to monitor the server. This parameter is required for a Replication Server.

rssd_passwd: Specifies the corresponding password that the RMS uses when establishing a connection to the server that contains the RSSD.

rssd_charset: Specifies the character set that the RMS uses when establishing a connection to the server that contains the RSSD. If you do not provide the charset, jConnect uses the server’s default character set.

rssd_lang: Specifies the language that the RMS uses when establishing a connection to the server that contains the RSSD. If you do not provide the language, jConnect uses the server’s default language.

monitoring: Specifies whether the RMS is monitoring the state of the server and its components. If this value is false, monitoring for this server is disabled. If this value is true (the default), RMS automatically monitors this server.

interval: Specifies the number of seconds between monitoring cycles. If the monitoring property is set to true, then RMS performs periodic monitoring based on the value of interval. For example, if the value is set to 120, the RMS checks the health of the server every 120 seconds. The range of values is 30 seconds to 1 hour and the default value for the interval is the value of ping_interval in RMS config.

ds: Specifies the name of the primary data server. The dbltm sends ds.db to the Replication Server when replicating transactions. The ds must match the server name used in the Replication Server connection. This parameter is optional and is valid only for a dbltm server.

db: Specifies the name of the primary database. The dbltm server sends ds.db to the Replication Server when replicating transactions. The db must match the database name used in the Replication Server connection. This parameter is optional and is valid only for a dbltm server.

Examples

Example 1

Adds a Replication Server named INVENTORY_RS to the RMS. Uses the user name “sa” without a password, character set, or language when establishing a connection. Uses the user name “sa” and the password “sa_pwd” when establishing a connection to the RSSD:

add replication server INVENTORY_RS
    set username to sa
    set rssd_username to sa
    set rssd_password to sa_pwd

Example 2

Adds a server named INVENTORY_PDS to the RMS. Sets the user name, password, language, monitoring and interval:

add ASE INVENTORY_PDS
    set username to sa
    set password to sa_ps
    set language to Japanese
    set monitoring to true
    set interval to 120

Usage

Use the RSSD options when adding a Replication Server to the RMS. You need not add the server that contains the RSSD to the RMS.

The server name must be in the interfaces file or LDAP server that is used by the RMS.

When you issue add server, the RMS attempts to connect to the specified server and automatically determines its type and version. If the type or version is invalid or cannot be determined, or the server is already being monitored, the RMS returns an error message.

If the new server is a Replication Server, supply the user name for the RSSD.

The add server command returns the following result set:

Table 9-3: Column descriptions for add server
Column

Description

Action

The name of the action

Result

The result of the execution