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.
Download description
| Filename | File size | Description |
|---|---|---|
| mdcsizer_AIX64_fp13.tar | 400KB | Tar file containing Multi-Dimensional Clustering Table Size Estimator for DB2 v8.1 fixpack13 AIX 64 bit |
| mdcsizer_AIX_fp14.tar | 260KB | Tar file containing Multi-Dimensional Clustering Table Size Estimator for DB2 v8.1 fixpak14, 64 bit AIX |
| mdcsizer_AIX_fp9.tar | 380KB | Tar file containing Multi-Dimensional Clustering Table Size Estimator for DB2 |
| mdcsizer_win_fp9.zip | 108KB | Tar file containing Multi-Dimensional Clustering Table Size Estimator for DB2 |
