Capture for multiple database partitions

If you are replicating data on a DB2® Enterprise Server Edition that is at Version 9.7 or older, you can capture changes to source tables that are spread across multiple database partitions.

The Capture program keeps a list of database partitions belonging to its partition group in the IBMSNAP_PARTITIONINFO table. This table is created by the Capture program when the Capture program is started for the first time and finds that there is more than one database partition in its partition group.

When the Capture program is started in warm mode, Capture reads the list of database partitions for the partition group in which its control tables are located. Capture compares the number of database partitions known to DB2 with the number of database partitions listed in the IBMSNAP_PARTITIONINFO table. The number of database partitions listed in the IBMSNAP_PARTITIONINFO table must match the number known to DB2 or the Capture program will not run.

If you added one or more database partitions since the last time you ran the Capture program, you must tell the Capture program about the new database partitions. You can do this in the Replication Center by selecting the One or more partitions have been added since Capture was last run check box when you set the startmode parameter to any of the warm start modes on the Start Capture window.

Capture from partitioned databases at Version 10.1 or newer is not supported.