Chapter 1. Introduction to DB2 deployment 17
1.3.3 DB2 product considerations
As discussed in 1.2, “DB2 9.5 for UNIX, Linux, and Windows products” on
page 3, DB2 is available is different editions and packages. All DB2 editions and
products share the same code base but are available with different features,
licensing, and different system limits. Table 1-6 summaries various DB2 for LUW
editions.
Table 1-6 DB2 for LUW Server product listing: Features and functions
Express-C and
Express-C FTL
DB2 Express edition DB2 Workgroup Server
Edition
DB2 Enterprise Server
Edition
Platform
Availability
Windows, Linux
POWER, Linux x64,
Solaris x64
(with FixPack 1)
Windows, Linux
POWER, Linux x64 and
Solaris x64
(with FixPack 1)
AIX, Windows, Linux
POWER, Linux x64,
Solaris and HP-UX IA-64
AIX, WIndows, Linux,
Solaris and HPUX IA-64
Imposed System
Limit
2 cores and 2 GB
memory for DB2
Express-C and 4 cores
and 4 GB memory for
DB2 Express-C FTL
200 PVU and 4 GB of
memory
480 PVU and 16 GB of
memory
No limit
Licensing Scheme DB2 Express-FTL is
licensed per server
Licensed with authorized
user license or per
processor based on
underlying server’s PVU
rating
Licensed with authorized
user license or per
processor based on
underlying server’s PVU
rating
Licensed with authorized
user license or per
processor based on
underlying server’s PVU
rating
Homogenous SQL
Replication
Yes with DB2 Express-C
FTL
Ye s Ye s Ye s
Homogenous Q
Replication
No No No Yes with Homogeneous
Replication Feature for
ESE option
High Availability
Disaster Recovery
Yes with DB2 Express-C
FTL
Yes with High Availability
Feature option
Ye s Ye s
Tivoli System
Automation
Yes with DB2 Express-C
FTL
Yes with High Availability
Feature option
Ye s Ye s
Online REORG No Yes with High Availability
Feature option
Ye s Ye s
Advanced Copy
Services
No Yes with High Availability
Feature option
Ye s Ye s
MQTNoNoYes with Query
Optimization Feature
option
Ye s
MDCNoNoYes with Query
Optimization Feature
option
Ye s
Query Parallelism No No Yes with Query
Optimization Feature
option
Ye s
