DB2 OLAP Server Installation Guide

Supported ODBC drivers and relational data sources

In most cases, DB2 OLAP Server and DB2 OLAP Integration Server require the minimal levels of ODBC drivers. If you install both products, check the following tables to make sure that you use an ODBC driver that meets the minimum requirements of both products.

For DB2 OLAP Server

MERANT (formerly INTERSOLV) ODBC driver version 4.0 is provided with DB2 OLAP Server Version 8.1 SQL Interface. Additionally, DB2 OLAP Server also supports some non-MERANT Windows NT drivers, which are listed in Table 9. These non-MERANT drivers are not provided with SQL Interface.

Table 9. Supported ODBC drivers for DB2 OLAP Server

Relational Database Server (Relational Data Source) ODBC drivers per supported operating system
Windows NT 4.0, Windows 2000, Windows XP Solaris 7, 8 (Sun OS 5.7, or 5.8) AIX 4.3.3, AIX 5L HP-UX 11.01, HP-UX 11i
DB2 UDB 6.1 (DB2 UDB 6.1) DB2 6.1 ODBC DB2 6.1 ODBC DB2 6.1 ODBC DB2 6.1 ODBC
DB2 UDB 7.1 (DB2 UDB 7.1) DB2 7.1 ODBC DB2 7.1 ODBC DB2 7.1 ODBC DB2 7.1 ODBC
DBASE V Microsoft Driver MERANT 4.0 Not supported MERANT 4.0
Informix 9.x (using Informix client) MERANT 4.0 MERANT 4.0

(ESQL 9.2)

MERANT 3.6

(ESQL 9.2)

Not supported
Oracle 8i (SQL Net 8) MERANT 4.0 MERANT 4.0 MERANT 3.62 MERANT 4.0
Oracle 9i (Oracle Net) MERANT 4.0 MERANT 4.0 MERANT 3.62 MERANT 4.0
MS SQL Server 7.0 MS SQL Server 7.0 ODBC Not supported Not supported Not supported
MS SQL Server 2000 MS SQL Server 2000 ODBC Not supported Not supported Not supported
Sybase 11.x (Adaptive Server) MERANT 4.0 MERANT 4.0 MERANT 3.62 Not supported
Sybase 12 MERANT 4.0 MERANT 4.0 MERANT 3.62 Not supported
Access 2000 Microsoft Driver Not supported Not supported Not supported
Access 2002 Microsoft Driver Not supported Not supported Not supported

Notes:

  1. MERANT 4.0 ODBC drivers are supported on HP-UX 11.0 computers when using 32-bit relational database client software only.

  2. For more information about using ODBC 3.6, see Preserving an existing ODBC Driver.

For DB2 OLAP Integration Server

DB2 OLAP Integration Server supports the ODBC drivers for the relational database management systems (RDBMS) and operating systems shown in Table 10.

Table 10. Supported ODBC drivers for DB2 OLAP Integration Server

Relational Database Server (Relational Data Source) ODBC drivers per supported operating system
Windows NT 4.0, Windows 2000, Windows XP Solaris Operating System 7, 8 (Sun OS 5.7, 5.8) AIX 4.3.3, AIX 5L HP-UX 11.0, HP-UX 11i1
DB2 UDB 6.1 (DB2 UDB 6.1) DB2 6.1 ODBC2 DB2 6.1 ODBC DB2 6.1 ODBC DB2 6.1 ODBC
DB2 UDB 7.1 (DB2 UDB 7.1) DB2 7.1 ODBC2 DB2 7.1 ODBC DB2 7.1 ODBC DB2 7.1 ODBC
DBASE V Not supported Not supported Not supported Not supported
Informix 9.2 (Connect 2.4) MERANT 4.02 MERANT 4.0 Not supported MERANT 4.0
Oracle 8i2 (Net8) MERANT 4.02

Oracle ODBC2

OCI direct connection2

MERANT 4.0

OCI direct connection

MERANT 4.0

OCI direct connection

MERANT 4.0

OCI direct connection

Oracle 9i2 (Oracle Net) MERANT 4.0

Oracle ODBC

OCI direct connection

MERANT 4.0

OCI direct connection

Not supported Not supported
Oracle 9i2 (Net8) MERANT 4.02

Oracle ODBC2

OCI direct connection2

MERANT 4.0

OCI direct connection

MERANT 4.0

OCI direct connection

MERANT 4.0

OCI direct connection

MS SQL Server 7.0 (no client required) MS SQL Server 3.7 ODBC (included in MDAC 2.5) Not supported Not supported Not supported
MS SQL Server 2000 (no client required) MS SQL Server 3.7 ODBC (included in MDAC 2.5)

MS SQL Server 2000.80

Not supported Not supported Not supported
Sybase 11.x (Adaptive Server) Not supported Not supported Not supported Not supported
Sybase 12 (On UNIX, Open Client 11.1; On Windows, no client required) MERANT 4.0 Wire Protocol MERANT 4.0 Wire Protocol Not supported Not supported
Access 2000 Not supported Not supported Not supported Not supported
Access 2002 Not supported Not supported Not supported Not supported

Notes:

  1. MERANT 4.0 ODBC drivers are supported on HP-UX 11.0 computers when using 32-bit relational database client software only.

  2. This RDBMS is not supported on Windows XP.

DB2 OLAP Integration Server provides MERANT 4.0 ODBC drivers for AIX, HP-UX, Solaris Operating System, Windows NT, Windows 2000, and Windows XP.

ODBC drivers used with DB2 OLAP Integration Server must be thread-safe. All drivers listed in Table 10 are thread-safe. HP-UX requires kernel-threads. Solaris Operating System requires Solaris threads, and AIX requires kernel-threads with pthread API.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]