Table of Contents

Search

  1. Introduction
  2. PowerExchange Client for PowerCenter (PWXPC)
  3. PowerExchange ODBC
  4. PowerExchange Interfaces for PowerCenter Tips
  5. Datatypes and Code Pages
  6. PowerExchange Interfaces for PowerCenter Troubleshooting

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Configuring Event Table Processing

Configuring Event Table Processing

The following table describes the optional
Event Table
connection attribute:
Connection Attribute
Change or Real Time
Description
Event Table
Real Time
Specifies the PowerExchange extraction map name that is used for event table processing.
You can use event table processing to stop the extraction of changes based on user-defined events, such as an end-of-day event. For example, to stop an extraction process every night, after all of the changes for the day have been processed, write a change to the event table at midnight. This change triggers PowerExchange to stop reading change data and shut down the extraction process after the current UOW completes.
Event table processing has the following rules and guidelines:
  • You can only use event table processing with real-time or continuous extraction modes.
  • You must create the event table, and define the applications that can update the table.
  • You must register the event table for change data capture from the PowerExchange Navigator.
  • The event table and all of the source tables in the CDC session must be of the same source type.
To use event table processing:
  1. Create an event table.
    The event table must be of the same source type and on the same machine as the change data that is extracted. For example, if you extract DB2 change data on MVS, the event table must be a DB2 table in the same DB2 subsystem as the DB2 source tables for the extraction.
  2. In the PowerExchange Navigator, create a capture registration and extraction map for the event table.
    When you create a capture registration, the PowerExchange Navigator generates an extraction map.
  3. In PowerCenter, create a CDC session, and specify the extraction map name in the
    Event Table
    attribute on the PWX CDC Real Time application connection.
  4. When the defined event occurs, update the event table.
    When PowerExchange reads the update to the event table, PowerExchange places an end-of-file (EOF) into 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 currently in the pipeline to the targets and then ends the CDC session.

0 COMMENTS

We’d like to hear from you!