invispix 10x10

IBM DB2 V11.1 Editions - available functions Comparison

The following table summarizes the functions available in each edition of DB2 11.1 for Linux, UNIX, and Windows:
DB2 Advanced Enterprise Server Edition
DB2 Direct Advanced Edition
DB2 Enterprise Server Edition  
DB2 Advanced Workgroup Server 
DB2 Workgroup Server 
DB2 Direct Standard 
DB2 Developer Edition
BLU Acceleration  Yes  -  Yes  -  Yes
pureScale  Yes  Yes (1)  Yes  Yes (1)  Yes
Data Partitioning  Yes  -  Yes  -  Yes
pureXML Storage  Yes  Yes  Yes  Yes  Yes
Time Travel Query  Yes  Yes  Yes  Yes  Yes
Compression(row, adaptive, index)  Yes  -  Yes  -  Yes
Compression (backup)  Yes  Yes  Yes  Yes  Yes
Row and Column Access Control  Yes  Yes  Yes  Yes  Yes
Label Based Access Control  Yes  Yes  Yes  Yes  Yes
SQL Replication (2)  Yes  Yes  Yes  Yes  Yes
Federation capabilities (4)  Yes (5)  Yes (3)  Yes (5)  Yes (3)  Yes (5)
WebSphere(R) MQ  Yes  Yes  Yes  Yes  Yes
High Availability Disaster Recovery  Yes  Yes  Yes  Yes  Yes
Tivoli System Automation  Yes  Yes  Yes  Yes  Yes
Online Reorg  Yes  Yes  Yes  Yes  Yes
Advanced Copy Services  Yes  Yes  Yes  Yes  Yes
Multitemperature Storage  Yes  Yes  Yes  Yes  Yes
Materialized Query Tables  Yes  Yes  Yes  -  Yes
Multi-Dimensional Clustering  Yes  Yes  Yes  Yes  Yes
Query Parallelism  Yes  Yes  Yes  Yes  Yes
Connection Concentrator  Yes  Yes  Yes  Yes  Yes
Table Partitioning  Yes  Yes  Yes  Yes  Yes
Plan Lockdown  Yes  Yes  Yes  Yes  Yes
Scan Sharing  Yes  Yes  Yes  Yes  Yes
Workload Management  Yes  Yes (6)  Yes  Yes (6)  Yes
MQ Replication (7)  Yes  -  Yes  -  Yes
CDC Replication (7, 8)  Yes  -  Yes  -  Yes
Continuous Data Ingest  Yes  Yes  Yes  Yes  Yes
DB2 Connect  Yes (9)  -  Yes (9)  -  Yes
( 1 ) Only to allow for an idle standby member within a pureScale cluster.
( 2 ) To DB2 for Linux, UNIX, and Windows data source only. Requires DB2 Connect or InfoSphere Replication when replicating with DB2 for z or DB2 for i.
( 3 ) Federation includes only DB2 and Informix(R) data sources.
( 4 ) Requires DB2 Connect when federating with DB2 for z and/or DB2 for i.
( 5 ) Federation includes all supported IBM and non-IBM data sources.
( 6 ) Available with the Performance Management Offering.
( 7 ) Restricted to a source DB2 for Linux, UNIX, and Windows server and no more than two other DB2 for Linux, UNIX, and Windows servers.
( 8 ) Restricted to unidirectional replication without data transformations between DB2 for Linux, UNIX, and Windows servers of the same version for the purpose of high availability/disaster recovery and for supporting shadow table functionality between a single DB2 for LUW instance to replicate from row-organized tables into column-organized tables.
( 9 ) For the purposes of using SQW tooling to access DB2 for z and DB2 for i.

invispix 10x10
invispix 10x10