Configuring a Replication Server

Configure a Replication Server using the values in the example.

Prerequisites
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
  1. Go to the $SYBASE directory.
  2. Add the primary Adaptive Server, the replicate Adaptive Server, the Replication Server, and the server containing the RSSD database to the interfaces file.
  3. Set the environment variables by sourcing the SYBASE.csh file.
  4. Go to $SYBASE/REP-15_5/init/rs.
  5. Make a copy of the install.rs file and rename it as myrs.rs.
  6. 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.

  7. Save the file.
  8. Go to the $SYBASE/REP-15_5/install directory.
  9. 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.