How To
Summary
The attached script uses the CHCCLP scripting tool to start a CDC subscription. If it is already running, then nothing happens. Use this script in a scheduled Windows task to periodically start a subscription. This scheduled task can be helpful when the CDC instance frequently loses connection with a database for a brief period.
Objective
The objective is to add resiliency to CDC subscriptions by periodically starting a subscription.
Steps
- Download this script onto a system running Access Server or Management Console. It is written for a Microsoft™ Windows™ environment.
- Edit the script.
- Replace the values in the script for the access server username and password.
- Replace the datastore names in the script for the source and target datastores.
- Save and close the script.
- Create a Basic Task by using Task Scheduler.
- Select "Start a Program" as the task's action type.
- In the task's "Program/script" field, complete the command CHCCLP -f c:\CHCCLP\subscription_start_example.txt
- Complete the "Start in" field with the path to CHCCLP. It is typically C:\Program Files (x86)\ibm\InfoSphere Data Replication\Access Server\bin
- Finish the task.
Related Information
Document Location
Worldwide
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSTRGZ","label":"InfoSphere Data Replication"},"Component":"","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF051","label":"Linux on IBM Z Systems"},{"code":"PF043","label":"Red Hat"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"All Versions","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Product Synonym
CDC;CDD;IIDR;IDR
Was this topic helpful?
Document Information
Modified date:
09 March 2020
UID
ibm15694375