IBM 3 DB2 product considerations, DB2 for LUW Server product listing Features and functions

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-6summaries various DB2 for LUW editions.

Table 1-6 DB2 for LUW Server product listing: Features and functions

	Express-C and	DB2 Express edition	DB2 Workgroup Server	DB2 Enterprise Server
	Express-C FTL		Edition	Edition
Platform	Windows, Linux	Windows, Linux	AIX, Windows, Linux	AIX, WIndows, Linux,
Availability	POWER, Linux x64,	POWER, Linux x64 and	POWER, Linux x64,	Solaris and HPUX IA-64
	Solaris x64	Solaris x64	Solaris and HP-UX IA-64
	(with FixPack 1)	(with FixPack 1)
Imposed System	2 cores and 2 GB	200 PVU and 4 GB of	480 PVU and 16 GB of	No limit
Limit	memory for DB2	memory	memory
	Express-C and 4 cores
	and 4 GB memory for
	DB2 Express-C FTL
Licensing Scheme	DB2 Express-FTL is	Licensed with authorized	Licensed with authorized	Licensed with authorized
	licensed per server	user license or per	user license or per	user license or per
		processor based on	processor based on	processor based on
		underlying server’s PVU	underlying server’s PVU	underlying server’s PVU
		rating	rating	rating
Homogenous SQL	Yes with DB2 Express-C	Yes	Yes	Yes
Replication	FTL
Homogenous Q	No	No	No	Yes with Homogeneous
Replication				Replication Feature for
				ESE option
High Availability	Yes with DB2 Express-C	Yes with High Availability	Yes	Yes
Disaster Recovery	FTL	Feature option
Tivoli System	Yes with DB2 Express-C	Yes with High Availability	Yes	Yes
Automation	FTL	Feature option
Online REORG	No	Yes with High Availability	Yes	Yes
		Feature option
Advanced Copy	No	Yes with High Availability	Yes	Yes
Services		Feature option
MQT	No	No	Yes with Query	Yes
			Optimization Feature
			option
MDC	No	No	Yes with Query	Yes
			Optimization Feature
			option
Query Parallelism	No	No	Yes with Query	Yes
			Optimization Feature
			option

Chapter 1. Introduction to DB2 deployment 17