Setup Datastage Change Data Capture after bulk load

DWS · Post by **DWS** » Tue Jan 15, 2013 9:36 am

Hi everyone, how can I setup a Change Data Capture job in Datastage to run right after my initial bulk load of a table has finished in DB2?

I've already created all the components and jobs for mirroring the logs from the mainframe Z/OS to our DB2 database on Solaris UNIX. The problem is, we want to make sure that the moment our Bulk Load job is complete that our mirroring jobs kicks in right away to pick up any changes from our mainframe DB2 database.

We are using Datastage 8.5 on Solaris UNIX with a DB2 database on both mainframe Z/OS and UNIX. Also using Change Data Capture version 6.5.

Let me know if more info is required.

DWS · Post by **DWS** » Tue Jan 15, 2013 9:56 am

By the way, forgot some info. The bulk load we would like to use is a Datastage job, table to table.

Thanks.