IBM 2 DB2 clients and drivers, DB2 Workgroup Server Edition, DB2 Enterprise Server Edition

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

4DB2 Deployment Guide