Skip to main content

Multi-Dimensional Clustering Table Size Estimator for DB2

A utility for determining space requirements and simplifying administration of Multi-Dimensional Clustering (MDC) tables in DB2.

Date Posted: August 22, 2006

alphaworks tab navigation


Update: February 19, 2008 Updated binaries/tool for DB2 Version 8.1 Fixpack 14 for 64-bit AIX.

1. Does the tool work on any release of DB2®, Version 8?

The TAR file contains the binary built on DB2 8.2.2. If you would like to use the tool on any other release other than 8.2.2, please e-mail the engineer and you will be provided with a version of the tool that works on your release.

2. Does the tool support XML tables?

No.

3. Does the tool work on DB2, Version 9?

If you would like to use the tool on DB2 9, please e-mail the engineer .

4. Can the tool work on existing MDC tables?

Yes, the tool can be used on existing MDC tables to estimate the space requirements if an existing MDC table is clustered on columns other than the ones on which it is currently clustered.

5. Does the tool work on partitioned tables?

No. Currently the tool is not supported on partitioned tables.

Trademarks




Related technologies