DB2 V10.5 Comparison - CURSOR Service Distribution

DB2 10.5 product lines and editions

Tabular comparison of DB2 10.5 editions

Requirements
Features
Restrictions

This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.

More information Ok

	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	PVU AU min. 25 User	PVU AU min. 25 User	PVU AU min. 25 User	PVU LUV AU 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

Tips for the DB2 Advanced Enterprise Server Edition

High Availability/Failover Configuration:

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

The advanced enterprise server is licensable under the TerraByte metric. Then it is usable but only for data warehousing purposes. The following conditions apply:

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.

The following licenses are also included:

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

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

Tips for the DB2 Enterprise Server Edition

High Availability/Failover Configuration:

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

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

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:

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.

The following licenses are also included:

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

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

Tips for the DB2 Workgroup Server Edition

High Availability/Failover Configuration:

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

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.