Compare the distributed DB2 9.7 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, Mac OS X, and Solaris x64.

DB2 Express-C is the only DB2 server that can run on the Mac OS X operating system.
Windows, Linux (POWER and x86 servers), and Solaris x64.Windows, Linux (POWER and x86 servers), AIX, Solaris (SPARC and x64), and HP-UX (Itanium). Windows, Linux (POWER, System z, and x86 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 (AU).Not applicable.

DB2 Express-C is a free package of DB2. It is optimized for 2 processing cores and 2 GB of memory; subsequently, DB2 Express-C will throttle its resource consumption to these optimized levels. You can install DB2 Express-C on any size server.
License using the FTL, SERVER, PVU, or AU licensing model.

When you license DB2 Express with an FTL license (new in DB2 9.7), you are effectively buying a yearly support and feature contract for your DB2 Express server. It's easy to calculate the costs of an FTL license. You don't have to concern yourself with the number of users, PVU conversion of the server, cores, or anything: you just buy an FTL license for every server. If you have 5 servers, you need 5 licenses. It's that easy.

A DB2 Express FTL license is optimized in the same manner as DB2 Express-C; however, it will throttle itself such that its resource consumption won't exceed four cores of available processing power or more than 4 GB of the available memory on the server. Much like DB2 Express-C, you can install DB2 Express FTL on any size server. The FTL license allows for an unlimited number of users to access the DB2 Express server.

The DB2 Express SERVER license (new in DB2 9.7) 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). A DB2 Express SERVER license has the same optimizations as the FTL license and can be installed on any size server. The SERVER license allows for an unlimited number of users to access the DB2 Express server.

The DB2 Express AU license allows you to license DB2 Express on a per-user basis. With this license, you have to buy an AU license for each user that wants to connect to a specific DB2 Express server. If the same user wants to connect to two different DB2 Express servers, that one person needs two AU licenses. In addition, you need to buy at least 5 AU licenses when licensing DB2 Express using this method.

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 underlying server; however, this server cannot exceed 200 PVUs.

We recommend investigating the DB2 Express FTL or SERVER licenses as they by far provide the most value. For example, beyond their economic savings, you can leverage HADR on a DB2 Express server without purchasing the High-Availability Feature Pack as is the case with the DB2 Express AU and PVU licenses.
License using the SOCKET, PVU, or AU licensing model.

The DB2 Workgroup SOCKET license (new in DB2 9.7) is procured by paying a specified price for each socket on the underlying server. For example, if you had a four-socket four-core server rated at 1920 PVUs, you would only have to buy four SOCKET licenses. A SOCKET license allows for an unlimited number of users to connect to a DB2 Workgroup server. Finally, no matter how many cores resides on a socket, DB2 will throttle usage to a maximum 16 cores based on the server's enumeration as defined in the BIOS.

The DB2 Workgroup AU license allows you to license DB2 Workgroup on a per-user basis and has the same minimum licensing requirements as the DB2 Express AU 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. The DB2 Workgroup PVU license used to be limited to 480 PVUs. However, as of June 2011, the 480-PVU restriction has been removed. and you can now license as many PVUs as assigned to DB2 Workgroup. This means you can now install and use DB2 Workgroup on physical or virtual servers with more than 480 PVUs, provided you have appropriately licensed all the PVUs that DB2 Workgroup has access to, up to 16 cores. If the physical or virtual server has more than 16 cores, you still only pay for 16 cores because that's all DB2 will use. This applies to 9.5 and 9.7.

We recommend investigating the DB2 Workgroup SOCKET license as it provides the most value compared to other licenses (in most cases). Using the DB2 Workgroup SOCKET license, you could effectively install your DB2 Workgroup software on a 1920 PVU-rated server. (Today's POWER 7 processor is rated at 120 PVUs/core; therefore, a four-socket quad core POWER 7 server is rated at 1920 PVUs. That's a lot of power. No pun intended.)
License using the PVU or AU licensing model.

DB2 Enterprise AU users are licensed in the same manner as the AU licenses for other DB2 editions. The minimum number of AU licenses you need for a DB2 Enterprise server is different from DB2 Express or DB2 Workgroup. If you are licensing DB2 Enterprise using an AU license, you minimally need to license 25 AU 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 AU 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 AU licenses since you have to minimally license DB2 Enterprise with 25 AU licenses per 100 PVUs when you use this license. If your environment had 125 users, in this example, you would need to procure 125 AU licenses since it is greater than the minimum. A DB2 Enterprise server with an AU license can be installed on any size server. There are no limits.

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 underlying server. You can install DB2 Enterprise on any size server. There are no limits.
License using the PVU or AU licensing model. Same as DB2 Enterprise.
Memory limitations on the server where the DB2 software is installed? 2 GB.

This limit is automatically enforced by the DB2 software.

For example, you could install DB2 Express-C on a server with 16 GB of RAM, but the software would only use 2 GB.
4 GB.

This limit is automatically enforced by the DB2 software.

For example, you could install DB2 Express on a server with 16 GB of RAM, but the software would only use 4 GB.
64 GB.

This limit is automatically enforced by the DB2 software.

For example, you could install DB2 Workgroup on a server with 128 GB of RAM, but the software would only use 64 GB.

NOTE: DB2 9.7 Fix Pack 3a is required to take advantage of the new 64 GB limit. The limit for versions prior to Fix Pack 3a remains at 16 GB. Contact your IBM rep if you can't get to DB2 9.7 Fix Pack 3a and need to leverage this new RAM limit.
No, unlimited.No, unlimited.
Eligible for virtualization (also known as sub-capacity) licensing; for example, LPAR, DLPAR, VMware, etc.? Different platforms and virtualization technologies have different prerequisites that allow you to use a DB2 edition or package in a sub-capacity environment. Find the details about the rules that govern these types of deployments. Yes.

You can deploy DB2 Express-C servers in a virtualized environment using supported virtualization software. If you have a 16 core server, you might install DB2 Express-C in four different virtualization sessions assigned four cores each; however, the software would not use more than the throttled CPU and RAM limits outlined earlier in this article.
Yes.

If you are using one of the new FTL or SERVER licenses, you can deploy DB2 Express servers in a virtualized environment using supported virtualization software. If you have an eight-socket quad core server with 32 cores, you might install DB2 Express in four different virtualization sessions assigned eight cores each; however, the software would not use more than the throttled CPU and RAM limits outlined earlier in this article.

When you buy DB2 Express using an FTL or SERVER license, you need to buy an FTL or SERVER license for each copy on the server. For example, if you install 10 copies of DB2 Express in 10 VMware sessions running on a 128-core server, you need to purchase 10 DB2 Express FTL or SERVER licenses.

DB2 license and resource limitations in virtualized scenarios 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 a PVU license; each partition could not be assigned more than 200 PVUs. Alternatively, if you chose to license this same server using AU licenses, you would have to have a minimum of five AU licenses for each partition and if a single user needed to access the software in all four partitions, that single user would need four AU licenses.
Yes.

If you are using the new SOCKET license, you can deploy DB2 Workgroup servers in a virtualized environment using supported virtualization software. If you have a four-socket quad-core server with 16 cores, you might install DB2 Workgroup in four different virtualization sessions assigned four cores each. Alternatively, you may install DB2 Workgroup on this same server in two different virtualization sessions assigned 8 cores each; however, the software would not use more than the throttled CPU and RAM limits outlined earlier in this article.

DB2 license and resource limitations in virtualized scenarios apply to each virtual session just like with DB2 Express.
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 AU license, you would have to at least purchase the minimum number of AU licenses per the 25 AU/100 PVU ratio outlined earlier in this article. If a single user needed to access the software in all four partitions, that single user would need four AU 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.
Installable with DB2 Connect? (more information)Yes.

You can't buy DB2 Connect Personal Edition and put it on a DB2 Express-C server. It must be a DB2 Connect server edition.
Yes.

Same as DB2 Express-C.
Yes.

Same as DB2 Express-C.
Yes.

Same as DB2 Express-C.
Yes.

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

If you licensed your DB2 Express server using an FTL or SERVER license, you have access to all the components in the High Availability Feature Pack at no extra charge. You can use these components to create an HA cluster.

When you cluster two DB2 Express-C servers licensed with either the FTL or SERVER license in an HA cluster, you must purchase a full license for each server in the cluster no matter what function they perform in the cluster. If you licensed your DB2 Express server using the PVU or AU model, the DB2 HA licensing rules you are likely most accustomed to apply. In addition, if you want to use HADR or the integrated cluster manager in DB2 with a DB2 Express PVU or AU license, you have to additionally purchase the High Availability Feature Pack.
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. Free with FTL and SERVER licenses. Priced add-on for PVU and AU licensed DB2 Express servers via the High Availability Feature Pack.

This feature pack needs to be licensed for all the PVUs or AUs on the primary server. This feature pack also includes online table reorganization, HADR, and rights to the use the built-in clustering software that's part of DB2.
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. Free with FTL and SERVER licenses. Priced add-on for PVU and AU licensed DB2 Express servers via the High Availability Feature Pack.

This feature pack also includes online table REORG, HADR, and ACS.
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. Read Licensing distributed DB2 9.7 servers in a high availability environment" by Paul Zikopoulos and Steven Astorino 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. Free with FTL and SERVER licenses. Priced add-on for PVU and AU licensed DB2 Express servers via the High Availability Feature Pack.

This feature pack also includes online table REORG, the integrated cluster manager, and ACS.
Yes. Included.Yes. Included.Yes. Included.
Online table reorganization (REORG) (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. Free with FTL and SERVER licenses. Priced add-on for PVU and AU licensed DB2 Express servers via the High Availability Feature Pack.

This feature pack also includes HADR, the integrated cluster manager, and ACS.
Yes. Included.
Yes. Included.
Yes. Included.
64-bit instance support? Yes.
Yes.
Yes.
Yes.
Yes.
DB2 pureScale® (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.

As of DB2 9.7 Fix Pack 3a, DB2 Workgroup Edition gives you access to install DB2 pureScale on a cluster that is no bigger than four sockets, not including processing cores attributed to the Cluster Caching Facility (CF).
Yes. Priced add on.

This feature pack is available for DB2 Enterprise via a PVU or AU 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 Pack. The CF servers do not need to be licensed with DB2 Enterprise or the DB2 pureScale Feature Pack.

One important thing to note is the DB2 pureScale is only available with DB2 9.8. However, the only reason you would move to DB2 9.8 is to run DB2 pureScale itself.
Yes. Priced add-on.

Same as DB2 Enterprise.
Label-Based Access Control (LBAC)? (more information)Not available.Not available.Not available.Yes. Priced add-on.

To implement label-based security in DB2, you must be using DB2 Enterprise and additionally purchase the Advanced Access Control Feature Pack.
Yes. Included.
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) or DB2 Governor? (more information) No.No.

These features are not available in a DB2 Express environment. They used to be available by purchasing the Workload Management Feature Pack in DB2 9. This feature pack was removed as an offering when DB2 9.5 became generally available, thereby removing these capabilities from this edition.
No.

Same as DB2 Express.
Included.Included.
Workload Management (WLM)? (more information) Not available.Not available.Not available.Yes. Priced add-on.

Part of the Performance Optimization Feature Pack for DB2 Enterprise.

This feature pack also includes Optim™ Performance Expert which is now replaced by Optim Performance Manager and DB2 Workload Manager.
Yes. Included.
Supports Materialized Query Tables (MQTs) (more information), Query Parallelism (more information), and Multidimensional Clustering (MDC) Tables (more information) No.No.

These features used to be part of the Query Optimization Feature Pack (formerly known as the Performance Optimization Feature Pack in DB2 9); however, it was removed as an eligible add-on for DB2 Express when DB2 9.5 became generally available.

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.
No.

Same as DB2 Express.
Included.Included.
Deep Compression Services (tables, indexes, temporary tables, XML XDA, and more)? (more information) 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 Pack.

This feature pack can only be purchased using a PVU license (there is no AU license available for this feature pack) and can only be added to a PVU-licensed DB2 Enterprise server, although it is included in DB2 Advanced Enterprise Edition.
Yes. Included.
Backup compression? (more information)No.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. No.Yes.Yes.Yes.Yes.

DB2 Advanced also includes federation to Oracle databases.
SQL replication? (more information)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)No.No.No.Priced add-on.Yes.

Restricted use Q-replication functionality to replicate DB2 LUW to DB2 LUW for Active-Active environments.
Table partitioning? (more information)No.No.No.Included.Included.
pureXML? (more information) Yes.Yes.Yes.Yes.Yes.
DB2 Text Search (more information) DB2 Text Search 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) 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.
Geodetic extender? (more information)No.No.No.Yes. Priced add-on.

If you are developing spatial applications that can't tolerate the distortions that can occur when applying projections to your data (as is the case with the DB2 Spatial Extender; for example, projecting the curvature of the earth), you can add advanced spatial modeling capabilities by purchasing this feature pack for DB2 Enterprise. In order to use this feature, you need to install the DB2 Spatial Extender which is available free of charge.
Yes. Priced add-on.

Same as DB2 Enterprise.
Optim Development Studio (more information) Previously known as IBM Data Studio Developer, Optim Development Studio provides an integrated database development environment for Oracle, DB2, and Informix. No.Yes.Yes.Yes.Yes.
Optim Database Administrator (more information) Previously known as Data Studio Administrator, Optim Database Administrator is part of the Optim family helping organizations manage data across heterogeneous environments. No.Yes.Yes.Yes.Yes.
Optim Performance Manager (more information) Provides a comprehensive and proactive performance management solution for database applications. No.No.No.Yes. Priced add-on.

The Add-on includes Optim Performance Manager Extended Edition.
Yes.

Includes Optim Performance Manager, not Optim Performance Manager Extended Edition. More information on the two editions of Optim Performance Manager can be found here.
IBM DB2 SQL Skin Feature 1.0 for applications compatible with Sybase ASE (more information) No.No.No.Yes. Priced add-on.Yes. Priced add-on

Return to article