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

IBM DB2 OLAP Integration Server, Version 8.1

Fix Pack 2

Support Matrix

April 2003

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

Service level:  Hyperion Essbase XTD Integration Services 6.5.3

This document lists the software supported by DB2® OLAP Integration Server, V8.1 Fix Pack 2, 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
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 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 6.1 (DB2 UDB 6.1) DB2 UDB 6.1 ODBC DB2 UDB 6.1 ODBC DB2 UDB 6.1 ODBC DB2 UDB 6.1 ODBC
DB2 UDB 7.1 (DB2 UDB 7.1) DB2 UDB 7.1 ODBC DB2 UDB 7.1 ODBC DB2 UDB 7.1 ODBC DB2 UDB 7.1 ODBC
DB2 UDB 7.2 (DB2 UDB 7.1) DB2 UDB 7.2 ODBC, DB2 UDB 7.2 ODBC DB2 UDB 7.2 ODBC DB2 UDB 7.2 ODBC
Informix 9.2 (Connect 2.5) Not Supported MERANT 4.0 MERANT 4.0 MERANT 4.0
Informix 9.3 (Connect 2.5) Not Supported MERANT 4.0 MERANT 4.0 MERANT 4.0
MS SQL Server 7.0 (No client required) Not Supported Not Supported Not Supported MS SQL Server 3.7 ODBC (included in MDAC 2.5)
MS SQL Server 2000 (No client required) Not Supported Not Supported Not Supported MS SQL Server 3.7 ODBC (included in MDAC 2.5),
MS SQL Server 2000.80
Oracle 8i
(Net8)		 MERANT 4.0,
OCI direct connection		 MERANT 4.0,
OCI direct connection		 MERANT 4.0,
OCI direct connection		 MERANT 4.0,
Oracle ODBC,
OCI direct connection
Oracle 9i
(Oracle Net)		 OCI direct connection OCI direct connection OCI direct connection Oracle ODBC,
OCI direct connection
Oracle 9i
(Net8)		 MERANT 4.0,
OCI direct connection		 MERANT 4.0,
OCI direct connection		 MERANT 4.0,
OCI direct connection		 MERANT 4.0,
Oracle ODBC,
OCI direct connection
Sybase 12.02 (No client required)
 MERANT 4.0 MERANT 4.0 MERANT 4.0
Sybase Wire Protocol 		MERANT 4.0
Sybase Wire Protocol
Sybase 12.52 (No client required) Not Supported Not Supported MERANT 4.0
Sybase Wire Protocol		 MERANT 4.0
Sybase Wire Protocol
Teradata V2R4.13 (No client required) TUF 6.1.04 with Teradata 2.04.02.00 ODBC TUF 6.1.04 with Teradata 2.04.02.00 ODBC Teradata 2.04.02.00 ODBC TUF 6.1.04 with Teradata 2.08.02.05 ODBC

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

2Wire protocol drivers require that the client software be installed only on the database server computer. No database client software is required on the Integration Server computer.

3Teradata ODBC drivers must be purchased separately from the NCR Corporation.

4Use TUF Version 6.1.0 drivers only; TUF Version 6.1.1 is not supported.

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.