The Q replication layer
This is the third and final layer, which comprises the following steps:
Create the replication control tables on the source and target servers.
Create the transport definitions. What we mean by this is that we somehow need to tell Q replication what the source and target table names are, what rows/columns we want to replicate, and which Queue Managers and queues to use.
The structure of the Q replication control tables are discussed in Chapter 3, The DB2 Database Layer, and their creation is discussed in the To create/drop the Q replication control tables section of Chapter 6.
Some of the terms that are covered in the remainder of this section are:
Logical table
Replication Queue Map
Q subscription
Subscription group (
SUBGROUP
)
What is a logical table?
In Q replication, we have the concept of a logical table, which is the term used to refer to both the source and target tables in one statement. An example in a peer-to-peer three-way scenario is shown in the following diagram...