Configuring a Replication Server

Configure a Replication Server using the values in the example.

Prerequisites

Allocate a disk partition of at least 20MB for each Replication Server you are installing. You can add more partitions later, if necessary.
Ensure that the raw device or file system is available and has write permissions. If using a raw device, allocate the entire partition to the Replication Server. You can add more space for the stable device later, if necessary. If you allocate only a part of the partition to Replication Server, you cannot use the remainder for any other purpose.

Task

Each replication system has a single Replication Server that manages the overall environment information. This Replication Server is called an ID Server. A primary database is the source of replication and can only belong to one Replication Server environment. A replicate database is the destination database.

This example creates a single Replication Server, which has a Replication Server System Database (RSSD) in an existing Adaptive Server. The script, in this example, creates the data and log devices that the RSSD database will use. In this example:

PRS – name of the Replication Server
sunak1505i – name of the Adaptive Server where the RSSD will reside

Go to the $SYBASE directory.
Add the primary Adaptive Server, the replicate Adaptive Server, the Replication Server, and the server containing the RSSD database to the interfaces file.
Set the environment variables by sourcing the SYBASE.csh file.
Go to $SYBASE/REP-15_5/init/rs.
Make a copy of the install.rs file and rename it as PRS.rs.

Edit the parameter values in PRS.rs file.

Note: You need to modify the parameters described in the Sample values for PRS.rs file table.

Sample Values for PRS.rs File
Parameter	Description	Values
sybinit.release_directory	Valid path where Replication Server instance is created ($SYBASE).	/opt/sybase
rs.rs_idserver_name	Name of the Replication Server.	PRS
rs.rs_id_server_is_rs_server	Specifies whether the Replication Server created is the ID server or not.	yes
rs.rs_idserver_user	Because this is the ID server, user name that other Replication Servers will use to connect to this Replication Server. If this is not the ID server, then it is the user name of the ID server identified in the parameter, rs.rs_idserver_name.	PRS_id_user Note: The default name is the name of the Replication Server followed by _id_user. For example, PRS_id_user.
rs.rs_idserver_pass	Password of the ID server user.	PRS_id_passwd
rs.rs_name	The name of the Replication Server.	PRS
rs.rs_rs_sa_pass	Password for the sa user ID.	sa_pass Note: You can enter a maximum of 30 bytes in the password field. For: single-byte character – enter 6 to 30 characters. double-byte character – enter 3 to 15 characters.
rs.rs_needs_repagent	Specifies whether the RSSD needs a RepAgent. This is needed when multiple replication severs are used to replicate data from the primary to the replicate.	no Note: If the primary database and the replicate database will be replicating through multiple Replication Servers, enter yes.
rs.rs_rssd_sqlsrvr	The name of the Adaptive Server where the RSSD will reside.	sunak1505i
rs.rs_rssd_db	Specifies the name of the RSSD database.	USE_DEFAULT Note: The default name is the name of the Replication Server followed by _RSSD. For example, PRS_RSSD.
rs.rs_create_rssd	Specifies whether the script will create the RSSD database.	yes
rs.rs_rssd_sa_login	Specifies the name of the login that has “sa” privileges.	sa
rs.rs_rssd_sa_pass	Specifies the password of the login entered in the rs.rs_rssd_sa_login parameter.	password
rs.rs_rssd_prim_user	User that the Replication Server uses to log into the RSSD.	PRS_RSSD_prim Note: The default name is the name of the RSSD database followed by _prim. For example, PRS_RSSD_prim.
rs.rs_rssd_prim_pass	Specifies the password of the login entered in the rs.rs_rssd_prim_user parameter.	PRS_RSSD_prim_ps
rs.rs_rssd_maint_user	User that the Replication Server uses to log into the RSSD when getting work from other Replication Servers.	PRS_RSSD_maint Note: The default name is the name of the RSSD database followed by _maint. For example, PRS_RSSD_maint.
rs.rs_rssd_maint_pass	Specifies the password of the login entered in the rs.rs_rssd_maint_user parameter.	PRS_RSSD_maint_ps
rs.rs_rsdddb_size	Specifies the size (in MB) of the system database device.	40
rs.rs_rssd_log_size	Specifies the size (in MB) of the RSSD database log device.	32
rs.rs_rssd_db_device_name	The name of the ASE device that stores the data portion of the RSSD database.	PRS_RSSD_data
rs.rs_create_rssd_database_dev	Specifies whether a new ASE device needs to be created for the data portion of the RSSD database.	yes
rs.rs_rssd_db_device_path	Specifies the physical path for file system and file (or raw device) for the RSSD database data device.	/opt/sybase/PRS_RSSD_data
rs.rs_rssddb_device_size	Specifies the size (in MB) of the RSSD database device.	40 The value must be the size of the data portion of the RSSD database specified in the rs.rs_rsdddb_size or greater.
rs.rs_rssd_log_device_name	Specifies the logical name of RSSD database log device.	PRS_RSSD_log
rs.rs_create_rssd_log_dev	Specifies whether the device for the log will be created.	yes Note: If the same device is used for both data and log, then enter no for this parameter.
rs.rs_rssd_log_device_path	Specifies the physical path for file system and file (or raw device) for the RSSD database log device.	/opt/sybase/PRS_RSSD_log
rs.rs_rssd_log_device_size	Specifies the size (in MB) of the RSSD database log device.	32 The value must be the size of the log portion of the RSSD database specified in the rs.rs_rsdddb_log_size or greater.
rs.rs_diskp_name	Specifies the path and raw device (or file name) for the Replication Server stable device. This file or device must already exist.	/opt/sybase/PRSpart1.dat
rs.rs_diskp_lname	Specifies the logical name of the stable device partition.	part1
rs.rs_diskp_size	Specifies the size, in MB, of the stable device partition.	20 The minimum size is 20MB.
rs.rs_rs_user	User that other Replication Servers can use when a route between Replication Servers is created .	PRS_rsi Note: The default name is the name of the Replication Server followed by _rsi. For example, PRS_rsi.
rs.rs_rs_pass	Specifies the password of the login entered in the rs.rs_rs_user parameter.	PRS_rsi_ps
rs.rs_ltm_rs_user	Default user for Replication Agents to log into the Replication Server.	PRS_ra Note: The default name is the name of the Replication Server followed by _ra. For example, PRS_ra.
rs.rs_ltm_rs_pass	Specifies the password of the login entered in the rs.rs_ltm_rs_user parameter.	PRS_ra_ps

Save the file.
Go to the $SYBASE/REP-15_5/install directory.
Create the Replication Server and the RSSD:
```
./rs_init -r ../init/rs/PRS.rs
```
Note: If the rs_init command does not complete, check the log file in $SYBASE/$SYBASE_REP/init/log, correct the error, and resubmit the rs_init. If the problem occurred because the RSSD database had no space, then run the isql command on the data server and delete the RSSD database (for example, PRS_RSSD). If the rs_init command created the devices for the RSSD database, drop the devices (sp_dropdevice), and resubmit the rs_init command.