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.

Important: On Linux, UNIX, and Windows, after you migrate your DB2® instance to Version 9, any log files that were created by the Version 8 DB2 instance will be inaccessible to the Capture program. Any transactions that were not processed before migration will be lost. To avoid losing transactions, make sure to stop your DB2 applications and let the Capture program process any remaining transactions in the DB2 recovery log before you migrate the DB2 instance.

For Version 9.7 (or Version 9.1 plus the PTF for APAR PK85947 on z/OS®), four new columns are added to the IBMSNAP_CAPMON control table to provide more monitoring information. These columns are optional. Also, the data length of the CAP_SCHEMA_NAME column in the IBMSNAP_CAPSCHEMAS table is increased to VARCHAR(128) to accommodate longer Capture schemas. The Capture program runs as usual whether or not you make these changes. If you applied the PTF that corresponds to V9.7 on z/OS, the changes are already made. The Apply control tables have no changes between V9.5 and V9.7.

To make the Capture control table changes, you can run one of the following scripts:

Table 1. Sample scripts for migrating SQL Replication control tables to Version 9.7
Platform	Sample
Linux, UNIX, Windows	SQLLIB/samples/repl/mig97/sql/asncapluwv97.sql
Oracle sources	SQLLIB/samples/repl/mig97/sql/asncaporav97.sql
Sybase sources	SQLLIB/samples/repl/mig97/sql/asncapsybv97.sql
Informix® sources	SQLLIB/samples/repl/mig97/sql/asncapinfxv97.sql
Microsoft SQL Server sources	SQLLIB/samples/repl/mig97/sql/asncapmssqlv97.sql