CDC Guide for Linux, UNIX, and Windows

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Adding or Dropping Database Partitions

Use this procedure to create a new partition in a partitioned database or to drop an existing partition, and then update the appropriate database partition group for the change.

Stop updates to the source tables.

Verify that any change data that was captured has completed extraction processing.

In PowerCenter, stop all CDC sessions that extract change data for the tables in the partitioned database instance.

For each table for which the DATA CAPTURE CHANGES clause is specified, specify DATA CAPTURE NONE.

This step temporarily disables DB2 capture of changes to its log files. If you do not perform this step, DB2 records the data redistribution changes that result from the REDISTRIBUTE command as regular change data activity.

Execute the SQL for adding the new database partition or for dropping an existing partition.

Execute the ALTER DATABASE PARTITION GROUP SQL to add the new partition to or remove the dropped partition from the appropriate database partition group.

Run the DB2 REDISTRIBUTE DATABASE PARTITION GROUP command to redistribute table data among the partitions in the altered database partition group.

Back up the PowerExchange capture catalog table.

Run the PowerExchange DTLUCUDB SNAPUPDT command. Set the REPLACE option set to Y. This step updates the PowerExchange capture catalog table to reflect the reconfigured partitioned database.

Informatica recommends that you first perform a test run with the REPLACE option set to N.

For each table for which you specified DATA CAPTURE NONE in step 2, reinstate the DATA CAPTURE CHANGES clause.

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Adding or Dropping Database Partitions

Adding or Dropping Database Partitions