Migrating the Q Capture program to Version 10.1 (Linux, UNIX, Windows)

You migrate the Q Capture control tables to the Version 10.1 level after you upgrade the Q Capture server to DB2® Version 10.1 for Linux, UNIX, and Windows.

1. Stop the Q Capture program.
2. Upgrade the DB2 instance to Version 10.1. See Upgrade essentials for DB2 servers for more information.

   From this point, do not use the replication administration tools to modify your replication configuration (for example to add a Q subscription) until your Q Capture control tables are migrated.

3. Activate InfoSphere® Data Replication 10.1.3 by installing the InfoSphere Data Replication Activation Kit.
4. Migrate the Q Capture control tables to the Version 10.1 level:
   1. Find the migration script for your DB2 or Oracle source database in the sqllib/samples/repl/mig10/q/ directory.

      Table 1. Migration scripts for different source databases

      Platform	Migration script file
      DB2	asnqcapluwv10.sql
      Oracle	asnoqcapluwv10.sql

      For fix pack versions: If you are migrating to a DB2 version that includes a fix pack rather than the GA version, use the script with a file name that includes "fp," for example asnqcapluwv10fp.sql.
   2. Change the variable for the Q Capture schema to your schema.
   3. Change all occurrences of !CAPTABLESPACE! to the name of the table space where your Q Capture control tables are created.
   4. Run the migration script.
5. Optional: Migrate any Q Apply programs that the Q Capture program replicates to, and then ensure that the value of the COMPATIBILITY column in the IBMQREP_CAPPARMS table is correct. Refer to the table in Coexistence support in Version 10 for the appropriate compatibility values. You can use the following SQL statement to update the value:

   UPDATE schema.IBMQREP_CAPPARMS
   SET COMPATIBILITY = '1001';

6. Start the Q Capture program with startmode=warmsi and migrate=y.