IBM Data Server Client and Data Server Driver types
Several types of IBM® clients and drivers are available for the data server. Each client and driver provides a particular type of support.
- 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
ClientNote: To connect to a Db2® for z/OS® or System i server from an IBM Data Server Client running on a Linux, AIX, or Windows system, you need to activate a Db2 Connect license at the client site. This requires you to copy an appropriate Db2 Connect license file to a folder on your IBM Data Server Client or IBM Data Server Runtime Client machine and then activating the license file by running the db2licm -a command. For more information, see Activating the license for Db2 Connect at the IBM Data Server Client site
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 can be redistributed by independent software vendors (ISVs). This driver can also be used for application distribution in mass deployment scenarios that are typical of large enterprises.
- The Command Line Processor Plus (CLPPlus), for dynamically creating, editing, and running SQL statements and scripts.
- Support for applications that use ODBC or CLI to access databases.
- Includes the dsdriver_fixlist.html file under the /license directory. This file lists all of the fixed Known Issues in a release, mod pack or fix pack. This file has only those Known Issues that affect the IBM Data Server Driver Package.
- 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 by 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 function is not included.
IBM Data Server Driver for JDBC and SQLJ
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 that use 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.
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 released with the IBM Data Server Runtime Client.
- All the functions 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 processor 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 disk space that is needed than the IBM Data Server Client.
- A catalog that stores information for connecting to databases and servers.
IBM Data Server Client
For applications that use DB2CI, use IBM Data Server Client. The IBM Data Server Client includes all the functions of the IBM Data Server Runtime Client, plus functions for database administration, application development that uses an API such as ODBC, CLI, .NET, or JDBC, and client/server configuration.
- 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 processor, 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.