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

IBM DB2 OLAP Server, Version 8.1

Fix Pack 3

Support Matrix 

September 2003;
October 2003 for Japanese

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

Fix pack service level:  Hyperion Essbase XTD Analytic Services 6.5.4 (For Japanese:  6.5.4.5 JP)

This document lists the software supported by DB2® OLAP Server™, Version 8.1 Fix Pack 3, 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 7/8 (Sun OS 5.7/5.8) Supported
HP-UX 11.0 / 11i Supported
Windows NT 4.0 for Intel Supported
Windows 2000 Supported
Windows XP Professional Supported
Redhat Linux 7.3 for 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.6 Supported Supported
Lotus 1-2-3 9.5 Supported Not Supported
 

Back to the top

Third-party components required

Third Party components Requirements
Java Runtime Environment JRE 1.4.0 
Java Runtime Environment JRE 1.3.1 #
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 NT
Windows 2000
Windows XP
Solaris 7/8
Sun OS 5.7/5.8
AIX 4.3.3/5L V5.1/V5.2 HP-UX 11.0/11i Linux Redhat 7.3
DB2 UDB 7.1 (Wired Drivers) Data Direct 4.1 Data Direct 4.1 Data Direct 4.11 Data Direct 4.1 Data Direct 4.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
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.70 ODBC Data Direct 4.1 (Wired Drivers) Data Direct 4.1 (Wired Drivers)1 Data Direct 4.1 (Wired Drivers) Data Direct 4.1 (Wired Drivers)
MS SQL Server 2000 MS SQL Server 3.70 ODBC Data Direct 4.1 (Wired Drivers) Data Direct 4.1 (Wired Drivers)1 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
Informix 9.x (Wired Drivers) Data Direct 4.1 Data Direct 4.1 Data Direct 4.11 Data Direct 4.1 Not Supported.
MS Access 2000 Microsoft Driver Not Supported Not Supported Not Supported Not Supported
MS 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.