DB2 10.5 for Linux, UNIX, and Windows

Setting up the datastore for shadow tables with commands for IBM InfoSphere CDC Access Server

Setting up the datastore for shadow tables with commands for IBM® InfoSphere® CDC Access Server 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.

Before you begin

Ensure that you can log in to the access-server-host as cdc-user.
Ensure that you can connect to db2-database-name as db2-cdc-user.
Ensure that you have access to cdc-instance-name, the InfoSphere CDC instance. For more information, see Setting up the InfoSphere CDC instance for shadow tables.

Procedure

To set up one datastore for shadow tables:

Create the datastore by running the following commands:

cd access-server-installation-dir/bin/ 
./dmcreatedatastore access-server-datastore-name access-server-datastore-desc
     cdc-server-host cdc-port

Add a datastore connection by running the following command:
```
./dmaddconnection access-server-user access-server-datastore-name 
   db2-database-name db2-cdc-user db2-cdc-user-password
   FALSE TRUE FALSE TRUE
```
This command creates a connection with the following characteristics:
- You are not prompted for a connection each time you try to connect to the datastore.
- All the connection parameters are displayed in a writeable format (except for the password) each time you try to connect to the datastore.
- You can save the connection parameters when you connect to the datastore.