distributed editions of DB2, for i5/OS, Linux, UNIX, and Windows
Here are some snippets from:
http://www.ibm.com/developerworks/db2/library/techarticle/dm-0611zikopou
los/?S_TACT=105AGX11&S_CMP=LP
Which distributed edition of DB2 9.5 is right for you?
Learn the details on what makes each edition of IBM(r) DB2(r) 9.5 for
Linux(r), UNIX(r), and Windows(r) unique. The author lays out the
specifications for each edition, outlines licensing considerations,
historical changes from DB2 9, and describes some interesting things
customers are doing with each edition of DB2. This popular article has
been rewritten for the DB2 9.5 release and is current as of the date of
publication.
At the heart of the Information Management portfolio are the DB2 9.5
data servers which are the focus of this article. Note that this article
describes only the DB2 data servers that run on distributed and
pervasive platforms. For information about the entire DB2 portfolio, see
the Information Management Software Web site or each product's
respective Web site: DB2 for z/OS (r) or DB2 for i5/OS (tm).
DB2 is DB2 is DB2
The first thing that you should understand when choosing an edition of
DB2 to service your workload is that, with the exception of DB2
Everyplace(r) and Apache Derby (whose SQL API is fully compatible with
DB2), each DB2 edition has the same code base across all the distributed
platforms. DB2's support for Linux extends across all of IBM's servers:
System i(r), System z(r), System x(r), and System p(r) -- the DB2 on all
of these platforms is the distributed version too. For example, DB2 for
Linux on System z is the same code base and licensed the same way as DB2
on an Intel or AMD-based workstation. This means that DB2 Connect is not
required to access this data even though the DB2 for System z Linux
server resides on a System z server. (Read that sentence twice - if you
were connecting to a DB2 for z/OS data server on the System z server,
you would require DB2 Connect; the difference here is that DB2 for Linux
on a System z Integrated Facility for Linux (IFL) is a distributed
version of DB2.)
+++++++++++++
http://www-03.ibm.com/systems/i/software/db2/
DB2 for i5/OS is an advanced, 64-bit Relational Database Management
System (RDBMS) that leverages the On-Demand features of IBM's System i5.
A member of IBM's leading edge family of DB2 products, DB2 for i5/OS
supports a broad range of applications and development environments at a
lower cost of ownership due to its unique autonomic computing
(self-managing) features.
DB2 Express Edition... It's simple, secure, and inexpensive
DB2 Express Edition (DB2 Express) is the entry level, fully supported
DB2 data server that is a specially tailored low cost, full feature,
industrial strength, and open industry standards-based relational
database. The target users of this edition of DB2 are typically SMBs
(small and medium businesses) and ISVs. DB2 Express provides a very
attractive entry and competitive price point for businesses that choose
to leverage the benefits of servers running on Linux, Solaris x86, and
Windows based servers (the previous links take you to the most up to
date platform support information).
DB2 Enterprise Server Edition... unmatched scalability, resiliency, and
flexibility
DB2 Enterprise Server Edition (DB2 Enterprise) is IBM's full function
premier Web-enabled client/server data server which is available on all
the supported distributed platforms where DB2 runs, namely: Linux,
Windows, AIX, Solaris, and HP-UX (the previous links take you to the
most up to date platform support information).
DB2 Data Stream Edition
DB2 Data Stream Edition (DB2 Data Stream - also known as DB2 Real Time
Insight): is a joint service, feature, and product offering that
includes DB2 Enterprise, the Data Partitioning Feature, and the
Real-Time Insight Feature. It provides a fast and efficient in-memory
data server with extended services for real time data streams.
For developers only...
For application development, a special offering called Database
Enterprise Developer's Edition (DEDE) is available. This is a reduced
price offering that gives application developers access to most of the
DB2 features and editions, as well as a set of Informix products and DB2
Connect for the purposes of development, evaluation, demonstration, and
testing of application programs. It is licensed on a per developer basis
midrange.com
