This document lists the software supported by DB2® OLAP Integration Server, V8.1 Fix Packs 5 and 5.1, 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 | Support | Requirement |
|---|---|---|
| Windows 2000 | Supported | |
| Windows 2003 | Supported | |
| Windows XP | Supported | |
| AIX 5L (V5.1 or V5.2) | Supported | PowerPC computers, including RS 6000 Running kernel-threads with pthread API for AIX |
| Sun SPARC or ULTRASPARC Version 2.8 or 2.9 (Sun 5.8 or 5.9) | Supported | Running Sun OS Solaris threads |
| HP-UX (11i) | Supported | PA-RISC computers Running HP-UXL kernel-threads |
| Red Hat Enterprise Linux AS 2.1 | Supported | Formerly Red Hat Linux Advanced Server |
| Operating System | Requirement |
|---|---|
| Windows 2000 | Service Pack 5 |
| Windows 2003 | |
| Windows XP |
Note: Fix Pack 5 (Essbase Integration Services 6.5.6) requires DB2 OLAP Server V8.1 (Essbase Analytic Services 6.5) or later.
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 5.1 or 5.2 | HP-UX 11.0 or 11i1 | Solaris 2.8 or 2.9 (Sun OS 5.8 or 5.9) | Linux Redhat AS 2.1 | Windows 2000, 2003, or XP | |
| DB2 UDB 7.2, Fix Pack 7 | DB2 UDB 7.2 ODBC, Data Direct 4.2 Wire Protocol | DB2 UDB 7.2 ODBC, Data Direct 4.2 Wire Protocol | DB2 UDB 7.2 ODBC, Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol | DB2 UDB 7.2 ODBC, Data Direct 4.2 Wire Protocol |
| DB2 UDB 8.1 | DB2 UDB 8.1 ODBC, Data Direct 4.2 Wire Protocol | DB2 UDB 8.1 ODBC, Data Direct 4.2 Wire Protocol | DB2 UDB 8.1 ODBC, Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol | DB2 UDB 8.1 ODBC, Data Direct 4.2 Wire Protocol |
| Informix 9.2 | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol |
| Informix 9.3 | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol |
| MS SQL Server 7.0 | Not supported | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol | MS SQL Server 3.7 ODBC (included in MDAC 2.6) |
| MS SQL Server 2000 SP3 | Not supported | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol | MS SQL Server 3.7 ODBC (included in MDAC 2.6) MS SQL Server 2000 ODBC1 |
| Oracle 8i R1, R3 (8.1.6, 8.1.7) (Client required with OCI direct connection) |
Data Direct 4.2 Wire Protocol OCI direct connection (AIX 5.2 supported with 8i 32-bit client only) |
Data Direct 4.2 Wire Protocol OCI direct connection |
Data Direct 4.2 Wire Protocol OCI direct connection |
Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol OCI direct connection |
| Oracle 9i R1, R2 (9.0.1, 9.2) (Client required with OCI direct connection) |
Data Direct 4.2 Wire Protocol OCI direct connection (AIX 5.2 supported with 8i 32-bit client only) |
Data Direct 4.2 Wire Protocol OCI direct connection |
Data Direct 4.2 Wire Protocol OCI direct connection |
Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol OCI direct connection |
| Sybase 12.0 |
Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol |
| Sybase 12.5 | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol | Data Direct 4.2 Wire Protocol |
| Teradata V2R5.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 |
| Teradata V2R5.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 | Not supported | TUF 7.0 with Teradata 3.2 ODBC |
Notes:
Table 2: Supported JDBC Drivers for Oracle and Teradata per Operating System
| JDBC Type | JDBC Driver per Supported Operating System | ||||
|---|---|---|---|---|---|
| AIX 5.1 or 5.2 | HP-UX 11.0 or 11i | Solaris 2.8 or 2.9 (Sun OS 5.8 or 5.9) | Linux Red Hat AS 2.1 | Windows 2000, 2003, or XP | |
| For Oracle: | |||||
| JDBC Type 1 | Supported | Supported | Supported | Supported | Supported |
| JDBC Type 41 | Supported | Supported | Supported | Supported | Supported |
| For Teradata: | |||||
| JDBC Type 12 | Unsupported | Unsupported | Unsupported | Unsupported | Unsupported |
| JDBC Type 33 | Supported | Supported | Supported | Unsupported | 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.