Some functionality is available in only certain DB2® database product editions.
The table indicates which functionality is included in a DB2 product edition and DB2 offering.
Functionality | DB2 Express-C | DB2 Express Server Edition | DB2 Workgroup Server Edition | DB2 Enterprise Server Edition | DB2 Advanced Workgroup Server Edition | DB2 Advanced Enterprise Server Edition | DB2 Developer Edition |
---|---|---|---|---|---|---|---|
Adaptive Compression and classic row compression | No | No | No | No | Yes | Yes | Yes |
Compression: backup | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Connection concentrator | No | No | No | Yes | Yes | Yes | Yes |
Continuous Data Ingest | No | No | No | No | Yes | Yes | Yes |
DB2 Advanced Copy Services (using Tivoli® Storage FlashCopy® Manager) | No | Yes | Yes | Yes | Yes | Yes | Yes |
DB2 column-organized tables5 | No | No | IBM® DB2 BLU Acceleration In-Memory Offering6 | IBM DB2 BLU Acceleration In-Memory Offering6 | Yes | Yes | Yes |
DB2 Connect™ functionality | No | No | No | No | Yes1 | Yes1 | Yes |
DB2 Governor | No | No | No | Yes | Yes | Yes | Yes |
DB2 pureScale® functionality | No | No | IBM DB2 Business Application Continuity Offering6 | IBM DB2 Business Application Continuity Offering6 | Yes | Yes | Yes |
Encryption - native backup encryption | Yes | IBM DB2 Encryption Offering6 | IBM DB2 Encryption Offering6 | IBM DB2 Encryption Offering6 | Yes | Yes | Yes |
Encryption - native database encryption | Yes | IBM DB2 Encryption Offering6 | IBM DB2 Encryption Offering6 | IBM DB2 Encryption Offering6 | Yes | Yes | Yes |
Federation with DB2 LUW and Informix® Data Server data sources | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Federation with DB2 LUW and Oracle data sources | No | No | No | Yes1 | Yes1 | Yes | Yes |
High availability disaster recovery | No | Yes | Yes | Yes | Yes | Yes | Yes |
IBM Data Studio | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
IBM(r) DB2 Merge Backup | No | IBM DB2 Advanced Recovery Feature | IBM DB2 Advanced Recovery Feature | IBM DB2 Advanced Recovery Feature | IBM DB2 Advanced Recovery Feature | IBM DB2 Advanced Recovery Feature | IBM DB2 Advanced Recovery Feature |
IBM(r) DB2 Recovery Expert | No | IBM DB2 Advanced Recovery Feature | IBM DB2 Advanced Recovery Feature | IBM DB2 Advanced Recovery Feature | IBM DB2 Advanced Recovery Feature | IBM DB2 Advanced Recovery Feature | IBM DB2 Advanced Recovery Feature |
IBM InfoSphere® Change Data Capture for DB2 for LUW4 | No | No | IBM DB2 BLU Acceleration In-Memory Offering6 | IBM DB2 BLU Acceleration In-Memory Offering6 | Yes | Yes | Yes |
IBM InfoSphere CDC Access Server4 | No | No | IBM DB2 BLU Acceleration In-Memory Offering6 | IBM DB2 BLU Acceleration In-Memory Offering6 | Yes | Yes | Yes |
IBM InfoSphere CDC Management Console4 | No | No | IBM DB2 BLU Acceleration In-Memory Offering6 | IBM DB2 BLU Acceleration In-Memory Offering6 | Yes | Yes | Yes |
IBM InfoSphere Data Architect | No | No | No | No | Yes2 | Yes2 | Yes2 |
IBM InfoSphere Optim™ Configuration Manager | No | No | No | No | Yes | Yes | Yes |
IBM InfoSphere Optim Performance Manager Extended Edition | No | IBM DB2 Performance Management Offering6 | IBM DB2 Performance Management Offering6 | IBM DB2 Performance Management Offering6 | Yes | Yes | Yes |
IBM InfoSphere Optim pureQuery® Runtime | No | No | No | No | Yes | Yes | Yes |
IBM InfoSphere Optim Query Workload Tuner | No | IBM DB2 Performance Management Offering6 | IBM DB2 Performance Management Offering6 | IBM DB2 Performance Management Offering6 | Yes | Yes | Yes |
IBM InfoSphere Optim High Performance Unload | IBM DB2 Advanced Recovery Feature | IBM DB2 Advanced Recovery Feature | IBM DB2 Advanced Recovery Feature | IBM DB2 Advanced Recovery Feature | IBM DB2 Advanced Recovery Feature | IBM DB2 Advanced Recovery Feature | |
Label-based access control (LBAC) | No | Yes | Yes | Yes | Yes | Yes | Yes |
Materialized query tables (MQTs) | No | No | No | Yes | Yes | Yes | Yes |
Multidimensional clustering (MDC) tables | No | No | No | Yes | Yes | Yes | Yes |
Multi-Temperature Storage | No | No | No | Yes | Yes | Yes | Yes |
Net Search Extender | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Online reorganization | No | Yes | Yes | Yes | Yes | Yes | Yes |
Oracle Compatibility | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Partitioning - partitioned database environment | No | No | No | No | Yes | Yes | Yes |
Partitioning - Table partitioning | No | No | Yes | Yes | Yes | Yes | Yes |
pureXML® storage | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
Q Replication with two other DB2 LUW servers | No | No | No | No | Yes | Yes | Yes |
Query parallelism | No | No | IBM DB2 BLU Acceleration In-Memory Offering6 | Yes | Yes | Yes | Yes |
Replication tools | Yes3 | Yes3 | Yes3 | Yes3 | Yes | Yes3 | Yes |
Row and column access control (RCAC) | No | Yes | Yes | Yes | Yes | Yes | Yes |
Spatial Extender | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
SQL Replication between DB2 LUW and Informix Data Server | No | Yes | Yes | Yes | Yes | Yes | Yes |
Time Travel Query | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
IBM Tivoli System Automation for Multiplatforms | No | Yes | Yes | Yes | Yes | Yes | Yes |
Workload management | No | IBM DB2 Performance Management Offering6 | IBM DB2 BLU Acceleration In-Memory Offering6 or IBM DB2 Performance Management Offering6 |
IBM DB2 BLU Acceleration In-Memory Offering6 or IBM DB2 Performance Management Offering6 |
Yes | Yes | Yes |