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.
DataDirect Technologies (formerly MERANT) ODBC driver version 4.2 is provided with the DB2 OLAP Server Version 8.2. DB2 OLAP Server also supports other drivers, which are listed in Table 12.
Relational Database Server (Relational Data Source) | ODBC drivers per supported operating system | ||||
Windows 2000, Windows 2003, Windows XP | Solaris 8, 9 (Sun OS 5.8, or 5.9) | AIX 5.1, 5.2 | HP-UX 11.0, HP-UX 11i | Red Hat Linux AS 2.1 | |
DB2 UDB 7.2 (Wired drivers) | DB2 UDB 7.2 ODBC, DataDirect 4.2 | DB2 UDB 7.2 ODBC, DataDirect 4.2 | DB2 UDB 7.2 ODBC, DataDirect 4.2 | DB2 UDB 7.2 ODBC, DataDirect 4.2 | DB2 UDB 7.2 ODBC, DataDirect 4.2 |
DB2 UDB 8.1 (Wired drivers) | DB2 UDB 8.1 ODBC, DataDirect 4.2 | DB2 UDB 8.1 ODBC, DataDirect 4.2 | DB2 UDB 8.1 ODBC, DataDirect 4.2 | DB2 UDB 8.1 ODBC, DataDirect 4.2 | DB2 UDB 8.1 ODBC, DataDirect 4.2 |
Informix(R) 9.x 1 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 |
Oracle 8i | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 |
Oracle 9i | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 |
Teradata V2 R4.1 | TUF 7.0 with Teradata 3.2 ODBC | TUF 7.0 with Teradata 3.2 ODBC | TUF 7.0 with Teradata 3.2 ODBC | TUF 7.0 with Teradata 3.2 ODBC | Not Supported |
Teradata V2 R5 | TUF 7.0 with Teradata 3.2 ODBC | TUF 7.0 with Teradata 3.2 ODBC | TUF 7.0 with Teradata 3.2 ODBC | TUF 7.0 with Teradata 3.2 ODBC | Not Supported |
MS SQL Server 7.0 | MS SQL Server 3.70 ODBC | DataDirect 4.2 | Not supported | DataDirect 4.2 | DataDirect 4.2 |
MS SQL Server 2000 | MS SQL Server 3.70 ODBC | DataDirect 4.2 | Not supported | DataDirect 4.2 | DataDirect 4.2 |
Sybase 12.0 1 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 |
Sybase 12.5 1 (Adaptive Server) | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 |
Access 2000 1 | Microsoft Driver | Not supported | Not supported | Not supported | Not Supported |
Access 2002 1 | Microsoft Driver | Not supported | Not supported | Not supported | Not Supported |
DB2 OLAP Integration Server supports the ODBC drivers for the relational database management systems (RDBMS) and operating systems shown in Table 13. Unless otherwise noted, client software is not required for the database server.
Relational Database Server (Relational Data Source) | ODBC drivers per supported operating system | ||||
AIX 5.1, 5.2 | HP-UX 11.0, HP-UX 11i | Solaris Operating System 8, 9 (Sun OS 5.8, 5.9) | Red hat Linux AS 2.1 | Windows 2000, Windows 2003, Windows XP | |
DB2 UDB 7.2, FP7 | DB2 UDB 7.2 ODBC, DataDirect 4.2 | DB2 UDB 7.2 ODBC, DataDirect 4.2 | DB2 UDB 7.2 ODBC, DataDirect 4.2 | DB2 UDB 7.2 ODBC, DataDirect 4.2 | DB2 UDB 7.2 ODBC, DataDirect 4.2 |
DB2 UDB 8.1 | DB2 UDB 8.1 ODBC, DataDirect 4.2 | DB2 UDB 8.1 ODBC, DataDirect 4.2 | DB2 UDB 8.1 ODBC, DataDirect 4.2 | DB2 UDB 8.1 ODBC, DataDirect 4.2 | DB2 UDB 8.1 ODBC, DataDirect 4.2 |
DB2 UDB for z/OS(R) and OS/390(R) V7 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 |
Informix 9.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 |
Informix 9.3 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 |
MS SQL Server 7.0 | Not supported | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | MS SQL Server 3.7 ODBC (included in MDAC 2.6) |
MS SQL Server 2000 | Not supported | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | MS SQL Server 3.7 ODBC (included in MDAC 2.6) |
Oracle 8i (Oracle 8i 32-bit client required with OCI direct connection) | DataDirect 4.2 Wire Protocol, OCI direct connection | DataDirect 4.2 Wire Protocol, OCI direct connection | DataDirect 4.2 Wire Protocol, OCI direct connection | DataDirect 4.2 | DataDirect 4.2 Wire Protocol, OCI direct connection |
Oracle 9i (Oracle 8i 32-bit client required with OCI direct connection) | DataDirect 4.2 Wire Protocol, OCI direct connection | DataDirect 4.2 Wire Protocol, OCI direct connection | DataDirect 4.2 Wire Protocol, OCI direct connection | DataDirect 4.2 | DataDirect 4.2 Wire Protocol, OCI direct connection |
Sybase 12.0 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 |
Sybase 12.5 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 | DataDirect 4.2 |
Teradata V2 R5.0 | TUF 7.0 with Teradata 3.2 ODBC | TUF 7.0 with Teradata 3.2 ODBC | TUF 7.0 with Teradata 3.2 ODBC | Not Supported | TUF 7.0 with Teradata 3.2 ODBC |
ODBC drivers used with DB2 OLAP Integration Server must be thread-safe. All drivers listed in Table 13 are thread-safe. HP-UX requires kernel-threads. Solaris Operating System requires Solaris threads, and AIX requires kernel-threads with pthread API.