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 data server client
product includes the following products:
- IBM Data
Server Driver Package(DS driver)
- 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
You
can add DB2 Connect™ capability
to any IBM data server client product.
IBM Data
Server Driver Package
The
IBM Data
Server Driver Package includes 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, 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 DB2 interactive
CLI, by using the db2cli command. Support for DRDA® traces, by using the db2drdat command.
- Support for IBM Informix® servers.
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 IBM Data Server Driver for ODBC
and CLI product
is a lightweight deployment solution that is designed for independent
software vendors (ISVs) to embed inside their products. It is not
intended for an end user to download. The IBM Data Server Driver for ODBC
and CLI product
provides runtime support for applications using the ODBC API or CLI API,
without the need to install the IBM Data
Server Client, IBM Data Server Runtime Client,
or the IBM data server products. The IBM Data Server Driver for ODBC
and CLI product
is available only as a compressed file, not as an installable image.
Messages are in English only.
Restriction: The IBM Data Server Driver for ODBC
and CLI product
does not support a custom DB2 copy name.
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 DB2 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.