beautypg.com

IBM Data Server DB2 User Manual

Page 19

background image

Chapter 1. Introduction to DB2 deployment

5

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.