Setting up replication with IBM InfoSphere CDC Management Console
The replication subscriptions are created in the Management Console. This section provides a high-level overview of the process with references to more detailed instructions in the IBM InfoSphere Change Data Capture Management Console, Administration Guide.
Before you begin
▪Check that the tables you intend to replicate exist on the solidDB® servers. It is also possible to create tables during the replication if the tables do not contain foreign keys.
▪Check that your solidDB® databases are running.
▪Check that your IBM InfoSphere CDC instances for solidDB® servers are running.
▪You have sufficient access privileges to your databases.
▪You have defined your desired replication principles in accordance with your business rules.
Procedure
1 Log into Management Console / Connect to Access Server.
For detailed instructions, see section Logging into Management Console (Connecting to Access Server) in the IBM InfoSphere Change Data Capture Management Console, Administration Guide.
Tip: To be able to work in the Access Manager perspective of the Management Console, you must be a System Administrator that has the privilege to manage datastores and user accounts. The System Administrator account was created during the installation of the Management Console.
2 Set up datastores.
a Add a new datastore. For detailed instructions, see “To add a new datastore” in the IBM InfoSphere Change Data Capture Management Console, Administration Guide.
b Set connection parameters. For detailed instructions, see “To set connection parameters on a datastore” in the IBM InfoSphere Change Data Capture Management Console, Administration Guide.
3 Assign datastores to users.
You need to assign all datastores to the same users.
a If necessary, add new users. To be able to add new users, you must be a System Administrator that has the privilege to manage user accounts. For detailed instructions, see “Managing user accounts” in the Management Console Administration Guide.
b Assign datastores to users. For detailed instructions, see “Assigning users to datastores” in the Management Console Administration Guide.
c To make the changes effective, disconnect and reconnect to the Access Server.
1. Click File > Access Server > Disconnect.
2. Click File > Access Server > Connect.
4 Optionally, set the connection preferences for connecting to the datastores.
You can also continue with the default settings.
For detailed instructions, see “Setting connection preferences” in the IBM InfoSphere Change Data Capture Management Console, Administration Guide.
5 Set up datastores for replication / connect to the datastores.
For detailed instructions, see “Setting up datastores for replication” in the IBM InfoSphere Change Data Capture Management Console, Administration Guide.
6 Optionally, set system parameters on the datastores.
For detailed instructions, see “Setting system parameters on source and target datastores” in the Management Console Administration Guide.
7 Set up subscriptions according to your replication needs.
For example, for bidirectional replication between node A and node B, do the following:
a Add a subscription where the node A is the source and node B is the target.
b Add a subscription where the node B is the source and node A is the target.
For detailed instructions, see “Setting up subscriptions” in the IBM InfoSphere Change Data Capture Management Console, Administration Guide.
8 Map tables for replication in all subscriptions.
For detailed instructions, see “Mapping tables” in the IBM InfoSphere Change Data Capture Management Console, Administration Guide.
9 For each table mapping, set conflict detection and resolution in accordance with your business rules.
For detailed instructions, see “Setting conflict detection and resolution in the IBM InfoSphere Change Data Capture Management Console, Administration Guide.
10 Start replication on all subscriptions.
For detailed instructions, see “Starting and ending replication on subscriptions” in the IBM InfoSphere Change Data Capture Management Console, Administration Guide.