3 db2 product considerations, Chapter 1. introduction to db2 deployment – IBM Data Server DB2 User Manual
Page 31
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
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
MQT
No
No
Yes with Query
Optimization Feature
option
Yes
MDC
No
No
Yes with Query
Optimization Feature
option
Yes
Query Parallelism
No
No
Yes with Query
Optimization Feature
option
Yes