SQL Replication Version 10.5 on Linux, UNIX, and Windows does not require
a control table migration from Version 10.1.
About this task
You only need to upgrade your DB2® instance to Version 10.5. SQL Replication in Version 10.5
is functionally equivalent to SQL Replication in Version 10.1 and
there are no changes to the control tables.
Procedure
- Perform the following steps on the Apply server:
- Stop the Apply program.
- Upgrade the DB2 instance to Version 10.5.
- Start the Apply program.
- Perform the following steps on the Capture server:
- Quiesce any applications that are updating replicated
tables and let Capture read to the end of the DB2 log.
- Stop the Capture program.
- Upgrade the DB2 instance to Version 10.5.
- Start the Capture program with a startmode of warmsi or warmns and with migrate=y.
- Release applications. You must start Capture
before you release applications to avoid losing data. Capture cannot
read any of the old logs that were created in the prior version, and
it starts reading the first active log that it receives from DB2.