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.
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 Replication Server SA user.
Copy the information you have provided in the “Replication Server interfaces information” section of the Replication Server installation worksheet 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. 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.
See the Replication Server Administration Guide Volume 1 for more information about login names for replication system components.
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 Chapter 3, “Managing Warm Standby Applications” in the Replication Server Administration Guide Volume 2.
If you are adding a database that is part of a warm standby database application, complete the “Logical connection information” section of the worksheet.
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, “Managing Warm Standby
Applications” in the Replication Server Administration
Guide
Volume 2 for more information and to configure warm standby
for Adaptive Server databases. See Chapter 14, “Managing
Heterogeneous Warm Standby” in the Replication
Server Heterogeneous Replication Guide to configure warm standby
for Oracle databases.
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 have selected a standby connection over an active 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 data server of the active database. Replication Server uses this login name to set up warm standby applications.
Active DB SA password Required – enter the password for the System Administrator login name of the data server of the active database.
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.
If the database requires a Replication Agent and if you have selected to replicate the database, complete the “Database RepAgent information” section of the worksheet.
RS user Enter the Replication Server login name that the Replication Agent will use to connect to the Replication Server.
The default RS user login name and password for this Replication Agent is the default login name and password for the RS user for the RSSD RepAgent, which you noted in the “RSSD RepAgent” section of 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 then grant connect source permission to the user.
