Table of Contents

Search

  1. Preface
  2. Change Data Capture Introduction
  3. PowerExchange Listener
  4. PowerExchange Condense
  5. DB2 for i5/OS Change Data Capture
  6. Remote Logging of Data
  7. Introduction to Change Data Extraction
  8. Extracting Change Data
  9. Monitoring CDC Sessions
  10. Managing Change Data Extractions
  11. Tuning CDC Sessions
  12. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for i5/OS

CDC Guide for i5/OS

Using Remote Journals with PowerExchange

Using Remote Journals with PowerExchange

PowerExchange can capture change data from remote journal receivers that reside on a remote system or in an independent disk pool. The remote journal receivers get change entries from the local journal receivers on the local system where the DB2 source tables reside.
You can run PowerExchange on the remote system where the remote journal receivers reside and not on the local system where the source tables reside. PowerExchange can use distributed data management (DDM) to access metadata for the DB2 source tables on the local system for registration and database row tests, provided that you specify values other than the default values for the RMTRDBDIRE and RMTSYSNAME parameters in the CRTPWXENV command or DBMOVER configuration member.
If you have copies of the DB2 source tables on the remote system, PowerExchange can access metadata for the tables without using DDM. In this case, you must accept the default values for the RMTRDBDIRE and RTMSYSNAME parameters. Also, PowerExchange does not create
dtllib
and
datalib
libraries on the local system during installation.
You might want to use remote journals for change capture if your local production system has space constraints or high overhead. By running PowerExchange CDC processing on a remote system with higher availability, you can avoid degrading performance of the production system.
The following figure shows a simple PowerExchange CDC configuration in which PowerExchange reads change entries from remote journal receivers and the source tables reside only on the local system:
In this configuration, the local i5/OS system contains the following items:
  • The journaled DB2 source tables that applications update.
  • The i5/OS local journals and journal receivers that contain change entries for the DB2 source tables.
  • The PowerExchange
    dtllib
    and
    datalib
    libraries on the local system. These libraries are created when you run the CRTPWXENV command on the remote system during PowerExchange installation. The local
    dtllib
    library contains a SQL package that enables the PowerExchange Listener on the remote system to access the local DB2 database. The local
    datalib
    library contains logical files, or SQL views, that enable PowerExchange to access metadata for DB2 tables of interest.
The remote system contains the following items:
  • The i5/OS remote journals and journal receivers
  • The PowerExchange for DB2 for i5/OS installation including:
    • dtllib
      ,
      datalib
      ,
      condlib
      , and
      cpxlib
      libraries
    • PowerExchange Listener
    • DBMOVER configuration member
    • PowerExchange Condense, if used, and its condense files, checkpoint files, CDCT file, and CFGCOND(CAPTPARM) configuration member
  • PowerExchange capture registrations and extraction maps for the DB2 source tables
When an application updates a journaled DB2 source table on the local system, i5/OS writes the entries for the changes to the local journals. Each local journal is associated with at least one remote journal. i5/OS replicates journal entries from the local journals to the associated remote journals. PowerExchange gets the journal entries from the remote journal receivers for the source tables and columns of interest, as identified by the capture registrations. If you use PowerExchange Condense, PowerExchange Condense reads the changes from the remote journal receivers and writes the changes to condense files on the remote system.
When you register DB2 source tables or perform database row tests from the PowerExchange Navigator, the PowerExchange Listener on the remote system connects to the local system to read metadata for the source tables. The PowerExchange Listener uses the SQL package and views in the
dtllib
and
datalib
libraries on the local system to access the metadata. PowerExchange stores the capture registrations and corresponding extraction maps in the
datalib
and
cpxlib
libraries, respectively, on the remote system.
If you have copies of the source tables on the remote system and accept the default values for the RMTRDBDIRE and RMTSYSNAME parameters, the CRTPWXENV command does not create the
dtllib
and
datalib
libraries during installation.

0 COMMENTS

We’d like to hear from you!