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. Table1-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 Yes Yes Yes
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 Yes Yes
Tivoli System
Automation Yes with DB2 Express-C
FTL Yes with High Availability
Feature option Yes Yes
Online REORG No Yes with High Availability
Feature option Yes Yes
Advanced Copy
Services No Yes with High Availability
Feature option Yes Yes
MQTNoNoYes with Query
Optimization Feature
option
Yes
MDCNoNoYes with Query
Optimization Feature
option
Yes
Query Parallelism No No Yes with Query
Optimization Feature
option
Yes