Chapter 1. Introduction to DB2 deployment 7
1.2.3 DB2 standalone and connect products
DB2 also provides various flexibility and options in its product offering. The DB2
connect products provide connectivity to host databases, while the DB2 personal
edition provides standalone database for local use.
DB2 Personal Edition
This is a restricted desktop product with a full functional database, without Query
Patroller, TSA, Geodetic Performance Expert, and Heterogeneous Federation. It
does not accept any remote incoming requests and therefore local database(s)
can only be accessed by local clients. It has all the functionality of the DB2 Client
for accessing databases on DB2 Servers. This product is available for Linux and
Windows.
DB2 Connect Personal Edition
This is a restricted desktop product that allows a personal computer to which it is
installed to access a host database (databases residing on System z®, System I,
and VM/VSE). As with DB2 Personal Edition, it can only be accessed by local
clients and does not accept any remote incoming requests. Therefore, it cannot
serve as a gateway to handle host connections. This product is available for
Linux, Windows, and Solaris (x64 as of fp1).
DB2 Connect Enterprise Edition
Designed for multi-tier applications, where it can be used as a gateway to
facilitate connectivity to host databases (databases residing on System z,
System i®, and VM/VSE). It concentrates and manages connections from
multiple remote clients. This product is available on AIX, HP-UX, Solaris, Linux,
and Windows.
DB2 Connect Application Server Edition
This edition provides Web and Application Server based connectivity for multi-tier
applications. This is similar to DB2 Connect™ Enterprise Edition but with a
different license scheme.
DB2 Connect Unlimited Edition for System z
This product provides access to DB2 on z/OS data servers. It contains both DB2
Connect Personal edition and DB2 Connect Enterprise Edition.
DB2 Connect Unlimited Edition for System i
This product provides access to DB2 on System i databases.