*****************************************************************

IBM DB2 OLAP Integration Server, Version 8.1

Fix Pack 3

Support Matrix

September 2003;
October 2003 for Japanese

*****************************************************************

Service level:  Hyperion Essbase XTD Integration Services 6.5.4 (For Japanese: 6.5.4.1J)

This document lists the software supported by DB2® OLAP Integration Server, V8.1 Fix Pack 3, 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.

Server Support

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

Back to the top

Client Support

Operating System Requirement
Windows NT 4.0 Service Pack 5
Windows 2000  
Windows XP  
Windows 98  

Back to the top

Supported ODBC Drivers

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.

Back to the top

Supported JDBC Drivers

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.

Back to the top


Copyright information

The following statements apply to all server and client components of IBM DB2 OLAP Server:

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.