Compare the distributed DB2 9.5 data servers

In a side-by-side comparison table, author Paul Zikopoulos makes it simple to understand the basic licensing rules, functions, and feature differences between the members of the distributed DB2 9.5 server family as of the interim release packaging changes announced on February 10th, 2009.

Paul Zikopoulos (paulz_ibm@msn.com), Senior Specialist, IBM Competitive Team, IBM

Photo: Paul C. ZikopoulosPaul C. Zikopoulos, BA, MBA, is the Program Director for the DB2 Evangelist team at IBM. He is an award-winning writer and speaker with more than 14 years of experience with DB2. Paul has written more than 230 magazine articles and 11 books on DB2 including, Information on Demand: Introduction to DB2 9.5 New Features, DB2 9 Database Administration Certification Guide and Reference (6th Edition), DB2 9: New Features, Information on Demand: Introduction to DB2 9 New Features, Off to the Races with Apache Derby, DB2 Version 8: The Official Guide, DB2: The Complete Reference, DB2 Fundamentals Certification for Dummies, DB2 for Dummies, and A DBA's Guide to Databases on Linux. Paul is a DB2 Certified Advanced Technical Expert (DRDA and Clusters) and a DB2 Certified Solutions Expert (BI and DBA). In his spare time, he enjoys all sorts of sporting activities, including running with his dog Chachi, avoiding punches in his MMA training, and trying to figure out the world according to Chloë – his daughter. You can reach him at paulz_ibm@msn.com.



10 February 2009 (First published 09 January 2003)

Also available in Chinese Russian

Please read the Notices section before reading this article.

Introduction

"DB2 is DB2 is DB2." This mantra holds true for the distributed platforms that DB2 9 runs on, the editions that are available for purchase, and the freely available DB2 Express-C package.

Quite simply, this memorable phrase means no worries when you need to grow. It means any application you write for any edition of DB2 will work with any DB2 database running on any distributed platform that DB2 supports (Windows, HP-UX, Sun Solaris, Linux, Mac OS X, and AIX). In fact, there's even a cross-family SQL reference book that developers can use to write cross-family DB2 for z/OS and DB2 for i (formerly known as DB2 for i5/OS or DB2 for AS/400) portable applications with a common SQL API.

In addition to this, the DB2 9.5 release introduces a whole new tool set called IBM Data Studio. The absence of the DB2 moniker is not accidental; IBM Data Studio is a tooling platform that spans the entire spectrum of the application lifecycle (Design, Develop, Deploy, Manage, and Govern) for all IBM relational databases and a vision for more. So not only do you have a portable SQL API, you also have a toolset that lets you instrument your business logic across the enterprise. This means that applications written for DB2 for Windows can be easily ported to or from DB2 for z/OS; it also means that your personnel skills investment can be dynamically moved from problem area to problem area, breaking free of costly database skill stove pipes. To further enhance the DB2 family value proposition, the newly updated (as of February 10th, 2009) packaging includes federation across the entire IBM relational database portfolio. This allows you to write a single SQL statement that transparently joins data from DB2 on Windows, or DB2 for z/OS, or Informix - any supported combination you can think of. What's more, you can add WebSphere Information Server software to solve cross-vendor information integration problems by extending the DB2 SQL API with transparent access to non-IBM relational databases (such as Oracle or SQL Server) and materialize non-relational data sources (like XML streams, spreadsheets, message queues, VSAM, IMS, and so on) as relational tables: thereby truly creating a corporate-wide common data model. Truly, DB2 enables in-place access to data wherever it may reside.

DB2 also comes in different editions and packages, including the free highly acclaimed DB2 Express-C package and its optional 12 Month License and Subscription option, commonly known as the Fixed Term License (FTL): DB2 Express-C FTL. (It's a small point, but DB2 Express-C is generally not referred to as a DB2 edition, rather a package.) All DB2 editions and packages share the same code base; they're really just feature and licensing distinctions that try to allocate the appropriate features, functions, and benefits available within DB2 to the appropriate target market at the appropriate price. Again, the underlying technology is always DB2, so decisions about what edition to use has nothing to do with portability, ease of use, and so on. Quite simply, this means if you write an application for the free DB2 Express-C engine, it will run on a DB2 Personal Edition (DB2 Personal), DB2 Express Edition (DB2 Express), DB2 Workgroup Edition (DB2 Workgroup), or DB2 Enterprise Edition (DB2 Enterprise) server.

Quite often clients (and IBMers for that matter) need a quick location to find up to date quick comparisons between licensing rules, features, and functions that are included in the distributed DB2 server offerings. In this article, I use a simple table to compare and contrast the different DB2 editions and packages as of February 10th, 2009 with respect to the most common questions I get from clients as to "what's in what", and so on. You should be aware that this article doesn't take into consideration specialized packages such as the InfoSphere Warehouse editions which all have DB2 as the core database engine.

By no means can this article, and the accompanying table below, be complete. Again, it attempts to answer 80% of the questions I get when talking to clients or in speaking engagements. (If I haven't covered a topic you have a question about, e-mail me and I'll add it to a future update.) The distributed DB2 editions are very much a set of Russian dolls -- what's generally in one edition is in the higher editions. For example, the High Availability Disaster Recovery (HADR) technology is not included in DB2 Express (unless you purchase an add-on Feature Pack), but is included in DB2 Workgroup; therefore, it stands to reason that HADR is also included for free in DB2 Enterprise - and it is. (DB2 Express-C FTL adds complexity to this rule of thumb as the HADR feature is included in this offering but is an add-on offering for DB2 Express; however, by and large, this rule of thumb holds true and it's fair to note that DB2 Express-C and DB2 Express-C FTL are considered packages, not editions.) The Self Tuning Memory Manager (STMM) is another example; since it's part of DB2 Personal, it's also part of every other edition.


Easy comparison table

The side-by-side comparison in Table 1 is designed to make it easier for you to determine which of the DB2 9.5 editions and packages are right for you. If a feature is not listed in the table, you can assume (for the most part) that the feature exists in all editions included in the table. For more information on the different editions of DB2, read "Which distributed edition of DB2 is right for you?" by Paul Zikopoulos.

Table 1. Side-by-side comparison of DB2 Express-C, DB2 Express-C FTL, DB2 Express, DB2 Workgroup, and DB2 Enterprise Version 9.5
Function, feature, and benefit DB2 Express-C DB2 Express-C FTL Subscription) DB2 Express DB2 Workgroup DB2 Enterprise
Platform Support?

The most up to date supported hardware and software platforms are here.
Windows, Linux (POWER and x86 servers), Mac OS X, and Solaris x64.
DB2 Express-C is the only DB2 server that can run Mac OS X.
Windows, Linux (POWER and x86 servers), and Solaris x64.Windows, Linux (POWER and x86 servers), and Solaris x64.Windows, Linux (POWER and x86 servers), AIX, Solaris (SPARC and x64), and HP-UX (only IA-64). Windows, Linux (POWER, System z, and x86 servers), AIX, Solaris (SPARC and x64), and HP-UX (only IA-64).
Eligibility for Processor Value Unit (PVU) pricing or authorized user licensing?
PVU pricing is also known as processor pricing. It allows for an unlimited number of connection to a database server.
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 down its resource consumption to these optimized levels. You can install DB2 Express-C on any sized server on any supported platform.
Not applicable. Uses a per server licensing metric.

When you buy DB2 Express-C FTL, you are effectively buying a yearly support and feature contract for your DB2 Express-C server. Since the DB2 component of this package is free, you simply pay for the fixed support term for the year. It's easy to license DB2 Express-C FTL. 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.

DB2 Express-C FTL is optimized in the same manner as DB2 Express-C; however it will throttle itself such that its resource consumption won't exceed 4 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-C FTL on any sized server on any supported platform.
Yes.

DB2 Express can be licensed with an authorized user license or per processor based on the underlying server's PVU rating.

For authorized users, you have to buy an authorized user 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 authorized user licenses. In addition, you need to minimally license 5 authorized users when using an authorized user license with this edition.

A DB2 Express processor license is also available and this license removes the requirement to count users. DB2 processor licenses are licensed via the PVU rating of the underlying server or virtualization session where the software runs.
Yes.

DB2 Workgroup can be licensed with an authorized user license or per processor based on the underlying server's PVU rating.

For authorized users, you have to buy an authorized user license for each user that wants to connect to a specific DB2 Workgroup server. If the same user wants to connect to two different DB2 Workgroup servers, that one person needs two authorized user licenses. In addition, you need to minimally license 5 authorized users when using an authorized user license with this edition.

A DB2 Workgroup processor license is also available and this license removes the requirement to count users. DB2 processor licenses are licensed via the PVU rating of the underlying server or virtualization session where the software runs.
Yes.

DB2 Enterprise can be licensed with an authorized user license or per processor based on the underlying server's PVU rating.

For authorized users, you have to buy an authorized user license for each user that wants to connect to a specific DB2 Enterprise server. If the same user wants to connect to two different DB2 Enterprise servers, that one person needs two authorized user licenses. In addition, you need to minimally license 25 authorized users for every 100 PVUs for the server upon which this edition is installed when using an authorized user license.

For example, if you installed DB2 Enterprise on a server rated for 400 PVUs, you would need to buy at least 100 authorized user 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 authorized user licenses since you have to minimally license DB2 Enterprise with 25 authorized user licenses per 100 PVUs when you use this license. If your environment had 125 users, in this example, you would need to procure 125 authorized user licenses since it is greater than the minimum.
Processor Value Unit (PVU) limitations?

The PVU limit of the underlying server, or virtualization session, where the DB2 server software is installed.
Not applicable.

DB2 Express-C is optimized and throttled to consume 2 cores of processing power on a server from an unlimited number of cores per socket, processors, and so on.
Not applicable.

DB2 Express-C FTL is optimized and throttled to consume 4 cores of processing power on a server from an unlimited number of cores per socket, processors, and so on.
200.

DB2 Express can be installed on a server with a maximum 200 PVU rating.
480.

DB2 Workgroup can be installed on a server with a maximum 480 PVU rating.

The 480 PVU limit was changed in 2008 from the former 400 PVU limit to accommodate the PVU rating of a POWER6 core (most are rated at 120 PVUs).
Unlimited.
Memory limitations on the server (or virtualization session) where the DB2 software is installed?2 GB.

This limit is automatically enforced by the DB2 software as of DB2 9.5.

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 as of DB2 9.5.

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

This limit is automatically enforced by the DB2 software as of DB2 9.5.

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

This limit is automatically enforced by the DB2 software as of DB2 9.5.

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

Before DB2 9.5, the RAM limit for DB2 Workgroup was for the entire server; however when DB2 9.5 was released, this limit was changed such that it follows the same logic as DB2 Express, only with the 16 GB limit instead of 4 GB.
No, unlimited.
Eligible for virtualization (also known as sub-capacity) licensing; for example, LPAR, DLPAR, VMWare, and so on?

Different platforms and virtualization technolgies have different pre-requisites which allow you to use a DB2 edition or package in a sub-capacity enviroment. Click here for details about the rules that govern these types of deployments.
Yes.

You can deploy DB2 Express-C servers in a virtualized environment using virtualization software such as VMWare. If you have a 16 core server, you might install DB2 Express-C in 4 different virtualization sessions, but each session will not use more than the throttled amount of CPU and RAM resources outlined earlier in this article.
Yes.

You can deploy DB2 Express-C FTL servers in a virtualized environment using virtualization software such as VMWare. If you have a 16 core server, you might install DB2 Express-C FTL in 4 different virtualization sessions, but each session will not use more than the throttled amount of CPU and RAM resources outlined earlier in this article.

When you buy DB2 Express-C FTL and use virtualization technologies to host multiple DB2 Express-C FTL installations, you need to buy the FTL support and feature contract for each copy on the server. For example, if you have 10 copies of DB2 Express-C FTL in 10 VMWare sessions running on an 16 core server, you need to purchase 10 DB2 Express-C FTL contracts.
Yes.

As of February 10th, 2009, DB2 Express is elgible for sub-capacity deployments.

DB2 license and resource limitations in virtualized scenarios appy to each virtual session.
Yes.

As of February 10th, 2009, DB2 Workgroup is elgible for sub-capacity deployments.

DB2 license and resource limitations in virtualized scenarios appy to each virtual session.
Yes.

DB2 Enterprise has always supported this licensing option.

DB2 license and resource limitations in virtualized scenarios appy to each virtual session.
IBM's legendary 24x7 direct-to-engineer support model with set maintenance streams for fixes and additional features?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 FixPack. 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.

Although no formal support is available for DB2 Express-C, you can leverage the support forum that's voluntarily monitored by some of the world's top DB2 engineers.
Yes.

Since DB2 Express-C FTL comes with a support contract, it has the same direct-to-engineer support and maintenance schedules as any other supported DB2 server.

Support, HADR, the built-in high availability clustering software in DB2, CPU, memory limits, and replication are the main differentiators between DB2 Express-C and DB2 Express-C FTL.
Yes.Yes.Yes
Installable with DB2 Connect?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. For example, DB2 Connect Enterprise Edition, DB2 Application Server Edition, or one of the DB2 Connect Unlimited Editions.

The DB2 Connect edition you select will be based on a number of factors such as number of users, growth of MIPS, growth of application servers, and more. For example, DB2 Connect Enterprise Edition, DB2 Application Server Edition, or one of the DB2 Connect Unlimited Editions.
Yes.

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

The DB2 Connect edition you select will be based on a number of factors such as number of users, growth of MIPS, growth of application servers, and more. For example, DB2 Connect Enterprise Edition, DB2 Application Server Edition, or one of the DB2 Connect Unlimited Editions.
Yes.

You can't buy DB2 Connect Personal Edition and put it on a DB2 Express server. It must be a DB2 Connect server edition. For example, DB2 Connect Enterprise Edition, DB2 Application Server Edition, or one of the DB2 Connect Unlimited Editions.

The DB2 Connect edition you select will be based on a number of factors such as number of users, growth of MIPS, growth of application servers, and more.
Yes.


You can't buy DB2 Connect Personal Edition and put it on a DB2 Workgroup server. It must be a DB2 Connect server edition. For example, DB2 Connect Enterprise Edition, DB2 Application Server Edition, or one of the DB2 Connect Unlimited Editions.

The DB2 Connect edition you select will be based on a number of factors such as number of users, growth of MIPS, growth of application servers, and more.
Yes.

You can't buy DB2 Connect Personal Edition and put it on a DB2 Enterprise server. It must be a DB2 Connect server edition. For example, DB2 Connect Enterprise Edition, DB2 Application Server Edition, or one of the DB2 Connect Unlimited Editions.

The DB2 Connect edition you select will be based on a number of factors, including number of users, growth of MIPS, growth of application servers, and more.

Note that DB2 Enterprise doesn't come with any DB2 Connect entitlements as was the case in DB2 8.
Eligible for high availability (HA) licensing?

For information on how to license DB2 9.5 servers in a high availability environment, read "Licensing distributed DB2 Version 9.5 servers in a high availability configuration" by Paul Zikopoulos.
No.

You cannot use HA clustering software of any kind to cluster DB2 Express-C servers for high availability. For example, availability clustering through Microsoft Clustering Services, SteeleEye, or even the built-in HA clustering facilities are not allowed with DB2 Express-C.
Yes.

A DB2 Express-C FTL license includes the ability to cluster these servers for HA. DB2 Express-C FTL also gives you access to HADR technology as well as the built-in clustering software that's embedded in DB2 9.5 for HA configurations

When you cluster two DB2 Express-C FTL servers in an HA cluster, you must purchase an FTL contract for each server in the cluster no matter what function they perform in the cluster.
Yes.

DB2 Express supports HA clustering using standard off-the-shelf HA clustering software such as Microsoft Clustering Services, SteeleEye, and so on.

If you want to cluster two DB2 Express servers together using the clustering software that's built-in to DB2 or HADR, you need to purchase the corresponding High Availability Feature Pack.
Yes.Yes.
Advanced Copy Services (ACS)

DB2 ACS enables you to leverage the fast copying technology of a storage device to perform the data copying part of backup and restore operations. Being able to use the storage device to perform the data copying makes the backup and restore operations much faster. A backup operation that uses DB2 ACS is called a snapshot backup.
No.
No.
Yes. Add-on.

You can use DB2 ACS with a DB2 Express database so long as you buy the corresponding High Availability Feature Pack. As of DB2 9.5, this Feature Pack only needs to be licensed for all the PVUs or authorized users on the primary server; you don't have to license this Feature Pack for the warm standby 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 9.5.
Yes. Included.
Yes. Includes.
Usage rights for the built-in cluster manager software (which is IBM Tivoli System Automation) in DB2? No.

DB2 Express isn't elgible for high availability clustering of any kind using any software.
Yes.

If you cluster two servers together using the built-in clustering facility in DB2, you need to buy a DB2 Express-C FTL contract for each server.
Yes. Add-on.

You can use the built-in clustering software in DB2 9.5 to create a high availability cluster or automate the failover for an HADR cluster with DB2 Express so long as you buy the corresponding High Availability Feature Pack.

As of DB2 9.5, this Feature Pack only needs to be licensed for all the PVUs or authorized users on the primary server; you don't have to license this Feature Pack for the warm standby server. This feature pack also includes DB2 ACS, HADR, and rights to run an online table reorganization.
Yes. Included.
Yes. Includes.
Supports High Availability Disaster Recovery (HADR)?

DB2 HADR is a technology that provides turnkey high availability and disaster recovery support for DB2 databases.
No.

DB2 Express-C doesn't support HADR.

In fact, DB2 Express-C isn't authorized for use in any high availability environment using any clustering software.
Yes. Included.

DB2 Express-C FTL includes licensed use of HADR as part of its FTL support component.
Yes. Add on.

You can use HADR with a DB2 Express database so long as you buy the corresponding High Availability Feature Pack.

As of DB2 9.5, this Feature Pack only needs to be licensed for all the PVUs or authorized users on the primary server; you don't have to license this Feature Pack for the warm standby server.

This feature pack also includes DB2 ACS, the built-in clustering software that's apart of DB2 9.5, and rights to run an online table reorganization.
Yes. Included.

As of DB2 9.5, HADR technology is included in DB2 Workgroup and requires no further licensing beyond the regular DB2 server high availability licensing rules.

Before DB2 9.5, you had to purchase this technology through the High Availability Feature Pack.
Yes. Included.
Online table reorganization (REORG)

Online (sometimes referred to as inplace) table reorganization allows the user to reorganize a table while permitting full access to that table.
No.
No.
Yes. Add-on.

You can perform online table reorganizations within a DB2 Express database so long as you buy the corresponding High Availability Feature Pack. As of DB2 9.5, this Feature Pack only needs to be licensed for all the PVUs or authorized users on the primary server; you don't have to license this Feature Pack for the warm standby server. This feature pack also includes DB2 ACS, HADR, and rights to use the built-in clustering software that's part of DB2 9.5.
Yes. Included.
Yes. Included.
64-bit instance support?Yes.
Yes.
Yes.
Yes.
Yes.
Label Based Access Control (LBAC)? Not available.Not available.Not available.Not available.Yes. Add-on.

To implement label-based security in DB2 you must be using DB2 Enterprise and additionally purchase the Advanced Access Control Feature Pack.
Supports Connection Concentration?

or
DB2 Governor?
No.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.

These features are not available in a DB2 Workgroup 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.
Included.
Workload Management (WLM)? Not available.Not available.Not available.Not available.Yes. Add-on.

Part of the Performance Optimization Feature Pack for DB2 Enterprise. This feature pack also includes DB2 Performance Expert and Extreme Workload Management (DB2 Query Patroller is also included although it's no longer the strategic DB2 workload management solution). This feature pack is included in InfoSphere Warehouse Enterprise and through the DB2 SAP OEM contract that includes DB2.
Materialized Query Tables (MQTs)?

or

Query Parallelism?

or

Multidimensional Clustering (MDC) Tables?
No.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.

You should note however that since these features are so strongly correlated with BI applications, they are part of every InfoSphere Warehouse edition. InfoSphere Warehouse has an edition that corresponds to DB2 Express called InfoSphere Warehouse Starter Edition.
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 Workgroup when DB2 9.5 became generally available.

You should note however that since these features are so strongly correlated with BI applications, they are part of every InfoSphere Warehouse Edition. InfoSphere Warehouse has an edition that corresponds to DB2 Workgroup called InfoSphere Warehouse Intermediate Edition.
Included.
Deep Compression? Not available.

You can however use System default and NULL value compression to optimize space usage for the representation of data and the storage structures used internally by DB2. This built-in DB2 feature will in no way provide results close to the compression available with deep row compression and has limited suitability for specific schemas. System default and NULL value compression can be used with deep compression.
Not available.

You can however use System default and NULL value compression to optimize space usage for the representation of data and the storage structures used internally by DB2. This built-in DB2 feature will in no way provide results close to the compression available with deeprow compression and has limited suitability for specific schemas. System default and NULL value compression can be used with deep compression.
Not available.

You can however use System default and NULL value compression to optimize space usage for the representation of data and the storage structures used internally by DB2. This built-in DB2 feature will in no way provide results close to the compression available with deep row compression and has limited suitability for specific schemas. System default and NULL value compression can be used with deep compression.
Not available.

You can however use System default and NULL value compression to optimize space usage for the representation of data and the storage structures used internally by DB2. This built-in DB2 feature will in no way provide results close to the compression available with deep row compression and has limited suitability for specific schemas. System default and NULL value compression can be used with deep compression.
Add-on.

To take advantage of the deep row compression capabilities available in DB2 you need to purchase the Storage Optimization Feature Pack.

This feature pack is only available for DB2 Enterprise and can only be purchased via PVUs (there is no authorized user option).

Deep compression is included for free in InfoSphere Warehouse Enterprise and through the DB2 SAP OEM contract.
Backup Compression? Yes.

Backup compression used to be free of charge in every DB2 edition back in DB2 8. In DB2 9, it became part of the Storage Optimization Feature Pack which was only available with DB2 Enterprise as an add-on Feature Pack.

I'm happy to say that this feature has been removed from the Storage Optimization Feature Pack and is once again freely available for all DB2 editions and packages as of February 10th, 2009.
Yes.

Backup compression used to be free of charge in every DB2 edition back in DB2 8. In DB2 9, it became part of the Storage Optimization Feature Pack which was only available with DB2 Enterprise as an add-on Feature Pack.

I'm happy to say that this feature has been removed from the Storage Optimization Feature Pack and is once again freely available for all DB2 editions and packages as of February 10th, 2009.
Yes.

Backup compression used to be free of charge in every DB2 edition back in DB2 8. In DB2 9, it became part of the Storage Optimization Feature Pack which was only available with DB2 Enterprise as an add-on Feature Pack.

I'm happy to say that this feature has been removed from the Storage Optimization Feature Pack and is once again freely available for all DB2 editions and packages as of February 10th, 2009.
Yes.

Backup compression used to be free of charge in every DB2 edition back in DB2 8. In DB2 9, it became part of the Storage Optimization Feature Pack which was only available with DB2 Enterprise as an add-on Feature Pack.

I'm happy to say that this feature has been removed from the Storage Optimization Feature Pack and is once again freely available for all DB2 editions and packages as of February 10th, 2009.
Yes.

Backup compression used to be free of charge in every DB2 edition back in DB2 8. In DB2 9, it became part of the Storage Optimization Feature Pack which was only available with DB2 Enterprise as an add-on Feature Pack.

I'm happy to say that this feature has been removed from the Storage Optimization Feature Pack and is once again freely available for all DB2 editions and packages as of February 10th, 2009.
Federation across IBM relational databases (DB2 on all platforms and Informix)? No.No.Yes.

Federation across IBM relational databases used to be free of charge in every DB2 edition back in DB2 8. In DB2 9, it became part of the Homogeneous Federation Feature Pack, which was only available with DB2 Express, DB2 Workgroup, and DB2 Enterprise as an add-on Feature Pack.

I'm happy to say that this feature has been removed from the Homogeneous Federation Feature Pack and is once again freely available for this edition of DB2 as of February 10th, 2009. If you want to federate to non-IBM data sources, you should look at IBM Information Server.
Yes.

Federation across IBM relational databases used to be free of charge in every DB2 edition back in DB2 8. In DB2 9, it became part of the Homogeneous Federation Feature Pack, which was only available with DB2 Express, DB2 Workgroup, and DB2 Enterprise as an add-on Feature Pack.

I'm happy to say that this feature has been removed from the Homogeneous Federation Feature Pack and is once again freely available for this edition of DB2 as of February 10th, 2009. If you want to federate to non-IBM data sources, you should look at IBM Information Server.
Yes.

Federation across IBM relational databases used to be free of charge in every DB2 edition back in DB2 8. In DB2 9, it became part of the Homogeneous Federation Feature Pack, which was only available with DB2 Express, DB2 Workgroup, and DB2 Enterprise as an add-on Feature Pack.

I'm happy to say that this feature has been removed from the Homogeneous Federation Feature Pack and is once again freely available for this edition of DB2 as of February 10th, 2009. If you want to federate to non-IBM data sources, you should look at IBM Information Server.
SQL replication? No.Yes.

Support is provided for SQL-based replication to the DB2 family. In addition, WebSphere products can add Queue-based replication. For example, WebSphere Replication Server.
Yes.

Support is provided for SQL-based replication to the DB2 family. In addition, WebSphere products can add Queue-based replication. For example, WebSphere Replication Server.
Yes.

Support is provided for SQL-based replication to the DB2 family. In addition, WebSphere products can add Queue-based replication. For example, WebSphere Replication Server.
Yes.

Support is provided for SQL-based replication to the DB2 family. In addition, WebSphere products can add Queue-based replication. For example, WebSphere Replication Server.
Table Partitioning? Not available.Not available.Not available.

Note that all InfoSphere Warehouse editions include this feature. InfoSphere Warehouse has an edition that corresponds to DB2 Express called InfoSphere Warehouse Starter Edition.
Not available.

Note that all InfoSphere Warehouse editions include this feature. InfoSphere Warehouse has an edition that corresponds to DB2 Workgroup called InfoSphere Warehouse Intermediate Edition.
Included.

Note that all InfoSphere Warehouse editions include this feature. InfoSphere Warehouse has a number of editions that correspond to DB2 Enterprise called InfoSphere Warehouse Base Edition, InfoSphere Warehouse Advanced Edition, and InfoSphere Warehouse Enterprise Edition.
Database Partitioning?

Use for scalability clusters: once known as DB2 EEE. This feature allows you to spread a single database image across multiple physical servers.
Not available.Not available.Not available.

Note that all InfoSphere Warehouse editions include this feature.

InfoSphere Warehouse has an edition that corresponds to DB2 Express called InfoSphere Warehouse Starter Edition.
Not available.

Note that all InfoSphere Warehouse editions include this feature.

InfoSphere Warehouse has an edition that corresponds to DB2 Workgroup called InfoSphere Warehouse Intermediate Edition.
Not available.

As of the time when DB2 9.5 became generally available, you can only get the Database Partitioning Feature (DPF) to create a partitioned database environment by buying an edition of InfoSphere Warehouse.

Note that all InfoSphere Warehouse editions include this feature.

InfoSphere Warehouse has a number of editions that corresponds to DB2 Enterprise called InfoSphere Warehouse Base Edition, InfoSphere Warehouse Advanced Edition, and InfoSphere Warehouse Enterprise Edition.
pureXML? Included.Included.Included.

I'm happy to say that as of the update to the DB2 9.5 licensing terms announced on February 10th, 2009; pureXML is now freely inlcuded in all DB2 editions.
Included.

I'm happy to say that as of the update to the DB2 9.5 licensing terms announced on February 10th, 2009; pureXML is now freely inlcuded in all DB2 editions.
Included.

I'm happy to say that as of the update to the DB2 9.5 licensing terms announced on February 10th, 2009; pureXML is now freely inlcuded in all DB2 editions.
DB2 Net Search Extender? Available free of charge via a download.

Note however, this feature is still unsupported as is any code delivered with this program.
Available free of charge via a download. Available free of charge via a download. Available free of charge via a download. Available free of charge via a download.
DB2 Text Search

DB2 Text Search allows you to search text columns stored in a DB2 table. By enabling text search support, you can use the CONTAINS, SCORE, and xmlcolumn-contains functions, which are built into DB2 to search text-specific indexes built from search arguments that you specify.

You can find a comparison between DB2 Text Search and DB2 Net Search Extender here.
Yes.Yes.Yes.Yes.Yes.
Spatial Extender? Available free of charge via a download.

Note however, this feature is still unsupported as is any code delivered with this program.
Available free of charge via a download. Available free of charge via a download. Available free of charge via a download. Available free of charge via a download.
Geodetic Extender? Not available.Not available.Not available.Not available.Yes. Add-on.

If you are developing spatial applications that cannot 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.
DB2 Everyplace (Sometimes referred to as Mobility on Demand)?Not available.Not available.

You can optionally purchase a DB2 Everyplace product to add mobile functionality to your DB2 Express-C FTL server.
Not available.

You can optionally purchase a DB2 Everyplace product to add mobile functionality to your DB2 Express server.
Not available.

You can optionally purchase a DB2 Everyplace product to add mobile functionality to your DB2 Workgroup server.
Yes. Add-on.

You can optionally purchase the Mobility on Demand Feature Pack as opposed to directly purchasing the DB2 Everyplace product as is the case with other DB2 server editions. This feature pack provides a more cost effective way to expand your enterprise servers for occasionally connected clients.

The Mobility on Demand Feature Pack provides the same function, features, and benefits as the DB2 Everyplace Enterprise product. While it is more cost effective to implement mobile solutions using this Feature Pack, you must install the DB2 Synchronization Server on the DB2 Enterprise server for which this feature pack was purchased; this can limit its flexibility depending on your environment. Also note that this Feature Pack is included with any of the DB2 Connect Unlimited Editions.

That's all for now...

Different businesses have different needs - but all businesses need cost-effective, robust, and scalable solutions. The different DB2 editions, packages, and Feature Packs allows clients to pick the features of DB2 that's right for them - without sacrificing core strengths. Furthermore, since DB2 is DB2 is DB2, you can rest assure that whatever edition or package you choose, it will not limit future decisions if you need to scale or extend the power of DB2 - just upgrade the license key.

Packaging is an ever-changing landscape, so I suggest you refer back to this article often and ensure you take note of the publication or update dates.

In this article I tried to cover the differences between the different DB2 data server editions, as well as the DB2 Express-C and DB2 Express-C FTL offerings, with respect to the most common questions I get from clients and at speaking engagements. If you have other criteria that you would like to see included in this table, or need more clarification, e-mail me.


Notices

The information presented in this article is presented on a best effort basis from the author's personal knowledge and not intended to be an official communication from IBM. Neither the author nor IBM are liable for any incorrect information in this article.

Resources

Learn

Get products and technologies

  • Build your next development project with IBM trial software, available for download directly from developerWorks.
  • Now you can use DB2 for free. Download DB2 Express-C, a no-charge version of DB2 Express Edition for the community that offers the same core data features as DB2 Express Edition and provides a solid base to build and deploy applications.

Discuss

Comments

developerWorks: Sign in

Required fields are indicated with an asterisk (*).


Need an IBM ID?
Forgot your IBM ID?


Forgot your password?
Change your password

By clicking Submit, you agree to the developerWorks terms of use.

 


The first time you sign into developerWorks, a profile is created for you. Information in your profile (your name, country/region, and company name) is displayed to the public and will accompany any content you post, unless you opt to hide your company name. You may update your IBM account at any time.

All information submitted is secure.

Choose your display name



The first time you sign in to developerWorks, a profile is created for you, so you need to choose a display name. Your display name accompanies the content you post on developerWorks.

Please choose a display name between 3-31 characters. Your display name must be unique in the developerWorks community and should not be your email address for privacy reasons.

Required fields are indicated with an asterisk (*).

(Must be between 3 – 31 characters.)

By clicking Submit, you agree to the developerWorks terms of use.

 


All information submitted is secure.

Dig deeper into Information management on developerWorks


static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=13795
ArticleTitle=Compare the distributed DB2 9.5 data servers
publish-date=02102009