Migrating
For SQL Replication, some control table migrations are optional, and others are required.
- Migrating from SQL Replication to Q Replication
You can migrate your source and target servers from SQL Replication to Q Replication without a full refresh of target tables, and with only a brief outage in replication. - Migrating to SQL Replication Version 11.1 (Linux, UNIX, Windows)
When you upgrade your source or target servers to DB2® Version 11.1 on Linux, UNIX, and Windows, the control tables must be at architecture level 1021. You must migrate the control tables if they are not at this level. - Migrating to SQL Replication ARCH_LEVEL 1021 on Linux, UNIX, and Windows
When you upgrade your SQL Replication servers to DB2 Version 10.5 Fix Pack 7 and later on Linux, UNIX, and Windows, you must migrate the control tables to architecture level 1021. - Migrating to Version 10.2.1 with ARCH_LEVEL 1021 (z/OS)
When you install the SQL Replication technology in InfoSphere® Data Replication for DB2® for z/OS® Version 10.2.1, you must migrate the control tables to the 1021 architecture level to match the code base. - 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. - Migrating to Version 10.1 with ARCH_LEVEL 1001 (z/OS)
When you install APAR PM75119 for SQL Replication Version 10.1 on z/OS®, you must migrate the control tables to the 1001 architecture level to match the code base. - Compatibility in SQL Replication Version 10 on z/OS
The different releases and architecture levels in SQL Replication Version 10 on z/OS require that you plan for compatibility of mixed-level Capture and Apply servers. - Migrating to SQL Replication Version 10.5 (Linux, UNIX, Windows)
SQL Replication Version 10.5 on Linux, UNIX, and Windows does not require a control table migration from Version 10.1. - Migrating to SQL Replication Version 10.1 (Linux, UNIX, and Windows)
When you upgrade your servers to DB2 10.1 for Linux, UNIX, and Windows, you must migrate the SQL Replication control tables and change-data (CD) tables, and in some cases your consistent-change-data (CCD) tables, because of changes to the structure of DB2 recovery log records. - Migrating to SQL Replication Version 10 (z/OS) and Version 9.7 Fix Pack 3 (Linux, UNIX, Windows)
After you upgrade your SQL Replication servers to Version 10 on z/OS or Version 9.7 Fix Pack 3 on Linux, UNIX, and Windows, migration of the Capture and Apply control tables is required. - Migrating to SQL Replication Version 9.7 Fix Pack 2
This migration is optional if you are upgrading from Version 9.7. For Version 9.7 Fix Pack 2, a new control table was added to maintain a history of changes to range-partitioned source tables on Linux, UNIX, or Windows systems. The new control table, IBMQREP_PART_HIST, is required only if you are replicating from range-partitioned tables on these systems. Because of this, the optional migration is limited to the Capture server. - Migrating to SQL Replication Version 9.7
This migration is optional if you are upgrading from Version 9.5. The migration enables you to store more historical data for the Capture program. - Migrating to SQL Replication Version 9.5
This migration is optional if you are upgrading from Version 9.1. For Version 9.5, a new column was added to the IBMQREP_IGNTRAN control table that facilitates tracing of ignored transactions. This control table is shared by SQL Replication and Q Replication. - Migrating to SQL Replication Version 9.1 (z/OS)
If your source server is upgraded to DB2 Version 9.1 for z/OS new-function mode, you must migrate the Capture program to Version 9.1 to handle the new DB2 log record format for Version 9.1 new-function mode. The Version 8 SQL Apply program can continue to work with DB2 Version 9.1 for z/OS in new-function mode. - Coexistence support in Version 10.1 (z/OS) and Version 9 SQL Replication
SQL Replication supports full coexistence between Version 10.1 (z/OS), Version 9.7, Version 9.5, and Version 9.1.