This IBM e-book is a must-read if you’re using DB2 UDB 8.1. IBM Redbooks | Up and Running with DB2 UDB ESE: Partitioning for Performance in an e-Business Intelligence World
It discusses:
- Guidelines on building the large database and determining the number of partitions
- Bulk load using the new multipartition load
- Performance enhancements using MultiDimensional Clustering and Materialized Query Tables.
- Availability through the new online utilities
- Self Managing And Resource Tuning features
- Migration scenarios