DB2 Version 9.7 for Linux, UNIX, and Windows

DB2 features and functions by edition

Some utilities and functionality are only available in particular DB2® database product editions. In some cases, the utility or functionality is associated with a particular DB2 feature and so you must purchase and register a license for that DB2 feature.

The following table lists utilities and functionality that are included in various editions of DB2 database products. Where a DB2 feature name appears, it means that you must obtain a license for that DB2 feature as well as for the DB2 database product.

Table 1. Utilities and functionality in DB2 database products
Utility or functionality DB2 Personal Edition DB2 Express Edition 12 month license and subscription DB2 Express Edition DB2 Express-C DB2 Workgroup Server Edition DB2 Enterprise Server Edition6 DB2 Advanced Enterprise Server Edition6
Advanced Copy Services No Yes IBM® DB2 High Availability Feature for Express Edition No Yes Yes Yes
Compression: backup No Yes Yes Yes Yes Yes Yes
Compression: row level No No No No No DB2 Storage Optimization Feature Yes
Connection concentrator No No No No No Yes Yes
Database partitioning 1 No No No No No No No
DB2 Governor No No No No No Yes Yes
DB2 pureScale® functionality No No No No No IBM DB2 pureScale Feature for Enterprise Server Edition V9.89 IBM DB2 pureScale Feature for Enterprise Server Edition V9.89
Geodetic Extender No No No No No DB2 Geodetic Data Management Feature 7 DB2 Geodetic Data Management Feature 7
High availability disaster recovery No Yes IBM DB2 High Availability Feature for Express Edition No Yes Yes Yes
Homogenous Federation Yes Yes Yes DB2 only Yes Yes Federation support can be used between DB2, IDS, and Oracle data sources.
Homogenous Q Replication No No No Homogenous Q Replication can be used with the purchase of InfoSphere® Replication Server. No IBM Homogeneous Replication Feature for DB2 Enterprise Server Edition Restricted use of queue-based replication functionality to replicate single DB2 for LUW source data server to single DB2 for LUW target data server.

IBM Homogeneous Replication Feature for DB2 Enterprise Server Edition is also offered for customers to perform queue-based replication between multiple DB2 for LUW, DB2 for i/OS, and DB2 for z/OS® data servers.
Homogenous SQL Replication Yes Yes Yes DB2 Express-C can be upgraded for a small fee to include SQL Replication. Yes Yes Yes
IBM Data Studio Yes Yes Yes No Yes Yes Yes
IBM InfoSphere Optim™ Performance Manager Extended Edition8 No No No No No IBM DB2 Performance Optimization Feature for Enterprise Server Edition 4 No
IBM InfoSphere Optim Performance Manager No No No No No No Yes
Label-based access control (LBAC) No No No No No DB2 Advanced Access Control Feature Yes
Materialized query tables (MQT) Yes No No No No Yes Yes
Multidimensional clustering (MDC) tables Yes No No No No Yes Yes
Net Search Extender Yes Yes Yes Yes Yes Yes Yes
Online reorganization Yes Yes IBM DB2 High Availability Feature for Express Edition No Yes Yes Yes
Oracle Compatibility Yes Yes Yes Yes10 Yes Yes Yes
Performance Expert No No No No No IBM DB2 Performance Optimization Feature for Enterprise Server Edition 4 No
pureXML® storage Yes Yes Yes Yes Yes Yes Yes
Query parallelism Yes No No No No Yes Yes
Query Patroller No No No No No IBM DB2 Performance Optimization Feature for Enterprise Server Edition 3 No
Spatial Extender Yes Yes Yes Yes Yes Yes Yes
Table partitioning No No No No No Yes Yes
IBM Tivoli® System Automation for Multiplatforms No Yes IBM DB2 High Availability Feature for Express Edition 5 No Yes Yes Yes
Workload management No No No No No IBM DB2 Performance Optimization Feature for Enterprise Server Edition Yes
Note:
  • 1 Partitioned database environment is no longer included or available in any DB2 database editions. It is included in all IBM InfoSphere Warehouse product editions.
  • 2 You can buy Performance Expert as a stand-alone product.
  • 3 IBM DB2 Performance Optimization Feature for Enterprise Server Edition does not contain DB2 Query Patroller for Solaris x64, Linux on IBM System z®, or any of the 64-bit editions of Windows Server 2003 or Windows Server 2008.
  • 4 IBM DB2 Performance Optimization Feature for Enterprise Server Edition does not contain Performance Expert for Solaris x64.
  • 5 IBM DB2 High Availability Feature for Express Edition does not contain IBM Tivoli System Automation for Multiplatforms (SA MP) for Solaris x64.
  • 6 All of the DB2 features listed in this column can also be purchased for use with IBM InfoSphere Warehouse Enterprise Base and Enterprise Edition products.
  • 7 Spatial Extender is a prerequisite for the DB2 Geodetic Data Management Feature.
  • 8IBM InfoSphere Optim Performance Manager Extended Edition is a follow on to Performance Expert. Starting with Version 9.7 Fix Pack 2 and later fix packs, IBM InfoSphere Optim Performance Manager Extended Edition helps optimize the performance and availability of mission critical databases and applications.
  • 9 In Version 9.7, the DB2 pureScale Feature is an add-on product for DB2 Advanced Enterprise Server Edition or DB2 Enterprise Server Edition. For DB2 Workgroup Server Edition, there is a limited use license.
  • 10 In order to take advantage of the DB2 compatibility features for Oracle applications, the DB2_COMPATIBILITY_VECTOR registry variable must be changed from its default value and set to ORA.
  • This table is for informational purposes only. For details of entitlement, rights and obligations, refer to the license agreement for your DB2 product.

Starting with DB2 Version 9.7 Fix Pack 3a, IBM Database Enterprise Developer Edition (DEDE) includes all of the DB2 features listed in the table).