IBM United States
Software Announcement 202-172
July 16, 2002

IBM DB2 OLAP Server V8.1 — New Enhancements Available

 ENUS202-172.PDF (68KB)


At a Glance

This improved release of DB2 OLAP Server V8.1 provides enhancements to DB2 OLAP Server Analyzer including:

  • Key language localizations
  • Expanded application server support
  • Additional operating system support

You can access a wide range of supported environments for deploying DB2 OLAP Server Analyzer.

For ordering, contact:

Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: YE001).

Overview

This new release of DB2 OLAP Server™ V8.1 includes new environments for deploying the DB2 OLAP Server Analyzer:

  • Key language localizations
  • Expanded application server support
  • Additional operating system support

Language Localizations

In this release, all of the following have been translated into German, French, and Japanese:

  • DB2 OLAP Server Analyzer User Interface
  • All Online Help except for Administrations Tools
  • Installation Guide
  • Readme

Improvements include expanded support for the application server and the operating system.

AIX® 5.0 is added to the currently supported AIX 4.3.3.

Key Prerequisites

  • Pentium®, or later, computers with Windows NT® 4.0, Windows® 2000, or Windows XP
  • PowerPC® computers, including RS/6000® with AIX 4.3.3 or 5L
  • Sun SPARC or ULTRASPARC computers with Sun Solaris 7 or 8 (Sun OS 5.7 or 5.8)
  • HP PA-RISC with HP-UX 11.0 or 11i

Planned Availability Dates

  • DB2 OLAP Servers (English):
    • April 19, 2002: Electronic Software Delivery
    • May 17, 2002: Media Pack Availability
  • DB2® OLAP Analyzer Analysis Server — Refresh:
    • July 19, 2002: Electronic Software Delivery
    • August 23, 2002: Media Pack Availability
  • DB2 OLAP Server Analyzer Windows Client:
    • July 19, 2002: Electronic Software Delivery
    • August 23, 2002: Media Pack Availability
    • August 23, 2002
  • High Concurrency Option: November 8, 2002
  • Administration Services: Via FixPack at a date to be determined

Description

What's New in DB2 OLAP Server V8.1

In addition to all of the features and benefits associated with DB2 OLAP Server V8.1 described in the following paragraphs, this new and improved release offers several enhancements to DB2 OLAP Server Analyzer including:

  • Support for AIX 5.0
  • Language localization: French, German, and Japanese
  • Inclusion of a Windows Client and migration tools for moving from V5.0.3 to V6.1.1

The DB2 OLAP Server V8.1 program is based on Hyperion Essbase 6.5. DB2 OLAP Server V8.1 also integrates a number of enhancements from Hyperion Essbase 6.2 and 6.1, which are available to DB2 OLAP Server V7.1 customers via fixpaks. In addition, the OLAP Miner feature is included in DB2 OLAP Server V8.1. This section describes these major enhancements available in DB2 OLAP Server V8.1.

Hybrid Analysis for Cube Scalability: The administrator can now define a multidimensional cube where the lower level members can reside on a relational database and the higher level members reside on the multidimensional store. The OLAP Server will access the relational source, prepare the cells, and return to the calling application as if data natively resides on the multidimensional store.

The OLAP Server can access lower level data in a relational database seamlessly. It improves:

  • Scalability of the cube — only a smaller physical cube needs to be loaded and precalculated in Essbase while the lower, more detailed levels of data can be accessed dynamically at execution time.
  • Relational drill through — previously the calling application had to handle the preparation for relational drill through — a rather complex task to set up. Now the relational drill through is handled transparently by the OLAP Server for all applications.

The Hybrid Analysis function in DB2 OLAP Server V8.1 essentially has extended the OLAP Server:

  • From a Multidimensional OLAP (MOLAP), which delivers excellent query performance
  • To a Hybrid OLAP (HOLAP), which combines MOLAP with Relational OLAP (ROLAP), to let the OLAP application designer create cubes based on optimized query performance and data scalability

DB2 OLAP Integration Server is required for data description tasks of Hybrid Analysis.

Parallelism to Improve Performance and Throughput: Previously the Essbase kernel operated in single-threaded mode and performed tasks serially. With DB2 OLAP Server V8.1, parallelism is extended to help exploit the modern hardware and to improve system performance and throughput.

  • If you enable parallel calculation , Essbase analyzes all the tasks in a calculation pass and breaks them down into subtasks. The subtasks that can be run independently of each other are scheduled to run simultaneously on up to four threads, each on a separate CPU.
  • You can specify the number of processing threads to be used in parallel data load processing. These threads can be allocated across processors on multiple CPUs for performance advantages.
  • Parallel export is supported. The new PAREXPORT command enables administrators to export Essbase databases natively on multiple threads.

Administration Improvements: DB2 OLAP Server Administration Services is the new framework for managing and maintaining OLAP Servers. The Administration Services consists of a client console and a middle-tier server that communicate directly with OLAP Servers.

Note that the Administration Services, which is based on Essbase Administration Services, will be delivered later by a FixPack.

The Administration Services console is the GUI that provides a single point of access for viewing, managing, and maintaining OLAP Servers and the Administration Server. The console incorporates much of the functionality of the Application Manager and other administration tools, such as MaxL.

The Administration Services offers new features not available in the Application Manager:

  • You can migrate applications and databases from one server to another, regardless of platform.
  • You can migrate users and groups from one server to another.
  • You can change a user's password and propagate the new password to other OLAP Servers.
  • You can sign on to Administration Services, which handles your connection to OLAP Servers, applications, and databases.
  • Using the Log Analyzer, you can filter, search, and analyze OLAP Server logs and application logs.
  • A new MaxL Script Editor is integrated with the Administrative Services Console.
  • You can execute calculations in the background while performing other online tasks with the Console.
  • The Administration Services are based on Java™ and can run on multiple platforms.
  • You can print the contents of many windows in the console.
  • You can gain a graphical view of Essbase objects.

Integration Server Improvements: DB2 OLAP Integration Server is based on Essbase Integration Services 6.5.

  • Hybrid Analysis — The Integration Server Console is used to define the data in the relational database and map to hierarchies in the OLAP cube. The OLAP Metadata Catalog in the Integration Server is used by the OLAP Server to access the relational database.
  • Multiple data source connectivity — You can now connect data from different data sources, providing considerable flexibility in creating OLAP models with data from multiple data sources.
  • Verification of formulas — You can rapidly verify and edit static formulas before using them in Essbase, saving significant time from encountering such errors during member and data loads.
  • Automatic migration to current release — Scripts are automatically run to migrate you from a previous release of the Integration Server to the current release.
  • Native driver support — In addition to the Open Database Connectivity (ODBC) drivers already supported, the Oracle native driver can also be used. Additional native drivers will be added in the future.
  • Automatic configuration settings supported — For command line parameters in a configuration file.

High Availability via Enterprise Services: DB2 OLAP Server Enterprise Services, which is based on Hyperion's Essbase Enterprise Services 6.5, will be available in the DB2 OLAP Server V8.1 July 2002 refresh release.

Enterprise Services is a middle-tier framework that extends the power of Essbase by creating a Web-enabled, distributed platform for Essbase applications. Enterprise Services introduces a new, native Java interface to Essbase, which supports the communication infrastructure for Essbase administration, metadata delivery, and more. Enterprise Services acts as a broker for client program requests to Essbase servers. New services such as connection pooling, clustering, and failover support extend the scalability and reliability of the platform to serve the analysis needs of large numbers of users in Web-based environments.

A new priced feature, High Concurrency Option, is required for cube clustering that is needed for load balancing and failover capabilities.

Analyzer Improvements: DB2 OLAP Analyzer Analysis Server V8.1 is based on Hyperion Analyzer 6.0. Analyzer enables users to analyze sophisticated multidimensional and relational data in an easy-to-use GUI. Analysis reports can be distributed internally and externally, saved as HTML Web content, and referenced by URLs. DB2 OLAP Analyzer Analysis Server V8.1 has been re-architected to run inside leading J2EE-compliant application servers.

  • The Analyzer's powerful analysis functionality is now available on the Web, using 100% Java-based Analyzer Java Web client. The Web client now includes design features previously offered separately.
  • The Analyzer Administration Tool has been re-architected to a 100% Java application as well. This enables administrators to manage users, user groups, and database connections anywhere they can access the Internet.
  • There is also a 100% HTML thin client for the Analyzer HTML Web Client.
  • Analyzer now has a new GUI making it even easier to use.
  • The Analyzer repository has been standardized to a more flexible XML storage format.
  • Analyzer now ships DB2 Personal Edition V7.2 as a default relational repository.
  • Analyzer now ships WebSphere® Standard Edition V3.5 as a default Application Server.
  • The Windows Client will continue to be available but will not be required for the Web environment.

OLAP Miner for Deviation Discovery: DB2 OLAP Server Miner is a no-charge feature of DB2 OLAP Server. OLAP Miner combines the powerful IBM data mining technologies with OLAP technologies.

OLAP Miner enables you to examine your OLAP cubes (multidimensional databases) more thoroughly and easily by finding atypical or deviant values automatically. Instead of searching through your data manually to find data values that might be higher or lower than you expected, OLAP Miner can do this work for you. The OLAP Miner algorithm is optimized so that it can be deployed on large OLAP cubes.

You can search specific areas (subcubes) of your cubes by creating deviation detection definitions, which specify the way in which OLAP Miner examines the data that you selected for the subcube. OLAP Miner gives you an easy-to-use wizard that helps you create deviation detection definitions. After you create a deviation detection definition, OLAP Miner applies a deviation detection algorithm to the data to find deviations. After the mining run is finished, you can view a simple list of deviations or view the deviations in the Deviation Viewer. From the Deviation Viewer, you can see the deviations in the context of other surrounding values.

You can also view deviations in a standard spreadsheet application. If you have the DB2 OLAP Server spreadsheet add-in, you can use all of the features of that product to view or report deviations.

Other Improvements: There are numerous other improvements in DB2 OLAP Server V8.1 that are described in product documentation. A few are listed below:

  • Calculations can be simulated to help you select dense and sparse settings for the dimensions in your outline.
  • Substitution variables can now be used in SQL Interface.
  • Back level clients (from DB2 OLAP Server V7.1 fixpak 8 on) can access the V8.1 OLAP Server.
  • Messages in the server log dealing with user logins and security changes now include additional details for auditability.
  • You can now build an outline from a data source without having to manually add at least one member first.

Relational Storage Manager: With the introduction of Hybrid Analysis, which provides a better approach to integrate relational data with OLAP data, the Relational Storage Manager option will no longer be available in DB2 OLAP Server V8.1. Current customers who have cubes in Relational Storage Manager should migrate to Multidimensional Storage Manager before installing V8.1 using instructions in existing documentation. Once the V8.1 is installed, these cubes will no longer be accessible from the DB2 OLAP Server. However, you can still copy the outline and load and recalc the cube from the original source into a Multidimensional Storage Manager.

DB2 OLAP Servers V8.1 for iSeries and z/OS™

As with the previous versions of DB2 OLAP Server, IBM again intends to deliver releases of DB2 OLAP Server V8.1 on IBM eServer iSeries and IBM eServer zSeries in the near future. Both of these releases will have substantially the same functionality as the V8.1 for the IBM eServer xSeries and IBM eServer pSeries platforms being announced here, and they will be released under two separate announcement letters.

All statements regarding IBM's future direction or intent are subject to change or withdrawal without notice, and represent goals and objectives only.

Section 508 of the U.S. Rehabilitation Act

DB2 OLAP Server V8.1 is capable as of April 19, 2002, when used in accordance with IBM's associated documentation, of satisfying the applicable requirements of Section 508 of the Rehabilitation Act, provided that any assistive technology used with the product properly interoperates with it.

Trademarks

 
The e-business logo, iSeries, zSeries, xSeries, pSeries, DB2 OLAP Server, and z/OS are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
AIX, PowerPC, RS/6000, DB2, and WebSphere are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Pentium is a registered trademark of Intel Corporation.
 
Windows and Windows NT are registered trademarks of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
Other company, product, and service names may be trademarks or service marks of others.

Education Support

The following OLAP courses are offered by IBM Learning Services:

                                             Course
Course Title                                 Number
 
DB2 OLAP Server(TM):  Up and Running         DW600
DB2 OLAP Server:  Administration             DW610
 and Tuning
DB2 OLAP Server: Partitioning                DW630
DB2 OLAP Server Calc Scripts                 U4540
DB2 OLAP Server End-User Training:           U4541
 Analyzer
DB2 OLAP Server Analyzer Developer           U4542
DB2 OLAP Server End-User Training:           U4543
 Spreadsheet Add-in

For additional information, visit:

The appropriate curriculum will be updated, as necessary, to include the enhancements described in this announcement.

Call IBM Education and Training at 800-IBM-TEACH (426-8322) for catalogs, schedules, and enrollments.

Offering Information

Product information is available through Offering Information (OITOOL) at:

Publications

No publications are shipped with this program.

The following publications can be ordered after the program planned availability. To order, contact your IBM representative. All publications are available in English.

                                             Order
Title                                        Number
 
Installation Guide                           SC27-1228
 
Quick Path                                   SC18-7000
 
OLAP Spreadsheet Add-in                      SC27-1231
 User's Guide for 1-2-3(R)
 
OLAP Spreadsheet Add-in                      SC27-1232
 User's Guide for Excel
 
                                             Order
Title                                        Number
 
 
Database Administrator's                     SC18-7001
 Guide, Volume 1:
 Essbase Basics
 
Database Administrator's                     SC18-7002
 Guide, Volume 2:  Loading,
 Calculation, and Retrieval
 
Database Administrator's                     SC18-7003
 Guide, Volume 3:  Maintaining,
 Automating and Optimizing
 Essbase
 
SQL Interface Guide                          SC18-7004
 
MaxL User's Guide                            SC18-7005
 
Integration Server                           SC27-1227
 Administration Guide
 
Integration Server                           SC18-7006
 Data Preparation Guide
 
OLAP Miner User's Guide                      SC27-1611
 
Analyzer Installation Guide                  SC18-7007
 
Analyzer Getting Started                     SC18-7008
 
Analyzer Product Overview                    SC18-7009
 
Analyzer Administrator's Guide               SC18-7010
 
Analyzer Release Notes                       SC18-7011

The Publications Notification System (PNS) is available by order number/product number. Customers currently subscribing to PNS will automatically receive notifications by e-mail. Customers who wish to subscribe, can visit the PNS Web site location at:

The IBM Publications Center Portal:

The Publications Center is a worldwide central repository for IBM product publications and marketing material with a catalog of 70,000 items. Extensive search facilities are provided, as well as payment options via credit card. Furthermore, a large number of publications are available online in various file formats, which can currently be downloaded free of charge.

Note that PNS subscribers most often order their publications via the Publications Center.

The following softcopy HTML documents are included with the media and on the Internet:

Title                              Language
 
API Reference                      English
 
Technical Reference                English
 
Message Reference                  English
 
MERANT DataDirect Connect          English
     ODBC Reference

The following softcopy Adobe Acrobat PDF documents are included with the media and on the Internet:

Title                              Language
 
Installation Guide                 English
 
Quick Path                         English
 
OLAP Spreadsheet Add-in            English
 User's Guide for 1-2-3
 
OLAP Spreadsheet Add-in            English
 User's Guide for Excel
 
Database Administrator's           English
 Guide, Volume 1
 
Database Administrator's           English
 Guide, Volume 2
 
Database Administrator's           English
 Guide, Volume 3
 
SQL Interface Guide                English
 
MaxL User's Guide                  English
 
Integration Server                 English
 Administration Guide
 
Integration Server                 English
 Data Preparation Guide
 
OLAP Miner User's Guide            English
 
Analyzer Installation Guide        English
 
Analyzer Getting Started           English
 
Analyzer Product Overview          English
 
Analyzer Administrator's Guide     English
 
Analyzer Release Notes             English

Technical Information

Specified Operating Environment

Hardware Requirements

Before installing the product components, you should refer to the Installation Guides for detailed requirements.

Server Platforms for OLAP Server and Integration Server

  • Processor
    • Pentium®, or later, computers for Windows NT® 4.0, Windows® 2000, or Windows XP
    • PowerPC® computers, including RS/6000® for AIX® 4.3.3 or 5L
    • Sun SPARC or ULTRASPARC computers for Sun Solaris 7 or 8 (Sun OS 5.7 or 5.8)
    • HP PA-RISC for HP-UX 11.0 or 11i
  • RAM — 64 MB or greater (128 MB minimum, 256 MB recommended for UNIX® platforms)
  • Disk space — 65 to 85 MB for the server components and sample applications

Client Platforms

  • Processor: Pentium, or later, computers for Windows 98, Windows NT 4.0, Windows ME, or Windows 2000
  • RAM — 16 MB for Spreadsheet Add-in and Application Manager; 32 MB for the Runtime Client
  • Disk space — 50 to 60 MB

API Client Platforms

  • Processor
    • Pentium, or later, computers for Windows 98, Windows NT 4.0, Windows ME, or Windows 2000
    • PowerPC computers, including RS/6000 for AIX 4.3.3 or 5L
    • Sun SPARC or ULTRASPARC computers for Sun Solaris 7 or 8 (Sun OS 5.7 or 5.8)
    • HP PA-RISC for HP-UX 11.0 or 11i
  • RAM — 64 MB (128 MB, or more, recommended for Windows platforms; 256 MB recommended for UNIX platforms)
  • Disk space — 15 MB for 32-bit Essbase API on Windows platforms; 10 MB for UNIX platforms

Analyzer

  • Application Server (WebSphere®)
    • RAM — 260 MB (512 MB recommended)
    • Disk space — 300 MB minimum (700 MB during installation)
  • Windows Client: Disk space — 50 MB

Software Requirements

Before installing the product components, you should refer to the Installation Guides for detailed requirements.

Server Platforms for OLAP Server and Integration Server

  • Operating System
    • Windows NT 4.0, Windows 2000, or Windows XP
    • AIX 4.3.3 or 5L
    • Sun Solaris 7 or 8 (Sun OS 5.7 or 5.8)
    • HP-UX 11.0 or 11i
  • Network protocol — TCP/IP or Named Pipes
  • Java™ Platform — Java Runtime Environment V1.2.2, or later

Client Platforms

  • Operating system: Windows 98, Windows NT 4.0, Windows ME, or Windows 2000
  • Spreadsheet
    • Excel XP, Excel 2000 (Excel 9)
    • Lotus® 97, Lotus 9.7, Lotus 9.6, Lotus 9.5
  • Network protocol — TCP/IP or Named Pipes

API Client Platforms

    Operating System
    • Windows 98, Windows NT 4.0, Windows ME, or Windows 2000
    • AIX 4.3.3 or 5L
    • Sun Solaris 7 or 8 (Sun OS 5.7 or 5.8)
    • HP-UX 11.0 or 11i

OLAP Miner

  • Server operating system: Windows NT 4.0, Windows 2000, and AIX 4.3.3
  • Client operating system: Windows 98, Windows ME, Windows NT 4.0, and Windows 2000

DB2 OLAP Server Administration Services

  • Windows NT 4.0
  • Windows 2000 on Pentium, or later, machines
  • Windows 98
  • Windows ME
  • Sun Solaris 6, 7, and 8
  • AIX 4.3.3, or later

Analyzer

  • Operating systems
    • Windows NT 4.0, Service Pack 6
    • Windows 2000, Service Pack 2
    • Sun Solaris 8
    • AIX 4.3.3 or 5.0
  • OLAP servers
    • DB2 OLAP Server V8.1
    • DB2 OLAP Server V7.1 fixpak 7, or later
  • Relational Repositories
    • DB2® 7.2 (Personal, Workgroup, and Enterprise Editions)

      Note: DB2 Personal Edition 7.2 is shipped with Analyzer for the default repository.

    • Microsoft™ SQL Server 2000
    • Oracle 8.1.7

      Note: Install Oracle 8.1.7 database server software on the Application Server machine, to use the OCI8 driver to access the repository.

  • Application Servers
    • WebSphere Application Server Standard or Advanced Edition 3.5.5 for Windows
    • WebSphere Application Server Standard or Advanced Edition 3.5.3 for AIX and Sun Solaris

      Note: WebSphere Application Server Standard Edition 3.5 is shipped with Analyzer for the default Application Server.

  • Client Operating Systems
    • Windows NT 4.0, Service Pack 6
    • Windows 2000
    • Windows XP
    • Windows 98
  • Web Browsers
    • Microsoft Internet Explorer 4 or 5
    • Netscape Navigator 4.7, or 6.0

      To use the Hyperion Analyzer Java Web Client, Hyperion Analyzer Administration Tools, and the Hyperion Analyzer API Toolkit, users must also have Sun Java Plug-in 1.3.0_02.

Additional Analyzer Requirements

  • Essbase Client and API
    • Windows operating systems

      To access Hyperion Essbase, the corresponding Hyperion Essbase client must be installed with the J2EE Application Server.

    • UNIX operating systems

      The Essbase OLAP Server and the Essbase API applications are required when installing on the Sun Solaris Operating System.

      Those accessing DB2 OLAP Server V7 fixpak 8 require only the Essbase client.

  • Web server requirements
    • Stop all running Web servers.

      If you intend to use the IBM HTTP Server delivered with WebSphere Standard Edition 3.5, disable any currently installed Web servers.

Planning Information

The DB2 OLAP Server Standard Edition includes a restricted-use copy of DB2 Universal Database® Enterprise Edition V7.2, which may only be used in support of the DB2 OLAP Server Standard Edition.

The DB2 Universal Databases shipped with the DB2 OLAP Server Personal Edition and with the DB2 OLAP Server Developer's Edition are licensed with their own terms and conditions. Within these terms and conditions, these included DB2 Universal Databases can be used with, or independently from, a DB2 OLAP Server.

The DB2 OLAP Servers can also be used with other DB2 Universal Databases, including the DB2 Universal Database Enterprise — Extended Edition.

Installability

Passport Advantage Customers Migrating from V7.1 to V8.1.

DB2 OLAP Server Standard Edition

  • DB2 OLAP Server Objects is not available as a part of V8.1
  • DB2 OLAP Server Allocations Manager is not available as a part of V8.1
  • DB2 OLAP Server Starter Kit is not available as a part of V8.1
  • DB2 OLAP Server High Concurrency for Standard Edition is new to V8.1
  • Other options and entitlements are unchanged

DB2 OLAP Server Developer's Edition

  • Now supports multiple users: Concurrent User is new to V8.1
  • Continues to include the Tools Bundle
  • Other optional programs are no longer included and must be ordered separately
    • DB2 OLAP Server Partitioning Option for Developer's Edition
    • DB2 OLAP Server Integration Server for Developer's Edition

DB2 OLAP Server Personal Edition

  • DB2 OLAP Server Objects is not available as a part of V8.1
  • Other options and entitlements are unchanged

DB2 OLAP Analyzer Analysis Server

  • Named User is no longer available. Existing subscriptions will be converted to Concurrent Users on the basis of one Concurrent User for three Named Users, with fractional values rounded up to the next integer.
  • Other options and entitlements are unchanged.

DB2 OLAP Server Analyzer Windows Client

Entitlements are unchanged.

Packaging: There are no "Programming Packages" for this passport advantage product.

Media Packs

  • Standard Edition: Multilanguage (including English) CD-ROMs with license information and documentation for the server and for the four optional programs.
  • Developer's Edition: Multilanguage (including English) CD-ROMs with license information and documentation for the server, the Tools Bundle, and for the two optional programs.
  • Personal Edition: Multilanguage (including English) CD-ROMs with license information and documentation for the server and for the three optional programs.
  • DB2 OLAP Analyzer Analysis Server V8.1 — Refresh: English, French, German, and Japanese CD-ROMs with license information and documentation for the server and for its optional feature.
  • DB2 OLAP Server Analyzer Windows Client: English, French, German, and Japanese CD-ROMs with license information and documentation.

Security, Auditability, and Control

The Essbase OLAP engine, which is included with DB2 OLAP Server, provides a comprehensive, multilayered security system. There are security elements and tasks associated with the Essbase data. The Essbase Security Manager manages Essbase user access to specific Essbase applications, cubes, and individual data cells.

The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.

Ordering Information

DB2 OLAP Server V8.1 is available in three editions:

  • DB2 OLAP Server Standard Edition V8.1 has two charge units for "installs" and "concurrent users." It has four optional components each with a single charge unit for "installs."
  • DB2 OLAP Server Developer's Edition V8.1 has two charge units for "installs" and "concurrent users." It has two optional components each with a single charge unit for "installs."
  • DB2 OLAP Server Personal Edition V8.1 has a single charge unit for "installs." It has three optional components each with a single charge unit for "installs."

An associated optional program DB2 OLAP Analyzer Analysis Server V8.1 — Refresh has two charge units for "installs" and "concurrent users." It has an optional component with a single charge unit for "installs."

An associated optional program DB2 OLAP Server Analyzer Windows Client V8.1 has a single charge unit for "installs."

The DB2 OLAP Server V8.1 is available in three editions — Standard Edition, Developer's Edition, and Personal Edition. Optional add-on programs are also available.

Media Packs

                                                       Part
Program Name                                           Number
 
DB2 OLAP Server Standard Edition                       BB00HML
 V8.1 Media Pack -- English/NLV
 
DB2 OLAP Server Developer's Edition                    BB00IML
 V8.1 Media Pack -- English/NLV
 
DB2 OLAP Server Personal Edition                       BB00JML
 V8.1 Media Pack -- English/NLV
 
DB2 OLAP Analyzer Analysis Server --                   BB0BHML
 Refresh V8.1 Media Pack
 
DB2 OLAP Server Analyzer Windows Client                BB00TML
 V8.1 Media Pack

Previously Announced Passport Advantage Part Numbers that Apply to DB2 OLAP Server V8.1

                                                            Passport
                                                            Advantage
                                                            Part
Description                                                 Number
 
DB2 OLAP Server Standard Edition -- Install
 
DB2 OLAP Server Standard Edition Server                     D5B3KLL
 Inst LIC/SW MAINT 1 ANNIV
DB2 OLAP Server Standard Edition Server                     D5B3LLL
 Inst LIC/SW MAINT 2 ANNIV
DB2 OLAP Server Standard Edition Server                     E1B3MLL
 Inst SW MAINT RNWL 1 ANNIV
DB2 OLAP Server Standard Edition Server                     D5B3NLL
 Inst SW MAINT AFT LIC 1 ANNIV
 
DB2 OLAP Server Standard Edition -- Concurrent
User
 
DB2 OLAP Server Standard Edition Server                     D5B3TLL
 User LIC/SW MAINT 1 ANNIV
DB2 OLAP Server Standard Edition Server                     D5B3ULL
 User LIC/SW MAINT 2 ANNIV
DB2 OLAP Server Standard Edition Server                     E1B3VLL
 User SW MAINT RNWL 1 ANNIV
DB2 OLAP Server Standard Edition Server                     D5B3WLL
 User SW MAINT AFT LIC 1 ANNIV
 
DB2 OLAP Server Partitioning Option for Standard
Edition
 
DB2 OLAP Server Partitioning Option                         D5B27LL
 Install LIC/SW MAINT 1 ANNIV
DB2 OLAP Server Partitioning Option                         D5B28LL
 Install LIC/SW MAINT 2 ANNIV
DB2 OLAP Server Partitioning Option                         E1B29LL
 Install SW MAINT RNWL 1 ANNIV
DB2 OLAP Server Partitioning Option                         D5B2ALL
 Install SW MAINT AFT LIC 1 ANNIV
 
DB2 OLAP Server Tools Bundle for Standard Edition
 
DB2 OLAP Server Tools Bundle Install                        D5B49LL
 LIC/SW MAINT 1 ANNIV
DB2 OLAP Server Tools Bundle Install                        D5B4ALL
 LIC/SW MAINT 2 ANNIV
DB2 OLAP Server Tools Bundle Install SW                     E1B4BLL
  MAINT RNWL 1 ANNIV
DB2 OLAP Server Tools Bundle Install SW                     D5B4CLL
 MAINT AFT LIC 1 ANNIV
 
DB2 OLAP Integration Server for Standard
Edition
 
DB2 OLAP Integration Server Install                         D5B1RLL
 LIC/SW MAINT 1 ANNIV
DB2 OLAP Integration Server Install                         D5B1SLL
 LIC/SW MAINT 2 ANNIV
DB2 OLAP Integration Server Install SW                      E1B1TLL
 MAINT RNWL 1 ANNIV
DB2 OLAP Integration Server Install SW                      D5B1ULL
 MAINT AFT LIC 1 ANNIV
 
DB2 OLAP Server High Concurrency for Standard
Edition
 
DB2 OLAP Std Edition High Concurrency                       D50WPLL
 Inst LIC/SW MAINT 1 ANNIV
DB2 OLAP Std Edition High Concurrency                       D50WQLL
 Inst LIC/SW MAINT 2 ANNIV
DB2 OLAP Std Edition High Concurrency                       E007WLL
 Inst SW MAINT RNWL 1 ANNIV
DB2 OLAP Std Edition High Concurrency                       D50WRLL
 Inst SW MAINT AFT LIC 1 ANNIV
 
DB2 OLAP Server Developer's Edition -- Install
 
DB2 OLAP Developer Edition Server                           D50YVLL
 Install LIC/SW MAINT 1 ANNIV
DB2 OLAP Developer Edition Server                           D50YWLL
 Install LIC/SW MAINT 2 ANNIV
DB2 OLAP Developer Edition Server                           E008KLL
 Install SW MAINT RNWL 1 ANNIV
DB2 OLAP Developer Edition Server                           D50YXLL
 Install SW MAINT AFT LIC 1 ANNIV
 
DB2 OLAP Server Developer's Edition --
Concurrent User
 
DB2 OLAP Developer Edition Concurrent                       D50WSLL
 User LIC/SW MAINT 1 ANNIV
DB2 OLAP Developer Edition Concurrent                       D50WULL
 User LIC/SW MAINT 2 ANNIV
DB2 OLAP Developer Edition Concurrent                       E007XLL
 User SW MAINT RNWL 1 ANNIV
DB2 OLAP Developer Edition Concurrent                       D50WWLL
 User SW MAINT AFT LIC 1 ANNIV
 
DB2 OLAP Server Partitioning Option for
Developer's Edition
 
DB2 OLAP Dev Ed Partitioning Option                         D50X0LL
 Inst LIC/SW MAINT 1 ANNIV
DB2 OLAP Dev Ed Partitioning Option                         D50X1LL
 Inst LIC/SW MAINT 2 ANNIV
DB2 OLAP Dev Ed Partitioning Option                         E007ZLL
 Inst SW MAINT RNWL 1 ANNIV
DB2 OLAP Dev Ed Partitioning Option                         D50X2LL
 Inst SW MAINT AFT LIC 1 ANNIV
 
DB2 OLAP Integration Server for Developer's
Edition
 
DB2 OLAP Dev Ed Integration Server                          D50X3LL
 Inst LIC/SW MAINT 1 ANNIV
DB2 OLAP Dev Ed Integration Server                          D50X4LL
 Inst LIC/SW MAINT 2 ANNIV
DB2 OLAP Dev Ed Integration Server                          E0080LL
 Inst SW MAINT RNWL 1 ANNIV
DB2 OLAP Dev Ed Integration Server                          D50X5LL
 Inst SW MAINT AFT LIC 1 ANNIV
 
DB2 OLAP Server Personal Edition -- Install
 
DB2 OLAP Server Personal Edition                            D5B2WLL
 Install LIC/SW MAINT 1 ANNIV
DB2 OLAP Server Personal Edition                            D5B2XLL
 Install LIC/SW MAINT 2 ANNIV
DB2 OLAP Server Personal Edition                            E1B2YLL
 Install SW MAINT RNWL 1 ANNIV
DB2 OLAP Server Personal Edition                            D5B2ZLL
 Install SW MAINT AFT LIC 1 ANNIV
 
DB2 OLAP Server Partitioning Option for Personal
Edition
 
DB2 OLAP Svr Partitioning Opt Pers Ed                       D5B2NLL
 Inst LIC/SW MAINT 1 ANNIV
DB2 OLAP Svr Partitioning Opt Pers Ed                       D5B2PLL
 Inst LIC/SW MAINT 2 ANNIV
DB2 OLAP Svr Partitioning Opt Pers Ed                       E1B2QLL
 Inst SW MAINT RNWL 1 ANNIV
DB2 OLAP Svr Partitioning Opt Pers Ed                       D5B2RLL
 Inst SW MAINT AFT LIC 1 ANNIV
 
DB2 OLAP Server Tools Bundle for Personal Edition
 
DB2 OLAP Svr Tools Bundle Pers Ed                           D5B34LL
 Install LIC/SW MAINT 1 ANNIV
DB2 OLAP Svr Tools Bundle Pers Ed                           D5B35LL
 Install LIC/SW MAINT 2 ANNIV
DB2 OLAP Svr Tools Bundle Pers Ed                           E1B36LL
 Install SW MAINT RNWL 1 ANNIV
DB2 OLAP Svr Tools Bundle Pers Ed                           D5B37LL
 Install SW MAINT AFT LIC 1 ANNIV
 
DB2 OLAP Integration Server for Personal Edition
 
DB2 OLAP Integration Svr Pers Ed                            D5B3CLL
 Install LIC/SW MAINT 1 ANNIV
DB2 OLAP Integration Svr Pers Ed                            D5B3DLL
 Install LIC/SW MAINT 2 ANNIV
DB2 OLAP Integration Svr Pers Ed                            E1B3ELL
 Install SW MAINT RNWL 1 ANNIV
DB2 OLAP Integration Svr Pers Ed                            D5B3FLL
 Install SW MAINT AFT LIC 1 ANNIV
 
DB2 OLAP Analyzer Analysis Server -- Install
 
DB2 OLAP Svr Analyzer Analysis Install                      D5B12LL
 LIC/SW MAINT 1 ANNIV
DB2 OLAP Svr Analyzer Analysis Install                      D5B13LL
 LIC/SW MAINT 2 ANNIV
DB2 OLAP Svr Analyzer Analysis Install                      E1B14LL
 SW MAINT RNWL 1 ANNIV
DB2 OLAP Svr Analyzer Analysis Install                      D5B15LL
 SW MAINT AFT LIC 1 ANNIV
 
 
DB2 OLAP Analyzer Analysis Server --
Concurrent User
 
DB2 OLAP Svr Analyzer Analysis Concur                       D5B0LLL
 User LIC/SW MAINT 1 ANNIV
DB2 OLAP Svr Analyzer Analysis Concur                       D5B0MLL
 User LIC/SW MAINT 2 ANNIV
DB2 OLAP Svr Analyzer Analysis Concur                       E1B0NLL
 User SW MAINT RNWL 1 ANNIV
DB2 OLAP Svr Analyzer Analysis Concur                       D5B0PLL
 User SW MAINT AFT LIC 1 ANNIV
 
DB2 OLAP Analyzer Analysis API Toolkit
 
DB2 OLAP Svr Analyzer API Toolkit Inst                      D5B0DLL
 LIC/SW MAINT 1 ANNIV
DB2 OLAP Svr Analyzer API Toolkit Inst                      D5B0ELL
 LIC/SW MAINT 2 ANNIV
DB2 OLAP Svr Analyzer API Toolkit Inst                      E1B0FLL
 SW MAINT RNWL 1 ANNIV
DB2 OLAP Svr Analyzer API Toolkit Inst                      D5B0GLL
 SW MAINT AFT LIC 1 ANNIV
 
DB2 OLAP Server Analyzer Windows Client
 
DB2 OLAP Server Analyzer Win Client                         D5B1ALL
 Usr Inst LIC/SW MAINT 1 ANNIV
DB2 OLAP Server Analyzer Win Client                         D5B1BLL
 Usr Inst LIC/SW MAINT 2 ANNIV
DB2 OLAP Server Analyzer Win Client                         E1B1CLL
 Usr Inst SW MAINT RNWL 1 ANNIV
DB2 OLAP Server Analyzer Win Client                         D5B1DLL
 Usr Inst SW MAINT AFT LIC 1 ANNIV

Passport Advantage Customer: Media Pack Entitlement Details

Customers with active subscriptions on the products listed below are entitled to receive the corresponding media packs.

Entitled Maintenance Offerings Description

  • DB2 OLAP SERVER STD EDITION INSTALL
  • DB2 OLAP SERVER STD EDITION USER
  • DB2 OLAP PARTITION OPT
  • DB2 OLAP TOOLS BNDL
  • DB2 OLAP HIGH CONCURRENCY SVR INSTL

                                                            Part
Media Packs Description                                     Number
 
DB2 OLAP Server Standard Edition                            BB00HML
 V8.1 Media Pack -- English/NLV

Entitled Maintenance Offerings Description

  • DB2 OLAP DEVELOPER ED SVR INSTALL
  • DB2 OLAP DEVELOPER EDITION CONC USR
  • DB2 OLAP PARTITION OPTION SVR INSTL
  • DB2 OLAP INTEGRATION SVR SVR INSTL

                                                            Part
Media Packs Description                                     Number
 
DB2 OLAP Server Developer's Edition                         BB00IML
 V8.1 Media Pack -- English/NLV

Entitled Maintenance Offerings Description

  • DB2 OLAP PERS EDITION
  • DB2 OLAP PERS ED PARTITION OPT
  • DB2 OLAP PERS ED TOOLS BNDL
  • DB2 OLAP PERS ED INTEGRATION SVR

                                                            Part
Media Packs Description                                     Number
 
DB2 OLAP Server Personal Edition                            BB00JML
 V8.1 Media Pack -- English/NLV

Entitled Maintenance Offerings Description

  • IBM DB2OLANLZ ANALYSIS SVR INSTALL
  • IBM DB2OLANLZ ANALYS SVR CONCRT USR
  • IBM DB2OLANLZ API TOOLKIT INSTALL

                                                            Part
Media Packs Description                                     Number
 
DB2 OLAP Analyzer Analysis Server                           BB0BHML
 V8.1 -- Refresh Media Pack

Entitled Maintenance Offerings Description: IBM DB2OLSVR ANLZR WIN CLI USR INST

                                                            Part
Media Packs Description                                     Number
 
DB2 OLAP Server Analyzer Windows Client                     BB00TML
 V8.1 Media Pack

Withdrawal of Previous Passport Advantage Part Numbers: The following Passport Advantage part numbers are being replaced or obsoleted by this announcement. The effective withdrawal date is August 23, 2002.

Orders for these part numbers will not be accepted after the stated effective date of withdrawal, nor will normal marketing activities or educational support be available unless previous agreement exists between the customer and IBM.

                                                            Part
Program Name/Description                                    Number
 
DB2 OLAP Analyzer Analysis                                  BB00SML
 Server V8.1 Media Pack

Terms and Conditions

Licensing: IBM International Program License Agreement. Proofs of Entitlement (PoEs) are required for all authorized use. Part number products only, offered outside of Passport Advantage, where applicable, are license only and do not include Software Maintenance.

This software license includes Software Maintenance, previously referred to as Software Subscription and Technical Support.

License Information Form Number: GC27-1631

Limited Warranty: Yes

Program Services: Available until July 19, 2004

Money-Back Guarantee: If for any reason you are dissatisfied with the Program, return it within 30 days from the invoice date, to the party (either IBM or its reseller) from whom you acquired it, for a refund. This applies only to your first acquisition of the Program.

Copy and Use on Home/Portable Computer: No

Volume Orders (IVO): No

Passport Advantage Applies: Yes, and through the Passport Advantage Web site at:

Usage Restriction: Yes

This product contains elements of the Microsoft Development Network. IBM's license with Microsoft prohibits users of this product from externally distributing commercial products created with this product and containing such elements without obtaining a separate license from Microsoft.

DB2 OLAP Server Standard Edition contains DB2 Universal Database components. You may only use these components in support of your licensed use of the Program. For each valid DB2 OLAP Server Standard Edition PoE, you are entitled to install, from the media provided with the Program, the DB2 Universal Database components required to support DB2 OLAP Server Standard Edition, regardless of platform and number of processors. For use of the DB2 Universal Database components other than in support of your licensed use of DB2 OLAP Server Standard Edition, you must acquire a full use license of DB2 Universal Database.

You may not authorize or permit any other party, as part of a service offering or otherwise, to access the Program or any component thereof, for the purpose of allowing such party to use the Program or any component thereof, to develop or significantly modify OLAP applications, for example, an application that creates or modifies dimensions or calculations at the server, unless such party is developing such applications on your behalf and at your cost and expense.

DB2 OLAP Server Personal Edition is only licensed to a customer who has already licensed a DB2 OLAP Server Standard Edition.

DB2 OLAP Server Developer's Edition is licensed for installation and use only for the purpose of evaluating, demonstrating, testing, and developing application programs.

DB2 OLAP Server Miner is licensed for use only with DB2 OLAP Server.

In a machine configuration where multiple copies of DB2 OLAP Server may be installed, each installed copy must be properly licensed.

Software Maintenance Applies: Yes

Software Maintenance, previously referred to as Subscription and Technical Support, is now included in the Passport Advantage Agreement. Installation and technical support for the products announced in this letter is provided by the Software Maintenance offering of the IBM International Passport Advantage Agreement. This fee service enhances customer productivity by providing voice and/or electronic access into the IBM support organizations.

IBM includes Software Maintenance with each Program acquired during the Coverage Period. Coverage Period. means the period commencing on the date you acquire the Program up to the first or second Anniversary Date, depending on whether you acquired coverage for one or two anniversaries. The Coverage Period for Software Maintenance acquired in the two months preceding an Anniversary Date will be extended to the next applicable anniversary date.

While your Software Maintenance is in effect, IBM provides you assistance for your:

  • Routine, short duration installation and usage (how-to) questions

    and

  • Code-related questions

IBM provides assistance via telephone and, if available, electronic access, only to your information systems (IS) technical support personnel during the normal business hours (published prime shift hours) of your IBM support center (this assistance is not available to your end users). IBM provides Severity 1 assistance 24 hours a day, every day of the year. For further details, consult your IBM Software Support Guide at:

Software Maintenance does not include assistance for:

  • The design and development of applications

  • Your use of Programs in other than their specified operating environment

    or

  • Failures caused by products for which IBM is not responsible under this Agreement

For more information, about the Passport Advantage Agreement refer to the IBM International Passport Advantage Agreement Software Announcement 201-202 , dated July 10, 2001, or visit the Passport Advantage Web site at:

AIX/UNIX Upgrade Protection Applies: No

Entitled Upgrade for Current AIX/UNIX Upgrade Protection Licensees: No

IBM eServer iSeries Software Subscription Applies: No

Variable Charges Apply: No

Educational Allowance Available: Not applicable

Prices

The prices provided in this announcement are suggested retail prices for the U.S. only and are provided for your information only. Dealer prices may vary, and prices may also vary by country. Prices are subject to change without notice. For additional information and current prices, contact your local IBM representative.

This is a Passport Advantage Program.

Passport Advantage

For Passport Advantage and charges, contact your authorized IBM Lotus Business Partner. Additional information is also available on the Passport Advantage Web site:

Customer Financing: IBM Global Financing offers attractive financing to credit-qualified commercial and government customers and Business Partners to assist them in acquiring IT solutions. Offerings, rates, terms, and availability can vary by country. Contact your local IBM Global Financing organization or visit the Web at:

Use the Select a Country menu to find a contact in your location or country.

Order Now

 Use Priority/Reference Code: YE001
 
 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@vnet.ibm.com
 Mail:      IBM Atlanta Sales Center
            Dept. YE001
            P.O. Box 2690
            Atlanta, GA  30301-2690

You can also contact your local IBM Business Partner or IBM representative. To identify them, call 800-IBM-4YOU.

Note: Shipments will begin after the planned availability date.

Trademarks

 
IBM eServer, iSeries, and DB2 OLAP Server are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
PowerPC, RS/6000, AIX, WebSphere, DB2, and DB2 Universal Database are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Pentium is a registered trademark of Intel Corporation.
 
Microsoft is a trademark of Microsoft Corporation.
 
Windows NT and Windows are registered trademarks of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
UNIX is a registered trademark of the Open Company in the United States and other countries.
 
1-2-3 and Lotus are registered trademarks of Lotus Development Corporation and/or IBM Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.