|  |
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
|
|
|
|
|
Platform requirements
Operating systems: Windows® and AIX®
Hardware: This tool has been tested on Intel- and RISC-based platforms.
Software:
- DB2® 8.1 or above. (Please e-mail the engineer if you wish to use this tool on any release of DB2 other than DB2 Version 8, Fixpak 9.)
- Base table/original table on which the tool is to be run, with up-to-date statistics.
Installation instructions
- Download the TAR/ZIP file corresponding to your operating system and your version of DB2.
- Extract the contents into a temporary directory.
- Copy the files into the corresponding DB2PATH directories:
- copy db2mdcsizer to sqllib/bin/
- copy db2mdcsizer.bnd to sqllib//bnd/
- copy db2mdcsizer.mo to sqllib/msg/en_US.iso88591
- Run the tool from a DB2 command prompt or CLP.
For the exact steps for installing and invoking the tool, please see the readme.txt file contained in the TAR/ZIP file.
Microsoft, Windows, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both.
AIX and DB2 are trademarks of IBM Corporation in the United States, other countries, or both.
Other company, product, or service names may be trademarks or service marks of others.
|
|
|
|
| |
|
