You can use a version of replication or publishing
that is newer than your DB2® version.
To do so, you must create the replication control tables to match
the version of replication and publishing instead of the version
of DB2. For example, if you
plan to use replication Version 9.7 with a DB2 Version 9.5 database, your control tables
must be at Version 9.7.
Before you begin
To
create control tables at a different version, first you must install
the replication or publishing product without upgrading DB2.
About this task
The
following diagram shows a configuration in which the Replication Center
creates Version 9.7 Q Apply control tables on a Version 9.1 DB2. You can also use the ASNCLP
command-line program to specify a different version for control tables.
Figure 1. Creating replication control tables with a different version
than DB2.
A Version
9.7 Replication Center can create control tables at either V9.7, V9.5,
or V9.1. In the diagram, the Replication Center creates the default
V9.5 control tables on a V9.5 DB2,
but creates V9.7 control tables on a V9.1 DB2. The level of the Q Capture program is thus
V9.5, and the level of the Q Apply program is V9.7. However, because
Q Capture is at a lower version than Q Apply, compatibility for Q
Capture must be set to 0905. At this setting, Q Capture sends V9.5
messages to Q Apply and V9.5 functions are supported.
Note: When the Q Capture and Q Apply control tables are at different
versions, the value of the COMPATIBILITY column in the IBMQREP_CAPPARMS
control table determines the level of messages that are sent by Q
Capture. The compatibility level of the Q Capture server must be lower
than, or at the same level as, the architecture level of the consuming
Q Apply program's control tables. In the diagram, Q Capture compatibility
is set to 0905 because the Q Capture program and its control tables
are at Version 9.5. In this case, the Q Capture program sends Version
9.5 messages, and even though Q Apply is at Version 9.7 the two programs
use Version 9.5 functionality.
Restrictions
- The replication or publishing product must be at a version that
is the same as or newer than the DB2 version.
The DB2 must be Version 8.2
or higher.
- The version of the control tables must match the version of the
replication or publishing product.
- Specifying the version of the control tables is not supported
on DB2 for z/OS®. On z/OS,
the Replication Center always creates control tables that match the
version of the DB2 client on
which the Replication Center runs. You can also use the sample SQL
that comes with the replication and publishing products on z/OS to create control tables.
- Some replication and publishing functions depend on the DB2 level. For example, you can
only replicate from compressed tables or range-partitioned tables
if the source DB2 is at Version
9.7 or newer. DB2 uncompresses log records before passing them
to the Q Capture program. The data is passed uncompressed from source
to target and the target does not need to have compression set.
Procedure
To create control tables at a different version, use one
of the following methods:
| Method |
Description |
|---|
| ASNCLP command-line program |
In the CREATE CONTROL TABLES FOR command, use the version
keyword to specify the version, as in the following example:CREATE CONTROL TABLES FOR CAPTURE SERVER USING
RESTARTQ "ASN1.QM1.RESTARTQ" ADMINQ "ASN1.QM1.ADMINQ"
version 9.5
|
| Replication Center |
On the Summary page of the Create Q Capture Control
Tables wizard or Create Q Apply Control Tables wizard,
click Change next to the listing of the Q Capture
or Q Apply version. In the Change Control Table version window,
specify the version. |
Q Replication and Event Publishing
