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.
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:
|
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).