DB2 Version 10.1 for Linux, UNIX, and Windows

Table partitioning is now available for DB2 pureScale environments

You can now use table partitioning for DB2® pureScale® tables.

With table partitioning, you can divide large table objects between multiple data partitions for better performance.

You can use table partitioning in DB2 pureScale tables; this includes tables that use the PARTITION BY RANGE clause. In addition, the commands associated with table partitioning can be used in a DB2 pureScale environment.

This means, for example, that all of the following operations are supported:

The roll-in and roll-out partition operations available through the ALTER TABLE statement
The PARTITIONED and NOT PARTITIONED clauses for the CREATE INDEX statement
For partitioned indexes, the ON DATA PARTITION clause of the REORG TABLE and REORG INDEXES ALL statements

In addition, the MON_GET_PAGE_ACCESS_INFO table function has been updated to work with table partitioning. All existing monitoring functions that operate on data partitions will work with DB2 pureScale tables.

If you are already using the DB2 pureScale Feature, you can use table partitioning to help resolve page contention issues. By spreading contention out over a larger range, you can reduce data page contention; similarly, you can reduce contention with index pages by using partitioned indexes.