This document lists the software supported by DB2® OLAP Integration Server, V8.1 Fix Pack 4, in the following areas:
This document describes only DB2 OLAP Integration Server. For support information about DB2 OLAP Server™ and DB2 OLAP Server Miner at this fix pack level, see the Support Matrix for DB2 OLAP Server.
| Operating System | Requirement |
|---|---|
| Windows NT 4.0 | Service Pack 5 |
| Windows 2000 | |
| Windows XP | |
| Solaris | Sun SPARC or ULTRASPARC computer Version 2.7 or 2.8 (Sun OS 5.7 or 5.8) Running Sun OS Solaris threads |
| AIX | PowerPC computers, including RS 6000 Version 4.3.3 or 5.1 Running kernel-threads with pthread API for AIX |
| HP-UX | PA-RISC computers Version 11.0/11i Running HP-UXL kernel-threads |
| Operating System | Requirement |
|---|---|
| Windows NT 4.0 | Service Pack 5 |
| Windows 2000 | |
| Windows XP |
ODBC drivers for relational database management systems (RDBMS) and operating systems are shown in Table 1. Unless otherwise noted, client software is not required for the database server.
Table 1: Supported ODBC Drivers per Operating System and RDBMS
| Tested Relational Database Server (Database Client) | ODBC Driver per Supported Operating System | |||
|---|---|---|---|---|
| AIX 4.3.3, 5.1, or 5.2 | HP-UX 11.0 or 11i1 | Solaris 2.7 or 2.8 (Sun OS 5.7 or 5.8) | Windows NT 4.0, 2000 or XP | |
| DB2 UDB 7.1 | MERANT 4.1 Wire Protocol Not supported on AIX 5.2. |
MERANT 4.1 Wire Protocol | MERANT 4.1 Wire Protocol | MERANT 4.1 Wire Protocol |
| DB2 UDB 7.2 | DB2 UDB 7.2 ODBC, MERANT 4.1 Wire Protocol Not supported on AIX 5.2. |
DB2 UDB 7.2 ODBC, MERANT 4.1 Wire Protocol | DB2 UDB 7.2 ODBC, MERANT 4.1 Wire Protocol | DB2 UDB 7.2 ODBC, MERANT 4.1 Wire Protocol |
| DB2 UDB 8.1 (DB2 UDB 8.1 client required) |
DB2 UDB 8.1 ODBC | DB2 UDB 8.1 ODBC | DB2 UDB 8.1 ODBC | DB2 8.1 UDB ODBC |
| Informix 9.2 | MERANT 4.1 Wire Protocol Not supported on AIX 5.2. |
MERANT 4.1 Wire Protocol | MERANT 4.1 Wire Protocol | MERANT 4.1 Wire Protocol |
| Informix 9.3 | MERANT 4.1 Wire Protocol Not supported on AIX 5.2. |
MERANT 4.1 Wire Protocol | MERANT 4.1 Wire Protocol | MERANT 4.1 Wire Protocol |
| MS SQL Server 7.0 | MERANT 4.1 Wire Protocol Not supported on AIX 5.2. |
MERANT 4.1 Wire Protocol | MERANT 4.1 Wire Protocol | MS SQL Server 3.7 ODBC (included in MDAC 2.6) |
| MS SQL Server 2000 | MERANT 4.1 Wire Protocol Not supported on AIX 5.2. |
MERANT 4.1 Wire Protocol | MERANT 4.1 Wire Protocol | MS SQL Server 3.7 ODBC (included in MDAC 2.6) MS SQL Server 2000 ODBC1 |
| Oracle 8i (Client required with OCI direct connection) |
MERANT 4.1 Wire Protocol OCI direct connection (AIX 5.2 supported with 8i 32-bit client only) |
MERANT 4.1 Wire Protocol OCI direct connection |
MERANT 4.1 Wire Protocol OCI direct connection |
MERANT 4.1 Wire Protocol OCI direct connection |
| Oracle 9i (Client required with OCI direct connection) |
MERANT 4.1 Wire Protocol OCI direct connection (AIX 5.2 supported with 8i 32-bit client only) |
MERANT 4.1 Wire Protocol OCI direct connection |
MERANT 4.1 Wire Protocol OCI direct connection |
MERANT 4.1 Wire Protocol OCI direct connection |
| Sybase 12.0 |
MERANT 4.1 Wire Protocol Not supported on AIX 5.2. |
MERANT 4.1 Wire Protocol | MERANT 4.1 Wire Protocol | MERANT 4.1 Wire Protocol |
| Sybase 12.5 | MERANT 4.1 Wire Protocol Not supported on AIX 5.2. |
MERANT 4.1 Wire Protocol | MERANT 4.1 Wire Protocol | MERANT 4.1 Wire Protocol |
| Teradata V2R4.12 | TUF 7.0 with Teradata 3.2 ODBC Not supported on AIX 5.2. |
TUF 7.0 with Teradata 3.2 ODBC | TUF 7.0 with Teradata 3.2 ODBC | TUF 7.0 with Teradata 3.2 ODBC |
| Teradata V2R52 | TUF 7.0 with Teradata 3.2 ODBC Not supported on AIX 5.2. |
TUF 7.0 with Teradata 3.2 ODBC | TUF 7.0 with Teradata 3.2 ODBC | TUF 7.0 with Teradata 3.2 ODBC |
1 MS SQL Server 2000 driver must be purchased separately from
Microsoft.
2 Teradata ODBC drivers must be purchased separately
from the NCR Corporation.
DB2 OLAP Integration Server provides MERANT 4.1 ODBC drivers on UNIX for supported databases running on AIX, HP-UX, and Solaris operating systems; and for Windows NT, Windows 2000, and Windows XP
Note: ODBC drivers used with DB2 OLAP Integration Server must be thread-safe. All drivers listed here are thread-safe. HP-UX requires kernel-threads, Solaris requires Solaris threads, and AIX requires kernel-threads with pthread API.
Table 2: Supported JDBC Drivers for Oracle and Teradata per Operating System
| JDBC Type | JDBC Driver per Supported Operating System | |||
|---|---|---|---|---|
| AIX 4.3.3 or 5.1 | HP-UX 11.0 or 11i | Solaris 2.7 or 2.8 (Sun OS 5.7 or 5.8) | Windows NT 4.0, 2000 or XP | |
| For Oracle: | ||||
| JDBC Type 1 | Supported | Supported | Supported | Supported |
| JDBC Type 41 | Supported | Supported | Supported | Supported |
| For Teradata: | ||||
| JDBC Type 12 | Unsupported | Unsupported | Unsupported | Unsupported |
| JDBC Type 33 | Supported | Supported | Supported | Supported |
1 JDBC Type 4 drivers must be implemented when Oracle with OCI is
being used.
2 For Teradata, JDBC Type 1 drivers function for all
platforms except HP-UX, but are not supported by NCR
Corporation.
3 JDBC Type 3 drivers must be purchased separately
for Teradata from the NCR corporation.
Licensed Material - Program Property of IBM
© Copyright IBM Corporation 1998, 2004. All Right Reserved.
US Government Users Restricted Rights - Use, duplication or disclosure
restricted by GSA ADP Schedule Contract with IBM Corp.
IBM, DB2, and DB2
OLAP Server are trademarks of International Business Machines Corporation in the
United States, other countries, or both.
Portions (c) 1991-2004 Hyperion
Solutions Corporation. All rights reserved. Hyperion is a registered
trademark and Hyperion Solutions is a trademark of Hyperion Solutions
Corporation.
Microsoft, Windows, and the Windows logo are trademarks of
Microsoft Corporation in the United States, other countries, or both.