Setting up the datastore for shadow
tables with the IBM® InfoSphere® CDC Management Console consists
of creating one datastore for the replication with InfoSphere CDC and
configuring a datastore connection.
This datastore represents
the data files that are required for data replication. The datastore
connection provides access to the InfoSphere CDC instance
from the access server for its configuration, monitoring, and operational
control.
Procedure
To set up one datastore for shadow tables:
- Log in to the InfoSphere CDC
Management Console as access-server-user in the access-server-host.
- Create the datastore:
- Click .
- Click .
- Enter access-server-datastore-name in the Name box.
- Enter a description in the Description box.
- Enter the host name or the full IP address of the cdc-server-host where
you installed InfoSphere CDC in
the Host Name box.
- Enter cdc-port of the
server in the Port box.
- Ping cdc-server-host.
If successful, the datastore properties dialog box is displayed.
- Click OK.
- Configure a datastore connection:
- Click .
- Select access-server-datastore-name that
you created in 2.
- Right-click the datastore and select Assign
user.
- In the Select Users window, select access-server-user and click OK.
- In the Connection Parameters section,
enter the information for the following fields:
- For DB login, enter db2-cdc-user.
- DB Password and Confirm Password, enter the password for db2-cdc-user.
- Complete the Connection/Retry Options section
as follows:
- Ensure that the Always show connection dialog box
is cleared.
- Select the Show parameter values box.
- Ensure that the Write-protect parameters box
is cleared.
- Select the Allow connection parameters saving box.
- Click OK.