IBM United States
Software Announcement 202-310
November 12, 2002

IBM DB2 OLAP Server for iSeries, V8.1 Delivers Relational Integration and Scalability

 ENUS202-310.PDF (59KB)

(Corrected on June 10, 2003)

Hardware and Software requirements updated.

(Corrected on November 19, 2002)

Intelligent Sparse Reporting details added.

At a Glance

A fast path to turn your warehouse data into business insight

  • Combines the high performance of multidimensional OLAP with relational scalability
  • Lets you exploit hardware with parallel calculation and data load
  • Gives you a single point of administration for managing multiple OLAP servers
  • Allows you to integrate information from multiple data sources
  • Enables you to automate the discovery of atypical patterns in your cubes

Uncover associations, patterns, and trends in your data assets to your competitive advantage.

For ordering, contact:

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

Overview

DB2® OLAP Server™ for iSeries™, V8.1, based on Hyperion Essbase 6.5, incorporates significant improvements in the areas of scalability, performance, ease of use, and administration.

Refer to Software Announcement 200-426 , dated November 28, 2000.

Hybrid Analysis for Cube Scalability

A logical cube now can be defined to have a lower portion of the cube reside in the relational database. The OLAP Server retrieves the "cells" from the relational database as if they physically reside on the cube storage.

Hybrid Analysis eliminates the need to load and store low-level members and their data with the physical cube itself, combining the efficiency of mass data scalability with sophisticated data analysis and rapid reporting of DB2 OLAP Server.

Improved Parallelism for Performance and Throughput

Many critical operations can be run in multithreaded mode, enabling you to take advantage of the improved hardware and to gain system performance and throughput.

  • Calculation — The OLAP engine can break down a calculation pass into subtasks that can be run on separate CPUs simultaneously.
  • Data Load — You can specify the number of processing threads for data load processing. These threads can be allocated across processors on different CPUs.
  • Export — You can export DB2 OLAP Server databases on multiple threads.

Integration Server Improvements

Use the Integration Server Console 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 DB2 OLAP Server to access the relational database. Multiple data source connection, formulas verification, native drivers, and other enhancements are added to this release.

OLAP Miner for Deviation Discovery

OLAP Miner combines the powerful IBM data mining technologies with OLAP technologies. It empowers your users to discover:

  • Anomalies and special segments from the wealth of data analyzed today
  • Notable fluctuations in sales numbers, budgets, or other data

Intelligent Sparse Reporting (ISR) enables faster query/retrieval processing for Essbase databases.

ISR accelerates front-end product retrieval for Analyzer, STRATEGY Query, STRATEGY Report Writer, or a spreadsheet that queries the Essbase database. It optimizes the search of potentially millions of blocks down to a few thousand or few hundred to satisfy the request.

Key Prerequisites

  • IBM eServer iSeries running OS/400® V5R1, or later (for the server)
  • Windows® clients

Planned Availability Dates

  • November 15, 2002, for Electronic Software Delivery through Passport Advantage
  • December 6, 2002, for Media Packs

Description

What's New in DB2 OLAP Server for iSeries, V8.1

The DB2 OLAP Server for iSeries V8.1 program is based on Hyperion Essbase 6.5. DB2 OLAP Server for iSeries, V8.1 also integrates a number of enhancements from Hyperion Essbase 6.2 and 6.1, which are available to DB2 OLAP Server for AS/400®, V7.1 customers via fixpaks. In addition, the OLAP Miner feature is included in DB2 OLAP Server for iSeries, V8.1.

Hybrid Analysis for Cube Scalability

The administrator can define a multidimensional cube where lower level members can reside on a relational database, and higher level members reside on the multidimensional store. DB2 OLAP Server for iSeries accesses the relational source, prepares the cells, and returns to the calling application as if data natively resides on the multidimensional store.

DB2 OLAP Server for iSeries can access lower level data in relational database in a seamless way. 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.
  • Improves relational drill-through — previously the calling application had to handle the preparation for relational drill-through (a rather complex task). 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 for iSeries, 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.

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 configuration settings for command line parameters in a configuration file is supported.

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. An easy-to-use wizard helps you create deviation detection definitions, then 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 to see deviations in the context of other surrounding values.

You can also view deviations in a standard spreadsheet application; for example, DB2 OLAP server spreadsheet add-in.

Other Improvements

Numerous other improvements in the DB2 OLAP Server for iSeries, V8.1 are described in the 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 be used in the SQL Interface.
  • Back-level clients (from DB2 OLAP Server for AS/400 V7.1 fixpak 8 on) can access the DB2 OLAP Server for iSeries, V8.1.
  • Messages in the server log dealing with user logins and security changes include additional details for auditability.
  • You can now build an outline from a data source without adding manually at least one member first.

Relational Storage Manager

With the introduction of hybrid analysis and a better approach to the integration of relational data with OLAP data, the relational storage manager option will no longer be available in DB2 OLAP Server for iSeries, V8.1.

Current customers who have cubes in the relational storage manager should migrate to the multidimensional storage manager before installing V8.1. Use instructions in existing documentation.

Once V8.1 is installed, the cubes no longer will be accessible from the DB2 OLAP Server. However, you can still copy the outline and load and recalculate the cube from the original source into a multidimensional storage manager.

Optional Features

Currency Conversion — Converts financial data using any currency exchange rate scenario. The Currency Conversion module lets you model the impact of exchange rates and perform ad hoc conversions directly from a spreadsheet or custom application.

API — Lets you use standard tools to create custom DB2 OLAP Server applications that take advantage of the powerful data storage, retrieval, and analytical capabilities. The API supports Visual Basic, C, C++, and other application development environments, and works with Windows 95/98, Windows NT®, and UNIX®.

Extended Spreadsheet Toolkit — Includes more than 20 macros and Visual Basic functions, letting you build custom Lotus® 1-2-3® or Microsoft™ Excel applications that tightly integrate with DB2 OLAP Server.

DB2 OLAP Server for iSeries Partitioning Option V8.1 — Offers a collection of powerful features that make it easy to design and administer multidimensional databases (cubes or star schemas) that span OLAP applications or servers. Functions can:

  • Integrate multiple physical cubes or stars into a single logical cube
  • Centrally administer and share metadata
  • Allow connection of cubes and stars with varying dimensionality
  • Allow partition replication between centralized and distributed cubes and stars

DB2 OLAP Server for iSeries Builder V8.1 — Builder assists in moving enterprise data to the AS/400 by transforming and simplifying online transaction data into meaningful information.

  • Easily builds data warehouse or data marts using full SQL support. Selects specific data from one or more tables in your OLTP database in DB2/400 and moves them to existing tables or new tables created "on-the-fly" by Builder.
  • Cleanses data by calling user programs or by entering any SQL statement either before or after the distribution.
  • Implements business rules, such as profit margin formulas or inventory reorder thresholds, using Builder's ability to create result columns and assign them meaningful names and descriptions.
  • Manages metadata by prejoining multiple tables, renaming files and fields when transforming the data, and maintaining a metadata repository for information about how the warehouse was created.
  • Presets the timing of data transformations or can be called from applications, which may determine the data transformation schedules.
  • Can distribute data from DB2 Distributed Relational Database Access (DRDA®) data sources other than the AS/400, including DB2 Universal Database® running on OS/390®, AIX®, and Windows NT.
Builders are available for the following:
  • DB2/AIX/MVS™ Source
  • DB2/NT Source
  • Additional DB2/400 Sources
  • MS Access/Excel (no-charge)
  • Lotus Domino™ (no-charge)

Intelligent Sparse Reporting (ISR) is a licensed enhancement to Essbase/400 that enables faster query/retrieval processing for Essbase databases containing related dimensions comprised of a large number of members (defined as sparse dimensions to the Essbase engine). As an example, a database may contain several dimensions representing product SKUs such as product, color, and size.

Although there may be a very large number of color and size members, the number of members relating to a product or set of products may be very small. If the database meets the criteria, then ISR can greatly enhance the retrieval time for any front-end product retrieval, such as Analyzer, STRATEGY Query, STRATEGY Report Writer, or a spreadsheet that queries the Essbase database.

In many cases, a retrieval/query that causes Essbase to search millions of blocks can be optimized to search only a few thousand or even a few hundred blocks reducing the amount of time and resources required to satisfy the request. In essence, ISR optimization uses a set of user-provided rules or constraints identifying valid member combinations to optimize a report focusing only on data that exists, eliminating unnecessary searching and processing

Users could obtain this same benefit by optimizing individual reports manually. However, the process to manually generate this report can be time-consuming and problematic due to the dynamic nature of multidimensional databases.

Section 508 of the U.S. Rehabilitation Act

DB2 OLAP Server for iSeries, V8.1 is capable as of November 15, 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.

Product Positioning

DB2 OLAP Server for iSeries is complementary to a number of IBM and non-IBM products, including:

  • Essbase-Ready ISV Products

    Many ISV desktop tools and applications use the Hyperion Essbase API to access multidimensional data. As the same API is transparently supported by DB2 OLAP Server, these ISV tools can now expand their products seamlessly to the relational marketplace.

  • DB2 Data Warehouse Center and DB2 Warehouse Manager

    Warehouse management facilities in DB2 Universal Database V7.2 give you an integrated, managed environment to transform, create, and maintain data marts and data warehouses. They can automate loading, updating, and recalculating the star schema tables and multidimensional cubes in the DB2 OLAP Server from a variety of data sources.

Trademarks

 
The e-business logo, DB2 OLAP Server, iSeries, and MVS are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
OS/400, AS/400, DB2, DRDA, DB2 Universal Database, AIX, and OS/390 are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Microsoft is a trademark of Microsoft Corporation.
 
Windows and Windows NT are registered trademarks of Microsoft Corporation.
 
UNIX is a registered trademark of the Open Company in the United States and other countries.
 
Domino is a trademark of Lotus Development Corporation and/or IBM Corporation.
 
Lotus and 1-2-3 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.

Education Support

The following courses are offered by IBM Learning Services:

                                             Course
Course Title                                 Number
 
DB2 OLAP Server(TM):  Up and Running         DW60x
DB2 OLAP Server:  Administration             DW61x
  and Tuning
DB2 OLAP Server:  Partitioning               DW63x

The "x" in the course number is a country suffix. Not all courses are available in every country. Visit:

The appropriate curriculum will include the enhancements described in this announcement.

Refer to the IBM Learning Services Home Page for available courses in your country. Visit:

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 from Mechanicsburg after the program planned availability. To order, contact your IBM representative.

                                                Order
Title                                           Number
 
 Installation Guide                             SC27-1228
 Installation Guide for iSeries(TM)             GC18-7225
 Administrator's Guide for                      SC18-7226
  OLAP on iSeries
 Administrator's Guide for                      SC18-7227
  Builder on iSeries
 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
 Database Administrator's                       SC18-7001
   Guide, Volume 1:
   Essbase Basics
 
                                                Order
Title                                           Number
 
 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

The Publications Notification System (PNS) is available by order number/product number. If you currently subscribe to PNS, you will receive notifications by e-mail automatically. If you want to subscribe, visit:

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 and payment options via credit card are provided.

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
 
API Reference
Technical Reference
Message Reference
MERANT DataDirect Connect ODBC Reference

The following softcopy documents are available in both HTML and Adobe Acrobat PDF formats and are included with the media and on the Internet:

Title
 
Installation Guide for iSeries
Administrator's Guide for OLAP on iSeries
Administrator's Guide for Builder on iSeries

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

Title
 
Installation Guide
Quick Path
OLAP Spreadsheet Add-in User's Guide for 1-2-3
OLAP Spreadsheet Add-in User's Guide for Excel
Database Administrator's Guide, Volume 1
Database Administrator's Guide, Volume 2
Database Administrator's Guide, Volume 3
SQL Interface Guide
MaxL User's Guide
Integration Server Administration Guide
Integration Server Data Preparation Guide
OLAP Miner User's Guide

Technical Information

Specified Operating Environment

Hardware Requirements

Server Platforms

  • Processor: iSeries (with OS/400® V5R1, or later) Advanced RISC Server
  • Memory: Minimum supported
  • Storage Devices: Minimum supported
  • Disk space for installation: 500 MB
  • Temporary disk space for install: 280 MB

Client Platforms

  • Processor: Pentium®, or later, computers for Windows® 98, NT 4, ME, or 2000, or XP
  • Terminal: VGA
  • 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, NT 4, ME, or 2000
  • RAM: 64 MB (128, or more, MB recommended for Windows platforms)
  • Disk space: 15 MB for 32-bit Essbase API on Windows platforms

Builder Client

  • Processor: Pentium 133
  • RAM: 64 MB or minimum requirement by system
  • Disk space: 150 MB available hard disk space for AppMan, Lotus® Millennium (or later) add-in, Microsoft™ Excel 2000 or XP add-in, or run-time client

Software Requirements

Server Platforms

  • Operating Systems: OS/400 V5R1, or later
  • Others
    • V5R1: 5722JV1 Java™ Developer Kit 1.2 and 1.3
    • V5R2: 5722JV1 Java Developer Kit 1.2 and 1.3
    • Toolbox for Java installed and compiled: V5R1 5722JC1
    • Qshell Interpreter: OS/400 V5R1 (5722-SS1)

Client Platforms:

  • Operating System: Windows 98, NT 4, ME, 2000, or XP
  • Spreadsheet
    • Excel XP, Excel 2000 (Excel 9)
    • Lotus 97, 9.7, 9.6, 9.5
  • Network protocol: TCP/IP

API Client Platforms

  • Operating System
    • Windows 98, NT 4, ME, 2000, or XP

OLAP Miner

  • Server Operating System
    • Windows NT® 4, Windows 2000
  • Client Operating System
    • Windows 98, ME, NT 4, 2000, or XP

Builder Client

  • Operating System:
    • Windows NT 4 (Service Pack 5, or later), 98, 2000, or XP
  • Others
    • Microsoft Office 2000 or XP
    • Internet Explorer 5.5, or later, or Netscape 6.2, or later

Planning Information

The DB2 OLAP Server for iSeries, V8.1 license includes an entitlement for one installation and for one concurrent user. Entitlements for additional installations and for additional concurrent users are available.

The DB2 OLAP Server for iSeries Developer's Edition, V8.1 license includes an entitlement for one installation and for one concurrent user. It is licensed to evaluate, demonstrate, test, and develop application programs. Entitlements for additional installations and additional concurrent users are available.

You must order the appropriate entitlements for the number of installations and for the maximum number of concurrent users.

Entitlements may also be purchased for use of the available optional programs.

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

Determining required licensing and monitoring the licensing requirements is the responsibility of the customer.

Security, Auditability, and Control

The security functions of DB2 OLAP Server for iSeries, V8.1 interface with the security functions of OS/400.

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

This product is only available via Passport Advantage. It is not available as shrinkwrap.


    Product Group: Business Intelligence
    Product Identifier Description (PID)
    DB2 OLAP Server for iSeries, V8.1 (5724-B78)

Product Category: DB2® OLAP SERVER

The DB2 OLAP Server for iSeries, V8.1 program has two charge units consisting of the number of installs and the number of concurrent users.

The DB2 OLAP Server for iSeries Developer's Edition, V8.1 program also has two charge units consisting of the number of installs and the number of concurrent users.

The additional optional programs each have a single charge unit consisting of the number of installs.

The DB2 OLAP Server for iSeries, V8.1 is also available in a Developer's Edition.

Optional add-on programs are also available.

Media Packs

                                                  Part
 Program Name                                     Number
 
DB2 OLAP Server for iSeries,                      BB0CQML
  V8.1 Media Pack -- Multilanguage

DB2 OLAP Server for iSeries Developer's Edition, V8.1

                                                  Part
 Program Name                                     Number
 
DB2 OLAP Server for iSeries Developer's           BB0CRML
  Edition V8.1 Media Pack -- Multilanguage

New Passport Advantage Part Numbers

DB2 OLAP Server for iSeries, V8.1

                                                  Passport
                                                  Advantage
Description                                       Part Number
 
Integration Server-Install
 
DB2 OLAP Server iSeries Integration               D51HRLL
  Svr Install LIC/SW MAINT 1 ANNIV
DB2 OLAP Server iSeries Integration               D51HSLL
 
  Svr Install LIC/SW MAINT  2 ANNIV
DB2 OLAP Server iSeries Integration               E00GELL
  Svr Install SW MAINT RNWL 1 ANNIV
DB2 OLAP Server iSeries Integration               D51HTLL
  Svr Install SW MAINT AFT LIC 1 ANNIV
 
Intelligent Sparse Reporting-Install
 
DB2 OLAP Server iSeries                           D51HXLL
  Intell Sparse Rptg Instl
  LIC/SW MAINT 1 ANNIV
DB2 OLAP Server iSeries                           D51HYLL
  Rptg Instl
  LIC/SW MAINT  2 ANNIV
DB2 OLAP Server iSeries                           E00GGLL
  Rptg Instl
  SW MAINT RNWL 1 ANNIV
DB2 OLAP Server iSeries                           D51HZLL
  Rptg Instl
  SW MAINT AFT LIC 1 ANNIV
 
Builder-Additional DB2 Data Source-Install
 
DB2 OLAP Server iSeries                           D51I0LL
  BldrAddl DB2/400Src
  Instl LIC/SW MAINT 1 ANNIV
DB2 OLAP Svr iSeries                              D51I1LL
  BldrAddl DB2/400Src
  Instl LIC/SW MAINT  2 ANNIV
DB2 OLAP Svr iSeries                              E00GILL
  BldrAddl DB2/400Src
  Instl SW MAINT RNWL 1 ANNIV
DB2 OLAP Svr iSeries                              D51I2LL
  BldrAddl DB2/400Src
  Instl SW MAINT AFT LIC 1 ANNIV
 
Builder-Oracle and SQL Server Data Source-Install
 
DB2OLAP Svr iSeries Bldr                          D51I3LL
  Oracle SQL Srce Ins
  LIC/SW MAINT 1 ANNIV
DB2OLAP Svr iSeries Bldr                          D51I4LL
  Oracle SQL Srce Ins
  LIC/SW MAINT  2 ANNIV
DB2OLAP Svr iSeries Bldr                          E00GLLL
  Oracle SQL Srce Ins
  SW MAINT RNWL 1 ANNIV
DB2OLAP Svr iSeries Bldr                          D51I5LL
  Oracle SQL Srce Ins
  SW MAINT AFT LIC 1 ANNIV

Previously Announced Passport Advantage Part Numbers

DB2 OLAP Server for iSeries, V8.1: AS/400® references below include AS/400 and iSeries.

                                                  Passport
                                                  Advantage
 Description                                      Part Number
 
Install
 
DB2 OLAP Svr AS/400 Install                       D5AZXLL
  LIC/SW MAINT 1 ANNIV
DB2 OLAP Svr AS/400 Install                       D5AZYLL
  LIC/SW MAINT  2 ANNIV
DB2 OLAP Svr AS/400 Install                       E1AZZLL
  SW MAINT RNWL 1 ANNIV
DB2 OLAP Svr AS/400 Install                       D5B00LL
  SW MAINT AFT LIC 1 ANNIV
 
Concurrent User
 
DB2 OLAP Svr AS/400                               D5AZGLL
  Concurrent User
  LIC/SW MAINT 1 ANNIV
DB2 OLAP Svr AS/400                               D5AZHLL
  Concurrent User
  LIC/SW MAINT  2 ANNIV
DB2 OLAP Svr AS/400                               E1AZILL
  Concurrent User
  SW MAINT RNWL 1 ANNIV
DB2 OLAP Svr AS/400                               D5AZJLL
  Concurrent User
  SW MAINT AFT LIC 1 ANNIV
 
Partitioning Option-Install
 
DB2 OLAP Svr AS/400 Partitioning                  D5AZPLL
  Option Instl
  LIC/SW MAINT 1 ANNIV
DB2 OLAP Svr AS/400 Partitioning                  D5AZQLL
  Option Instl
  LIC/SW MAINT  2 ANNIV
DB2 OLAP Svr AS/400 Partitioning                  E1AZRLL
  Option Instl
  SW MAINT RNWL 1 ANNIV
DB2 OLAP Svr AS/400 Partitioning                  D5AZSLL
  Option Instl
  SW MAINT AFT LIC 1 ANNIV
 
Currency Conversion-Install
 
DB2 OLAP Svr AS/400                               D5AYJLL
  Currency Conversion Instl
  LIC/SW MAINT 1 ANNIV
DB2 OLAP Svr AS/400                               D5AYKLL
  Currency Conversion Instl
  LIC/SW MAINT  2 ANNIV
DB2 OLAP Svr AS/400                               E1AYLLL
  Currency Conversion Instl
  SW MAINT RNWL 1 ANNIV
DB2 OLAP Svr AS/400                               D5AYMLL
  Currency Conversion Instl
  SW MAINT AFT LIC 1 ANNIV
 
Application Program Interface-Install
 
DB2 OLAP Svr AS/400 App Prog                      D5AYBLL
  Intf Install LIC/SW MAINT 1 ANNIV
DB2 OLAP Svr AS/400 App Prog                      D5AYCLL
  Intf Install LIC/SW MAINT  2 ANNIV
DB2 OLAP Svr AS/400 App Prog                      E1AYDLL
  Intf Install SW MAINT RNWL 1 ANNIV
DB2 OLAP Svr AS/400 App Prog                      D5AYELL
  Intf Install SW MAINT AFT LIC 1 ANNIV
 
Extended Spreadsheet Toolkit-Install
 
DB2 OLAP Svr AS/400 Ext Sprdsht                   D5AYSLL
  Tlkt Install LIC/SW MAINT 1 ANNIV
DB2 OLAP Svr AS/400 Ext Sprdsht                   D5AYTLL
  Tlkt Install LIC/SW MAINT  2 ANNIV
DB2 OLAP Svr AS/400 Ext Sprdsht                   E1AYULL
  Tlkt Install SW MAINT RNWL 1 ANNIV
DB2 OLAP Svr AS/400 Ext Sprdsht                   D5AYVLL
  Tlkt Install SW MAINT AFT LIC 1 ANNIV
 
Builder-Install
 
DB2 OLAP Svr AS/400 Builder                       D5AZ0LL
  Install LIC/SW MAINT 1 ANNIV
DB2 OLAP Svr AS/400 Builder                       D5AZ1LL
  Install LIC/SW MAINT  2 ANNIV
DB2 OLAP Svr AS/400 Builder                       E1AZ2LL
  Install SW MAINT RNWL 1 ANNIV
DB2 OLAP Svr AS/400 Builder                       D5AZ3LL
  Install SW MAINT AFT LIC 1 ANNIV
 
Builder-Data Source on AIX and z/OS-Install
 
DB2 OLAP Svr AS/400 Builder                       D5B05LL
  AIX/MVS(TM) Install LIC/SW MAINT 1 ANNIV
DB2 OLAP Svr AS/400 Builder                       D5B06LL
  AIX/MVS Install LIC/SW MAINT 2 ANNIV
DB2 OLAP Svr AS/400 Builder AIX/MVS               E1B07LL
  Install SW MAINT RNWL 1 ANNIV
DB2 OLAP Svr AS/400 Builder AIX/MVS               D5B08LL
  Install SW MAINT AFT LIC 1 ANNIV
 
Builder-Data Source on Windows-Install
 
DB2 OLAP Server AS/400 Builder                    D5AZ8LL
  NT Install LIC/SW MAINT 1 ANNIV
DB2 OLAP Server AS/400 Builder                    D5AZ9LL
  NT Install LIC/SW MAINT  2 ANNIV
DB2 OLAP Server AS/400 Builder                    E1AZALL
  NT Install SW MAINT RNWL 1 ANNIV
DB2 OLAP Server AS/400 Builder                    D5AZBLL
  NT Install SW MAINT AFT LIC 1 ANNIV

DB2 OLAP Server for iSeries Developer's Edition, V8.1

AS/400 references below include AS/400 and iSeries.

                                                  Passport
                                                  Advantage
 Description                                      Part Number
 
Developer's Edition-Install
 
DB2 OLAP Svr AS/400 DevEd Install                 D5AXMLL
  LIC/SW MAINT 1 ANNIV
DB2 OLAP Svr AS/400 DevEd Install                 D5AXNLL
  LIC/SW MAINT  2 ANNIV
DB2 OLAP Svr AS/400 DevEd Install                 E1AXPLL
  SW MAINT RNWL 1 ANNIV
DB2 OLAP Svr AS/400 DevEd Install                 D5AXQLL
  SW MAINT AFT LIC 1 ANNIV
 
Developer's Edition-Concurrent User
 
DB2 OLAP Svr AS/400 DevEd Concu Us                D5AX6LL
  LIC/SW MAINT 1 ANNIV
DB2 OLAP Svr AS/400 DevEd Concu Us                D5AX7LL
  LIC/SW MAINT  2 ANNIV
DB2 OLAP Svr AS/400 DevEd Concu Us                E1AX8LL
  SW MAINT RNWL 1 ANNIV
DB2 OLAP Svr AS/400 DevEd Concu Us                D5AX8LL
  SW MAINT AFT LIC 1 ANNIV
 
Developer's Edition-Partitioning Option-Install
 
DB2 OLAP Svr As/400 Dev Ed Part Op                D5AXELL
  LIC/SW MAINT 1 ANNIV
DB2 OLAP Svr As/400 Dev Ed Part Op                D5AXFLL
  LIC/SW MAINT  2 ANNIV
DB2 OLAP Svr As/400 Dev Ed Part Op                E1AXGLL
  SW MAINT RNWL 1 ANNIV
DB2 OLAP Svr As/400 Dev Ed Part Op                D5AXHLL
  SW MAINT AFT LIC 1 ANNIV
 
Developer's Edition-Currency Conversion-Install
 
DB2OLAPAS/400DevEd Currency Conv.                 D5AY3LL
  LIC/SW MAINT 1 ANNIV
DB2OLAPAS/400DevEd Currency Conv.                 D5AY4LL
  LIC/SW MAINT  2 ANNIV
DB2OLAPAS/400DevEd Currency Conv.                 E1AY5LL
  SW MAINT RNWL 1 ANNIV
DB2OLAPAS/400DevEd Currency Conv.                 D5AY6LL
  SW MAINT AFT LIC 1 ANNIV
 
Developer's Edition --
Application Program Interface-Install
 
DB2 OLAP Svr AS/400 Dev Ed API                    D5AXVLL
  Inst LIC/SW MAINT 1 ANNIV
DB2 OLAP Svr AS/400 Dev Ed API                    D5AXWLL
  Inst LIC/SW MAINT  2 ANNIV
DB2 OLAP Svr AS/400 Dev Ed API                    E1AXXLL
  Inst SW MAINT RNWL 1 ANNIV
DB2 OLAP Svr AS/400 Dev Ed API                    D5AXYLL
  Inst SW MAINT AFT LIC 1 ANNIV
 
Developer's Edition --
Extended Spreadsheet Toolkit-Install
 
DB2 OLAP AS/400 Dev Ext Spreadsheet               D5CV5LL
  Tlkt Proc LIC/SW MAINT 1 ANNIV
DB2 OLAP AS/400 Dev Ext Spreadsheet               D5CV6LL
  Tlkt Proc LIC/SW MAINT  2 ANNIV
DB2 OLAP AS/400 Dev Ext Spreadsheet               E1CV7LL
  Tlkt Proc SW MAINT RNWL 1 ANNIV
DB2 OLAP AS/400 Dev Ext Spreadsheet               D5CV8LL
  Tlkt Proc SW MAINT AFT LIC 1 ANNIV

Passport Advantage Customer: Media Pack Entitlement Details

Customers with active subscriptions on the following programs are entitled to receive the corresponding media pack.

OLAP400 APPLIC PRGRM INTRFACE INST
OLAP400 CURRENCY CONVERSION INSTALL
OLAP400 EXTENDED SPRDSHT TLKT INS
DB2 OLAP SVR FOR AS/400 BUILDER
DB2OLAP SVR AS400 BLD DB2NT SC
DB2 OLAP SVR FOR AS/400 CONC USER
DB2 OLAP SVR FOR AS/400 PARTITION
DB2 OLAP SERVER FOR AS/400
DB2OLAP SVR AS400 BL AIXMVS SC
DB2 OL ISR BLD AD DB2400 SC SVR INS
DB2 OL ISR BLD ORASQL SVR SC SVR IN
DB2 OLAP ISER INTEGRATN SVR SVR INS
DB2 OL ISR INTLG SPARS REPRT SVR IN

                                                  Part
Media Packs                                       Number
 
DB2 OLAP Server for iSeries,                      BB0CQML
  V8.1 Media Pack -- Multilanguage
 
Entitled maintenance offerings:
DB2 OLAP SVR AS/400 DEV ED CNC USR
DB2 OLAP SERVR AS/400 DEV PART
DB2 OLAP SVR FOR AS/400 DEV EDITION
OL400DVP APPLIC PRGRM INTRFACE INST
OL400DVP CURRENCY CONVERSION INST
OL400DVP EXTENDED SPRDSHT TLKT INS
 
DB2 OLAP Server for iSeries Developer's           BB0CRML
  Edition V8.1 Media Pack -- Multilanguage

Terms and Conditions

This product is available only via Passport Advantage. It is not available as shrinkwrap.

Licensing: IBM International Program License Agreement. Proofs of Entitlement (PoE) 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: GC18-7228

Limited Warranty Applies: Yes

Program Services: Available until December 31, 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; visit 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.

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 Developer's Edition is licensed for installation and use only for the purpose of evaluating, demonstrating, testing, and developing application programs.

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. The 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 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 additional 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
  • 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:

AIX/UNIX Upgrade Protection Applies: No

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

iSeries Software Subscription Applies: No

Variable Charges Apply: No

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.

All items are under Passport Advantage.

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 at:

IBM Global Financing offers competitive financing to credit-qualified Customers to assist them in acquiring IT solutions. Our offerings include financing for IT acquisition, including hardware, software, and services, both from IBM and other manufacturers or vendors. Offerings (for all customer segments: small, medium, and large enterprise), rates, terms, and availability can vary by country. Contact your local IBM Global Financing organization or visit:

Order Now

 Use Priority/Reference Code: AE001
 
 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@vnet.ibm.com
 Mail:      IBM Atlanta Sales Center
            Dept. AE001
            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

 
DB2 OLAP Server, iSeries, z/OS, and MVS are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
OS/400, AIX, PowerPC, RS/6000, DB2, and AS/400 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 and Windows NT 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.