Generally, Sybase recommends that you use the Sybase Central Add Server wizard to set up the Replication Server domain. However, in certain situations, you might prefer to use the following commands. For example, if you are setting domains for 30 servers, it may be easier to write a script using these commands than to use Sybase Central, so you can avoid having to issue each command to the RSM Server separately.
If you are installing an RSM Server for the first time and are using it to upgrade routes, define the RSM Server domain to include the Adaptive Servers and Replication Servers you want the specific RSM Server to manage.
To add a Replication Server to the domain, enter:
repserver name createobj login pwd use security_settings security_mechanism security_settings RSSD_Server RSSD_database RSSD_user RSSD_user_pwd RSSD_dbo RSSD_dbo_pwd log_file_path_name
To add an Adaptive Server to the domain:
sqlserver name createobj login pwd use_security_settings security_mechanism security_settings log_file_path_name
where:
name – is the name of the server you are adding.
login – is your login name.
pwd – is your password.
RSSD_Server – is the name of the RSSD Server you are defining.
RSSD_database – is the name of the RSSD.
RSSD_user – is the login name for the RSSD.
RSSD_user_pwd – is the password for the RSSD.
RSSD_dbo – is the database owner for the RSSD.
RSSD_dbo_pwd – is the password for the RSSD database owner.
log_file_path_name – is the path name for the log file.
Be sure you have enough log space in the RSSD before you execute repserver creatobj, which loads RSM stored procedures into the corresponding RSSD.