There are several types of IBM® data
server clients and drivers available. Each provides a particular type
of support.
The IBM data server client
and driver types are as follows:
- IBM Data
Server Driver Package
- IBM Data Server
Driver for JDBC and SQLJ
- IBM Data
Server Driver for ODBC and CLI
- IBM Data Server Runtime Client
- IBM Data
Server Client
The DB2 Connect™ Personal Edition product
includes all the functionality of IBM Data
Server Client and connects to midrange and mainframe
databases. DB2 Connect capability
can be added to any client or driver and the recommended approach
is to use the DS driver.
Each IBM data server client
and driver provides a particular type of support:
- For Java™ applications only,
use IBM Data Server
Driver for JDBC and SQLJ.
- For applications using ODBC or CLI only, use IBM Data
Server Driver for ODBC and CLI.
(Also referred to as cli driver.)
- For applications using ODBC, CLI, .NET, OLE DB,
PHP, Ruby, JDBC, or SQLJ, use IBM Data
Server Driver Package.
- For applications using DB2CI, use IBM Data
Server Client.
- If you need DB2® Command
Line Processor Plus (CLPPlus) support, use IBM Data
Server Driver Package.
- To have command line processor (CLP) support and basic client
support for running and deploying applications, use IBM Data Server Runtime Client.
Alternatively use CLPPlus,which is a component of the recommended
IBM Data Server Driver Package.
- To have support for database administration, and application development
using an application programming interface (API), such as ODBC, CLI,
.NET, or JDBC, use IBM Data
Server Client.
IBM Data
Server Driver Package
IBM Data
Server Driver Package is a lightweight deployment
solution that provides runtime support for applications using ODBC,
CLI, .NET, OLE DB, PHP, Ruby, JDBC, or SQLJ, without the need to install
the Data Server Runtime Client or Data Server
Client.
This driver has a small footprint and is designed to be redistributed
by independent software vendors (ISVs), and to be used for application
distribution in mass deployment scenarios typical of large enterprises.
The
IBM Data
Server Driver Packageinclude the following capabilities:
- DB2 Command Line Processor
Plus (CLPPlus), for dynamically creating, editing, and running SQL
statements and scripts.
- Support for applications that use ODBC, CLI, PHP, or Ruby to access
databases.
- On Windows operating
systems, IBM Data
Server Driver Package also provides support for
applications that use .NET or OLE DB to access databases. In addition,
this driver package is available as an installable image. Merge modules
are available to allow you to easily embed the driver in a Windows Installer-based installation.
- Support for client applications and applets that are written in
the Java language using JDBC
and for embedded SQL for Java (SQLJ).
- Support for running embedded SQL applications. No precompiler
or bind capabilities are provided.
- Application header files to rebuild the PHP, Ruby, Python, and
Perl drivers. The Python and Perl drivers are not available in IBM Data
Server Driver Package; however, you can download and build these drivers
by using the header files.
- Support for DB2 Interactive
CLI through the db2cli command.
- Support for DRDA® traces
through the db2drdat command.
- This client package also supports IBM Informix® servers.
IBM Data Server
Driver for JDBC and SQLJ
IBM Data Server
Driver for JDBC and SQLJ is
the default driver for Java stored
procedures and user-defined functions. This driver provides support
for client applications and applets that are written in Java using JDBC to access local or remote servers,
and SQLJ for embedded static SQL in Java applications. This
driver is a prerequisite for IBM InfoSphere® Optim™ pureQuery
Runtime,
which provides static support for Java,
enables optimized data access using the pureQuery API, and is supported
by a full integrated development environment (IDE) for Java database application development using IBM InfoSphere Optim Development
Studio.
(Both Optim products are available
separately.)
IBM Data
Server Driver for ODBC and CLI
Data
Server Driver for ODBC and CLI is
a lightweight deployment solution designed for independent software
vendors (ISV) deployments. This driver, also referred to as cli driver,
provides runtime support for applications using ODBC API, or CLI API
without need of installing the Data Server
Client or
the Data Server Runtime Client.
This driver is available only as a tar file, not as an installable
image. Messages are reported only in English.
IBM Data Server Runtime Client
The IBM Data Server Runtime Client provides a way to run applications on
remote databases. GUI tools are not shipped with the IBM Data Server Runtime Client.
Capabilities
include the following ones:
- All the functionality from IBM Data Server Driver, excluding
development tools and libraries.
- The DB2 command line processor
(CLP) for issuing commands. The CLP also provides a basic way to remotely
administer servers.
- The ASNCLP command-line program to set up and administer
all replication programs for Q replication and SQL replication.
- Support for common network communication protocols: TCP/IP, and
Named Pipe.
- Smaller deployment footprint compared to that of the full IBM Data
Server Client in
terms of installation image size and disk space required.
- A catalog that stores information for connecting to databases
and servers.
IBM Data
Server Client
IBM Data
Server Client includes
all the functionality of IBM Data Server Runtime Client,
plus functionality for database administration, application development,
and client/server configuration.
Capabilities include the following
ones:
- The ability to prune the IBM Data
Server Client image
to reduce the installation image size on the Windows operating system.
- Replication tools to set up and administer all
replication programs for Q replication and SQL replication. These
tools are the Replication Center, the ASNCLP command-line program,
and the Replication Alert Monitor tool. The Replication Center is
available only on Linux and Windows operating systems.
- First Steps documentation for new users.
- Visual Studio tools.
- Application header files.
- Precompilers for various programming languages.
- Bind support.
- Samples and tutorials.
DB2 Version 9.7 for Linux, UNIX, and Windows