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