Starting the subscription and running the job

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

  1. Log on to the InfoSphere CDC Management Console. Specify a user ID that is authorized to run the subscription.
  2. Open the Monitoring perspective.
  3. 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.
  4. 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.
  5. 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.
  6. Optional: After changes are committed to the source database, view the data that is written to the target database. For example, for DB2® connector:
    1. In the Designer client, open the database connector stage.
    2. 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.