DB2 Version 10.1 for Linux, UNIX, and Windows

Functionality in DB2 features and DB2 product editions

Some functionality is available in only certain DB2® database product editions. In some cases, the functionality is associated with a particular DB2 feature.

The table indicates which functionality is included in a DB2 product edition. If the functionality is not included but it is available in a DB2 feature, the name of the feature is specified. You must obtain a license for that DB2 feature as well as for the DB2 database product edition.

Note: This table is for informational purposes only. For details of entitlement, rights and obligations, refer to the license agreement for your DB2 product.
Table 1. Functionality in DB2 features and DB2 database product editions
Functionality DB2 Express-C DB2 Express Edition1 DB2 Workgroup Server Edition DB2 Enterprise Server Edition2 DB2 Advanced Enterprise Server Edition2 IBM Database Enterprise Developer Edition
Adaptive Compression and classic row compression No No No DB2 Storage Optimization Feature4 Yes Yes
Compression: backup Yes Yes Yes Yes Yes Yes
Connection concentrator No No No Yes Yes Yes
Continuous Data Ingest No No No No Yes Yes
DB2 Advanced Copy Services No Yes Yes Yes Yes Yes
DB2 Connect™ functionality No No No No No Yes
DB2 Governor No No No Yes Yes Yes
DB2 pureScale® functionality No No You are entitled to use DB2 pureScale Feature in a maximum of 16 cores and 64 GB total cluster size. DB2 pureScale Feature4 DB2 pureScale Feature4 Yes
Federation with DB2 LUW and Informix® Data Server data sources Yes Yes Yes Yes Yes Yes
Federation with DB2 LUW and Oracle data sources No No No No Yes Yes
High availability disaster recovery No Yes Yes Yes Yes Yes
IBM Data Studio Yes Yes Yes Yes Yes Yes
IBM InfoSphere® Data Architect No No No No Yes5 Yes
IBM InfoSphere Optim™ Configuration Manager No No No No Yes Yes
IBM InfoSphere Optim Performance Manager Extended Edition3 No No No No Yes Yes
IBM InfoSphere Optim pureQuery Runtime No No No No Yes Yes
IBM InfoSphere Optim Query Workload Tuner No No No No Yes Yes
IBM Mobile Database Yes Yes Yes Yes Yes Yes
IBM Mobile Database Sync Yes Yes Yes Yes Yes Yes
Label-based access control (LBAC) No Yes Yes Yes Yes Yes
Materialized query tables (MQTs) No No No Yes Yes Yes
Multidimensional clustering (MDC) tables No No No Yes Yes Yes
Multi-Temperature Storage No No No Yes Yes Yes
Net Search Extender Yes Yes Yes Yes Yes Yes
Online reorganization No Yes Yes Yes Yes Yes
Oracle Compatibility Yes Yes Yes Yes Yes Yes
Partitioning - partitioned database environment 3 No No No No No Yes
Partitioning - Table partitioning No No No Yes Yes Yes
pureXML® storage Yes Yes Yes Yes Yes Yes
Q Replication with two other DB2 LUW servers No No No No Yes Yes
Query parallelism No No No Yes Yes Yes
Replication tools Yes6 Yes6 Yes6 Yes6 Yes6 Yes
Row and column access control (RCAC) No Yes Yes Yes Yes Yes
Spatial Extender Yes Yes Yes Yes Yes Yes
SQL Replication between DB2 LUW and Informix Data Server No Yes Yes Yes Yes Yes
Time Travel Query Yes Yes Yes Yes Yes Yes
Tivoli Storage FlashCopy Manager No Yes Yes Yes Yes Yes
IBM Tivoli® System Automation for Multiplatforms No Yes Yes Yes Yes Yes
Workload management No No No No Yes Yes
Note:
  1. DB2 Express Edition including DB2 Express Edition Fixed Term License
  2. You can purchase all of the DB2 features that are listed in this column for use with IBM InfoSphere Warehouse Enterprise Base and Enterprise Edition products.
  3. Partitioned database environment is also bundled with all editions of IBM InfoSphere Warehouse.
  4. Separately priced feature.
  5. DB2 Advanced Enterprise Server Edition includes 10 InfoSphere Data Architect user licenses.
  6. Replication tools except the Replication Center are available on all supported operating systems. The Replication Center is available only on Linux and Windows operating systems.
Parent topic: DB2 features and DB2 product editions