Migrating to replication and publishing Version 9.7

Migrating to replication and publishing Version 9.7 from Version 9.5, or Version 9.1 involves running SQL scripts that add new columns to existing control tables, change other control tables, and update the architecture level and compatibility information in the control tables.

Migrating your control tables to Version 9.7 differs depending on your operating system:

z/OS®: To migrate to the Version 9.7 level on z/OS, you first apply the PTF for APAR PK85947 to WebSphere® Replication Server for z/OS Version 9.1. This PTF adds the functionality of Version 9.7 even though there is no Version 9.7 replication or Event Publishing product on z/OS. After applying the PTF, you run SQL scripts in the ASNQMZ97 sample data set to migrate the control tables to the V9.7 level.
Linux, UNIX, Windows: On Linux, UNIX, and Windows, first you upgrade your DB2® instance to Version 9.7, and then you install InfoSphere® Replication Server Version 9.7 or InfoSphere Data Event Publisher Version 9.7. Finally, you run SQL scripts to migrate the control tables to Version 9.7.

Migrating from Version 9.1 is a multi-step process: You run a series of scripts, each of which migrates the control tables to the next version. When the control tables are at Version 9.5, you run a script to migrate them to Version 9.7.

You can migrate the Version 9.5 Q Capture and Q Apply servers independently. Coexistence support in Version 9.7 Q Replication and Event Publishing describes the ability of the Version 9.7, Version 9.5, and Version 9.1 replication and Event Publishing programs to work together so that you can upgrade your environment in stages.

Changes to initialization protocol for multidirectional replication

The initialization protocol for peer-to-peer and bidirectional replication changed with Version 9.7. Because of this change, if any of the Q Capture or Q Apply programs in the configuration are migrated to Version 9.7, all of the Q Capture and Q Apply programs in the configuration must be at Version 9.7. If a Q Capture program participates in both unidirectional and bidirectional or peer-to-peer configurations and any of the servers are migrated to V9.7, all components that are involved in both unidirectional and multidirectional configurations must be migrated to V9.7.

Using the replication administration tools with different versions

You can use the Version 9.7 replication tools with any combination of V9.7, V9.5, and V9.1 Q Capture and Q Apply servers. The product function that is available with the tools is based on the lowest level of Q Capture or Q Apply program that exists in a scenario. For example, if you use a V9.7 ASNCLP command-line program to create a Q subscription between a Version 9.7 Q Capture and Version 9.5 Q Apply, the Q subscription is at the V9.5 level and does not have the full function of V9.7.

Starting with V9.7, you can specify a different release level for the Q Capture or Q Apply control tables when you use the Replication Center or ASNCLP command-line program to create the control tables.

If your tools are at a higher version than your Q Capture or Q Apply control tables, the tools can work with the lower-level control tables but you cannot use new function that is introduced in the higher version.

Migrating the Replication Alert Monitor to Version 9.7

Version 9.7 does not introduce any changes for the Replication Alert Monitor or its control tables. You must migrate to a Version 9.5 Monitor to work with Version 9.5 and higher replication and publishing programs. A Monitor program at Version 9.7, Version 9.5, or Version 9.1 can work with Version 9.7, Version 9.5, or Version 9.1 replication and Event Publishing programs. You do not need to migrate the Monitor control tables when you migrate the replication and publishing programs.