Use this procedure to implement event table processing. With event table processing, you can stop change data extraction processing based on user-defined events.
Create an event table.
The event table must be of the same source type and on the same machine as the change data to be extracted. For example, if you extract Db2 change data on z/OS, the event table must be a Db2 table in the same Db2 subsystem as the Db2 source tables for the extraction.
In the PowerExchange Navigator, create a capture registration for the event table.
When you create the capture registration, the PowerExchange Navigator generates a corresponding extraction map.
In PowerCenter, create a CDC connection and session.
In the
Event Table
attribute on the PWX CDC Real Time application connection, enter the name of the extraction map associated with the capture registration that you created.
Define applications that write an update to the event table whenever the defined event occurs.
PowerExchange reads the update and places an end-of-file (EOF) in the change stream. PWXPC processes the EOF, passes it to the PowerCenter Integration Service, and then shuts down the PowerExchange reader. The PowerCenter Integration Service completes writing all of the data that is in the pipeline to the targets and then ends the CDC session.