Several types of IBM® clients
and drivers are available for the data server. Each client and driver
provides a particular type of support.
The IBM clients and drivers
are as follows:
- IBM Data
Server Driver Package(DS driver)
- IBM Data
Server Driver Package -
Without Encryption
- IBM Data Server
Driver for JDBC and SQLJ
- IBM Data Server Driver for ODBC
and CLI
- IBM Data Server Driver for ODBC
and CLI
- Without Encryption
- IBM Data Server Runtime Client
- IBM Data
Server Client
You
can add DB2 Connect™ capability
to any client or driver.
IBM Data
Server Driver Package
The IBM Data
Server Driver Package is a lightweight
deployment solution that provides runtime support for applications
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 that are typical of large
enterprises.
The
IBM Data
Server Driver Package includes the following capabilities:
- The 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, 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, which you can use 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 the IBM Data
Server Driver Package; however, you can download and build these drivers
by using the header files.
- Support for the interactive CLI, by using the db2cli command.
Support for DRDA® traces, by
using the db2drdat command.
- Support for IBM Informix® servers.
The IBM Data
Server Driver Package -
Without Encryption includes the same capabilities as the IBM Data
Server Driver Package,
except that encryption functionality is not included.
IBM Data Server
Driver for JDBC and SQLJ
The 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 Java client applications and applets that use JDBC to access local
or remote servers and that use SQLJ for embedded static SQL in Java applications. This
driver is a prerequisite for IBM InfoSphere® Optim™ pureQuery® Runtime.
This product provides static support for Java client applications
and applets and enables optimized data access by using the pureQuery
API. In addition, this product is supported by a full integrated development
environment (IDE) for Java database
application development using IBM Data Studio.
IBM Data Server Driver for ODBC
and CLI
The Data Server Driver
for ODBC and CLI is
a lightweight solution that is designed for ISV deployments. This
driver, also referred to as the CLI
driver,
provides runtime support for applications using the ODBC API or CLI
API, without the need to install 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 in English only.
The Data Server Driver
for ODBC and CLI -
Without Encryption includes the same capabilities as the Data Server Driver
for ODBC and CLI,
except that encryption functionality is not included.
IBM Data Server Runtime Client
To
have command line processor (CLP) support and basic client support
for running and deploying applications, use the 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 of the IBM Data Server Driver Package, excluding
development tools and libraries.
- The command line processor for issuing commands. The CLP also
provides a basic way to remotely administer servers.
- The ASNCLP command-line program, for
setting up and administering all replication programs for Q replication
and SQL replication.
- Support for common network communication protocols: TCP/IP and
named pipes.
- A smaller deployment footprint that requires less installation
image size and less required disk space than that of the IBM Data
Server Client.
- A catalog that stores information for connecting to databases
and servers.
IBM Data
Server Client
For
applications using DB2CI, use IBM Data Server Client. The IBM Data
Server Client includes
all the functionality of the IBM Data Server Runtime Client,
plus functionality for database administration, application development
using an API such as ODBC, CLI, .NET, or JDBC., 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.