Compare the distributed DB2 10.1 database servers

Return to article

Table 1. Side-by-side comparison of DB2® Express-C, DB2 Express, DB2 Workgroup, DB2 Enterprise and DB2 Advanced Enterprise.
Function, feature, and benefitDB2 Express-CDB2 ExpressDB2 WorkgroupDB2 EnterpriseDB2 Advanced
Platform support? Find the list of the most up-to-date supported hardware and software platforms.Windows®, Linux® x86, and Solaris x64.Windows, Linux x86, and Solaris x64.Windows, Linux (x86 and POWER servers), AIX, Solaris (SPARC and x64), and HP-UX (Itanium). Windows, Linux (x86, POWER, and System z servers), AIX, Solaris (SPARC and x64), and HP-UX (Itanium).

For Linux on x86-32 hardware and Windows non-server editions (32- and 64-bit) only test and development environments are supported.
Same as DB2 Enterprise.
Supported licensing options? Different editions of DB2 support different kinds of licensing methods. For example, depending on the DB2 edition, you can license a DB2 server using the per-server Fixed-Term License (FTL), a per-server perpetual license (SERVER), the number of sockets on the server (SOCKET), the Processor Value Unit (PVU) rating of the server, or the number of Authorized Users per Single Install (AUSI).Not applicable.

DB2 Express-C is a free package of DB2.
License using the FTL, SERVER, PVU, or AUSI licensing model.

When you license DB2 Express with a FTL license, you are buying a yearly support contract. It's easy to calculate the cost of a FTL license: you just buy a FTL license for every physical or virtual server on which Express is installed. If you have 5 servers, you need 5 licenses. It's that easy. The FTL license allows for unlimited users to access the DB2 Express server.

The DB2 Express SERVER license is procured in the same manner as the FTL license — on a per-server basis. The difference between the FTL license and the SERVER license is that the FTL license is a subscription (you are leasing the software) and the SERVER license is a perpetual license (you own the software). The SERVER license also allows for an unlimited number of users to access the DB2 Express server.

The DB2 Express AUSI license allows you to license DB2 Express on a per-user, per-Install basis. With this license, you have to buy an AUSI license for each user that wants to connect to a specific DB2 Express Install. You must purchase a minimum of 5 AUSI licenses per physical or virtual server on which DB2 Express is installed.

The DB2 Express PVU license allows an unlimited number of users to access a DB2 Express server. You have to buy the number of PVUs that match the PVU rating of the physical or virtual server on which DB2 Express is installed. We recommend investigating the DB2 Express FTL or SERVER license options as they often provide the most cost effective way to license this DB2 edition.
License using the SOCKET, PVU, or AUSI licensing model.

Under the SOCKET model, one DB2 Workgroup SOCKET license is required for each socket on the physical or virtual server that DB2 Workgroup has access to. For example, if you had an unpartitioned four-socket four-core server rated at 1920 PVUs, you would need four SOCKET licenses. A SOCKET license allows for an unlimited number of users to connect to a DB2 Workgroup server.

The DB2 Workgroup AUSI license allows you to license DB2 Workgroup on a per-user, per-Install basis and has the same minimum licensing requirements as the DB2 Express AUSI license.

The DB2 Workgroup PVU license allows an unlimited number of users to access a DB2 Workgroup server. It's licensed in the same manner as the DB2 Express PVU license. We recommend investigating the DB2 Workgroup SOCKET license as it can provide the most value compared to other licenses models. For example, using the DB2 Workgroup SOCKET license, you could install DB2 Workgroup on a 4 socket, 16 core, 120 PVU/core rated server. You need only compare the cost of 4 DB2 Workgroup SOCKET licenses versus licensing 1920 PVU to see why the SOCKET license delivers the best value on powerful servers.
License using the PVU or AUSI licensing model.

DB2 Enterprise AUSI users are licensed in the same manner as the AUSI licenses for other DB2 editions. The minimum number of AUSI licenses you need for a DB2 Enterprise server is different from DB2 Express or DB2 Workgroup. If you are licensing DB2 Enterprise using an AUSI license, you minimally need to license 25 AUSI licenses for every 100 PVUs for the server upon which this edition is installed. For example, if you installed DB2 Enterprise on a server rated for 400 PVUs, you would need to buy at least 100 AUSI licenses (400 PVUs/100 PVU = 4 * 25 = 100). Even if you only had 25 users in your environment, you would still need to buy 100 AUSI licenses since you have to minimally license DB2 Enterprise with 25 AUSI licenses per 100 PVUs when you use this license. If your environment had 125 users, in this example, you would need to procure 125 AUSI licenses since it is greater than the minimum.

The DB2 Enterprise PVU license allows an unlimited number of users to access a DB2 Enterprise server. You have to buy the number of PVUs that match the PVU rating of the physical or virtual server on which DB2 Enterprise is installed.
License using the PVU or AUSI licensing model. Same as DB2 Enterprise.
Processor core limitations? All editions of DB2 10.1 can be installed on any size machine regardless of license model. However, some DB2 Editions restrict the number of cores that can be made available to DB2. Where applicable, you need to use eligible partitioning or virtualization technologies to enforce these restrictions.2 cores

This limit is automatically enforced by the DB2 software on Windows and Linux x86. On Solaris x64, you must manually enforce the restriction. For example, you could install DB2 Express-C on a 4 core Windows server and the software would only use 2 cores. However, if installed on a 4 core Solaris x64 server, you would need to use an eligible virtualization technology to restrict DB2 to at most 2 cores per virtual server.
4 cores

As with Express-C, this limit is automatically enforced by the DB2 software on Windows and Linux x86. On Solaris x64, you must manually enforce the restriction using an eligible partitioning or virtualization technology. Regardless of platform, additional restrictions may be required depending on the license metric used. See the virtualization / sub-capacity eligibility section below for details.
16 cores

As with Express-C, this limit is automatically enforced by the DB2 software on Windows and Linux x86. On all other platforms, you must manually enforce the restriction using an eligible partitioning or virtualization technology. Regardless of platform, additional restrictions may be required depending on the license metric used. See the virtualization / sub-capacity eligibility section below for details.
No, unlimited.

The DB2 Enterprise Edition software will use as many cores as are made available to it. If licensed by PVU, ensure you have properly licensed all cores that DB2 has access to.
No, unlimited.

Same as DB2 Enterprise Edition.
Memory limitations on the server where the DB2 software is installed? There are no limits on the memory that can be installed on the machine. However, certain editions of DB2 restrict the amount of memory that can be made available to DB2. If necessary, this can be restricted at the DB2 Instance level via the instance memory configuration parameter.4 GB.

This limit is automatically enforced by the DB2 software per instance. If multiple instances are running in the same physical or virtual server, you must manually enforce this limit across all instances.

For example, you could install and run one instance of DB2 Express-C on a server with 16 GB of RAM and the software would only use 4 GB.
8 GB.

This limit is automatically enforced by the DB2 software per instance. If multiple instances are running in the same physical or virtual server, you must manually enforce this limit across all instances.

For example, you could install and run one instance of DB2 Express on a server with 32 GB of RAM and the software would only use 8 GB.
64 GB.

This limit is automatically enforced by the DB2 software per instance. If multiple instances are running in the same physical or virtual server, you must manually enforce this limit across all instances.

For example, you could install and run one instance of DB2 Workgroup on a server with 128 GB of RAM and the software would only use 64 GB.
No, unlimited.No, unlimited.
Eligible for virtualization (for example, LPAR, DLPAR, VMware, etc.) and sub-capacity licensing? Different licensing models, platforms, and virtualization technologies have different prerequisites that allow you to use a DB2 edition or package in a virtualized and/or sub-capacity environment. Find the details about the rules that govern PVU or SERVER and SOCKET deployments. Yes.

You can deploy DB2 Express-C servers in a virtualized environment using supported virtualization software. For example, if you have an 8 core server, you might install DB2 Express-C in four different virtualization sessions assigned two cores each. The CPU and RAM limits per virtual server was outlined earlier in this article.
Yes.

The DB2 license and resource limitations outlined earlier in this article apply to each virtual session. For example, if you install DB2 Express in four VMware sessions on the same server and licensed the software using AUSI licenses, you would have to have a minimum of five AUSI licenses for each partition and if a single user needed to access the software in all four partitions, that single user would need four AUSI licenses. As another example, if you install 10 copies of DB2 Express licensed by FTL or SERVER licenses in 10 VMware sessions running on a 128-core server, you would need to purchase 10 DB2 Express FTL or SERVER licenses. If you are using FTL, SERVER, or AUSI licenses, you don't need to worry about subcapacity licensing since these license metrics aren't based on cores. If you are using PVU licenses, then in addition to the resource restrictions outlined earlier, you must use an eligible virtualization technology to restrict DB2 Express to 4 cores per virtual server on all platforms. For example, you could install DB2 Express licensed under the SERVER metric on an unpartitioned 20 core Linux x64 server. However, if licensed under the PVU metric, you would need to use partitioning or virtualization to restrict DB2 to at most 4 cores per virtual server.
Yes.

The DB2 license and resource limitations outlined earlier in this article apply to each virtual session. For example, if you install DB2 Workgroup in four VMware sessions on the same server and licensed the software using AUSI licenses, you would have to have a minimum of five AUSI licenses for each partition and if a single user needed to access the software in all four partitions, that single user would need four AUSI licenses. If you are using AUSI licenses, you don't need to worry about subcapacity licensing since this license metric isn't based on cores. If you are using SOCKET or PVU licenses, then in addition to the resource restrictions outlined earlier, you must use an eligible virtualization technology to restrict DB2 Workgroup to 16 cores per virtual server on all platforms. For example, you could install DB2 Workgroup licensed under the AUSI metric on an unpartitioned 64 core Linux x64 server. However, if licensed under the PVU or SOCKET metrics, you would need to use partitioning or virtualization to restrict DB2 to at most 16 cores per virtual server.
Yes.

DB2 license and resource limitations in virtualized scenarios apply to each virtual session. Since DB2 Enterprise has no resource limits, this is a moot point. However, if you install DB2 Enterprise in a virtualized session using an AUSI license, you would have to at least purchase the minimum number of AUSI licenses per the 25 AU/100 PVU ratio outlined earlier in this article. If a single user needed to access the software in four different partitions, that single user would need four AUSI licenses.
Yes.

Same conditions as DB2 Enterprise Edition.
IBM's legendary 24x7 direct-to-engineer support model with set maintenance streams for fixes and additional features? (more information) No.

DB2 Express-C doesn't have a set maintenance stream or direct-to-engineer phone support since it is an unsupported product.

DB2 Express-C releases are loosely based on DB2 releases. For example, while a supported DB2 edition may have a predefined maintenance schedule, DB2 Express-C images may skip a Fix Pack. You should also be aware that only one version of DB2 Express-C is ever available. In other words, the moment a new version of DB2 Express-C is released, the previously available version is removed from the download site.
Yes.Yes.Yes.Yes.
Included DB2 Connect functionality? (more information)No.

Not available. You can buy any DB2 Connect Server Edition to get DB2 Connect functionality and entitlement.
No.

Same as DB2 Express-C.
No.

Same as DB2 Express-C.
No.

Same as DB2 Express-C.
No.

Same as DB2 Express-C.
Supports easy migrations to DB2 with the new DB2 10.1 Oracle Database compatibility support feature set (which includes PL/SQL, SQL*Plus, Oracle Database concurrency, data types, and more)? Yes.Yes.Yes.Yes.Yes.
Eligible for high availability (HA) licensing? For information on how to license DB2 servers in an HA environment, read "Licensing distributed DB2 Version 10.1 servers in a high availability configuration" by Paul Zikopoulos, Steven Astorino, and William Kulju. No.

You cannot use HA clustering software of any kind to cluster DB2 Express-C servers for HA. For example, availability clustering through Microsoft Clustering Services, SteeleEye, or even the built-in DB2 HA clustering facilities are not allowed with DB2 Express-C.
Yes.Yes.Yes.Yes.
Support for DB2 Advanced Copy Services (ACS) (more information) DB2 ACS enables you to leverage the fast-copying technology of supported storage devices to perform the data-copying part of backup and restore operations (sometimes called a snapshot). Being able to use the storage device to perform the data copy phase makes backup and restore operations much faster.No.
Yes. Included.
Yes. Included.
Yes. Included.
Yes. Included.
Usage rights for the DB2 integrated cluster manager software provided by IBM Tivoli® System Automation for Multi-platforms (SA-MP) in DB2? (more information) No.

DB2 Express-C isn't eligible for HA clustering of any kind using any software.
Yes. Included.
Yes. Included.
Yes. Included.
Yes. Included.
Supports High Availability Disaster Recovery (HADR)? (more information) DB2 HADR is a technology that provides turnkey high availability with optional Read on Standby and disaster recovery support for DB2 databases operating in a non-DPF or non-pureScale environments. DB2 HADR supports up to 3 standby servers. Read Licensing distributed DB2 10.1 servers in a high availability environment" by Paul Zikopoulos, Steven Astorino, and William Kulju for more information.No.

You cannot use HA clustering software of any kind to cluster DB2 Express-C servers for HA. For example, availability clustering through Microsoft Clustering Services, SteeleEye, or even the built-in DB2 HA clustering facilities are not allowed with DB2 Express-C.
Yes. Included.Yes. Included.Yes. Included.Yes. Included.
Online table reorganization (REORG) support? (more information) Online (sometimes referred to as inplace) table reorganization allows a user to reorganize a table while permitting full access to that table.No.
Yes. Included.
Yes. Included.
Yes. Included.
Yes. Included.
64-bit instance support? Yes.
Yes.
Yes.
Yes.
Yes.
DB2 pureScale® support? (more information) DB2 pureScale allows you to transparently scale OLTP clusters without application change while at the same time maintaining the highest availability levels available on distributed platforms. It's primarily used to create active/active scale-out OLTP clusters.No.
No.
Yes. Included.

The use of DB2 pureScale feature is restricted to a total of 16 processor cores and 64 GB of memory across all servers in the cluster. These limits do not apply to the Cluster Caching Facility (CF).
Yes. Priced add on.

This feature option is available for DB2 Enterprise via a PVU or AUSI license.

A DB2 pureScale cluster involves data processing members as well as Cluster Caching Facility (CF) servers. Each member in a DB2 pureScale cluster requires a DB2 Enterprise license as well as the DB2 pureScale Feature option. The CF servers do not need to be licensed with DB2 Enterprise or the DB2 pureScale Feature option.
Yes. Priced add-on.

Same as DB2 Enterprise.
Row and Column Access Control support? (more information) Row and Column Access Control lets you use simple ALTER statements to restrict the rows and column data a user has access to according to business need without the user knowing that they are being restricted. As a result, this functionality is also ideal for implementing multi-tenant databases.Not available.Yes. Included.
Yes. Included.
Yes. Included.
Yes. Included.
Label-Based Access Control (LBAC)? (more information) Similar to Row and Column Access Control but designed especially for implementing security policies based on clearance hierarchies.Not available.Yes. Included.
Yes. Included.
Yes. Included.
Yes. Included.
Time Travel Query (more information) Time Travel Query provides SQL-level support for temporal data and queries against that data. With this feature you can easily see what data looked like at a point in the past or will look like at some point in the future.Yes. Included.
Yes. Included.
Yes. Included.
Yes. Included.
Yes. Included.
Multi-temperature Data Management (more information) Multi-temperature Data management lets you distribute data across different storage devices according to data usage patterns in order to get the best performance from ones storage investment. For example, ‘hot’ most commonly accessed data could go on fast SSD, whereas ‘cold’ infrequently accessed data could go on slow SATA drives. Not available.Not available.Not available.Yes. Included.
Yes. Included.

Multi-temperature Data Management combines with Workload Management (see below) to also allow workload prioritization based on the storage being accessed through use of special data tags.
Scan Sharing (more information) Scan sharing enables specific scanners to exploit the work done by another scanner to avoid repeated I/O cycles for the same pages. Examples of shared work that can share scans include disk page reads, disk seeks, buffer pool content reuse, decompression, and so on. Not available.Not available.Not available.Yes.

Scan sharing is primarily a data warehousing feature. If you want to use DB2 for data warehousing, we strongly recommend you check out the appropriate IBM data warehousing-focused packages.
Yes.

Same as DB2 Enterprise.
Supports Connection Concentration? (more information)No.No.No.Included.Included.
Workload Management (WLM)? (more information) WLM makes it possible to throttle or accelerate workloads based on business priorities. This feature is ideal for mixed workload environments where you can’t afford to have priority work bogged down by less important work that’s running in parallel.Not available.Not available.Not available.Partially included.

You can monitor your system using WLM, but you cannot change priorities of your workloads.
Yes. Fully included.

Includes both monitoring and control of workloads. WLM is especially useful for data warehouses and operational data stores. If you want to use DB2 for data warehousing, we strongly recommend you check out the appropriate IBM data warehousing-focused packages.
Supports Materialized Query Tables (MQTs) (more information), Query Parallelism (more information), and Multidimensional Clustering (MDC) Tables (more information) These technologies improve the performance of complex queries.No.No.No.Included.

These features are primarily data warehousing features. If you want to use DB2 for data warehousing, we strongly recommend you check out the appropriate IBM data warehousing-focused packages.
Included.

Same as DB2 Enterprise.
Deep Compression Services including Adaptive Compression (compresses tables, indexes, temporary tables, XML XDA, and more)? (more information) DB2 Compression can cut storage costs by up to 10x, and can improve performance at the same time.Not available.Not available.Not available.Priced add-on.

To take advantage of the deep compression capabilities available in DB2 Enterprise you need to additionally purchase the Storage Optimization Feature option.

This feature option can only be purchased using a PVU license (there is no AUSI license available for this feature option) and can only be added to a PVU-licensed DB2 Enterprise server.
Yes. Included.
Backup compression? (more information)Yes.Yes.Yes.Yes.Yes.
Federation across IBM relational databases (DB2 on all platforms and Informix®)? (more information) Homogeneous Federation allows you to perform distributed joins and updates across different IBM relational databases. For example, in a single SELECT statement, you could perform a three-way join of data from tables that reside in Informix for AIX, DB2 for z/OS, and DB2 for Windows databases. Note that federation to DB2 for z and I also requires purchase of DB2 Connect at a minimum.Yes.Yes.Yes.Yes.Yes.

DB2 Advanced also includes federation to Oracle databases.
SQL replication? (more information) SQL replication replicates data to one or more targets using good old fashioned SQL statements.No.Yes.

Support is provided for SQL-based replication to the DB2 family. In addition, other Information Management products can add queue-based replication.
Yes.

Same as DB2 Express.
Yes.

Same as DB2 Express.
Yes.

Same as DB2 Express.
Q-Replication? (more information) Q-replication uses message queue technology to provide high performance replication services to one or more target servers.No.No.No.No.Yes.

Restricted use Q-replication functionality to replicate DB2 LUW to 2 DB2 LUW servers for Active-Active environments.
Table partitioning? (more information) Table partitioning (also known as range partitioning) allows you to store ranges of values from a single table into different storage containers, thereby allowing easier table maintenance and index management.No.No.No.Included.Included.
pureXML? (more information) pureXML lets you store and manage XML data easily and without sacrificing performance or searchability.Yes.Yes.Yes.Yes.Yes.
Resource Description Framework (RDF) Graph Store support? (more information) RDF lets you preserve the relationship between subject, predicate and object data triplets so that you can easily perform queries based on the relationship within and between triplets using the SPARQL query language.Yes.Yes.Yes.Yes.Yes.
DB2 Text Search and DB2 Net Search Extender (more information) DB2 Text Search (which replaces the deprecated DB2 Net Search Extender function) allows you to search text columns stored in a DB2 table. You can find a comparison between DB2 Text Search and the DB2 Net Search Extender.Yes.Yes.Yes.Yes.Yes.
Spatial extender? (more information) DB2 Spatial extender allows you to include spatial attributes, such as distance, in queries.Available free of charge as a download.Available free of charge as a download.Available free of charge as a download.Available free of charge as a download.Available free of charge as a download.
Continuous Data Ingest (more information) Continuous Data Ingest is a client side utility that allows you to trickle feed data that is read from a file or pile into a data warehouse without locking tables or otherwise affecting the performance of the warehouse.No.No.No.No.Yes. Included

This is primarily a data warehousing feature. If you want to use DB2 for data warehousing, we strongly recommend you check out the appropriate IBM data warehousing-focused packages.
IBM Data Studio (more information) IBM Data Studio combines the functionalities of Optim Development Studio and Optim Database Administrator, and provides an integrated database development and administration environment for Oracle, DB2, and Informix. Yes.Yes.Yes.Yes.Yes.
Optim Performance Manager (more information) Provides a comprehensive and proactive performance management solution for database applications. Yes. Priced add-on.Yes. Priced add-on.Yes. Priced add-on.Yes. Priced add-on.Yes.

Includes Optim Performance Manager, Extended Edition which includes Extended Insight.
Optim Query Workload Tuner (more information) The Optim Query Workload Tuner tool provides a time saving and expert advice interface to help you quickly maximize query performance.Yes. Priced add-on.Yes. Priced add-on.Yes. Priced add-on.Yes. Priced add-on.Yes.
Optim pureQuery Runtime (more information) Optim pureQuery Runtime allows you to transparently replace dynamic JDBC with static JDBC to improve performance and security.Yes. Priced add-on.Yes. Priced add-on.Yes. Priced add-on.Yes. Priced add-on.Yes.
Optim Configuration Manager (more information) Optim Configuration Manager offers centralized management of database and client configuration.Yes. Priced add-on.Yes. Priced add-on.Yes. Priced add-on.Yes. Priced add-on.Yes.
InfoSphere Data Architect (more information) InfoSphere Data Architect helps you model, integrate, and standardize data across your organization.Yes. Priced add-on.Yes. Priced add-on.Yes. Priced add-on.Yes. Priced add-on.Yes. Includes 10 Authorized Licenses.

Return to article