DB2 10.5 for Linux, UNIX, and Windows

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 details of entitlement, rights and obligations, refer to the license agreement for your DB2 product and offering.

Table 1. Functionality in DB2 database product editions and DB2 offerings
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 tables⁵	No	No	IBM® DB2 BLU Acceleration In-Memory Offering⁶	IBM DB2 BLU Acceleration In-Memory Offering⁶	Yes	Yes	Yes
DB2 Connect™ functionality	No	No	No	No	Yes¹	Yes¹	Yes
DB2 Governor	No	No	No	Yes	Yes	Yes	Yes
DB2 pureScale® functionality	No	No	IBM DB2 Business Application Continuity Offering⁶	IBM DB2 Business Application Continuity Offering⁶	Yes	Yes	Yes
Encryption - native backup encryption	Yes	IBM DB2 Encryption Offering⁶	IBM DB2 Encryption Offering⁶	IBM DB2 Encryption Offering⁶	Yes	Yes	Yes
Encryption - native database encryption	Yes	IBM DB2 Encryption Offering⁶	IBM DB2 Encryption Offering⁶	IBM DB2 Encryption Offering⁶	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	Yes¹	Yes¹	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 LUW⁴	No	No	IBM DB2 BLU Acceleration In-Memory Offering⁶	IBM DB2 BLU Acceleration In-Memory Offering⁶	Yes	Yes	Yes
IBM InfoSphere CDC Access Server⁴	No	No	IBM DB2 BLU Acceleration In-Memory Offering⁶	IBM DB2 BLU Acceleration In-Memory Offering⁶	Yes	Yes	Yes
IBM InfoSphere CDC Management Console⁴	No	No	IBM DB2 BLU Acceleration In-Memory Offering⁶	IBM DB2 BLU Acceleration In-Memory Offering⁶	Yes	Yes	Yes
IBM InfoSphere Data Architect	No	No	No	No	Yes²	Yes²	Yes²
IBM InfoSphere Optim™ Configuration Manager	No	No	No	No	Yes	Yes	Yes
IBM InfoSphere Optim Performance Manager Extended Edition	No	IBM DB2 Performance Management Offering⁶	IBM DB2 Performance Management Offering⁶	IBM DB2 Performance Management Offering⁶	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 Offering⁶	IBM DB2 Performance Management Offering⁶	IBM DB2 Performance Management Offering⁶	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 Offering⁶	Yes	Yes	Yes	Yes
Replication tools	Yes³	Yes³	Yes³	Yes³	Yes	Yes³	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 Offering⁶	IBM DB2 BLU Acceleration In-Memory Offering⁶ or IBM DB2 Performance Management Offering⁶	IBM DB2 BLU Acceleration In-Memory Offering⁶ or IBM DB2 Performance Management Offering⁶	Yes	Yes	Yes

Note:

This functionality is availably 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 for LUW source and no more than two DB2 for LUW servers of the same version for the purpose of HADR
- For supporting shadow table functionality within a single DB2 for LUW 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 details 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.