You start the subscription in the InfoSphere® CDC Management Console.
If auto-start is selected, starting the subscription automatically
starts the InfoSphere DataStage® job.
If auto-start is not selected, you must start the job manually.
Before you begin
If the subscription has been running recently,
verify that the previous InfoSphere DataStage job
run has completed and that all data has been processed before starting
the subscription. If replication begins before the previous job run
has completed, the job might produce errors or fail.
Also
verify that the job is compiled and that it is ready to run.
Procedure
- Log on to the InfoSphere CDC Management Console.
Specify a user ID that is authorized to run the subscription.
- Open the Monitoring perspective.
- In the Subscriptions tab, right-click
the name of the subscription, and select one of the following replication
methods:
Option |
Description |
Start Mirroring |
Select this option to continuously monitor the source for
updates. |
Start Refresh |
Select this option to replicate all existing data
on the source to the target. This option provides a simple snapshot
of the source. For more information about this option, see the InfoSphere CDC documentation. |
- Select one of the following options to control how the
job runs:
Option |
Description |
Continuous |
Select this option to replicate continuously until the subscription
is stopped. All updates are captured. |
Scheduled end |
Select this option to replicate until a specified time or
location in the log is reached. |
- If the job is not configured to start automatically, start
the job. In the IBM® InfoSphere DataStage and QualityStage® Designer client,
open the job, and click Run. When
the job is running, the links turn blue, and you can see that the
row count for the bookmark link increments.
- Optional: After changes are committed to the
source database, view the data that is written to the target database.
For example, for DB2® connector:
- In the Designer client,
open the database connector stage.
- Select an input link that is associated with a table.
In the Properties tab, click View
Data. The View Data window
shows all change data records that are stored in the target database
table. Repeat this step to see data for other tables.
You can also run, schedule, and monitor the job in the InfoSphere DataStage and QualityStage Director client.