Express-C and

DB2 Express edition

DB2 Workgroup Server

DB2 Enterprise Server

 

Express-C FTL

 

Edition

Edition

 

 

 

 

 

Connection

No

No

No

Yes

Concentrator

 

 

 

 

 

 

 

 

 

Table Partitioning

No

No

No

Yes

 

 

 

 

 

Governor

No

No

No

Yes

 

 

 

 

 

Homogenous

No

Yes with Homogeneous

Yes with Homogeneous

Yes with Homogeneous

Federation

 

Federation Feature

Federation Feature

Federation Feature

 

 

option

option

option

 

 

 

 

 

Compression: Row

No

No

No

Yes with Storage

Level or Backup

 

 

 

Optimization Feature

 

 

 

 

option

 

 

 

 

 

Query Patroller

No

No

No

Yes with Performance

 

 

 

 

Optimization Feature

 

 

 

 

option

 

 

 

 

 

Workload

No

No

No

Yes with Performance

Management

 

 

 

Optimization Feature

 

 

 

 

option

 

 

 

 

 

Performance

No

No

No

Yes with Performance

Expert

 

 

 

Optimization Feature

 

 

 

 

option

 

 

 

 

 

pureXML Storage

Yes

Yes with pureXML

Yes with pureXML

Yes with pureXML

 

 

Feature for Express

Feature for WSE option

Feature for ESE option

 

 

option

 

 

 

 

 

 

 

Note: Database Partitioning Feature (DPF) is now only available through InfoSphere Warehouse Version 9.5. Existing DPF licenses will be upgraded automatically to the IBM Base Warehouse Feature for DB2 Version 9.5. Customers can also acquire the IBM Enterprise Warehouse Feature for DB2 Version 9.5 to obtain DPF.

18DB2 Deployment Guide

Page 32
Image 32
IBM manual 18 DB2 Deployment Guide