2 db2 clients and drivers – IBM Data Server DB2 User Manual
Page 18
4
DB2 Deployment Guide
DB2 Workgroup Server Edition
Designed for midsize businesses,
it has all of the functionality of DB2 Express
plus an optional Query Optimization Feature. It has more extensive licensing and
a resource usage limit of 480 Processor Value Unit (PVU) and memory limit of
16 GB. This product is available on AIX, Windows, Linux, HP-UX, and Solaris.
DB2 Enterprise Server Edition
Scalable to handle large volume transaction processing, it is designed for large
businesses. All features available to DB2 can be had in the DB2 Enterprise
Server Edition with exception of the Data Partitioning Feature (DPF) with
unlimited Processor Value Unit (PVU) and unlimited memory. This product is
available on AIX, Windows, Linux, HP-UX, and Solaris.
1.2.2 DB2 clients and drivers
DB2 clients and drivers are used to access databases that reside on DB2
servers. A database cannot be created on a DB2 client.
IBM Data Server Runtime Client
Previously known as DB2 Runtime Client, this product provides various means
for applications and user to establish connection against remote DB2 databases.
In order to reduce disk footprint, it is not shipped with any graphical user interface
(GUI) tools or DB2 bind files. It includes DB2 Command Line Processor (CLP) as
wheel as base client support to handle database connections, SQL statements,
XQuery statements, and DB2 commands.
Support for common database interfaces include:
Java Database Connectivity (JDBC™)
DB2 Command Line Interface (CLI)
Open Database Connectivity (ODBC)
ADO.NET
Object Linking and Embedding Database (OLE DB)
DB Data Server Runtime client allows free redistribution. IBM Data Server
Runtime client is also available as Windows Installer merge module on
supported Windows platforms. This allows only part of the client you want,
through specific RTCL DLL files, to be included in a custom application
installation package.
IBM Data Server Client
IBM Data Server Client contains all the functionality of the DB2 Data Server
Runtime Client plus graphical user interface (GUI) tools to perform database