IBM DB2 IBM Data Server Driver for ODBC, CLI, and .NET, IBM Data Server Driver for Jdbc and Sqlj

administration and client/server configuration. Note that GUI tools are available for Windows on x86 32 bit, Windows on x64 (EM64T/AMD64), Linux on x86/ EM64T/AMD64. It also contains tools to assist with application development and contains bind files. The application development tools include application header files, pre-compilers, bind utilities, and sample codes. It was previously known as DB2 Administration Client or DB2 Client.

IBM Data Server Driver for ODBC, CLI, and .NET

New to DB2 9.5, IBM Data Server Driver for ODBC, CLI and .NET is a lightweight deployment solution for Windows applications. It provides runtime support for applications using DB2 CLI API, ODBC API, or .NET API without having to install Data Server Client or the Data Server Runtime Client.

IBM Data Server Driver for ODBC, CLI and .NET supports application that uses CLI, ODBC, .NET, PHP, or Ruby to access DB2 databases.

The client is available as an installable image on Windows operating systems and merge modules are available for embedding client in Windows installer based installation.

On Linux and UNIX operating systems, a separate deliverable called IBM Data Server Driver for ODBC and CLI provides a similar lightweight deployment solution without the .NET support in tar file format.

IBM Data Server Driver for JDBC and SQLJ

IBM Data Server Driver for JDBC and SQLJ is a driver which includes both JDBC Type 2 and JDBC Type 4 behaviors. It consists of single driver which is available in two versions. The IBM Data Server Driver for JDBC and SQLJ Version 3.5 is JDBC 3.0 compliant and Version 4.0 supports JDBC 3.0 and some JDBC 4.0 functions. Both versions of the driver include SQLJ application programming interfaces.

IBM Data Server Driver for JDBC and SQLJ supports Java 2 Platform, Enterprise Edition (J2EE) Java Transaction Service (JTS), and Java Transaction API (JTA) specifications. Using the Type 2 connectivity, Java user-defined functions and stored procedures can establish connection to a database.

Note that IBM Data Server Driver for JDBC and SQLJ has following requirements:

￿SDK for Java 1.4.2 or later has to be installed. For JDBC 4.0 functions, SDK for Java 6 or later is required.

￿All JVMs that run Java application which accesses DB2 database must include native threads support.

Chapter 1. Introduction to DB2 deployment 5