Make a copy of “Database setup worksheet” for each database you plan to add to the replication system.
Each primary or replicate database in your replication system is managed by a Replication Server. The database may also require a Replication Agent. See “Which databases require Replication Agents?” for more information.
See the Replication Server Design Guide for guidelines on configuring character sets, languages, and sort orders in your replication system.
See the Replication Server Administration Guide for more information about login names for replication system components.
Use the information in this section to complete the “Replication Server information” section of the worksheet, which identifies the Replication Server that will manage the database. The Replication Server must be installed and running before you can add the database to the replication system:
Replication Server name Required – enter the name of the Replication Server that will manage the database.
RS SA user Required – enter the Replication Server System Administrator (RS SA) login name (usually “sa”).
RS SA password Required – enter the password for the RS SA user.
Copy the information for the “Replication Server interfaces information” section from the Replication Server installation worksheet you completed for the Replication Server that will manage this database. Since the Replication Server is already installed, you do not have to enter this information again unless you start rs_init in a release directory that uses a different interfaces file.
Hostname/Address Required – enter the name of the machine where the Replication Server is running.
Port Required – enter the port number assigned to the Replication Server.
The “Database information” section of the worksheet identifies the database you are adding to the replication system:
Adaptive Server name Required – enter the name of the Adaptive Server where the database resides.
SA user Enter the “sa” login name for the Adaptive Server managing the database.
Will the database be replicated? Required – select Yes if the database requires a Replication Agent, and No if it does not. See “Which databases require Replication Agents?” for more information.
Maintenance user Enter a login name for Replication Server to use when updating replicated data. This user must be granted all permissions necessary to maintain the replicated data. rs_init creates this login, if it does not already exist, and grants the necessary permissions.
Maintenance password Enter the password for the maintenance user.
Is this a physical connection for an existing logical connection?
Select Yes if you are adding an active or standby database for a warm standby application, and No if you are not.
See the instructions for setting up warm standby databases in the Replication Server Administration Guide.
Complete the “Logical connection information” section of the worksheet only if you are adding a database that is part of a warm standby database application.
Setting up a warm standby application requires that
you perform additional tasks in the Replication Server before and
after you use rs_init to add the databases
to the replication system. See Chapter 3 of “Managing Warm Standby
Applications,” in the Replication Server Administration
Guide
Volume 2.
Is this an active connection or standby connection? Required –select Active if you are adding the active database for the warm standby application.
Select Standby if you are adding the standby database for the warm standby application.
Logical DS name Required – enter the name of the logical data server for the logical connection. You must have already created it using create logical connection.
Logical DB name Required – enter the name of the logical database for the logical connection. You must have already created it using create logical connection.
Complete the rest of the items in this section only if you selected standby in response to “Is this an active connection or standby connection?”
Active DS name Required – enter the name of the data server with the active database. Enter the actual data server name, not the logical data server name defined for the warm standby database pair.
Active DB name Required – enter the name of the active database. Enter the actual database name, not the logical database name defined for the warm standby database pair.
Active DB SA user Required – enter the login name of the System Administrator for the active database’s data server. Replication Server uses this login name to set up warm standby applications.
Active DB SA password Required – enter the password for the active data server’s System Administrator login name.
Initialize standby using dump and load? Required – select Yes if you plan to initialize the standby database with the contents of the active database with the dump and load commands.
Select No if you plan to initialize the standby database with the bcp utility, or if you do not need to initialize the standby database.
Use dump marker to start replicating to standby? Required – select Yes if transactions will be executed in the active database while the standby database is initialized, and No if they are not.
Complete the “Database RepAgent information” section of the worksheet if the database requires a RepAgent, and you selected Yes for “Will the database be replicated?”
RS user Enter the Replication Server login name that the RepAgent will use to connect to the Replication Server.
The default RS user login name and password for this RepAgent is the default login name and password for the RS user for the RSSD RepAgent, which you noted in the section titled “RSSD RepAgent” on the Replication Server installation worksheet. If you want this user to use a different login name and password, you must first create the user in the Replication Server and grant it connect source permission.
