IBM Balanced Warehouse C-Class is a data warehouse solution that includes IBM DB2 Warehouse 9.5 software. The solution can be easily deployed on IBM System x and IBM System Storage products.
This architecture guide presents IBM Balanced Warehouse C-Class Version 9.5.0 solutions for Linux and Windows. It describes the Partner Toolkit that deploys a pre-integrated data warehouse and reporting solution on IBM System x and optional IBM System Storage products, and lists software components including DB2 Warehouse 9.5 and, on Linux, SUSE Linux Enterprise Server 10 SP1.
The hardware overview covers C1000 configurations on IBM System x3500, C3000 configurations on System x3650, and C1000 and C3000 configurations on BladeCenter S. It gives example configurations with CPU, memory, internal and external disk, RAID, database partition counts, database and raw data sizes, and approximate deployment times.
| Data warehouse software | DB2 Warehouse 9.5.0 |
|---|---|
| C1000_50GB processor and memory | Dual Core CPU and 4GB RAM |
| C1000_50GB database and raw data size | 200GB database size, 50GB actual raw data |
| C1000_100GB internal storage | 3 internal SAS hard disks in a single RAID-5 volume |
| C1000_350GB database and raw data size | 1000GB database size, 350GB actual raw data |
| C3000_500GB external storage | DS3200 with 12 SAS hard disks, each 300GB |
| C3000_500GB database size | 1500GB database size, 500GB raw data |
The guide says the complete data warehouse and reporting solution includes IBM DB2 Warehouse 9.5 software.
The C1000_50GB configuration is described as the smallest Balanced Warehouse C-Class, built on IBM System x3500.
Approximately 35-40 minutes on Linux and 60 minutes on Windows after operating system and prerequisite installation.
The guide lists C1000_100GB_Blade, C1000_150GB_Blade and C1000_250GB_Blade as alternatives on BladeCenter S.