IBM data server client and driver types
The data server has different types of IBM clients and drivers.A particular type of support is provided by each client and driver
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
This 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 and it also has a small foot print. This 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.
The IBM Data Server Driver Package includes the following capabilities:
- It is available as an installable image. On Windows operating systems, support for applications that use .NET or OLE DB to access databases. Merge modules can be used to embed the driver in a Windows Installer-based installation.
- Applications that use ODBC, CLI, PHP, or Ruby to access databases are supported.
- Support for IBM Informix servers.
- Application header files are used to rebuild the PHP, Ruby, Python, and Perl drivers. The Python and Perl drivers are not available in the IBM Data Server Driver Package. You can download and build these drivers by using the header files.
- Precompiler or bind capabilities are not provided.
- Support for running embedded SQL applications.
- For dynamically creating, editing, and running SQL statements and scripts, DB2 Command Line Processor Plus (CLPPlus).
- Support for DRDA traces, by using the db2drdat command. Support for DB2 interactive CLI, by using the db2cli command.
- Support for DB2 interactive CLI, by using the db2cli command. Support for DRDA® traces, by using the db2drdat command.
- Java language using JDBC and for embedded SQL for Java (SQLJ) is used to write client applications and applets.
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
for Java stored procedures and user-defined functions, IBM Data Server Driver for JDBC and SQLJ is the default driver. This driver is a prerequisite for IBM InfoSphere Optim pureQuery Runtime. 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 product is also supported by a full integrated development environment (IDE) for Java database application development using IBM Data Studio. This product provides static support for Java client applications and applets and enables optimized data access by using the pureQuery API.
IBM Data Server Driver for ODBC and CLI
This is a 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 file is not available as an installable image but is available only as a tar file
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.