Producer and Consumer

[tcapturesupport]

Before you can publish or replicate data, you must create control tables and functions for a TCapture RepSrv database.

With TCapture RepSrv you replicate committed transactional data from source tables to target tables by using two programs:

Producer program

The Producer program reads the recovery logs for changed source data and writes the changes to queues.

Consumer program

The program retrieves captured changes from queues and writes the changes to targets.

The Produccer and the Consumer programs use a set of control tables to track the information that they require , to do their tasks and to store information that they generate themselves, such as information that you can use to find out how well they are performing.

You create these tables when you tell TCapture RepSrv what your replication sources and targets are.

The Producer program uses a set of control tables called TCapture control tables.

These tables contain information about your replication sources, the targets that correspond to them, and which queue manager and queues are being used by the Producer program.

These tables also contain data that you can use to check and monitor the performance, such as data about the program's current position in the transaction log.
The schema that is associated with a set of control tables identifies the program that uses those control tables.
This schema is called _rdb_bdr schema.