SQL Replication compatibility for ARCH_LEVEL 1021 and 1001 on Linux, UNIX, and Windows
When the Capture and Apply programs are at different levels, the Capture COMPATIBILITY parameter must be set to the correct value to enable coexistence.
Table 1 shows the required values for the COMPATIBILITY column in the IBMSNAP_CAPPARMS table for different Q Apply program versions.
Apply version | ||||||
Capture |
V9.7 (ARCH_LEVEL 1001) | V10.1 (ARCH_LEVEL 1001) | V10.5 Fix Pack 6 (ARCH_LEVEL 1001) | V10.5 Fix Pack 7 and later (ARCH_LEVEL 1021) | V11.1 (ARCH_LEVEL 1021) | |
V10.1 |
0801 1 | 1001 | 1001 | 1001 | 1001 | |
V10.5 |
0801 1 | 1001 | 1001 | 1001 | 1001 | |
V10.5 |
0801 2 | 1001 or 1021 3 | 1001 or 1021 3 | 1021 | 1021 | |
V11.1 |
0801 2 | 1001 or 1021 3 | 1001 or 1021 3 | 1021 | 1021 |
- The Apply program must be at V9.7 Fix Pack 8 or later.
- The Apply program must be at V9.7 Fix Pack 8 or later if you use the COMMIT_COUNT feature. If you use COMMIT_COUNT with an Apply program at V9.7, after migrating you must manually update the V10.5 Fix Pack 7 or later Capture ARCH_LEVEL value from 1021 to 1001, for example UPDATE ASN.IBMSNAP_CAPPARMS SET ARCH_LEVEL='1001'. The value of COMPATIBILITY must stay at 0801.
- At V10.1 Fix Pack 4 or later and V10.5 Fix Pack 3 or later, both values are valid. Note that if the Capture program is at ARCH_LEVEL 1021, when you create a subscription-set member the ASNCLP program sets the ARCH_LEVEL column in the IBMSNAP_SUBS_SET table at 1021. On Linux, UNIX, or Windows, Apply must be at Version 10.1 Fix Pack 4 or Version 10.5 Fix Pack 3 or later or it deactivates the subscription set because the older Apply program does not support ARCH_LEVEL 1021.
Apply V9.7 with V10.x Capture: If the
Apply program is at Version 9.7 and the Capture program is at Version 10.x or
newer, the ARCH_LEVEL value in the IBMSNAP_CAPPARMS table must be 1001 and the COMPATIBILITY value
must be 0801. With these two values you can migrate any server in the configuration in any
order.