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. Check each partition to make sure it is available and has write permissions.
Allocate a raw device or a file system that can be at least 20 MB for each Replication Server you are installing. You can add more space for the stable device later, if necessary. Ensure that the raw device or file is available and has write permissions. If using a raw device, allocate the entire partition to the Replication Server. If you allocate only a port of the partion 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 myrs.rs.

Edit the parameter values in myrs.rs file.

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

Sample Values for myrs.rs File
Parameter	Description	Values
sybinit.release_directory	Valid path where Replication Server instance is created ($SYBASE).	/opt/software
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_name	The name of the Replication Server	PRS
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 Note: Leave blank if you have a null password.
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_rsdddb_size	Specifies the size (in MB) of the system database device.	40
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_size	Specifies the size (in MB) of the RSSD database log device.	32
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.

Save the file.
Go to the $SYBASE/REP-15_5/install directory.
Create the Replication Server and the RSSD:
```
./rs_init -r ../init/rs/myrs.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.