Functionality in Db2 product editions and Db2 offerings
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.
Note: This table is for informational purposes only. For information about entitlement, rights, and
obligations, refer to the license agreement for your Db2 product and offering.
Express-C is currently unavailable. For similar functionality, please use Developer-C instead.
| Functionality | Db2 Workgroup Server Edition | Db2 Enterprise Server Edition | Db2 Advanced Workgroup Server Edition | Db2 Advanced Enterprise Server Edition | Direct Advanced Edition | Direct Standard Edition | Developer Edition |
|---|---|---|---|---|---|---|---|
| Access Plan Reuse | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Adaptive Compression and classic row compression | No | No | Yes | Yes | Yes | No | Yes |
| Compression - backup | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Connection concentrator | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Continuous Data Ingest | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Db2 Data Management Console | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Data Server Manager Base | Yes | Yes | No | No | No | Yes | No |
| Data Server Manager
Enterprise Attention: Support
for IBM® Data Server Manager
(DSM) is ending on April 30th 2021. Users are asked to migrate from DSM to the IBM Data Management Console (DMC).
|
IBM Db2 Performance Management Offering | IBM Db2 Performance Management Offering | Yes | Yes | Yes | IBM Db2 Performance Management offering | Yes |
| Db2 Advanced Copy Services | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Db2 column-organized tables 5 | No | No | Yes | Yes | Yes | No | Yes |
| Db2 Connect functionality | No | No | Yes1 | Yes1 | Yes9 | No | Yes |
| Db2 pureScale® functionality | Yes7 | Yes7 | Yes | Yes | Yes | Yes7 | Yes |
| Encryption - native backup encryption | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Encryption - native database encryption | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Federation with IBM data servers | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Federation with Db2 for IBM i and Db2 for z/OS® | Yes8 | Yes8 | Yes8 | Yes8 | Yes8 | Yes8 | Yes |
| Federation with all other data sources, including Oracle | No | No | Yes | Yes | Yes | No | Yes |
| High availability disaster recovery | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| IBM Data Studio | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| IBM(r) Db2 Merge Backup | IBM Db2 Advanced Recovery Feature | IBM Db2 Advanced Recovery Feature | IBM Db2 Advanced Recovery Feature | IBM Db2 Advanced Recovery Feature | No | No | IBM Db2 Advanced Recovery Feature |
| IBM(r) Db2 Recovery Expert | IBM Db2 Advanced Recovery Feature | IBM Db2 Advanced Recovery Feature | IBM Db2 Advanced Recovery Feature | IBM Db2 Advanced Recovery Feature | No | No | IBM Db2 Advanced Recovery Feature |
| IBM InfoSphere® Change Data Capture for Db24 | No | No | Yes | Yes | Yes | No | Yes |
| IBM InfoSphere CDC Access Server4 | No | No | Yes | Yes | Yes | No | Yes |
| IBM InfoSphere CDC Management Console4 | No | No | Yes | Yes | Yes | No | Yes |
| IBM InfoSphere Data Architect | No | No | Yes2 | Yes2 | Yes2 | No | Yes2 |
| 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 | No | No | IBM Db2 Advanced Recovery Feature |
| Index Compression | No | No | Yes | Yes | Yes | No | Yes |
| Label-based access control (LBAC) | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Materialized query tables (MQTs) | No | Yes | Yes | Yes | Yes | No | Yes |
| Multidimensional clustering (MDC) tables | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Multi-Temperature Storage | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Net Search Extender | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Online reorganization | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Oracle Compatibility | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Partitioning - partitioned database environment | No | No | Yes | Yes | Yes | No | Yes |
| Partitioning - Table partitioning | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| pureXML® storage | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Q Replication with two other Db2 servers | No | No | Yes | Yes | Yes | No | Yes |
| Query parallelism | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Replication tools | Yes3 | Yes3 | Yes | Yes3 | Yes3 | Yes3 | Yes |
| Row and column access control (RCAC) | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Scan Sharing | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Spatial Extender | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL Replication with Db2 databases | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Time Travel Query | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| IBM Tivoli® System Automation for Multiplatforms | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Workload management |
IBM Db2 Performance Management Offering6 |
IBM Db2 Performance Management Offering6 |
Yes | Yes | Yes |
IBM Db2 Performance Management Offering6 |
Yes |
Note:
- This functionality is available only by using the SQL Warehouse tool (SQW).
- Db2 Advanced Enterprise Server Edition includes 10 InfoSphere Data Architect user licenses.
- 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.
- IBM
InfoSphere Change Data Capture software
components are included for support of:
- Unidirectional replication without data transformations between a single Db2 source and no more than two Db2 servers of the same version for HADR
- For supporting shadow table functionality within a single Db2 instance to replicate from row-organized tables into column-organized tables.
- Includes
support for:
- Column-organized tables,
- Shadow tables (a column-organized copy of a row-organized table), and
- InfoSphere Change Data Capture (for replication of the shadow table).
- In Db2 version 10.5 Fix Pack 5 and later fix packs, this functionality is available with the Db2 offering listed. In addition to applying the base license certificate file for the Db2 database product edition, also apply the license certificate file for the offering. For more information about the functionality available with each Db2 offering, see Db2 database product editions and Db2 offerings. For the license file names, see Db2 license files.
- The support for the Db2 Workgroup Server Edition and the Db2 Enterprise Server Edition on pureScale is only for one primary server and one standby server. The standby server can be used only for administrative tasks, or be ready to take over from the primary server during an outage.
- Federation with Db2 for IBM i and Db2 for z data sources is possible with sufficient entitlement to Db2 Connect.
- Db2 Connect functionality is possible with sufficient entitlement to Db2 Connect.