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.

Table 1. Functionality in Db2 database product editions and Db2 offerings
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:
  1. This functionality is available only by using the SQL Warehouse tool (SQW).
  2. Db2 Advanced Enterprise Server Edition includes 10 InfoSphere Data Architect user licenses.
  3. 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.
  4. 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.
  5. 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).
  6. 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.
  7. 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.
  8. Federation with Db2 for IBM i and Db2 for z data sources is possible with sufficient entitlement to Db2 Connect.
  9. Db2 Connect functionality is possible with sufficient entitlement to Db2 Connect.