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:
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.
The “Database information” section of the worksheet identifies the database you are adding to the replication system:
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.
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.
Select Standby if you are adding the standby database for the warm standby application.
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?”
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.
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?”
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.