DB2 10.5 product lines and editions
Tabular comparison of DB2 10.5 editions
- Requirements
- Features
- Restrictions
| DB2 Advanced Enterprise Server Edition | DB2 Enterprise Server Edition | DB2 Advanced Workgroup Server Edition | DB2 Workgroup Server Edition | DB2 Express-C Edition | DB2 Devel- oper Edition | |
|---|---|---|---|---|---|---|
| License models available | PVUAU min. 25 User | PVUAU min. 25 User | PVUAU min. 25 User | PVULUVAU min. 5 User | free of charge | AU |
| max. socket count | unlimited | unlimited | max. 4 sockets on terabyte metric. | max. 4 sockets | no restrictions listed | no restrictions listed |
| max. cores count | unlimited | unlimited | 16 | 16 | 2 | unlimited |
| max. memory | unlimited | unlimited | 128GB only on AUSI and PVU metric | 128GB | 16GB | unlimited |
| max. storage | unlimited | unlimited | 15 TerraByte User-Data per Database | 15 TerraByte User-Data per Database | 15 TerraByte User-Data per Database | unlimited |
| Advanced Recovery Feature | option | option | option | option | option | option |
| Performance Management Offering allowed | is included | option | is included | option | no | is included |
| Blue Acceleration available | is included | no | is included | no | no | is included |
| pureScale available |
included free of charge ->is only available on AIX pSeries and x86 servers Please read information on supported hardware here. |
limited to a idle-standby in a pureScale cluster. |
included free of charge ->is only available on AIX pSeries and x86 servers Please read information on supported hardware here. |
limited to a idle-standby in a pureScale cluster. |
no |
included free of charge ->is only available on AIX pSeries and x86 servers Please read information on supported hardware here. |
| Data Partitioning available | is included | no | is included | no | no | is included |
| Compression (row, adaptive, index) available | is included | no | is included | no | no | is included |
| Federation Capabilities (more as DB2 and Informix) available | is included | no | is included | no | no | is included |
| Materialized Querys available | is included | is included | is included | no | no | is included |
| Workload Management available | is included | option | is included | option | no | is included |
| MQ Replication available | is included | no | is included | no | no | is included |
| CDC Replication available | is included | no | is included | no | no | is included |
features in the license not included
DB2 Advanced Enterprise Server Edition
- If licensing under the Terabyte metric: pureScale clustering technology
- Accessing federated data in DB2 for i or DB2 for z data servers outside of the SQL Warehousing Tool unless Licensee has separately acquired sufficient entitlement to IBM DB2 Connect
- SQL Replication with non-DB2 LUW databases ("DB2 LUW databases" includes databases hosted on IBM DB2 on Cloud)
- Q Replication functionality except to replicate data between the Program and no more than two DB2 for LUW or IBM DB2 on Cloud data servers
- Change Data Capture functionality, except for the following: (1) unidirectional replication without data transformations between a single DB2 for LUW source and no more than two DB2 for LUW or IBM DB2 on Cloud databases of the same version for the purpose of high availability / disaster recovery; (2) for supporting shadow table functionality within a single DB2 for LUW instance to replicate from row-organized tables into column-organized tables
- Hot Standby: secondarys must be fully licensed according to the same metric as the Primary has been licensed. (Read on Standby is on)
- Idle Standby: Secondary must be licensed with 100 PVU or 25 AU
- Cold Standby: Secondary free
- Licensee must obtain Terabyte entitlements for this Program sufficient to cover the Terabytes of user data, as reported by the Program. The number of required entitlements must be calculated separately for each database.
- Licensee may only use the Program for a data warehouse and run a data warehouse workload. A data warehouse is a subject-oriented, integrated, time-variant collection of data that integrates data from multiple data sources for historical ad hoc data reporting and querying. A data warehouse workload is a workload that typically scans thousands or millions of rows in a single query in order to support the analysis of data in a data warehouse.
- Licensee must have user data from a single database spread across two or more active data partitions or at least 75% of the user data residing in column-organized tables with a majority of the workload accessing the column-organized tables.
- IBM Cognos Analytics User - 5 Authorized User
- IBM Cognos Analytics Administrator - 1 Authorized User
- IBM InfoSphere Data Architect - 10 Authorized User
- IBM DB2 Connect components - Use Limitations: Use by Principal Program
Tips for the DB2 Advanced Enterprise Server Edition
High Availability/Failover Configuration:
The advanced enterprise server is licensable under the TerraByte metric. Then it is usable but only for data warehousing purposes. The following conditions apply:
The following licenses are also included:
DB2 Enterprise Server Edition
- DB2 Database Partitioning Feature
- pureScale clustering technology may be used with the Program only in cluster configurations with a maximum of two pureScale members. If the cluster configuration is configured with two pureScale members, at least one pureScale member must act as an Idle/Warm Standby server (as defined below).
- Row Compression
- Adaptive Compression
- Intelligent Mining
- Workload Management
- Unstructured Text Analysis
- Accessing federated data in DB2 for i or DB2 for z data servers
- Accessing federated data in non-IBM data servers
- SQL Replication with non-DB2 LUW databases ("DB2 LUW databases" includes databases hosted on IBM DB2 on Cloud)
- Q Replication
- Change Data Capture (CDC)
- DB2 Connect components
- column-organized tables
- Index compression
- Hot Standby: secondarys must be fully licensed according to the same metric as the Primary has been licensed. (Read on Standby is on)
- Idle Standby: Secondary must be licensed with 100 PVU or 25 AU
- Cold Standby: Secondary free
Tips for the DB2 Enterprise Server Edition
High Availability/Failover Configuration:
DB2 Advanced Workgroup Server Edition
- Accessing federated data in DB2 for i or DB2 for z data servers
- If licensing under the Terabyte metric: pureScale clustering technology
- SQL Replication with non-DB2 LUW databases ("DB2 LUW databases" includes databases hosted on IBM DB2 on Cloud)
- Q Replication functionality except to replicate data between the Program and no more than two other DB2 for LUW data servers
- Change Data Capture functionality, except for the following: (1) unidirectional replication without data transformations between a single DB2 for LUW source and no more than two DB2 for LUW or IBM DB2 on Cloud databases of the same version for the purpose of high availability / disaster recovery; (2) for supporting shadow table functionality within a single DB2 for LUW instance to replicate from row-organized tables into column-organized tables
- Licensee must obtain Terabyte entitlements for this Program sufficient to cover the Terabytes of user data, as reported by the Program. The number of required entitlements must be calculated separately for each database.
- Licensee may only use the Program for a data warehouse and run a data warehouse workload. A data warehouse is a subject-oriented, integrated, time-variant collection of data that integrates data from multiple data sources for historical ad hoc data reporting and querying. A data warehouse workload is a workload that typically scans thousands or millions of rows in a single query in order to support the analysis of data in a data warehouse.
- Licensee must have user data from a single database spread across two or more active data partitions or at least 75% of the user data residing in column-organized tables with a majority of the workload accessing the column-organized tables.
- IBM Cognos Analytics User - 5 Authorized User
- IBM Cognos Analytics Administrator - 1 Authorized User
- IBM InfoSphere Data Architect - 10 Authorized User
- IBM DB2 Connect components - Use Limitations: Use by Principal Program
Tips for the DB2 Advanced Workgroup Server Edition
The advanced enterprise server is licensable under the TerraByte metric. Then it is usable but only for data warehousing purposes. The following conditions apply:
The following licenses are also included:
DB2 Workgroup Server Edition
- Database Partitioning Feature
- Materialized Query Tables
- Workload Management
- Intelligent Mining
- Adaptive Compression
- Row Compression
- Index compression
- column-organized tables
- Unstructured Text Analysis
- Accessing federated data in DB2 for i or DB2 for z data servers
- Accessing federated data in non-IBM data servers
- SQL Replication with non-DB2 LUW databases ("DB2 LUW databases" includes databases hosted on IBM DB2 on Cloud)
- Change Data Capture (CDC) and Q Replication
- DB2 Connect components
- Hot Standby: secondarys must be fully licensed according to the same metric as the Primary has been licensed. (Read on Standby is on)
- Idle Standby: Secondary must be licensed with 100 PVU or 1 LUS or 5 AU
- Cold Standby: Secondary free
Tips for the DB2 Workgroup Server Edition
High Availability/Failover Configuration:
When licensing by LUS in virtual environments, the sum of the sockets used of all instances don't exceed fourth.
The use of DB2 pureScale Feature is restricted to a total of 16 processor cores and 128 GB of memory across all servers in the cluster.
DB2 Express-C Edition
- IBM DB2 pureScale clustering technology
- column-organized tables
- Row Compression
- Database Partitioning
- Adaptive Compression
- Index compression
- Row & Column Access Control
- Label Based Access Control
- Advanced Copy Service
- High Availability Disaster Recovery
- Online Reorg
- Materialized Query Tables
- Multi-Dimensional Clustering
- Query Parallelism
- Connection Concentrator
- Table Partitioning
- Access Plan Reuse
- Scan Sharing
- Workload Management
- Multi-temperature Storage
- Intelligent Mining
- Unstructured Text Analysis
- Accessing federated data except in DB2 for Linux, UNIX and Windows (LUW) and Informix data servers
- SQL Replication
- Q Replication
- Change Data Capture (CDC)
- Use of any component of the Program in a clustered database environment, including (without limitation) any use of the Program on a group of servers connected together to create a single database image.
DB2 Developer Edition
- nothing
Productgroup DB2:
(Here you can find more information about the DB2 product group)
- IBM DB2 Advanced Enterprise Server Edition
- IBM DB2 Enterprise Server Edition
- IBM DB2 Workgroup Server Edition
- IBM DB2 Express Edition
- IBM DB2 Express-C Edition
- DB2 Content Manager
- DB2 Alphablox
- DB2 Connect
- DB2 Content Manager
- DB2 Document Manager
- DB2 Data Entity
- DB2 Data Warehouse
- DB2 Everyplace
- DB2 KnowledgeX
- DB2 Query
- DB2 Records Manager
- DB2 Tools
- DB2 UDB