Migrating to Q 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.

About this task

After upgrading DB2, you migrate the Q Apply and Q Capture control tables to ARCH_LEVEL 1021, and then if required activate the replication license file. (Some editions of DB2 do not require a separate replication license.)

Procedure

  1. Perform the following steps on the Q Apply server:
    1. Stop the Q Apply program.
    2. Upgrade the DB2 instance to Version 11.1.
    3. Migrate the Q Apply control tables. Follow the procedure in Migrating the Q Apply program to ARCH_LEVEL 1021 on Linux, UNIX, and Windows.
  2. Perform the following steps on the Q Capture server:
    1. Quiesce any applications that are updating replicated tables and let Q Capture read to the end of the DB2 log.
    2. Stop the Q Capture program.
    3. Upgrade the DB2 instance to Version 11.1
    4. Migrate the Q Capture control tables. Follow the procedure in Migrating the Q Capture program to ARCH_LEVEL 1021 on Linux, UNIX, and Windows.
    5. If required, activate replication by using the iidr.lic file that is included in the activation kit from InfoSphere® Data Replication Version 10.2.1.
    6. Start the Q Capture program with a startmode of warmsi or warmsn and with migrate=y.
    7. Release applications. You must start Q Capture before you release applications to avoid losing data. Q 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.