InfoSphere Warehouse is a comprehensive platform that combines the strength of DB2 Enterprise Server Edition with a data warehousing infrastructure from IBM. You can use InfoSphere Warehouse to build a complete data warehousing solution that includes a highly scalable relational database, data access capabilities, and front-end analysis tools. Compare the available editions to find the one that is right for your organization's business needs.
Note: InfoSphere Warehouse Developer Edition provides all the features of Enterprise Edition but is licensed for use in a non-production environment.
The following table summarizes the features available in each edition of InfoSphere Warehouse beginning with v10:
| Advanced Enterprise | Enterprise *** | Enterprise Base | Advanced Departmental | Departmental | Developer | |
|---|---|---|---|---|---|---|
| DB2 10 Enterprise Server Edition with Database Partitioning |  |
|
|
|
|
|
| Continuous Data Ingest | |
|
n/a | |
n/a | |
| Multi-Temperature Data Management | |
|
n/a | |
n/a | |
| Storage Optimization Feature (with Adaptive Compression) | |
|
n/a | |
|
|
| Label and Row Based Access Control | |
|
|
|
| |
| Cubing Services | |
|
|
|
|
|
| SQL Warehousing Tool (SQW) | |
|
|
|
|
|
| InfoSphere Federation Server | |
|
|
|
|
|
| Design Studio | |
|
|
|
|
|
| Administration Console | |
|
|
|
|
|
| Cognos 10 BI | 5 users | 5 users | n/a | 5 users | 5 users | 1 user |
| InfoSphere Replication Server* | |
|
|
|
|
|
| DB2 Workload Management | |
|
|
|
| |
|
Optim Performance Manager |
Extended Edition Included | Extended Edition Included | n/a | |
|
Extended Edition Included. |
| Intelligent Miner | |
|
n/a | |
|
|
| Text Analytics | |
|
n/a | |
|
|
| InfoSphere Data Architect | 10 users | n/a | n/a | n/a | n/a | n/a |
| Optim Query Workload Tuner | |
n/a | n/a | |
n/a | n/a |
| Optim High Performance Unload | |
n/a | n/a | n/a | n/a | n/a |
| DB2 Merge Backup | |
n/a | n/a | n/a | n/a | n/a |
| DB2 Recovery Expert | |
n/a | n/a | n/a | n/a | n/a |
| Optim Database Administrator | |
|
|
|
|
|
| Administration Console | |
|
|
|
|
|
| DB2 Configuration Manager | |
n/a | n/a | |
|
n/a |
| Optim Development Studio | |
|
|
|
|
|
| InfoSphere Warehouse Pack Customer Insight | |
Available | Available | |
Available | Available |
| InfoSphere Warehouse Pack Market and Campaign Insight | |
Available | Available | |
Available | Available |
| InfoSphere Warehouse Pack Supply Chain Insight | |
Available | Available | |
Available | Available |
* Certain usage restrictions apply to these components. For details, refer to the program's license information document.
| Advanced Enterprise | Enterprise | Enterprise Base | Advanced Departmental | Departmental | Developer | |
|---|---|---|---|---|---|---|
| Maximum DB2 Instance Memory | Unlimited | Unlimited | Unlimited | Unlimited | 64GB | n/a |
| Maximum Processor Cores Used by DB2 | Unlimited | Unlimited | Unlimited | Unlimited ** | 16 | n/a |
| Maximum Number of Sockets | Unlimited | Unlimited | Unlimited | 4 | 4 | n/a |
| Maximum Terabyte of User Data | Unlimited* | Unlimited* | n/a | 15TB | 15TB | n/a |
* Maximum DB2 Database Size applies if licensed under the Terabyte charge metric.
Platform support, licensing, and pricing
Advanced Enterprise Edition
Maximum DB2 server instance memory: Unrestricted
Maximum processor cores used by DB2 server: Unrestricted
Operating system: Windows, UNIX, Linux
Licensing: Terabyte Pricing, Processor Value Unit (PVU)
View pricing
Enterprise Edition
Maximum DB2 server instance memory: Unrestricted
Maximum processor cores used by DB2 server: Unrestricted
Operating system: Windows, UNIX, Linux
Licensing: Terabyte Pricing, Processor Value Unit (PVU)
View pricing
Enterprise Base Edition
Maximum DB2 server instance memory: Unrestricted
Maximum processor cores used by DB2 server: Unrestricted
Operating system: Windows, UNIX, Linux
Licensing: Processor Value Unit (PVU)
View pricing
Advanced Departmental Edition
Maximum DB2 server instance memory: 64 GB
Maximum processor cores used by DB2 server: 16
Operating system: Windows, UNIX, Linux
Licensing: Terabyte Pricing (maximum 15TB), Limited Use Socket (maximum 4 sockets) or Authorized User (min 30 users per socket)
View pricing
Departmental Edition
Maximum DB2 server instance memory: 64 GB
Maximum processor cores used by DB2 server: 16
Operating system: Windows, UNIX, Linux
Licensing: Terabyte Pricing (maximum 15TB), Limited Use Socket (maximum 4 sockets) or Authorized User (min 30 users per socket)
View pricing
Developer Edition
Maximum DB2 server instance memory: Unrestricted
Maximum processor cores used by DB2 server: Unrestricted
Operating system: Windows, UNIX, Linux
Licensing: Authorized User limited for use only in a non-production environment.