What's New

Updateable Partitioning Keys

DB2 Version 7.2 allows you to update the columns in a partitioning key. (A partitioning key exists only in a table spread over multiple database partitions.) Before DB2 Version 7.2, if you wanted to change the partitioning key, you needed two steps:

  1. Delete the row.
  2. Insert the row with the new key.
Each step impacted the log space requirements on both the database partition losing the data and the one gaining the data.

With DB2 Version 7.2, this can be done in one step with an update statement. In an online transaction processing (OLTP) environment, updateable partitioning keys provide performance improvements in data redistribution.


[ Top of Page | Previous Page | Next Page ]