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

IBM DB2 OLAP Server, Version 8.1

Fix Pack 4

Support Matrix

April 2004

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

Fix pack service level:  Hyperion Essbase XTD Analytic Services 6.5.5.3

This document lists the software supported by DB2® OLAP Server™, Version 8.1 Fix Pack 4, in the following areas:

This document describes only DB2 OLAP Server and DB2 OLAP Server Miner.  For support information about DB2 OLAP Integration Server at this fix pack level, see the Support Matrix for DB2 OLAP Integration Server.

Server support

Operating System Support
AIX 4.3.3, 5L (V5.1, V5.2) Supported
Sun Solaris 8/9 (Sun OS 5.8/5.9) Supported
HP-UX 11.0 / 11i Supported
Windows NT Supported
Windows 2000 (SP3) Supported
Windows 2003 Supported
Windows XP Professional Supported
Redhat Linux AS 2.1 (Intel) Supported

Back to the top

Spreadsheet Add-in client support

Spreadsheet Version Microsoft Windows XP/2000/2003 Citrix Metaframe XP w/ Windows 2000 Server
Excel XP Supported Supported
Excel 2000
(Microsoft Excel 9)		 Supported Supported
Excel 97 Supported Not Supported
Lotus 1-2-3 9.7 Supported Not Supported
 

Back to the top

Third-party components required

Third Party components Requirements
Java Runtime Environment JRE 1.4.0 (part of batteries included configuration)
Java Runtime Environment JRE 1.3.1 (part of batteries included configuration)#
Java Cryptography Extension JCE 1.2.2 required for Single sign-on only#
Java Secure Socket Extension JSSE 1.0.3.01 required for Single sign-on only#

# AIX 4.3.3 doesn't support JRE 1.4 and requires JRE 1.3.1, JCE 1.2.2 and JSSE 1.0.3.01.

Back to the top

SQL Interface RDBMS/platform support

Tested Relational Database Client ODBC Driver(s) per Supported Essbase Server Operating System Platform
Windows 2000/2003
Windows XP		 Solaris 8/9
Sun OS 5.8/5.9		 AIX 4.3.3/5L V5.1/V5.2 HP-UX 11.0/11i Linux Redhat AS 2.1
DB2 UDB 7.2 (Wired Drivers) DB2 UDB 7.2 ODBC 
Data Direct 4.1		 DB2 UDB 7.2 ODBC 
Data Direct 4.1		 DB2 UDB 7.2 ODBC 
Data Direct 4.11 		DB2 UDB 7.2 ODBC 
Data Direct 4.1		 DB2 UDB 7.2 ODBC 
Data Direct 4.1
DB2 UDB 8.1 (Wired Drivers) DB2 8.1 ODBC DB2 8.1 ODBC DB2 8.1 ODBC DB2 8.1 ODBC DB2 8.1 ODBC
Informix 9.x (Wired Drivers) Data Direct 4.1 Data Direct 4.1 Data Direct 4.11 Data Direct 4.1 Data Direct 4.1
Oracle 8i (Wired Drivers) Data Direct 4.1 Data Direct 4.1 Data Direct 4.11 Data Direct 4.1 Data Direct 4.1
Oracle 9i (Wired Drivers) Data Direct 4.1 Data Direct 4.1 Data Direct 4.11 Data Direct 4.1 Data Direct 4.1
Teradata V2R4.1 Teradata 3.2 ODBC Teradata 3.2 ODBC Teradata 3.2 ODBC Teradata 3.2 ODBC Not Supported
Teradata V2R5 Teradata 3.2 ODBC Teradata 3.2 ODBC Teradata 3.2 ODBC Teradata 3.2 ODBC Not Supported
MS SQL Server 7.0 MS SQL Server 3.7 ODBC Data Direct 4.1 (Wired Drivers) Not Supported Data Direct 4.1 (Wired Drivers) Data Direct 4.1 (Wired Drivers)
MS SQL Server 2000 MS SQL Server 3.7 ODBC Data Direct 4.1 (Wired Drivers) Not Supported Data Direct 4.1 (Wired Drivers) Data Direct 4.1 (Wired Drivers)
Sybase 12.0 (Wired Drivers) Data Direct 4.1 Data Direct 4.1 Data Direct 4.11 Data Direct 4.1 Data Direct 4.1
Sybase 12.5 (Wired Drivers) Data Direct 4.1 Data Direct 4.1 Data Direct 4.11 Data Direct 4.1 Data Direct 4.1
Access 2000 Microsoft Driver Not Supported Not Supported Not Supported Not Supported
Access 2002 Microsoft Driver Not Supported Not Supported Not Supported Not Supported
DBASE V Microsoft Driver Not Supported Not Supported Not Supported Not Supported

1 DataDirect 4.1 ODBC drivers only support AIX 4.3.3 and AIX 5.1 but not 5.2.

Back to the top

DB2 OLAP Server Miner support

Operating System

 Support

Server components:
AIX 5L (V5.1, V5.2) Supported
Windows XP Professional Supported
Windows 2000 Supported
Windows NT 4.0  Supported

Client components:
Windows XP Professional Supported
Windows 2000 Supported
Windows NT 4.0  Supported
Windows 98 Not supported
Windows 95 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.