Configuring InfoSphere CDC

After installing InfoSphere® CDC, the installation program starts a configuration tool. You use the configuration tool to add and configure InfoSphere CDC instances for your environment. You must configure InfoSphere CDC for the source database and for the target (InfoSphere DataStage®) before you can start replication.

Before you begin

Install InfoSphere CDC. For more information, see the InfoSphere CDC documentation.

About this task

This procedure describes the general steps that you must perform to configure InfoSphere CDC to work with the CDC Transaction stage. For more information about configuring InfoSphere CDC, see the InfoSphere CDC documentation that describes how to add and configure new instances.

Tip: If you plan to configure your job to start automatically when the subscription starts, ensure that the PATH environment variable contains the path to the dsjob executable file before you add the new CDC instances.

Procedure

Configure InfoSphere CDC for the source database. For example, if you are using IBM® DB2® Database for Linux, UNIX, and Windows as a source database, you configure InfoSphere CDC for DB2 for Linux, UNIX, and Windows.
1. On the computer where InfoSphere CDC for the source database is installed, start the InfoSphere CDC configuration tool (if it is not already running).
2. Add a new instance of InfoSphere CDC.
3. Specify configuration details about the instance, including the following settings:
  - For the Server Port, specify the port number that other servers will use to communicate with this instance of InfoSphere CDC for the source database. Write down the port number that you specify. You provide this port number when you specify access parameters for this data store in the Access Manager perspective in InfoSphere CDC Management Console.
  - Specify connection details for the database that contains the tables that you want to replicate.
4. Start the instance.
Configure InfoSphere CDC for InfoSphere DataStage.
1. On the computer where InfoSphere CDC for InfoSphere DataStage is installed, start the InfoSphere CDC configuration tool (if it is not already running).
2. Add a new instance of InfoSphere CDC.
  Important: After creating this instance, you cannot delete and recreate it without making subscriptions that use the instance unusable.
3. Specify configuration details about the instance, including the following settings:
  - For the Server Port, specify the port number that other servers will use to communicate with this instance of InfoSphere CDC for InfoSphere DataStage. Write down the port number that you specify. You provide this port number when you specify access parameters for InfoSphere DataStage in the Access Manager perspective in InfoSphere CDC Management Console.
  - Specify a password for the user named tsuser. Write down the password that you specify. You provide the tsuser ID and password when you specify connection parameters for InfoSphere DataStage in the Access Manager perspective in the InfoSphere CDC Management Console.

What to do next

After configuring InfoSphere CDC, you set up a new ODBC data source name (DSN) on the computer where InfoSphere DataStage is installed. For more information, see the topic about configuring access to ODBC data sources. The CDC Transaction stage uses ODBC to return bookmark information from the target database. You specify the ODBC DSN as a stage property when you configure the InfoSphere DataStage job.