Coexistence support in Version 10

The Q Capture and Q Apply programs support interoperability between many of their versions, but some coexistence scenarios are not supported.

Table 1 shows relationships between Version 9 and Version 10 replication programs and the effect of the COMPATIBILITY setting.

Table 1. Required settings for COMPATIBILITY column in IBMQREP_CAPPARMS table to enable coexistence between different versions. Unless specified, versions apply to both z/OS and Linux, UNIX, and Windows.
Q Capture version (includes Oracle sources)		Q Apply version
		9.5	9.7	9.7 FP2 (Linux, UNIX, Windows)	9.8 FP3 or above (Linux, UNIX, Windows)	10.1 (z/OS) with ARCH_LEVEL 100Z	10.1 (z/OS) with ARCH_LEVEL 1001	10.1 (Linux, UNIX, Windows) ¹	10.2.1 (z/OS)
	9.5	0905
	9.7	0905	0907
	9.8 FP2 or above (Linux, UNIX, Windows)	Not supported		0908
	10.1 (z/OS) with ARCH_LEVEL 100Z	0905	0907
	10.1 (z/OS) with ARCH_LEVEL 1001		0907		0908	0907	1001
	10.1 (Linux, UNIX, Windows) ¹	Not supported	0907
	10.1 (Linux, UNIX, Windows) with multiple pureScale® members ¹	Not supported
	10.2.1 (z/OS)						1001		1021

In terms of coexistence, Version 10.5 on Linux, UNIX, and Windows is equivalent to Version 10.1 on Linux, UNIX, and Windows.

Q Apply program support for different message levels from Q Capture

Q Apply programs at different levels and on different operating systems can handle the following levels of messages from the Q Capture program. The message levels from the Q Capture program are determined by the setting of the COMPATIBILITY column in IBMQREP_CAPPARMS table.

Table 2 shows the levels when Q Apply is on z/OS:

Table 2. Messages levels that the Q Apply program can handle on z/OS
Q Apply version	Level of messages that Q Apply can handle
10.2.1	COMPATIBILITY=1021 and below
10.1 with ARCH_LEVEL=1001	COMPATIBILITY=1001 and below
10.1 with ARCH_LEVEL=100Z	COMPATIBILITY=0907 and below
9.7	COMPATIBILITY=0907 and below
9.5	COMPATIBILITY=0905 and below

Table 3 shows the levels when Q Apply is on Linux, UNIX, or Windows:

Table 3. Messages levels that the Q Apply program can handle on Linux, UNIX, and Windows
Q Apply version	Level of messages that Q Apply can handle
10.1	COMPATIBILITY=1001 and below
9.8	COMPATIBILITY=0908 and below
9.7	COMPATIBILITY=0907 and below
9.5	COMPATIBILITY=0905 and below

ASNCLP and Replication Center

Although in most cases the ASNCLP command-line program and Replication Center support the creation of control tables that are at a newer version than the DB2® server on which they are created, for Version 10 this is not the case.

The Version 10 control tables are designed to accommodate longer, 16-byte log sequence numbers that are used starting with DB2 10.1 for Linux, UNIX, and Windows, and so Version 10.1 control tables can only be created on a DB2 10.1 for Linux, UNIX, and Windows or newer database. The ASNCLP and Replication Center always create the latest level of control tables on z/OS.

Table 4 shows the level of control tables that are created by the ASNCLP program and Replication Center on different server levels as indicated by the value of the ARCH_LEVEL column in the IBMQREP_CAPPARMS table.

Table 4. Version of control tables created by different levels of replication administration tools on different server levels
Admin client	Server level
		z/OS V11 or below	Linux, UNIX, Windows V10.1	Linux, UNIX, Windows V9.7 FP3-FP5	Linux, UNIX, Windows V9.8 FP2-FP3	Linux, UNIX, Windows V9.7-V9.7 FP2	Linux, UNIX, Windows V9.5	Oracle source
	V10.5 FP3	1021	1001	0973	0908	0907 ²	0905 ²	1001
	V10.1 ³	1001
	V9.7 FP5	100Z	0973					0973
	V9.7 FP4
	V9.8 FP3
	V9.7 FP3
	V9.8 FP2	0907			0908 ¹			0907
	V9.7 FP2	0907
	V9.5	0905						Not supported

Only the ASNCLP command-line program is supported.
Administration clients that are at Version 9.7 FP2 and newer allow you to create control tables at a version that is higher than the DB2 server, as long as the ARCH_LEVEL value of the control tables is lower than 1001.
Starting with the Version 10.1 Fix Pack 3 administration client, the replication tools create control tables by default at the 1021 ARCH_LEVEL