ENUSZP04-0172.PDF (67KB)

DB2 OLAP Server V8.2 delivers powerful capabilities built on Essbase V7.1 technology

IBM Europe Middle East Africa - Last revised on August 10, 2004

Table of Contents

IBM Announcement Letter No. ZP04-0172 dated July 27, 2004.

  • Title
  • Overview
  • Key Prerequisites
  • At a Glance
  • Description
  • Program Number
  • Availability of National Languages
  • Education Support
  • Offering Information
  • Publications
  • Technical Information
  • Specified Operating Environment
  • Planning Information
  • Security, Auditability and Control
  • Ordering Information
  • Passport Advantage customer: media pack entitlement details
  • Withdrawal of Previous Passport Advantage Part Numbers
  • Integrated Technology Services (IBM Global Services)
  • Pricing
  • Terms and Conditions
  • Announcement Countries

    • IBM Announcement Letter No. ZP04-0172 dated July 27, 2004.


    Last revised on August 10, 2004.


    See final section for details of availability and limitations, if applicable.

    Title

    DB2 OLAP Server V8.2 delivers powerful capabilities built on Essbase V7.1 technology

    Overview

    The DB2 OLAP Server product family delivers services to provide insightful information to stakeholders responsible for managing business performance. A shared approach to business intelligence and performance management is critical to informed decision making and thus the success of your company. The DB2 OLAP Server product family provides the critical foundation technology that creates the shared information you need to manage your business Version 8.2 brings you powerful capabilities and support on Linux across the product family.

    DB2 OLAP Server is the engine that provides the analytical processing power, scalability, performance, manageability, and security needed for delivering information to a broad class of users. Version 8.2 delivers significant and exciting enhancements including massive dimensional scalability and reduction in aggregation time for sparse databases; the ability to more easily engage in global development; greater flexibility in accessing multidimensional data and metadata; the ability to more easily customize the end-user experience; the ability to quickly zoom in on relevant portions of the cube; and performance and administration enhancements.

    DB2 OLAP Server Administration Services , a robust, GUI component of DB2 OLAP Server, provides rich capabilities to make administration tasks and comprehensive life-cycle management easy to perform. Version 8.2 delivers key enhancements to support the new DB2 OLAP Server capabilities; an expanded set of deployment options with support for WebSphere, WebLogic, DB2 UDB and Oracle; richer interfaces to manage your outlines; easier monitoring and charting of information from a log view; a new MDX Script Editor; and many other improvements that collectively ease administration activities.

    DB2 OLAP Integration Server

    , an option of DB2 OLAP Server, is a suite of graphical tools and data integration services that dramatically reduce the cost of creating, deploying, and managing tailored DB2 OLAP Server applications, while providing a vital link to detailed data stored in relational databases. Version 8.2 delivers key improvements including support for the new DB2 OLAP Server capabilities; integration with DB2 Cube Views; drill-through reporting enhancements; hybrid analysis enhancements; shared user-defined members; and incremental loads.

    DB2 OLAP Server Deployment Services

    , a component of DB2 OLAP Server, provides a set of middle-tier services that enable broad deployment of business intelligence solutions to large user communities in distributed environments by extending the scalability, reliability, and availability of analytic applications. Version 8.2 delivers significant enhancements including connection pooling; several new Java APIs for custom-defined functions and for managing security access privileges; querying using MDX; Veritas Cluster Server on Windows; and support for the new DB2 OLAP Server capabilities.

    DB2 OLAP Server Spreadsheet Services provides a highly intuitive, user-friendly, thin-client spreadsheet environment for OLAP analysis with DB2 OLAP Server through integration into Excel. Enhancements in Version 8.2 include an improved query designer; an improved look and feel throughout the product; enhanced member selection dialog box; lightweight installation for client software; hybrid analysis support; support for current and many new VBA functions; and support for the new DB2 OLAP Server capabilities.

    Key Prerequisites

    The DB2 OLAP Server supports these operating systems:

    • IBM AIX
    • Hewlett-Packard HP-UX
    • Sun Solaris
    • Microsoft Windows
    • Linux for Intel

    For additional information about all hardware and software prerequisites for the DB2 OLAP Server , refer to the Hardware requirements and Software requirements sections.

    At a Glance

    DB2 OLAP Server lets you extract more value out of your operational, transactional and Business Intelligence data. Improvements in this release of DB2 OLAP Server including...

    • Aggregate Storage Option (ASO) support for Sparse Data

    • Enhanced Analytical Processing

    • Improved Scalability and Performance

    • Easier Administration and Maintenance

    • Improved Deployment

    • Improved Interfaces

    • Enhanced Platform Coverage

    ...allow your business to stay fast, focused, and flexible, while ensuring that your IT infrastructure remains streamlined and connected to improvements in business results.

    Planned availability dates:

    The Globalized, English-only version of DB2 OLAP Server V8.2 will be available for electronic download on July 30, 2004. It will be physically available on August 27, 2004.

    A fully Localized version of DB2 OLAP Server V8.2 will be available for electronic download on September 30, 2004. It will be physically available on November 12, 2004.

    See the complete letter for globalization details.

    Description

    DB2 OLAP Server Product Family

    The DB2 OLAP Server product family delivers services to access and integrate data from a wide range of sources, generate insightful information, and deliver that information to every stakeholder, within and outside the enterprise, who is responsible for managing business performance. How quickly and how well your company performs is directly related to the power and integration of your business intelligence and business performance management solutions.

    To improve profitability and business performance, you need insight into and accountability across every business activity. Employees need to understand how decisions in one department or division affect other areas of the company. They need to make time-critical, insightful decisions that lower costs, increase revenues, and improve collaboration. No company today succeeds without a shared approach to performance management. That approach requires powerful analytical processing. Analytical processing is the critical foundation technology that creates the shared information you depend on for business performance management.

    DB2 OLAP Server

    DB2 OLAP Server provides the processing power, scalability, performance, manageability, and security needed for delivering information to a broad class of users. From Line-of-Business executives to operational managers to front-line workers, DB2 OLAP Server can power insight and action across your extended enterprise.

    Powerful analytics. Rich functionality, including more than 250 sophisticated algorithms out-of-the-box, attributes, multi-user write-back, procedural logic, and custom-defined functions and macros to enable businesses to leverage deep insight from their Business Performance Management applications.

    Massive Scalability. Features such as cross-platform support, database partitioning, distributed processing, the ability to combine both relational and multi-dimensional data storage, and the brand new ability to support an optional aggregate storage kernel for huge, sparse databases enable DB2 OLAP Server to support communities as large as tens of thousands of users, while accessing massive volumes of information.

    Superior Performance. Parallel processing, caching, direct I/O and other features enable DB2 OLAP Server to deliver superior load, calculate, query and update performance for enterprise wide deployments. End users benefit from speed-of-thought query response even when performing the most sophisticated analytics.

    Easy Manageability. Features such as graphical interfaces, process automation and reusable dimensions, hierarchies and business rules enable DB2 OLAP Server to deliver an environment that offers the control and cost efficiency of centralization, while enabling departments and business units latitude in how resources are used.

    Robust Security. Tight control of user access down to the individual cell level enables DB2 OLAP Server to safeguard sensitive information. Group-and role-based security models provide flexibility in allowing users access to the information they need to drive breakthrough performance.

    DB2 OLAP Server V8.2 Highlights

    • Aggregate Storage Option - Support for aggregate storage databases (provided by a new aggregate storage kernel) enables dramatic scalability improvements in both database aggregation time and dimensional scalability. The aggregate storage kernel does not replace the current block storage kernel. Aggregate storage databases typically address read-only, "rack and stack" applications that have large dimensionality, such as the following applications:

      • Customer analysis - data is analyzed from any dimension and there are potentially millions of customers

      • Procurement analysis - many products are tracked across many vendors

      • Logistics analysis - near real-time updates of product shipments

      Aggregate storage databases with many dimensions calculate (aggregate) in minutes.

    • Outline Paging - Aggregate storage databases may have outlines with millions of members. Support for outline paging significantly reduces memory usage, enhancing the end-user experience. Depending on the operating system and available memory, you can create outlines with up to 20 million members.

    • Unicode (UTF8) Enabled Server - DB2 OLAP Server now supports a single database with data from multiple locales, through new Unicode support. Customers can now more easily engage in global development and easily provide all users access to data, regardless of their location and locale preference. DB2 OLAP Server will have two modes, non-Unicode and Unicode. Each DB2 OLAP Server application is designated as a non-Unicode-mode application (the default), or a Unicode-mode application. Administration Services, MaxL, and the API enable the migration of non-Unicode-mode applications to Unicode mode. Alias Tables will be available so that users can access views of information in their choice of language. Unicode support also extends to the following features: MDX, Query Logging, Hybrid Analysis, Triggers, and Data Mining.

    • Metadata Security - Many customers wish to filter metadata members so that they can restrict the ability of users to view these members. DB2 OLAP Server currently filters the data values, but not the member names and aliases. This release of DB2 OLAP Server now adds the ability for administrators to set security on metadata members to provide tailored metadata views to end-users. This will greatly enhance the customer's ability to customize the end-user experience and to deliver extranet applications to their vendors, suppliers, and end customers over the web.

    • Remote Authentication Module - The Remote Authentication Module is an optional component of the DB2 OLAP Server security platform. The security platform is a framework that provides DB2 OLAP Server applications with external authentication and single sign-on capabilities. The Remote Authentication Module is applicable to the following circumstances:

      • DB2 OLAP Server is deployed in a UNIX environment with authentication occurring against a Windows domain.

      • DB2 OLAP Server is deployed in a Windows environment, and users must log in to more than one Windows domain without changing the trust relationships.

    • Triggers on Write Operations - This release adds support for triggers based on write and load operations. Triggers can be used to track certain types of state changes, create constraints to watch for over a cube area, and track if the constraints are violated during updates (events) in the area. If a violation is detected, triggers enable the administrator to proactively send email alerts or wireless messages, or spool violated cells into a known file for further action. DB2 OLAP Server V8.2 supports several new trigger features:

      • On-update triggers and after-update triggers are now supported. The new after-update triggers fire only after all updates to the database are complete for a specific transaction.

      • In MaxL, create trigger statements are supported as well as the existing create or replace trigger statements.

      • For on-update triggers, you can now choose to add both old and new data values to the trigger spool file.

      • You can set triggers for databases in Unicode-mode applications.

    • MaxL Enhancements: With DB2 OLAP Server V8.2, MaxL now includes the following enhancements:

      • MaxL DML (XML for Analysis) - DB2 OLAP Server now enables access to multidimensional data and metadata through MaxL DML (data-manipulation language). MaxL DML is based on MDX, the XML for Analysis specification and is a robust language and expression syntax for creating and querying cube data. You can use either the MaxL Shell (essmsh) or MDX Editor in Administration Services to execute MDX queries.

      • MaxL support for Data Definition Language (DDL) operations such as creation, deletion, updating of users, applications, databases, and database objects.

      • New grammar to support aggregate storage application and database operations.

      • MaxL support of Unicode

      • Addition to the display object statement, for displaying only locked objects.

      • Additions to the alter session statement: one addition for setting MDX display options, and one addition enabling compression of the security file.

      • Additions to the create trigger statement, for specifying on-update triggers (the default) or after-update triggers. After-update triggers are supported only in traditional block-storage mode.

      • Ability to view and delete data-monitoring logs (logs created by triggers) from within the MaxL Shell

      • Filter Enhancements: Lines can be added to filter definitions using alter filter. A new level of filter access is added to create filter and alter filter statements

      • Improved STDOUT, STDIN, STDERR: Errors can be redirected to STDERR. STDERR and STDOUT can be redirected to a MaxL output log.

      • Improved Database-Related Grammar: The text of database notes is displayed as part of display database. Database free-space recovery is available using alter database statement. Explicit restructuring is available in alter database.

      • Display Location Aliases per Application

      • Display Port Information

      • Full ESSCMD Functionality Available in MaxL

    • Attribute and drill-through support for Hybrid members - DB2 OLAP Server now enables Hybrid stored members to have attributes associated with them. This greatly enhances the types of applications that DB2 OLAP Server can support. For instance, a DB2 OLAP Server application can now include a large customer dimension stored in the relational data store and have demographics information associated with this customer dimension as attribute dimensions. In addition, drill-through support is now extended to Hybrid members and attribute dimensions. This means that Hybrid levels and attribute dimensions can now be present in a drill-through reports intersection level.

    • Data Mining Java Framework - DB2 OLAP Server now includes a data-mining framework. Users can now leverage data mining algorithms using DB2 OLAP Server and their existing analytical data. A number of data mining algorithms are supported out of the box and additional algorithms can be added to the framework through customization.

    • Reduced Security-File Fragmentation - Fragmentation of the essbase.sec file can gradually develop when DB2 OLAP Server entities such as users, groups, applications, or databases are removed or changed. This can slow down security-related performance. With this release, the security file is compacted each time the Agent is shut down. Additionally, you can compact the security file without shutting down the Agent.

    • API - DB2 OLAP Server V8.2 provides new features and enhancements for improved API functionality to support:

      • Aggregate Storage Databases

      • Various Trigger Functions

      • C Outline API Function

      • Performance improvements for querying members

      • A new API function that verifies the Rules file.

      • A new API function that can verify a formula during an outline edit session.

      • An upgrade of the Member Information structure to include additional information. Because this structure is retained locally during a client session, several time-consuming retrievals can be eliminated, saving the client session significant time.

      • New capability that enables you to issue MDX statements from an application program.

      • Many functions added to the DB2 OLAP Server Visual Basic API that provide the same capabilities present in the DB2 OLAP Server C API.

    • Performance - DB2 OLAP Server provides performance improvements in the following areas:

      • Query Performance for Transparent Partitions - Query performance has been improved for transparent partitions containing outlines that have a time dimension with Dynamic Time Series members.

      • Performance for Large Outlines - Data load times and overall index size have been improved for large outlines.

      • Improved Data Compression - In some instances, compression of the database has been improved. The most significant impact can occur on databases with large block sizes, where the blocks are highly sparse.

    • Calculation - DB2 OLAP Server V8.2 includes the following calculation enhancements:

      • More Control of Currency Conversions after Loading Data

      • Calculation Script Control over the Create Blocks on Equation Feature

      • Calculation Script Control Over #MISSING Block Creation

    • Dimension Build - DB2 OLAP Server V8.2 includes the following rules file enhancements for building dimensions:

      • Changes to Existing Member Storage Properties

      • Replacement of UDA Values

      • Dimension Arrangement for Optimal Performance

    • Metadata Sampling - DB2 OLAP Server is a multidimensional database engine that provides support for ad hoc analysis. Such analysis is entirely driven by the intuition of the analyst and can be time-consuming as data volume increases. Large cubes tend to have more dimensions and sometimes more levels, making hierarchical navigation very cumbersome. DB2 OLAP Server V8.2 now includes support for metadata sampling, which enables you to analyze on large cubes with a focus on data trends or approximate information in the initial stages. Because you query on a sample of your data, retrieval is quick. Metadata sampling enables you to zoom in on a portion of the vast amount of data in your database in a fraction of the time that it usually takes to analyze the whole database. You can view many samples in a small amount of time and make early decisions. Later, you can follow with organized data exploration. With the introduction of Hybrid Analysis, you can store part of a DB2 OLAP Server cube in a relational database. Metadata sampling enables you to zoom in on all the data that you specify, whether it is in Analytic Services or in an underlying relational database.

    • Monitoring Data Changes: Triggers - The DB2 OLAP Server V8.2 triggers feature enables you to monitor data changes in a database efficiently. If data breaks the rules that you have specified, DB2 OLAP Server can send an e-mail (to a user or system administrator) or log the information in a file. You can create and delete triggers using MaxL statements.

    • Administration - DB2 OLAP Server V8.2 provides additional or improved administration functionality in the following areas:

      • Application Log Enhancements

      • Multiple Agent Enhancements

      • Optimize Outline for Batch Calculation

      • Explicit Restructure Command

    • Delayed Free Space Recovery - Improvements have been made to the free space recovery process, which is the most expensive part of database recovery. Database recovery takes place any time you load an application that ends abnormally. Changes have been made to the free space recovery process, as follows:

      • Performance has been improved significantly.

      • Free space recovery, which happened automatically before, is now delayed by default. The user must explicitly trigger free space recovery. A configuration option has been added to specify whether or not to delay free space recovery by default.

      • Explicit free space recovery has been added with a new MaxL grammar for alter database.

      • The GETDBSTATS command adds two lines of information about free space recovery.

      • If free space is recoverable, the block counters are estimates and do not necessarily match the number of existing blocks.

      • A new C API function, EssRecoverDbFreeSpace, has been added.

      • The ESB_DBSTATS_T structure has been changed.

    • Server Threads Specified by Application - Previously, the SERVERTHREADS configuration setting could only specify a single server thread value for all applications, meaning each application on the server had to use the same value. Now, users can choose to specify a different number of server threads for certain applications.

    • Additional Platform Support and Speadsheet-addin changes - With V8.2, DB2 OLAP Server adds IBM AIX 5.2, Red Hat Linux AS 2.1, Microsoft Windows 2003, and Sun Solaris 9 (Sun OS 5.0.9) to its list of supported platforms. For a complete list of supported operating systems, refer to the Software Requirements section. Spreadsheet-addin for Lotus 1-2-3 is not shipped with DB2 OLAP Server V8.2. Support for Lotus 1-2-3 Release 9.7 is available with the DB2 OLAP Server V8.1 FP5 or higher spreadsheet-addin client in conjunction with DB2 OLAP Server V8.2.

    DB2 OLAP Server Administration Services

    DB2 OLAP Server Administration Services is a robust, cross-platform graphical user interface that makes administration tasks easy to perform. Administrators can simultaneously view and edit properties for multiple applications, databases, users, scripts and other objects from a single intuitive view. The Administration Services Console also provides wizards, editors, dynamic menus and other tools to help you implement, monitor, and maintain Business Intelligence solutions.

    Personalized Multi-Server Administration - Makes it easier for administrators to view and access only the servers, applications, databases, and users they are responsible for managing

    Drag-and-drop Creation of Complex Business Logic - Users can rapidly and easily create application models and outlines, calculations, end user profiles and other application metadata

    Powerful Scripting Functionality - Enables batch processing of routine administration tasks, enhancing end user productivity and enabling centralized process management

    Interactive Administration Editors - Key word color coding and syntax auto-completion make it easy to build and validate administration, calculation, and report creation scripts

    Comprehensive Life-cycle Management - Administrators can easily and reliably migrate applications, from development to test to production

    Messages Panel and Log Analysis - Users can view, search, filter and analyze information about application and server status, and perform usage analysis by end-user, application and servers

    DB2 OLAP Server Administration Services V8.2 Highlights

    DB2 OLAP Server Administration Services V8.2 extends the power of DB2 OLAP Server in many ways:

    • Support for DB2 OLAP Server enhancements -

      • Aggregate Storage Support: Manage and maintain Aggregate Storage databases. Wizards for migrating Block Storage outline to Aggregate Storage outline

      • Metadata security: Adds a layer of security for metadata (dimensions and members) in outlines, similar to read-only security for data cells. In Filter Editor, a new Access type called MetaRead can be applied to dimensions or members in filter definitions to restrict access to them when retrieving an outline in a report.

      • Unicode (UTF-8) support: Administration Services fully supports the new DB2 OLAP Server Unicode feature, which enables sharing of database information across computers that are set up for different character sets.

      • Data mining framework: To support the new DB2 OLAP Server data mining framework, Administration Services provides a Data Mining menu and a Mining Wizard to help you find hidden relationships and patterns in a database.

      • Multiple agent enhancements: The process for a client to connect to multiple Agents on a single machine has been simplified.

      • Rules file enhancements for dimension builds: Data Prep Editor supports rules file enhancements for dimension builds, such as arranging dimensions in an hourglass shape and allowing UDA changes.

      • Outline optimization: You can optimize an outline for calculation performance either from a right-click menu in Enterprise View or from the Actions menu.

    • Extended Functionality in Outline Editor and Outline Viewer - Outline Viewer, the fast-loading option for viewing outlines, now matches the Outline Editor display of all outline and member properties, including member formulas, aliases, attributes, UDAs, and so on. Outline Viewer also provides a search facility to locate specific members in the outline. Outline Editor provides significant performance improvements, including better performance when opening large outlines and when drilling down on members with large numbers of children. The Outline Editor and Outline viewer provide the following additional improvements:

      • Significant performance improvement when drilling down on members with large numbers of children (for example, 50,000 members or more).

      • Enhancements in expanding and collapsing outlines (expand entire outline, expand to children, expand to descendants, and collapse to ancestor).

      • Ability to undo most operations in the current outline editing session, even after saving the outline. This includes the ability to undo multiple operations at one time.

      • Ability to update an outline using a rules file while the outline is open in Outline Editor.

      • Ability to search and replace in Outline Editor.

      • New options to disable confirmation prompts when deleting or moving members.

    • Improved Deployment Options - with support for additional Application Servers and Relational Databases - Deployment options for Administration Services have been increased by adding support for WebSphere and WebLogic as application servers as well as DB2 and Oracle as relational databases

    • Administration Server Management - This release provides the following improvements in Administration Server management:

      • Ability to add multiple Administration Servers to Enterprise View, and to remove Administration Servers from Enterprise View.

      • Ability to disconnect from and reconnect to Administration Servers from Enterprise View.

      • Ability to check the status of Administration Servers from Enterprise View (Running, Connected, Stopped, or Unknown).

    • New Log Viewer and Log Analyzer - Administrators can now easily monitor and chart information from a DB2 OLAP Server log view. Using the new Log Viewer, you can view DB2 OLAP Server logs and application logs. Log Viewer displays up to 5 megabytes (MB) of log information. If the log contains more information, Log Viewer displays the most recent information in the log. You can also specify a starting date from which to view log information, and you can search the log for specific text. You can use the new Log Analyzer to filter, search, and analyze DB2 OLAP Server logs and application logs. Based on filters you choose or create, you can view robust graphical charts for a log.

    • New MDX Script Editor - An MDX Script Editor with autocomplete functionality makes it easy to quickly use the power and flexibility of the MDX query language

    • Auto-Completion in Script Editors - This release adds auto-completion of script syntax to Calculation Script Editor and Report Script Editor. As you start to type command and function names, a drop-down list is displayed so that you can select the command or function from the list instead of typing it manually. Auto-completion is also available in MaxL Script Editor and MDX Script Editor.

    • Rules File Printing - Administrators can now print the content of a rules file, making it easier to debug a rules file

    • Management of Database Triggers - You can use the Administration Services Console to view, create, modify, delete, enable, or disable triggers. Triggers are rules that create areas of the database that are monitored during all write operations to the database. When specified conditions are met, certain actions are performed on behalf of the user.

    • Users and Groups in Tabular Display - DB2 OLAP Server users and groups are now displayed in a tabular format. This format provides a better overall view of users and groups, and provides greater flexibility and ease in user and group management tasks. From the Users or Groups table, you can perform operations on multiple users and groups at one time.

    • Accessibility - The Administration Services Console provides accessibility features, such as keyboard shortcuts, keyboard navigation for tree controls, default focus and default action buttons in dialog boxes and windows, logical tabbing order, keyboard scrolling, tooltips for UI elements, and an accessible help system.

    • Start/Stop DB2 OLAP Server Servers Remotely - Administrators can now start and stop DB2 OLAP Server servers remotely. This is supported for DB2 OLAP Server 8.2 and V8.1

    • Administration of DB2 OLAP Server Deployment Servers - The Administration Services Console provides an interface to manage DB2 OLAP Server Deployment Servers from the Enterprise View tree. Some DB2 OLAP Server Deployment Server features are activated through a separately licensed DB2 OLAP Server option (High Concurrency option). These features are available only if a valid license is installed that enables the DB2 OLAP Server Deployment Server High Concurrency option. The High Concurrency option enables you to cluster multiple DB2 OLAP Server servers to create a fault-tolerant and load-balancing DB2 OLAP Server configuration. In addition, this option enables connection pooling across multiple named users to provide more efficient use of DB2 OLAP Server connections.

    • Export and Import Selection Rules for Partition Areas - To help with creating area mappings in partitions, you can export and import member selection rules. This feature enables you to import selection rules that were previously exported from Application Manager. (Application Manager is a component of DB2 OLAP Server V8.1 that's no longer available with DB2 OLAP Server V8.2).

    • Data Preview Grid - Administrators can now navigate data directly from the Administration Services Console

    • Database Properties in Tabular Display - Database properties for all databases on Analytic Server can now be viewed from a single table. You can rearrange and sort the items in the table, and you can print and e-mail the contents of the table.

    • Extended Administration Services Functionality Using Java Plug-in Components - Administration Services enables you to extend the functionality of the product by developing Java plug-in components. A Developer's Guide explains the concepts, procedures, and examples needed to extend functionality, and a Java API Reference provides descriptions of the classes, interfaces, and methods that a plug-in author implements.

    • Reduced Number of Nodes in Enterprise View - The Enterprise View tree now includes fewer nodes. Nodes are no longer duplicated under servers, applications, and databases. These changes facilitate navigation through the tree.

    • Migration Wizard Enhancements - Migration Wizard (added in Release 6.5.1) steps you through the process of migrating (copying) applications and databases across Analytic Servers. Several enhancements have been made to Migration Wizard.

    • Extended Functionality in Partitioning - Improvements have been made to the partitioning interface, including: You can now import area definitions for partitions from an external text file instead of creating the area definitions manually, and you can use the new Subset dialog box to apply additional rules to a subset of members when defining areas in partitions.

    • Support for Long File Names - File names for Analytic Services objects are no longer restricted to 8 characters.

    • New Output Options for Reports - When you execute a report script, you can now output the report directly to a console window, a printer, or to a file.

    • Text Mode Agent for Administration Server - To facilitate running Administration Server as a Windows service and to eliminate the need to use XWindows on UNIX computers, Administration Server now runs in a text-mode Agent process or DOS window. The previous server user interface has been moved to Administration Services Console. To view Administration Server properties in Enterprise View, right-click the Administration Server node and select Edit properties. Note that XWindows is still needed to run the Administration Services installer on UNIX computers.

    • Additional Platform Support - With V8.2, DB2 OLAP Server Administration Services adds IBM AIX 5.2, Red Hat Linux AS 2.1, Microsoft Windows 2003, and Sun Solaris 9 (Sun OS 5.0.9) to its list of supported platforms. For a complete list of supported operating systems, refer to the Software Requirements section.

    DB2 OLAP Integration Server (an option of DB2 OLAP Server)

    DB2 OLAP Integration Server is a suite of graphical tools and scalable data integration services that will dramatically reduce the time and expense required to create, deploy, and manage tailored applications. DB2 OLAP Integration Server provides a vital link between tailored-made applications based on DB2 OLAP Server and detailed data stored in relational databases.

    A centralized OLAP Metadata repository simplifies tailored application administration, promotes reusability of dimensions, calculations, and business rules and facilitates delivery of business-focused applications driving insight across the enterprise. Use DB2 OLAP Integration Server with DB2 OLAP Server to achieve rapid development and deployment of performance management applications that support a wide range of business needs. Built on a flexible, multi-tier architecture, DB2 OLAP Integration Server easily scales to accommodate changing requirements and delivers scalability, performance, and reliability at a low total cost of ownership.

    DB2 OLAP Integration Server V8.2 Highlights:

    • Support for Aggregate Storage and Block Storage databases - Integration Server V8.2 now includes support for Aggregate Storage and Block Storage databases.

    • Unicode (UTF-8) Support - With V8.2, DB2 OLAP Integration Server provides Unicode support for both data sources and OLAP Metadata Catalogs, enabling you to use multiple languages within your business environment. DB2 OLAP Integration Server supports both native and Unicode Text Format (UTF-8) data sources. It also supports separate catalogs for native and UTF-8 applications. When you connect to a catalog and data source, DB2 OLAP Integration Server determines the encoding that you use and ensures that any DB2 OLAP Server applications that you use are in the same encoding. Unicode support is available on both Microsoft Windows and UNIX-based platforms. Hybrid Analysis also now supports Unicode.

    • DB2 Cube Views Support - DB2 OLAP Integration Server V8.2 supports IBM DB2 Cube Views so that you that can import and export OLAP model and metaoutline metadata objects between DB2 Cube Views and DB2 OLAP Integration Server. To take advantage of this capability, you first export your models or metaoutlines to an XML file. The XML file maps DB2 OLAP Integration Server metadata objects with DB2 Cube Views metadata objects. The XML file is then used to import the metadata objects between the DB2 catalog and the DB2 OLAP Integration Server metadata catalog.

    • Support for DB2 UDB for OS/390 and z/OS V7 - With V8.2, DB2 OLAP Integration Server now includes support for DB2 UDB for OS/390 and z/OS V7.

    • Hybrid Analysis Enhancements - With V8.2, Hybrid Analysis is enhanced to include support for Unicode (UTF-8), Dynamic Time Series, and DB2 UDB for OS/390 and z/OS V7.

    • Drill through Reporting to Web Sites - DB2 OLAP Integration Server expands the options for drill-through reports by giving you the capability of specifying a Web site as the data source. To take advantage of this option, you can easily customize the drill-through SQL template by replacing the relational data source with an HTML source. DB2 OLAP Integration Server passes the Web site to DB2 OLAP Spreadsheet Services, (or another drill-through client), which then launches the Web site in a browser.

    • Drill-through to a Secondary Data Source - In addition to enabling you to drill-through to a Web site as described earlier, DB2 OLAP Integration Server V8.2 gives you an additional option for drill-through reports by giving you the capability of replacing your primary data source with any secondary data source for the report.

    • Drill-through Reporting with Attribute Dimensions - In V8.2 of DB2 OLAP Integration Server, drill-through reporting capabilities are greatly expanded for attributes. Now you can select attribute dimensions and attribute members as OLAP intersections.

    • Drill-through Reporting with Hybrid Analysis Members - In V8.2 of DB2 OLAP Integration Server, drill-through reporting capabilities are greatly expanded for Hybrid Analysis members. Now you can select hybrid analysis dimensions and hybrid analysis member columns as OLAP intersections.

    • Attribute Support for Hybrid Analysis Members - V8.2 of DB2 OLAP Integration Server gives you the option of associating attributes to Hybrid Analysis members. In earlier versions, attributes could not be tagged as Hybrid Analysis enabled hierarchies.

    • Alternate Hierarchy Support for Hybrid Analysis - As mentioned earlier, V8.2 of DB2 OLAP Integration Server expands the functionality of Hybrid Analysis by giving you the option of associating Hybrid Analysis members to attribute dimensions and selecting Hybrid Analysis member columns as intersections. DB2 OLAP Integration Server V8.2 further expands the functionality of Hybrid Analysis by supporting alternate hierarchies within your Hybrid Analysis data.

    • Shared User-Defined Members - In V8.2 of DB2 OLAP Integration Server, you can designate your own user-defined members as shared members. This option enables user-defined members to share storage space with other members of the same name.

      • Managing different versions of XML models and metaoutlines

      • Restoring a past version of an XML model or metaoutline to the current version

    • Extended Prefix and Suffix Aliases Functionality - Several business environments require multiple versions of data. For example, many companies keep track of order dates, ship dates, payment-due dates, as well as multiple locations such as order-origin city and destination city. This data often uses both original names and code names; for example, Los Angeles and LA. To make tracking such data easier and more efficient, DB2 OLAP Integration Server V8.2 enables you to attach prefixes and suffixes to aliases when you perform member loads and data loads. The attached prefixes and suffixes can take several forms:

      • Member names

      • Numeric values

      • Text values

      • Mix of numeric and text values

    • Time-based Incremental Loads/Updates - Using DB2 OLAP Integration Server V8.2, you can perform incremental updates, loading only data that has changed or been added since your last data load. To help you monitor data loads, DB2 OLAP Integration Server keeps track of data load information and displays it in your Metaoutline Properties dialog box. You can take advantage of this new feature if your fact table has a time-stamp column. The following information is updated each time you perform a data load:

      • The DB2 OLAP Server name

      • The DB2 OLAP Server application name

      • The DB2 OLAP Server database name

      • The date-time stamp of the last data load

    • Enhanced Logging - To assist you in verifying that data loads are being performed correctly, DB2 OLAP Integration Server V8.2 creates two files:

      • dataloadrecord.txt file containing the first 1,000 successfully loaded records

      • hisdld.rul file containing the names of the dimensions loaded followed by the leaf node number of each dimension and member

    • Additional DB2 OLAP Server Settings Support - DB2 OLAP Integration Server V8.2 increases the number of DB2 OLAP Server settings that can be loaded from a database column during a data load. These settings are loaded from a database column in the same way as a Consolidation attribute and a UDA are loaded.

      • Comments

      • Currency Name attribute

      • Currency Category attribute

    • Updated Sample Applications - With V8.2, DB2 OLAP Integration Server updates its sample applications database to demonstrate several new features and functionality. Among the features demonstrated in the new sample applications are the following:

      • SQL drill-through

      • SQL data load override

      • Pass-through SQL

      • Use of multiple data sources

    • Automatic Migration to V8.2 - When you create or update an OLAP Metadata Catalog for the first time within a new release of DB2 OLAP Integration Server, a set of scripts is automatically run which enable you to migrate to the current release of DB2 OLAP Integration Server from an earlier release.

    • New XML Data Type Definition Documents - V8.2 of DB2 OLAP Integration Server provides two new documents that give details on OLAP model and metaoutline XML Import/Export data type definitions (DTDs). The two new documents, XMLImport/Export OLAP Model DTD and XML Import/Export OLAP Metaoutline DTD are included in the standard documentation set. Each DTD element is described in detail:

      • The element name in full

      • Description of the element, including its function

      • Explanation of the parameters for the element

      • Any special notes for the element, if applicable

    • Additional Platform Support - With V8.2, DB2 OLAP Integration Server adds IBM AIX 5.2, Red Hat Linux AS 2.1, Microsoft Windows 2003, and Sun Solaris 9 (Sun OS 5.09) to its list of supported platforms. For a complete list of supported operating systems, refer to the Software Requirements section.

    DB2 OLAP Server Deployment Services (a component of DB2 OLAP Server)

    DB2 OLAP Server Deployment Services provides a set of middle-tier services that enables broad deployment of business performance management solutions to large user communities in distributed environments. DB2 OLAP Server Deployment Services extend the scalability and reliability of analytic applications and supports thousands of concurrent users in distributed environments with Web-based architectures. Connection pooling, database clustering, load balancing, and fail over ensure applications are available 24x7x 365.

    DB2 OLAP Server Deployment Services also supports the creation and deployment of powerful web oriented analytical applications. Applications written as Java servlets, Java applets, Enterprise Java Beans (EJB) or stand-alone Java applications can easily be deployed using the multi-tier Web-based Deployment Services framework.

    Connection Pooling - Enables client requests to share database connections, which improves query response times and conserves software, server and network resources.

    High Availability - Enables the creation of an DB2 OLAP Server cluster that serve as a single data source for applications, increasing the availability of analytic data for end user queries. For example, applications can continue to service requests with no user impact when one or more servers within the cluster fails or is taken off-line for update.

    Web Optimized - Supports scalable web deployments and can extend seamlessly to the entire extended enterprise. Complements Developer Workbench and Analysis Studio by providing the underlying J2EE based foundation and a full set of Java APIs.

    Horizontal Scalability - Enables the creation of an DB2 OLAP Server cluster that serve as a single data source for applications allowing end user requests to be distributed across multiple physical machines, increasing user scalability and ensuring consistent query response times.

    DB2 OLAP Server Deployment Services V8.2 Highlights

    • Several new Java APIs for custom-defined functions and macros, and for managing security access privileges

    • New Java API capabilities for listing calculation functions

    • Support for querying DB2 OLAP Server using MDX (new Java API support for MDX); XMLA support

    • Supports better password control

    • Zero maintenance option for tools users

    • Zero maintenance option that enables automated addition of new user information to the DB2 OLAP Server Deployment Services server

    • Administrators can now manage DB2 OLAP Server Deployment Services using the DB2 OLAP Server Administration Services Console, as DB2 OLAP Server Deployment Services administration has been integrated into DB2 OLAP Server Administration Services

    • Veritas Cluster Server support for DB2 OLAP Server on Windows platform

    • Ability to identify and halt specific DB2 OLAP Server requests

    • Unicode (UTF-8) support

    • Metadata security support

    • Ability to perform an Integration Server Drill-Through on a range of cells

    • Ability to perform a Drill-Across on a range of cells

    • Support for connection pooling with com.essbase.api.metadata and com.essbase.api.datasource

    • Support for the DB2 OLAP Server security platform (also referred to as CSS - Common Security Services)

    • Support for External Authentication

    • Outline caching support for member selection queries

    • Backward compatibility with DB2 OLAP Server V8.1

    • Additional Platform Support: With V8.2, DB2 OLAP Server Deployment Services adds IBM AIX 5.2, Red Hat Linux AS 2.1, Microsoft Windows 2003, and Sun Solaris 9 (Sun OS 5.0.9) to its list of supported platforms. For a complete list of supported operating systems, refer to the Software Requirements section.

    DB2 OLAP Server Spreadsheet Services

    DB2 OLAP Server Spreadsheet Services provides a user-friendly spreadsheet environment for OLAP analysis with DB2 OLAP Server. By integrating directly into Excel, users can complete powerful ad-hoc analysis through an already familiar environment. This highly intuitive, ultra-thin spreadsheet client provides full functionality via the Web, and its Web services architecture runs securely across networks and seamlessly through firewalls.

    DB2 OLAP Server Spreadsheet Services V8.2 Highlights:

    • The new DB2 OLAP Server Query Designer allows DB2 OLAP Server Spreadsheet Services clients to create, save, and open queries, allows access to queries on the open worksheet, and can export queries to report scripts.

    • Improved look and feel throughout the product

    • Ability for spreadsheet users to change passwords

    • Enhanced Member Selection dialog box - dialogs are now modeless and resizable

    • Connection and disconnection from servers is now available from the client

    • Lightweight installation for client software (MSI client)

    • Allow Setting Global and sheet specific Options

    • Cascading Reports

    • Support for Linked Reporting Objects

    • Support for Formula Fill and Formula Preservation

    • Unicode (UTF-8) support

    • Metadata security support

    • DB2 OLAP Integration Server drill-through support

    • Hybrid Analysis support

    • Backward compatibility with DB2 OLAP Server V8.1

    • Support for Sheet Level Options using defined names

    • Support for substitution variables

    • Support for named ranges

    • Support for Dynamic Time Series

    • Lock and Send Menu item

    • Support for current and many new VBA functions

    • Support for localization

    • Excel 2003 support

    • Additional Platform Support: With V8.2, DB2 OLAP Spreadsheet Services adds IBM AIX 5.2, Red Hat Linux AS 2.1, Microsoft Windows 2003, and Sun Solaris 9 (Sun OS 5.09) to its list of supported platforms. For a complete list of supported operating systems, refer to the Software Requirements section.

    DB2 OLAP Server Documentation Installation Improvements

    Starting with DB2 OLAP Server V8.2, all DB2 OLAP Server documentation is installed separately from the software product installation.

    Program Number

    Program name                      Program number
--------------------------------- ---------------------------------
DB2 OLAP Server                   5724-OLP

    Availability of National Languages

    Product          Language         Electronic       Physical
description                       Availability     Availability
                                  date             date
---------------- ---------------- ---------------- ----------------
DB2 OLAP Server  English US       July 30, 2004    August 27, 2004
 Dev Ed V8.2.0
DB2 OLAP Server  Multilingual(Fre September 30,    November 12,
 Dev Ed V8.2.0    nch, Danish,     2004             2004
                  Russian,
                  Korean, Chinese
                  - Simplified,
                  Spanish,
                  Norwegian
                  Bokmal,
                  Brazilian
                  Portuguese,
                  German,
                  Swedish,
                  Chinese -
                  Traditional,
                  Japanese,
                  Hungarian,
                  English US,
                  Czech, Italian,
                  Finnish,
                  Polish)
DB2 OLAP Server  English US       July 30, 2004    August 27, 2004
 Pers Ed V8.2.0
DB2 OLAP Server  Multilingual(Fre September 30,    November 12,
 Pers Ed V8.2.0   nch, Danish,     2004             2004
                  Russian,
                  Korean, Chinese
                  - Simplified,
                  Spanish,
                  Norwegian
                  Bokmal,
                  Brazilian
                  Portuguese,
                  German,
                  Swedish,
                  Chinese -
                  Traditional,
                  Japanese,
                  Hungarian,
                  English US,
                  Czech, Italian,
                  Finnish,
                  Polish)
DB2 OLAP Server  English US       July 30, 2004    August 27, 2004
 Std Ed V8.2.0
DB2 OLAP Server  Multilingual(Fre September 30,    November 12,
 Std Ed V8.2.0    nch, Danish,     2004             2004
                  Russian,
                  Korean, Chinese
                  - Simplified,
                  Spanish,
                  Norwegian
                  Bokmal,
                  Brazilian
                  Portuguese,
                  German,
                  Swedish,
                  Chinese -
                  Traditional,
                  Japanese,
                  Hungarian,
                  English US,
                  Czech, Italian,
                  Finnish,
                  Polish)
DB2 OLAP Svr     English US       July 30, 2004    August 27, 2004
 Sprdsht Svc
 V8.2.0
DB2 OLAP Svr     Multilingual(Fre September 30,    November 12,
 Sprdsht Svc      nch, Danish,     2004             2004
 V8.2.0           Russian,
                  Korean, Chinese
                  - Simplified,
                  Spanish,
                  Norwegian
                  Bokmal,
                  Brazilian
                  Portuguese,
                  German,
                  Swedish,
                  Chinese -
                  Traditional,
                  Japanese,
                  Hungarian,
                  English US,
                  Czech, Italian,
                  Finnish,
                  Polish)

    Education Support

    The following educational offerings are available as listed below:

    IBM Learning Services courses for OLAP:

    • DW600 - DB2 OLAP Server: Up and Running
    • DW620 - DB2 OLAP Server: Administration, Tuning, and Partitioning

    IBM Global Services, IT Education Services, provides education to support many IBM offerings. Descriptions of courses for IT professionals and managers are on the IBM Learning Services Web site:

    http://www-3.ibm.com/services/learning/

    Refer to the IBM IT Education Services Web site for information on course locations and availability dates.

    Contact your IBM representative for course information.

    Offering Information

    Product information is available via the Offering Information Web site

    http://www.ibm.com/common/ssi

    Also, visit the Passport Advantage Web site

    http://www.ibm.com/software/passportadvantage

    Publications

    No publications are shipped with this product.

    The IBM Publications Center

    http://www.ibm.com/shop/publications/order

    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. Payment options for orders are via credit card (in the U.S.) or customer number for 50 countries. A large number of publications are available online in various file formats, and they can all be downloaded by all countries free of charge.

    The IBM Publications Notification System (PNS)

    http://service5.boulder.ibm.com/pnsrege.nsf/messages/welcome

    PNS enables subscribers to set up profiles of interest by order number/product number. PNS subscribers automatically receive e-mail notifications of all new publications defined in their profiles. These may then be ordered/downloaded from the Publications Center.

    The PNS site is available in English and Canadian French. 

    Title                             Form Number
--------------------------------- ---------------------------------
DB2 OLAP Server Installation      SC18-9205
 Guide (for English-only GA;
 also, will be updated to -01
 level for NLV GA)
OLAP Miner User's Guide           SC27-1611
 (Reshipping the V8.1 edition,
 but OLAP Miner itself is being
 called "V8.1.2."
Analytical Services New Features  SC18-9206
Analytical Services Spreadsheet   SC18-9207
 Add-in User's Guide for Excel
Analytical Services Database      SC18-9208
 Administrator's Guide.
Analytical Services SQL           SC18-9209
 Interface Guide
Integration Services New          SC18-9210
 Features
Integration Services              SC18-9211
 Administration Guide
Integration Services Data         SC18-9212
 Preparation Guide
Integration Services XML          SC18-9213
 Import/Export OLAP Model DTD
 definition
Integration Services XML          SC18-9214
 Import/Export OLAP Metaoutline
 DTD definition
Administration Services           SC18-9215
 Installation Guide
Deployment Services Installation  SC18-9216
 Guide
Spreadsheet Services              SC18-9276
 Installation Guide
Analytical Services Technical
 Reference (html only)
Analytical Services Message
 Reference (html only)
Analytical Services API
 Reference (html only)

    Technical Information

    Specified Operating Environment

    Hardware requirements::  

    DB2 OLAP Server - Platforms

    • Processor/Version/Platform

      • Pentium, and higher, computers for Windows 2000, Windows XP Professional (Personal Edition only) and Windows 2003

      • AIX 5L (V5.1, V5.2) on RS/6000 Power PC computers
        Note: AIX 5L ML1 and ML4 are not supported

      • HP-UX 11.0/11i on PA-RISC computers

      • Red Hat Linux AS 2.1 for Intel

      • Sun Solaris 8/9 (Sun OS 5.8/5.9)

    • RAM:

      • Windows: 64 MB

      • UNIX and Linux: 128 MB minimum (256 or more MB recommended)

    • Disk space:

      • Windows: Approximately 260 MB for server components and sample application.

      • AIX: 665 MB is required (600 MB for software + 65 MB for sample application).

      • HP-UX: 665 MB is required (600 MB for software + 65 MB for sample applications).

      • Linux: 375 MB required (310 MB for software + 65 MB for sample application).

      • Solaris: 306 MB required (188 MB for software + 118 MB for sample applications).

    DB2 OLAP Integration Server - Platforms

    • Processor/Version/Platform

      • Pentium, or higher, computers for Windows 2000, Windows XP, and Windows 2003 - server and clients

      • AIX 5L (V5.1, V5.2) on RS/6000 Power PC computers - server only
        Note: AIX 5L ML1 and ML4 are not supported

      • HP-UX 11i (only) on PA-RISC computers - server only

      • Red Hat Linux AS 2.1 for Intel - server only

      • Sun Solaris 8/9 (Sun OS 5.8/5.9) - server only

    • RAM:

      • Windows: 64 MB minimum

      • UNIX and Linux: 256 MB minimum

    • Disk space (server only):

      • Total disk space required:

        • 105 MB total (without Hybrid Analysis or Unicode sample application)

        • 125 MB total (after Hybrid Analysis sample data is loaded)

        • 155 MB total (after Hybrid Analysis and Unicode sample data is loaded)

      • Optional items requiring disk space:

        • 4 MB for Integration Server PDF documentation

        • 11 MB for DataDirect ODBC drivers and PDF documentation

    • Disk space (console and shell clients only):

      • 42 MB total (20 MB for console and common files + 22 MB for Java and Jar files

      • 4 MB for Integration Server PDF documentation

    DB2 OLAP Server Administration Services - Platforms

    • Processor/Version/Platform

      • Pentium, or higher, computers for Windows 2000 and Windows 2003 - server only

      • Pentium, or higher, computers for Windows 2000, Windows XP and Windows 2003 - client only

      • AIX 5L (V5.1, V5.2) on RS/6000 Power PC computers - server only
        Note: AIX 5L ML1 and ML4 are not supported

      • HP-UX 11.0/11i on PA-RISC computers - server only

      • Red Hat Linux AS 2.1 for Intel - server only

      • Sun Solaris 8/9 (Sun OS 5.8/5.9) - server only

    • RAM (server):

      • Startup memory: 38 MB (16 MB initial heap + 22 MB for code)

      • Working memory: 32 MB * maximum number of request processing threads in Administration Server

        • Note: The default maximum number of processors is 10.

      • Outline memory: 1 KB per member for outlines open for editing (This memory is used by the outline API cache when outlines are opened in Outline Editor)

      • -Xmx parameter in adminsvr.lax; the default value is 128 MB (Recommended value = initial heap memory + working memory)

    • RAM (client):

      • Startup memory: 57 MB (consists of 32 MB initial heap + 25 MB for code)

      • Working memory: 64 MB per connected DB2 OLAP Server

      • Outline memory: 1 KB per visible member (A member is visible if its parent is expanded in Outline Editor or Outline Viewer)

      • -Xmx parameter in admincon.lax. The default value is 256 MB (Recommended value = initial heap memory + working memory)

    • Disk space:

      • 180 MB minimum (server)

      • 90 MB minimum (includes Java Development Kit) (client)

    DB2 OLAP Server Spreadsheet Services - Platforms

    • Processor/Version/Platform

      • Pentium, or higher, computers for Windows 2000 and Windows 2003 - server only

      • Pentium, or higher, computers for Windows 2000 and Windows XP - client only

      • AIX 5L (V5.1, V5.2) on RS/6000 Power PC computers - server only Note: AIX 5L ML1 and ML4 are not supported

      • HP-UX 11i on PA-RISC computers - server only

      • Red Hat Linux AS 2.1 for Intel - server only

      • Sun Solaris 8/9 (Sun OS 5.8/5.9) - server only

    • RAM (Server):

      • Windows: 128 MB (16 MB initial heap + 22 MB for code)

      • UNIX and Linux: 128 MB

    • Disk Space:

      • Windows: 70 MB (including server software, API, sample applications and documentation, DB2 OLAP Server libraries and Java Runtime Environment) (server)

      • UNIX and Linux: 50 MB (including server software, API, sample applications and documentation, DB2 OLAP Server libraries and Java Runtime Environment) (server)

    DB2 OLAP Server Deployment Services Platforms

    • Processor/Version/Platform

      • Pentium, or higher, computers for Windows 2000 and Windows 2003 - server only

      • Pentium, or higher, computers for Windows 2000 and Windows XP - client only

      • AIX 5L (V5.1, V5.2) on RS/6000 Power PC computers - server only
        Note: AIX 5L ML1 and ML4 are not supported

      • HP-UX 11i on PA-RISC computers - server only

      • Red Hat Linux AS 2.1 for Intel - server only

      • Sun Solaris 8/9 (Sun OS 5.8/5.9) - server only

    • RAM: 128 MB

    • Disk space: 148 MB (including server software, API, sample applications and documentation, DB2 OLAP Server libraries and Java Runtime Environment) (server)

    DB2 OLAP Server Spreadsheet Add-in for Excel and Runtime Client - Platforms

    • Processor: Pentium, or higher, computers for Windows 2000, Windows XP, and Windows 2003

    • RAM:

      • 16 MB for Spreadsheet Add-in

      • 32 MB for Runtime Client

    • Disk space:

      • 16.7 MB for Spreadsheet Add-In

      • 14 MB for Runtime client

    DB2 OLAP API Client Development Platforms

    • Processor

      • Pentium, or higher, computers for Windows 2000 and Windows 2003

      • PowerPC computers, including RS/6000 for AIX 5L (V5.1/V5.2)

      • Sun SPARC or ULTRASPARC computers for Sun Solaris 8/9 (Sun OS 5.8/5.0)

      • HP PA-RISC for HP-UX 11.0/11i

      • Red Hat Enterprise Linux AS 2.1 for Intel Microprocessor based computers

    • RAM:

      • 64 MB (128 MB, or more, recommended) for Windows XP and Windows 2000

      • Physical memory: 64 MB (256 MB recommended) for AIX, HP-UX, and Solaris platforms

    • Disk space:

      • 15 MB for 32-bit DB2 OLAP API on Windows XP and Windows 2000

      • 14 MB for AIX, HP-UX, and Solaris platforms

    Software requirements:  

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

    DB2 OLAP Server Support

    • Operating system

      • Windows 2000 SP3 and Windows 2003

      • Windows XP Professional (Personal DB2 OLAP Server only)

      • AIX 5L (V5.1/V5.2)
        Note: AIX 5L ML1 and ML4 are not supported

      • Sun Solaris 8/9 (Sun OS 5.8/5.9)

      • HP-UX 11.0/11i

      • RedHat Linux AS 2.1

    • Network protocol: TCP/IP

    • Java Platform: Java Runtime Environment V1.4.1

    DB2 OLAP Integration Server Platforms

    • Operating System

      • Windows 2000 sp3, Windows XP and Windows 2003 - server and clients

      • AIX 5L (V5.1/V5.2) - server only

      • Sun Solaris 8/9 (Sun OS 5.8/5.9) - server only

      • HP-UX 11i (Note: DB2 OLAP Integration Server is a 32-bit application) - server only

      • RedHat Linux AS 2.1 - server only

    • Network protocol: TCP/IP

    • Java Platform (server only)

      • JRE 1.3.1 is shipped with AIX and is required for the XML import export feature only

      • JRE 1.4.1 is shipped with HPUX, Solaris and Linux platforms and is required for the XML import export feature only

    DB2 OLAP Server Administration Services Platforms

    • Operating Systems

      • Windows 2000 sp3 and Windows 2003 (server only)

      • Windows 2000 sp3, Windows XP and Windows 2003 (console only)

      • AIX 5L (V5.1/V5.2) (server only)

      • Sun Solaris 8/9 (Sun OS 5.8/5.9) (server only)

      • HP-UX 11.0/11i (server only)

      • RedHat Linux AS 2.1 (server only)

    • Network protocol: TCP/IP

    • RDBMS:

      • IBM DB2 7.2/8.1

      • Oracle 8i and 9i

    • Application server:

      • IBM Websphere 5.1

      • Apache Tomcat Server 4.1.30

      • BEA WebLogic Server 8.1

    • JRE: Java Runtime Environment V1.4.1

    DB2 OLAP Server Spreadsheet Services Platforms

    • Operating System (Middle Tier)

      • Windows 2000 SP3 and windows 2003

      • AIX 5L (V5.1/V5.2)

      • Sun Solaris 8/9 (Sun OS 5.8/5.9)

      • HP-UX 11i

      • RedHat Linux AS/ES/WS 2.1 for Intel

    • Operating System (Client)

      • Windows 2000 SP3 and Windows XP Professional

    • Application Server Support

      • Websphere 5.0 (5.0.1 for Solaris) / 5.1

      • Weblogic Server 7.0 sp2, 8.1 sp2

      • Apache Tomcat 4.1.30

      • Sun ONE 7.0

    • Network Protocol: HTTP/1.1 and HTTPS

    • JRE: Java Runtime Environment V1.4.1 (Build 2)

    • Spreadsheet Support: Excel 2003, Excel 2002 (OFfice XP), Excel 2000 and Lotus 9.7 (only when using version V8.1 FP4 (Hyperion 6.5.5.3) or, later, of add-in)

    DB2 OLAP Server Deployment Services Platforms

    • Operating System

      • Windows 2000 sp3 and Windows 2003 (client only)

      • Windows 2000 sp3 and Windows XP (middle tier)

      • AIX 5L (V5.1/V5.2) (middle tier)

      • Sun Solaris 8/9 (Sun OS 5.8/5.9) (middle tier)

      • HP-UX 11i (middle tier)

      • RedHat Linux AS/ES/WS 2.1 for Intel (middle tier)

    • Application Server Support

      • Websphere 5.0 (5.0.1 for Solaris) / 5.1

      • Weblogic Server 7.0 sp2 and 8.1

      • Apache Tomcat 4.1.30

      • Sun ONE 7.0

    • Network Protocol: TCP/IP, HTTP/1.1 and HTTPS

    • JRE: Java Runtime Environment V1.4.1

    • RDBMS:

      • DB2 UDB 7.2 Fix Pack 7 and DB2 UDB V8.1

      • Oracle 9.2.0.1 and 8.1.7

    DB2 OLAP Server Spreadsheet Add-in for Excel and Runtime Client Support

    • Operating system:

      • Windows 2000, Windows XP and Windows 2003

    • Spreadsheet version (for Spreadsheet Add-in)

      • Excel 2003

      • Excel 2002 (Office XP)

      • Excel 2000

      • Lotus 9.7 (only when using version V8.1 FP4 (Hyperion 6.5.5.3) or, later, of add-in)

    • Network protocol: TCP/IP

    DB2 OLAP Server API Client Development Platforms

    • Operating Systems:

      • Windows 2000 sp3 and Windows 2003

      • AIX 5L (V5.1/V5.2)

      • Sun Solaris 8/9 (Sun OS 5.8/5.9)

      • HP-UX 11.0/11i

      • RedHat Linux AS 2.1

      • RedHat Linux AS/ES/WS 2.1 for Intel (middle tier)

    DB2 OLAP Server Miner Platforms

    • Operating Systems (server):

      • Windows 2000, Windows XP Professional

      • AIX 5L (V5.1/V5.2)

    • Operating Systems (client):

      • Windows 2000, and Windows XP Professional

    Compatibility

    DB2 OLAP Server

    DB2 OLAP Server V8.2 is backward-compatible with V8.1 (including Spreadsheet Add-in, Application Manager), with the following restrictions:

    • V8.1 clients must be installed on a different computer from the computer on which DB2 OLAP Server V8.2 is installed

    • V8.1 clients must be at the V8.1 Fix pack 2, or later, level

    • V8.1 clients can connect only to V8.2 non-Unicode applications

    • DB2 OLAP Server Application Manager V8.1 cannot edit non-Unicode V8.2 rules files

    • DB2 OLAP Server Application Manager V8.1 does not work with aggregate storage

    • Supported API Versions:

      • Programs compiled with DB2 OLAP Server V8.2 API do not work with DB2 OLAP Server V8.1.

      • DB2 OLAP Server API programs compiled with header files from a specific release must use the libraries from the same release.

    For information regarding compatibility between DB2 OLAP Server V8.2 and DB2 OLAP Analyzer V8.1 (as well as DB2 OLAP Server Analyzer Windows Client V8.1), refer to http://www.ibm.com/software/data/db2/db2olap/fixpacks.html.
    DB2 OLAP Integration Server

    DB2 OLAP Server Integration Server V8.2 is backward-compatible with DB2 OLAP Server V8.1, Fix Pack 3, or later, with the following restriction: to use the current Hybrid Analysis features or Unicode, you must connect to DB2 OLAP Server V8.2.
    DB2 OLAP Administration Services

    DB2 OLAP Server Adminstration Services V8.2 is backward-compatible with DB2 OLAP Server V8.1 Fix pack 1 or later, including Fix Pack 1, Refresh#2 (the Linux platform release for DB2 OLAP Server V8.1), with the following restrictions:

    • Although you can connect to an earlier release of DB2 OLAP Server, you cannot use features introduced in later releases of DB2 OLAP Server.

    • When you upgrade to a new release of DB2 OLAP Server Administration Services, you must upgrade both the Administration Server and Administration Services Console.

    DB2 OLAP Server Spreadsheet Services

    DB2 OLAP Server Spreadsheet Services V8.2 is backward-compatible with DB2 OLAP Server V8.1.
    DB2 OLAP Server Deployment Services

    DB2 OLAP Server Deployment Services V8.2 is backward-compatible with DB2 OLAP Server V8.1.
    DB2 UDB

    DB2 OLAP Server V8.2 and its components are interoperable with Fix Pack 2 and higher levels of DB2 UDB V8.1.
    Websphere Application Server

    DB2 OLAP Server V8.2 and its components are interoperable with WebSphere Application Server, V5.0 (5.0.1 for Solaris) and WebSphere 5.1.

    Limitations

    DB2 OLAP Server V8.2 for English (and the related English-Only features/functions/components) will be Generally Available electronically on July 30, 2004, and physically on August 27, 2004. Customers who desire the Localization version, for use in any other language, will need to wait until the Localization version is Generally Available electronically on September 30 2004. The Localization version will be become Generally Available physically on November 12, 2004.

    Planning Information

    Customer Responsibilities

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

    Only the English-language version of DB2 OLAP Server will be available until September 30, 2004. Therefore customers who would like to download, order or install the Globalization version of DB2 OLAP Server, should wait until September 30, 2004 before purchasing or upgrading to DB2 OLAP Server V8.2.

    Installability

    When upgrading to the latest version of DB2 OLAP Server, keep the following in mind:

    DB2 OLAP Server, V8.2 includes a copy of DB2 Universal Database V8 for use only with DB2 OLAP Server. If you want to use this version of DB2 UDB with DB2 OLAP Server, you must apply a fix pack: Fix Pack 2 (or later) of DB2 UDB, V8. You can download this fix pack from the following Web site: http://www.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/down load.d2w/report

    Software Maintenance, previously referred to as Subscription and Technical Support, is now included in the Passport Advantage Agreement. Installation and technical support for the product(s) announced in this letter are 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.

    Packaging

    Media Packs:

    • Standard Edition
      Multi Language (including English) CD-ROMs with license information and documentation for the server and for the four optional programs:

      • DB2 OLAP Server Integration Server for Standard Edition V8.2

      • DB2 OLAP Server Partitioning Option for Standard Edition V8.2

      • DB2 OLAP Server High Concurrency Option for Standard Edition V8.2

      • DB2 OLAP Server Tools Bundle for Standard Edition V8.2
    • Developer's Edition
      Multi Language (including English) CD-ROMs with license information and documentation for the server and for the two optional programs:

      • DB2 OLAP Server Integration Server for Developer's Edition V8.2

      • DB2 OLAP Server Partitioning Option for Developer's Edition V8.2
    • Personal Edition
      Multi Language (including English) CD-ROMs with license information and documentation for the server and for the three optional programs.

      • DB2 OLAP Server Integration Server for Personal Edition V8.2

      • DB2 OLAP Server Partitioning Option for Personal Edition V8.2

      • DB2 OLAP Server Tools Bundle for Personal Edition V8.2
    • Spreadsheet Services
      Multi Language (including English) CD-ROMs with license information and documentation for the server.

    This program, when downloaded from a Web site, contains the applicable IBM license agreement and License Information (LI), if appropriate. It will be presented for acceptance at the time of installation of the program. The license and LI will be stored in a directory such as LICENSE.TXT for future reference.

    Security, Auditability and Control

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

    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 can only be ordered by part numbers. The preferred customer ordering route for IBM WorkStation Software is via remarketers. Refer to Announcement Letters ZA99-0208 and ZA99-0231 for more information on the ordering process for IBM WorkStation Software.

    For ordering information on this product, consult your authorized IBM Business Partner or refer to the information on the following IBM Web site

    http://www.lotus.com/services/passport.nsf/WebDocs/Passport_Advantage_ Home

    Product information 

    Licensed function      Product group          Product category
title
---------------------- ---------------------- ---------------------
DB2 OLAP Integration   IBM Database           Database Management
 Server                 Management Other       Other
DB2 OLAP Server High   IBM Database           Database Management
 Concurrency Standard   Management Other       Other
 Edition
DB2 OLAP Server Tools  IBM Database           Database Management
 Bundle Standard        Management Other       Other
 Edition
DB2 OLAP Server        IBM Database           Database Management
 Standard Edition       Management Other       Other
DB2 OLAP Server        IBM Database           Database Management
 Partitioning Option    Management Other       Other
 Standard Edition
DB2 OLAP Server        IBM Database           Database Management
 Partitioning Option    Management Other       Other
 Developer Ed
DB2 OLAP Server        IBM Database           Database Management
 Developers Edition     Management Other       Other
DB2 OLAP Server        IBM Database           Database Management
 Integration Server     Management Other       Other
 for Developer's
 Edition
DB2 OLAP Server Tools  IBM Database           Database Management
 Bundle Personal        Management Other       Other
 Edition
DB2 OLAP Integration   IBM Database           Database Management
 Server Personal        Management Other       Other
 Edition
DB2 OLAP Server        IBM Database           Database Management
 Personal Edition       Management Other       Other
DB2 OLAP Server        IBM Database           Database Management
 Partitioning Option    Management Other       Other
 Personal Edition
IBM DB2 OLAP Server    IBM Database           Database Management
 Spreadsheet Services   Management Other       Other

    DB2 OLAP Server V8.2 is available in three editions, plus Spreadsheet Services:

    • DB2 OLAP Server Standard Edition V8.2 has two charge units for "installs" and "concurrent users".
      It has four optional components each with a single charge unit of "installs".

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

    • DB2 OLAP Server Personal Edition V8.2 has one charge unit for "installs".
      It has three optional components each with a single charge unit of "installs".

    • DB2 OLAP Server Spreadsheet Services has two charge units for "installs" and "users".

    Passport Advantage program licenses

    DB2 OLAP Server 

    Part description                  Part number
--------------------------------- ---------------------------------
DB2 OLAP INTEGRATION SERVER
 PERSONAL EDITION
DB2 OLAP Svr Personal Ed          D5B3CLL
 Integration Server Install Lic 1
 SW Maint 12 Mo
DB2 OLAP Svr Pers Ed Integration  D5B3FLL
 Svr Install SW Maint
 Reinstatement 12 Mo
DB2 OLAP Svr Personal Ed          E1B3ELL
 Integration Server Install SW
 Maint Annual Renewal

    DB2 OLAP Server 

    Part description                  Part number
--------------------------------- ---------------------------------
DB2 OLAP SERVER TOOLS BUNDLE
 PERSONAL EDITION
DB2 OLAP Personal Edition Tools   E1B36LL
 Bundle Install SW Maint Annual
 Renewal
DB2 OLAP Personal Edition Tools   D5B34LL
 Bundle Install Lic & SW Maint 12
 Mo
DB2 OLAP Personal Edition Tools   D5B37LL
 Bundle Install SW Maint
 Reinstatement 12 Mo

    DB2 OLAP Server 

    Part description                  Part number
--------------------------------- ---------------------------------
DB2 OLAP SERVER INTEGRATION
 SERVER FOR DEVELOPER'S EDITION
DB2 OLAP Developer Ed             E0080LL
 Integration Server Install SW
 Maint Annual Renewal
DB2 OLAP Developer Edition        D50X3LL
 Integration Server Install Lic 1
 SW Maint 12 Mo
DB2 OLAP Developer Ed             D50X5LL
 Integration Svr Install SW Maint
 Reinstatement 12 Mo

    DB2 OLAP Server 

    Part description                  Part number
--------------------------------- ---------------------------------
IBM DB2 OLAP SERVER SPREADSHEET
 SERVICES
DB2 OLAP Server Spreadsheet       D526TLL
 Services User SW Maint
 Reinstatement 12 Mo
DB2 OLAP Server Spreadsheet       D526QLL
 Services Install SW Maint
 Reinstatement 12 Mo
DB2 OLAP Server Spreadsheet       E00P0LL
 Services User SW Maint Annual
 Renewal
DB2 OLAP Server Spreadsheet       D526RLL
 Services User Lic & SW Maint 12
 Mo
DB2 OLAP Server Spreadsheet       D526NLL
 Services Install Lic & SW Maint
 12 Mo
DB2 OLAP Server Spreadsheet       E00NZLL
 Services Install SW Maint Annual
 Renewal

    DB2 OLAP Server 

    Part description                  Part number
--------------------------------- ---------------------------------
DB2 OLAP SERVER PARTITIONING
 OPTION PERSONAL EDITION
DB2 OLAP Personal Ed              E1B2QLL
 Partitioning Option Install SW
 Maint Annual Renewal
DB2 OLAP Personal Ed              D5B2NLL
 Partitioning Option Install Lic
 & SW Maint 12 Mo
DB2 OLAP Pers Ed Partitioning     D5B2RLL
 Option Install SW Maint
 Reinstatement 12 Mo

    DB2 OLAP Server 

    Part description                  Part number
--------------------------------- ---------------------------------
DB2 OLAP SERVER PERSONAL EDITION
DB2 OLAP Server Personal Edition  E1B2YLL
 Install SW Maint Annual Renewal
DB2 OLAP Server Personal Edition  D5B2WLL
 Install Lic & SW Maint 12 Mo
DB2 OLAP Server Personal Edition  D5B2ZLL
 Install SW Maint Reinstatement
 12 Mo

    DB2 OLAP Server 

    Part description                  Part number
--------------------------------- ---------------------------------
DB2 OLAP SERVER DEVELOPERS
 EDITION
DB2 OLAP Server Developer         D5B1LLL
 Edition Conc User SW Maint
 Reinstatement 12 Mo
DB2 OLAP Server Developer         D50YXLL
 Edition Install SW Maint
 Reinstatement 12 Mo
DB2 OLAP Server Developer         E1B1KLL
 Edition Concurrent User SW Maint
 Annual Renewal
DB2 OLAP Server Developer         D5B1ILL
 Edition Conc User Lic & SW Maint
 12 Mo
DB2 OLAP Server Developer         D50YVLL
 Edition Install Lic & SW Maint
 12 Mo
DB2 OLAP Server Developer         E008KLL
 Edition Install SW Maint Annual
 Renewal

    DB2 OLAP Server 

    Part description                  Part number
--------------------------------- ---------------------------------
DB2 OLAP SERVER TOOLS BUNDLE
 STANDARD EDITION
DB2 OLAP Server Tools Bundle Std  E1B4BLL
 Ed Install SW Maint Annual
 Renewal
DB2 OLAP Server Tools Bundle      D5B49LL
 Standard Ed Install Lic & SW
 Maint 12 Mo
DB2 OLAP Server Tools Bundle Std  D5B4CLL
 Ed Install SW Maint
 Reinstatement 12 Mo

    DB2 OLAP Server 

    Part description                  Part number
--------------------------------- ---------------------------------
DB2 OLAP SERVER HIGH CONCURRENCY
 STANDARD EDITION
DB2 OLAP Server High Concurrency  E007WLL
 Std Ed Install SW Maint Annual
 Renewal
DB2 OLAP Server High Concurrency  D50WPLL
 Standard Ed Install Lic & SW
 Maint 12 Mo
DB2 OLAP Server High Concurrency  D50WRLL
 Std Ed Install SW Maint
 Reinstatemnt 12 Mo

    DB2 OLAP Server 

    Part description                  Part number
--------------------------------- ---------------------------------
DB2 OLAP INTEGRATION SERVER
DB2 OLAP Server Integration       E1B1TLL
 Server Std Ed Install SW Maint
 Annual Renewal
DB2 OLAP Server Integration       D5B1RLL
 Server Std Ed Install Lic & SW
 Maint 12 Mo
DB2 OLAP Svr Integration Svr Std  D5B1ULL
 Ed Installs SW Maint
 Reinstatement 12 Mo

    DB2 OLAP Server 

    Part description                  Part number
--------------------------------- ---------------------------------
DB2 OLAP SERVER PARTITIONING
 OPTION DEVELOPER ED
DB2 OLAP Developer Ed             D50X0LL
 Partitioning Option Install Lic
 & SW Maint 12 Mo
DB2 OLAP Dev Ed Partitioning      D50X2LL
 Option Install SW Maint
 Reinstatement 12 Mo
DB2 OLAP Dev Ed Partitioning      E007ZLL
 Option Install SW Maint Annual
 Renewal

    DB2 OLAP Server 

    Part description                  Part number
--------------------------------- ---------------------------------
DB2 OLAP SERVER PARTITIONING
 OPTION STANDARD EDITION
DB2 OLAP Svr Partitioning Option  E1B29LL
 Std Ed Install SW Maint Annual
 Renewal
DB2 OLAP Server Partitioning      D5B27LL
 Option Std Ed Install Lic & SW
 Maint 12 Mo
DB2 OLAP Svr Partitioning Option  D5B2ALL
 Std Ed Install SW Mnt
 Reinstatement 12 Mo

    DB2 OLAP Server 

    Part description                  Part number
--------------------------------- ---------------------------------
DB2 OLAP SERVER STANDARD EDITION
DB2 OLAP Server Standard Edition  D5B3KLL
 Install Lic & SW Maint 12 Mo
DB2 OLAP Server Standard Edition  E1B3MLL
 Install SW Maint Annual Renewal
DB2 OLAP Server Standard Edition  E1B3VLL
 Conc User SW Maint Annual
 Renewal
DB2 OLAP Server Standard Edition  D5B3TLL
 Conc User Lic & SW Maint 12 Mo
DB2 OLAP Server Standard Edition  D5B3WLL
 Conc User SW Maint Reinstatement
 12 Mo
DB2 OLAP Server Standard Edition  D5B3NLL
 Install SW Maint Reinstatement
 12 Mo

    Passport Advantage supply 

    Program name/description          Part number
--------------------------------- ---------------------------------
DB2 OLAP SERVER DEV ED V8.2.0
Media Pack English US Windows     BB0JXNA
 2000, Windows XP, Solaris (SUN
 Microsystems), Windows Server
 2003, AIX V5.x, HP-UX 11.x,
 Linux for x86Series Intel-based
 servers CD-ROM Digital Disk -
 ISO 9660 Standard V8.2.0
Media Pack Multilingual(French,   BB0JUML
 Danish, Russian, Korean, Chinese
 - Simplified, Spanish, Norwegian
 Bokmal, Brazilian Portuguese,
 German, Swedish, Japanese,
 Chinese - Traditional,
 Hungarian, English US, Czech,
 Italian, Finnish, Polish)
 Windows 2000, Windows XP,
 Solaris (SUN Microsystems),
 Windows Server 2003, AIX V5.x,
 HP-UX 11.x CD-ROM Digital Disk -
 ISO 9660 Standard V8.2.0
DB2 OLAP SERVER PERS ED V8.2.0
Media Pack English US Windows     BB0JYNA
 2000, Windows XP, Windows Server
 2003 CD-ROM Digital Disk - ISO
 9660 Standard V8.2.0
Media Pack Multilingual(French,   BB0JVML
 Danish, Russian, Korean, Chinese
 - Simplified, Spanish, Norwegian
 Bokmal, Brazilian Portuguese,
 German, Swedish, Japanese,
 Chinese - Traditional,
 Hungarian, English US, Czech,
 Italian, Finnish, Polish)
 Windows 2000, Windows XP,
 Windows Server 2003 CD-ROM
 Digital Disk - ISO 9660 Standard
 V8.2.0
DB2 OLAP SERVER STD ED V8.2.0
Media Pack English US Windows     BB0JZNA
 2000, Windows XP, Solaris (SUN
 Microsystems), Windows Server
 2003, AIX V5.x, HP-UX 11.x,
 Linux for x86Series Intel-based
 servers CD-ROM Digital Disk -
 ISO 9660 Standard V8.2.0
Media Pack Multilingual(French,   BB0JWML
 Danish, Russian, Korean, Chinese
 - Simplified, Spanish, Norwegian
 Bokmal, Brazilian Portuguese,
 German, Swedish, Japanese,
 Chinese - Traditional,
 Hungarian, English US, Czech,
 Italian, Finnish, Polish)
 Windows 2000, Windows XP,
 Solaris (SUN Microsystems),
 Windows Server 2003, AIX V5.x,
 HP-UX 11.x, Linux for x86Series
 Intel-based servers CD-ROM
 Digital Disk - ISO 9660 Standard
 V8.2.0
DB2 OLAP SVR SPRDSHT SVC V8.2.0
Media Pack English US Windows     BB0K7NA
 2000, Windows XP, Solaris (SUN
 Microsystems), Windows Server
 2003, AIX V5.x, HP-UX 11.x,
 Linux for x86Series Intel-based
 servers CD-ROM Digital Disk -
 ISO 9660 Standard V8.2.0
Media Pack Multilingual(French,   BB0K7ML
 Danish, Russian, Korean, Chinese
 - Simplified, Spanish, Norwegian
 Bokmal, Brazilian Portuguese,
 German, Swedish, Japanese,
 Chinese - Traditional,
 Hungarian, English US, Czech,
 Italian, Finnish, Polish)
 Windows 2000, Windows XP,
 Solaris (SUN Microsystems),
 Windows Server 2003, AIX V5.x,
 HP-UX 11.x, Linux for x86Series
 Intel-based servers CD-ROM
 Digital Disk - ISO 9660 Standard
 V8.2.0

    Passport Advantage customer: media pack entitlement details

    Customers with active maintenance or subscription for the products listed are entitled to receive the corresponding media pack.

    DB2 OLAP Server Dev Ed V8.2.0 

    Entitled Maintenance   Media Packs            Part Number
Offerings Description  Description
---------------------- ---------------------- ---------------------
DB2 OLAP PARTITION     DB2 OLAP Server Dev    BB0JXNA
 OPTION SVR INSTL       Ed English US Windows
                        2000, Windows XP,
                        Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP PARTITION     DB2 OLAP Server Dev    BB0JUML
 OPTION SVR INSTL       Ed
                        Multilingual(French,
                        Danish, Russian,
                        Korean, Chinese -
                        Simplified, Spanish,
                        Norwegian Bokmal,
                        Brazilian Portuguese,
                        German, Swedish,
                        Japanese, Chinese -
                        Traditional,
                        Hungarian, English
                        US, Czech, Italian,
                        Finnish, Polish)
                        Windows 2000, Windows
                        XP, Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP DEVELOPER     DB2 OLAP Server Dev    BB0JXNA
 EDITION CONC USR       Ed English US Windows
                        2000, Windows XP,
                        Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP DEVELOPER     DB2 OLAP Server Dev    BB0JUML
 EDITION CONC USR       Ed
                        Multilingual(French,
                        Danish, Russian,
                        Korean, Chinese -
                        Simplified, Spanish,
                        Norwegian Bokmal,
                        Brazilian Portuguese,
                        German, Swedish,
                        Japanese, Chinese -
                        Traditional,
                        Hungarian, English
                        US, Czech, Italian,
                        Finnish, Polish)
                        Windows 2000, Windows
                        XP, Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP DEVELOPER ED  DB2 OLAP Server Dev    BB0JXNA
 SVR INSTALL            Ed English US Windows
                        2000, Windows XP,
                        Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP DEVELOPER ED  DB2 OLAP Server Dev    BB0JUML
 SVR INSTALL            Ed
                        Multilingual(French,
                        Danish, Russian,
                        Korean, Chinese -
                        Simplified, Spanish,
                        Norwegian Bokmal,
                        Brazilian Portuguese,
                        German, Swedish,
                        Japanese, Chinese -
                        Traditional,
                        Hungarian, English
                        US, Czech, Italian,
                        Finnish, Polish)
                        Windows 2000, Windows
                        XP, Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP INTEGRATION   DB2 OLAP Server Dev    BB0JXNA
 SVR SVR INSTL          Ed English US Windows
                        2000, Windows XP,
                        Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP INTEGRATION   DB2 OLAP Server Dev    BB0JUML
 SVR SVR INSTL          Ed
                        Multilingual(French,
                        Danish, Russian,
                        Korean, Chinese -
                        Simplified, Spanish,
                        Norwegian Bokmal,
                        Brazilian Portuguese,
                        German, Swedish,
                        Japanese, Chinese -
                        Traditional,
                        Hungarian, English
                        US, Czech, Italian,
                        Finnish, Polish)
                        Windows 2000, Windows
                        XP, Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x
                        CD-ROM Digital Disk -
                        ISO 9660 Standard

    DB2 OLAP Server Pers Ed V8.2.0 

    Entitled Maintenance   Media Packs            Part Number
Offerings Description  Description
---------------------- ---------------------- ---------------------
DB2 OLAP PERS ED       DB2 OLAP Server Pers   BB0JYNA
 TOOLS BNDL             Ed English US Windows
                        2000, Windows XP,
                        Windows Server 2003
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP PERS ED       DB2 OLAP Server Pers   BB0JVML
 TOOLS BNDL             Ed
                        Multilingual(French,
                        Danish, Russian,
                        Korean, Chinese -
                        Simplified, Spanish,
                        Norwegian Bokmal,
                        Brazilian Portuguese,
                        German, Swedish,
                        Japanese, Chinese -
                        Traditional,
                        Hungarian, English
                        US, Czech, Italian,
                        Finnish, Polish)
                        Windows 2000, Windows
                        XP, Windows Server
                        2003 CD-ROM Digital
                        Disk - ISO 9660
                        Standard
DB2 OLAP PERS ED       DB2 OLAP Server Pers   BB0JYNA
 INTEGRATION SVR        Ed English US Windows
                        2000, Windows XP,
                        Windows Server 2003
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP PERS ED       DB2 OLAP Server Pers   BB0JVML
 INTEGRATION SVR        Ed
                        Multilingual(French,
                        Danish, Russian,
                        Korean, Chinese -
                        Simplified, Spanish,
                        Norwegian Bokmal,
                        Brazilian Portuguese,
                        German, Swedish,
                        Japanese, Chinese -
                        Traditional,
                        Hungarian, English
                        US, Czech, Italian,
                        Finnish, Polish)
                        Windows 2000, Windows
                        XP, Windows Server
                        2003 CD-ROM Digital
                        Disk - ISO 9660
                        Standard
DB2 OLAP PERS EDITION  DB2 OLAP Server Pers   BB0JYNA
                        Ed English US Windows
                        2000, Windows XP,
                        Windows Server 2003
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP PERS EDITION  DB2 OLAP Server Pers   BB0JVML
                        Ed
                        Multilingual(French,
                        Danish, Russian,
                        Korean, Chinese -
                        Simplified, Spanish,
                        Norwegian Bokmal,
                        Brazilian Portuguese,
                        German, Swedish,
                        Japanese, Chinese -
                        Traditional,
                        Hungarian, English
                        US, Czech, Italian,
                        Finnish, Polish)
                        Windows 2000, Windows
                        XP, Windows Server
                        2003 CD-ROM Digital
                        Disk - ISO 9660
                        Standard
DB2 OLAP PERS ED       DB2 OLAP Server Pers   BB0JYNA
 PARTITION OPT          Ed English US Windows
                        2000, Windows XP,
                        Windows Server 2003
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP PERS ED       DB2 OLAP Server Pers   BB0JVML
 PARTITION OPT          Ed
                        Multilingual(French,
                        Danish, Russian,
                        Korean, Chinese -
                        Simplified, Spanish,
                        Norwegian Bokmal,
                        Brazilian Portuguese,
                        German, Swedish,
                        Japanese, Chinese -
                        Traditional,
                        Hungarian, English
                        US, Czech, Italian,
                        Finnish, Polish)
                        Windows 2000, Windows
                        XP, Windows Server
                        2003 CD-ROM Digital
                        Disk - ISO 9660
                        Standard

    DB2 OLAP Server Std Ed V8.2.0 

    Entitled Maintenance   Media Packs            Part Number
Offerings Description  Description
---------------------- ---------------------- ---------------------
DB2 OLAP HIGH          DB2 OLAP Server Std    BB0JZNA
 CONCURRENCY SVR INSTL  Ed English US Windows
                        2000, Windows XP,
                        Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP HIGH          DB2 OLAP Server Std    BB0JWML
 CONCURRENCY SVR INSTL  Ed
                        Multilingual(French,
                        Danish, Russian,
                        Korean, Chinese -
                        Simplified, Spanish,
                        Norwegian Bokmal,
                        Brazilian Portuguese,
                        German, Swedish,
                        Japanese, Chinese -
                        Traditional,
                        Hungarian, English
                        US, Czech, Italian,
                        Finnish, Polish)
                        Windows 2000, Windows
                        XP, Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP TOOLS BNDL    DB2 OLAP Server Std    BB0JZNA
                        Ed English US Windows
                        2000, Windows XP,
                        Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP TOOLS BNDL    DB2 OLAP Server Std    BB0JWML
                        Ed
                        Multilingual(French,
                        Danish, Russian,
                        Korean, Chinese -
                        Simplified, Spanish,
                        Norwegian Bokmal,
                        Brazilian Portuguese,
                        German, Swedish,
                        Japanese, Chinese -
                        Traditional,
                        Hungarian, English
                        US, Czech, Italian,
                        Finnish, Polish)
                        Windows 2000, Windows
                        XP, Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP SVR STD ED    DB2 OLAP Server Std    BB0JZNA
 INTEGRATION SVR        Ed English US Windows
                        2000, Windows XP,
                        Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP SVR STD ED    DB2 OLAP Server Std    BB0JWML
 INTEGRATION SVR        Ed
                        Multilingual(French,
                        Danish, Russian,
                        Korean, Chinese -
                        Simplified, Spanish,
                        Norwegian Bokmal,
                        Brazilian Portuguese,
                        German, Swedish,
                        Japanese, Chinese -
                        Traditional,
                        Hungarian, English
                        US, Czech, Italian,
                        Finnish, Polish)
                        Windows 2000, Windows
                        XP, Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP SERVER STD    DB2 OLAP Server Std    BB0JZNA
 EDITION USER           Ed English US Windows
                        2000, Windows XP,
                        Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP SERVER STD    DB2 OLAP Server Std    BB0JWML
 EDITION USER           Ed
                        Multilingual(French,
                        Danish, Russian,
                        Korean, Chinese -
                        Simplified, Spanish,
                        Norwegian Bokmal,
                        Brazilian Portuguese,
                        German, Swedish,
                        Japanese, Chinese -
                        Traditional,
                        Hungarian, English
                        US, Czech, Italian,
                        Finnish, Polish)
                        Windows 2000, Windows
                        XP, Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP SERVER STD    DB2 OLAP Server Std    BB0JZNA
 EDITION INSTALL        Ed English US Windows
                        2000, Windows XP,
                        Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP SERVER STD    DB2 OLAP Server Std    BB0JWML
 EDITION INSTALL        Ed
                        Multilingual(French,
                        Danish, Russian,
                        Korean, Chinese -
                        Simplified, Spanish,
                        Norwegian Bokmal,
                        Brazilian Portuguese,
                        German, Swedish,
                        Japanese, Chinese -
                        Traditional,
                        Hungarian, English
                        US, Czech, Italian,
                        Finnish, Polish)
                        Windows 2000, Windows
                        XP, Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP PARTITION     DB2 OLAP Server Std    BB0JZNA
 OPT                    Ed English US Windows
                        2000, Windows XP,
                        Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP PARTITION     DB2 OLAP Server Std    BB0JWML
 OPT                    Ed
                        Multilingual(French,
                        Danish, Russian,
                        Korean, Chinese -
                        Simplified, Spanish,
                        Norwegian Bokmal,
                        Brazilian Portuguese,
                        German, Swedish,
                        Japanese, Chinese -
                        Traditional,
                        Hungarian, English
                        US, Czech, Italian,
                        Finnish, Polish)
                        Windows 2000, Windows
                        XP, Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard

    DB2 OLAP Svr Sprdsht Svc V8.2.0 

    Entitled Maintenance   Media Packs            Part Number
Offerings Description  Description
---------------------- ---------------------- ---------------------
DB2 OLAP Server        DB2 OLAP Svr Sprdsht   BB0K7NA
 Spreadsheet Services   Svc English US
 User                   Windows 2000, Windows
                        XP, Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP Server        DB2 OLAP Svr Sprdsht   BB0K7ML
 Spreadsheet Services   Svc
 User                   Multilingual(French,
                        Danish, Russian,
                        Korean, Chinese -
                        Simplified, Spanish,
                        Norwegian Bokmal,
                        Brazilian Portuguese,
                        German, Swedish,
                        Japanese, Chinese -
                        Traditional,
                        Hungarian, English
                        US, Czech, Italian,
                        Finnish, Polish)
                        Windows 2000, Windows
                        XP, Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP Server        DB2 OLAP Svr Sprdsht   BB0K7NA
 Spreadsheet Services   Svc English US
 Server Install         Windows 2000, Windows
                        XP, Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard
DB2 OLAP Server        DB2 OLAP Svr Sprdsht   BB0K7ML
 Spreadsheet Services   Svc
 Server Install         Multilingual(French,
                        Danish, Russian,
                        Korean, Chinese -
                        Simplified, Spanish,
                        Norwegian Bokmal,
                        Brazilian Portuguese,
                        German, Swedish,
                        Japanese, Chinese -
                        Traditional,
                        Hungarian, English
                        US, Czech, Italian,
                        Finnish, Polish)
                        Windows 2000, Windows
                        XP, Solaris (SUN
                        Microsystems),
                        Windows Server 2003,
                        AIX V5.x, HP-UX 11.x,
                        Linux for x86Series
                        Intel-based servers
                        CD-ROM Digital Disk -
                        ISO 9660 Standard

    Withdrawal of Previous Passport Advantage Part Numbers

    IBM will withdraw from marketing the following parts licensed under the IBM International Program License Agreement on the dates specified. 

    Program      Program       Part          Part number   Withdrawal
name         number        description                 from
                                                       marketing
                                                       date
------------ ------------- ------------- ------------- ------------
DB2 OLAP     5724-OLP      DB2 OLAP      BB00MJA       11/12/04
 Server                     SERVER
 V8.1.0                     DEVELOPER
                            EDITION 8.1
                            DOC PACK JPN
DB2 OLAP     5724-OLP      DB2 OLAP      BB00NJA       11/12/04
 Server                     SERVER
 V8.1.0                     PERSONAL
                            EDITION 8.1
                            DOC PACK JPN
DB2 OLAP     5724-OLP      DB2 OLAP      BB00LJA       11/12/04
 Server                     SERVER
 V8.1.0                     EDITION V8.1
                            JAPANESE DOC
                            PACK
DB2 OLAP     5724-OLP      DB2 OLAP      BB00IJA       11/12/04
 Server                     SERVER
 V8.1.0                     DEVELOPER
                            EDITION 8.1
                            PA CD MEDIA
                            PACK JPN
DB2 OLAP     5724-OLP      DB2 OLAP      BB00IKO       11/12/04
 Server                     SERVER
 V8.1.0                     DEVELOPER
                            EDITION 8.1
                            PA CD MEDIA
                            PACK KOR
DB2 OLAP     5724-OLP      DB2 OLAP      BB00ISC       11/12/04
 Server                     SERVER
 V8.1.0                     DEVELOPER
                            EDITION 8.1
                            PA CD MEDIA
                            PACK SCH
DB2 OLAP     5724-OLP      DB2 OLAP      BB00IML       11/12/04
 Server                     SERVER
 V8.1.0                     DEVELOPER
                            EDITION V8.1
                            MEDIA PACK
                            MULTILINGUAL
DB2 OLAP     5724-OLP      DB2 OLAP      BB00ITC       11/12/04
 Server                     SERVER
 V8.1.0                     DEVELOPER
                            EDITION V8.1
                            PA CD MEDIA
                            PACK TCH
DB2 OLAP     5724-OLP      DB2 OLAP      BB00JJA       11/12/04
 Server                     SERVER
 V8.1.0                     PERSONAL
                            EDITION 8.1
                            PA CD MEDIA
                            PACK JPN
DB2 OLAP     5724-OLP      DB2 OLAP      BB00JKO       11/12/04
 Server                     SERVER
 V8.1.0                     PERSONAL
                            EDITION 8.1
                            PA CD MEDIA
                            PACK KOR
DB2 OLAP     5724-OLP      DB2 OLAP      BB00JSC       11/12/04
 Server                     SERVER
 V8.1.0                     PERSONAL
                            EDITION 8.1
                            PA CD MEDIA
                            PACK SCH
DB2 OLAP     5724-OLP      DB2 OLAP      BB00JTC       11/12/04
 Server                     SERVER
 V8.1.0                     PERSONAL
                            EDITION 8.1
                            PA CD MEDIA
                            PACK TCH
DB2 OLAP     5724-OLP      DB2 OLAP      BB00JML       11/12/04
 Server                     SERVER
 V8.1.0                     PERSONAL
                            EDITION V8.1
                            MEDIA PACK
                            MULTILINGUAL
DB2 OLAP     5724-OLP      DB2 OLAP      BB0GVNA       11/12/04
 Server                     SERVER
 V8.1.0                     SPREADSHEET
                            SERVICES 8.1
                            MEDIA PACK
                            ENGLISH
DB2 OLAP     5724-OLP      DB2 OLAP      BB00HJA       11/12/04
 Server                     SERVER
 V8.1.0                     STANDARD
                            EDITION 8.1
                            PA CD MEDIA
                            PACK JPN
DB2 OLAP     5724-OLP      DB2 OLAP      BB00HKO       11/12/04
 Server                     SERVER
 V8.1.0                     STANDARD
                            EDITION 8.1
                            PA CD MEDIA
                            PACK KOR
DB2 OLAP     5724-OLP      DB2 OLAP      BB00HSC       11/12/04
 Server                     SERVER
 V8.1.0                     STANDARD
                            EDITION 8.1
                            PA CD MEDIA
                            PACK SCH
DB2 OLAP     5724-OLP      DB2 OLAP      BB00HTC       11/12/04
 Server                     SERVER
 V8.1.0                     STANDARD
                            EDITION 8.1
                            PA CD MEDIA
                            PACK TCH
DB2 OLAP     5724-OLP      DB2 OLAP      BB00HML       11/12/04
 Server                     SERVER
 V8.1.0                     STANDARD
                            EDITION V8.1
                            MEDIA PACK
                            MULTILINGUAL

    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.

    Integrated Technology Services (IBM Global Services)

    Contact your IBM Representative for the list of selected services available in your country, either as standard or customized offerings for the efficient installation, implementation and/or integration of this product.

    Pricing

    Passport Advantage

    For Passport Advantage information and charges, contact your IBM representative or authorized IBM Business Partner. Additional information is also available at

    http://www.ibm.com/software/passportadvantage

    Terms and Conditions

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

    Licensing

    IBM International Program License Agreement (IPLA). 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.

    Passport Advantage applies

    Yes and through the Passport Advantage Web site at

    http://www.ibm.com/software/passportadvantage

    AS/400 Software Subscription applies

    No

    Limited Warranty

    Yes

    Warranty:   This program has warranty for a minimum of one year from acquisition from IBM or authorized IBM Business Partner. The warranty provided to the customer, for at least one year from acquisition, is access to databases (read Web sites) for program information and FAQs, including any known fixes to defects, which the customer can download or obtain otherwise and install at leisure.

    Usage Restriction

    Yes

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

    OLAP functionality modification: 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.

    Warranty: This program has program services for a minimum of one year from the date of notification of an end to support for this Program.

    Program technical support: Technical Support of the program will be available for a minimum of three years from the general availability date, as long as your Software Maintenance is in effect. This Technical Support allows you to obtain assistance (via telephone or electronic means) from IBM for program-specific, task-oriented questions regarding the installation and operation of the program. Software Maintenance also provides you with access to updates, releases, and versions of the program. Customers will be notified, via announcement letter, of discontinuance of support with 12 months' notice. If you require additional technical support from IBM, including an extension of support beyond the discontinuance date, contact your IBM representative or Business Partner. This extension may be available for a fee.

    The DB2 OLAP Server Standard Edition V8.2, DB2 OLAP Server Personal Edition V8.2, and DB2 OLAP Server Developer's Edition V8.2 each consist of a number of packaged components as well as optional features that can be purchased separately. The program-unique terms of the DB2 OLAP Server V8.2 license supersede and replace the terms of the program unique terms for each of the individual components comprising this program.

    ** The following program-unique terms apply to DB2 OLAP Server Standard Edition V8.2:

    DB2 OLAP Server Standard Edition V8.2 includes the following components:

    • DB2 OLAP Server V8.2

    • DB2 OLAP Server Administration Services V8.2

    • DB2 OLAP Server Deployment Services V8.2 (requisite for, but does not include High-Concurrency Option)

    • DB2 Universal Database Enterprise Server Edition for Linux, UNIX, and Windows V8

    The use-based charges described here supersede any use-based charges that may appear in the licenses for each of these components. However, all other terms or restrictions described in licenses for these components continue to apply unless otherwise modified here.

    In addition, for customers and Business Partners who want to purchase additional components (features) in conjunction with their development or production use of DB2 OLAP Server, the following additional components are available:

    • DB2 OLAP Server Integration Server for Standard Edition V8.2

    • DB2 OLAP Server Partitioning Option for Standard Edition V8.2

    • DB2 OLAP Server High Concurrency Option for Standard Edition V8.2

    • DB2 OLAP Server Tools Bundle for Standard Edition V8.2 which includes the following subcomponents:

      • OLAP API

      • SQL API

      • CSLSQL API

      • Spreadsheet Add-in (Macros)

      • Currency Conversion

    • DB2 OLAP Server Spreadsheet Services

    Usage Restriction -- Use as program bundle only

    This program is comprised of various components, and the components are licensed for use solely in combination with the packaged components. None of the included components may be used, transferred, sublicensed, or redistributed individually or in any combination of components other than as a complete package consisting of each and all of the components listed here.

    Use-based charges -- Resources

    Charges for this Program are based on server install, plus the number of concurrent users that are attached or available to the DB2 OLAP Server on which it is licensed. A DB2 OLAP Server is defined as a single OLAP multi-dimensional database image across a single SMP (regardless of the number of virtual partitions) or multiple server configuration. The total number of concurrent users may not exceed the number authorized by the applicable PoEs or authorized by each program authorization acquired under Passport Advantage. If the total number exceeds the quantity in your PoEs or exceeds your program authorizations acquired under Passport Advantage, you must notify IBM or its reseller as stated in the IPLA.

    Resource and use restriction

    Single server only

    All components provided with the Program can only be installed and used with the DB2 OLAP Server for which this Program is licensed, unless otherwise authorized in the license for the individual components.

    DB2 Universal Database V8 -- Limited use only

    The copy of DB2 Universal Database V8 that is provided with the Program may only be used in conjunction with DB2 OLAP Server V8.2 to provide data warehouse/retention capability related to production and development use. If additional use is required, by programs other than DB2 OLAP Server and its associated components, additional DB2 Universal Database V8 program entitlements must be acquired.

    Limited platform support

    If the Program is acquired under the terms of an IBM offering for limited platform support (for instance, the program is acquired for use on a single platform or less than all available platforms), then the Program is licensed only for installation and use on the specific platforms or operating systems as designated by the offering terms and conditions.

    High availability/failover licensing

    In Idle Standby or Active Standby, you must acquire the correct number of program authorizations:

    • An idle standby server has DB2 OLAP Server installed on it, but that DB2 OLAP Server is not processing any end-user transactions or query workloads. The DB2 OLAP server is considered "idle" if it is used exclusively for administrative actions that assist in failover scenarios. In Idle Standby, you must license the program for one (1) server install on the Idle Standby server; no concurrent user licenses are required.

    • An active standby server has an independent, operational DB2 OLAP Server that services user transactions and queries. Because the active standby machine is used for user transactions and queries before or after a failure, it must be fully licensed. In Active Standby, you must license the Program for the server, as well as the maximum number of concurrent user connections that can be associated with the active standby server.

    Software maintenance applies: Yes

    ** The following program-unique terms apply to DB2 OLAP Server Personal Edition V8.2:

    DB2 OLAP Server Personal Edition V8.2 includes the following components:

    • DB2 OLAP Server V8.2

    • DB2 OLAP Server Administration Services V8.2

    • DB2 Universal Database Personal Edition for Linux, UNIX, and Windows V8

    DB2 OLAP Server Personal Edition is only licensed to customers who have already licensed DB2 OLAP Server Standard Edition.

    The use-based charges described here supersede any use-based charges that may appear in the licenses for each of these components. However, all other terms or restrictions described in licenses for these components continue to apply unless otherwise modified here.

    In addition, for customers and/or business partners who wish to purchase additional components (features) in conjunction with their development and/or production use of DB2 OLAP Server, the following additional components are available:

    • DB2 OLAP Server Integration Server for Personal Edition V8.2

    • DB2 OLAP Server Partitioning Option for Personal Edition V8.2

    • DB2 OLAP Server Tools Bundle for Personal Edition V8.2 which includes the following subcomponents:

      • OLAP API

      • SQL API

      • CSLSQL API

      • Spreadsheet Add-in (Macros)

      • Currency Conversion

    Usage Restriction -- Use as program bundle only

    This program is comprised of various components which are licensed for use solely in combination with the packaged components. None of the included components may be used, transferred, sublicensed or redistributed individually or in any combination of components other than as a complete package consisting of each and all of the components listed here.

    Use-based charges -- Resources

    Charges for this program are based on portable/workstation install only. A DB2 OLAP Server is defined as a single OLAP multi-dimensional database image across a single portable PC or workstation (regardless of the number of virtual partitions).

    Resource and use restriction

    Single portable/workstation only

    All components provided with the program can only be installed and used with the DB2 OLAP Server for which this program is licensed, unless otherwise authorized in the license for the individual components.

    DB2 Universal Database V8 -- Limited use only

    The copy of DB2 Universal Database Personal Edition V8 that is provided with the program may only be used in conjunction with DB2 OLAP Server V8.2 to provide data warehouse/retention capability related to production and development use. If additional use is required, by programs other than DB2 OLAP Server and its associated components, additional DB2 Universal Database V8 program entitlements must be acquired.

    Limited platform support

    If the program is acquired under the terms of an IBM offering for limited platform support (for instance, the program is acquired for use on a single platform or less than all available platforms), then that program is licensed only for installation and use on the specific platforms or operating systems as designated by the offering terms and conditions.

    High availability/failover licensing

    The DB2 OLAP Server High Concurrency Option is not available for DB2 OLAP Server Personal Edition. Therefore there is no High Availability or High Concurrency/failover option available for this edition.

    ** The following program-unique terms apply to DB2 OLAP Server Developer's Edition V8.2:

    DB2 OLAP Server Developer's Edition V8.2 includes the following components:

    • DB2 OLAP Server V8.2
    • DB2 OLAP Server Administration Services V8.2
    • DB2 OLAP Server Deployment Services V8.2 (Requisite for, but does not include High-Concurrency Option)
    • DB2 OLAP Server High Concurrency Option
    • DB2 OLAP Server Tools Bundle which includes the following subcomponents:

      • OLAP API

      • SQL API

      • CSLSQL API

      • Spreadsheet Add-in (Macros)

      • Currency Conversion
    • DB2 Universal Database for Linux, UNIX and Windows V8

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

    The use-based charges described here supersede any use-based charges that may appear in the licenses for each of these components. However, all other terms or restrictions described in licenses for these components continue to apply unless otherwise modified here.

    In addition, for customers and/or business partners who wish to purchase additional components (features) in conjunction with their development use of DB2 OLAP Server, the following additional components are available:

    DB2 OLAP Server Integration Server for Developer's Edition V8.2

    DB2 OLAP Server Partitioning Option for Developer's Edition V8.2

    DB2 OLAP Server Spreadsheet Services V8.2

    Usage Restriction -- Use as program bundle only

    This program is comprised of various components, and the components are licensed for use solely in combination with the packaged components. None of the included components may be used, transferred, sublicensed or redistributed individually or in any combination of components other than as a complete package consisting of each and all of the components listed here.

    Use-based charges -- Resources

    Charges for this program are based on server install, plus the number of concurrent users that are attached or available to the DB2 OLAP Server on which it is licensed. A DB2 OLAP Server is defined as a single OLAP multi-dimensional database image across a single SMP (regardless of the number of virtual partitions) or multiple server configuration. The total number of concurrent users may not exceed the number authorized by the applicable PoEs or authorized by each program authorization acquired under Passport Advantage. If the total number exceeds the quantity in your PoEs or exceeds your program authorizations acquired under Passport Advantage, you must notify IBM or its reseller as stated in the IPLA.

    Resource and use restriction

    Single server only

    All components provided with the program can only be installed and used with the DB2 OLAP Server for which this program is licensed, unless otherwise authorized in the license for the individual components.

    DB2 Universal Database V8 Limited use only

    The copy of DB2 Universal Database Developer's Edition V8 that is provided with the program may only be used in conjunction with DB2 OLAP Server Developer's Edition V8.2 to provide data warehouse/retention capability related to production and development use. If additional use is required, by programs other than DB2 OLAP Server and its associated components, additional DB2 Universal Database V8 program entitlements must be acquired.

    Limited platform support

    If the program is acquired under the terms of an IBM offering for limited platform support (for instance, the program is acquired for use on a single platform or less than all available platforms), then that program is licensed only for installation and use on the specific platforms or operating systems as designated by the offering terms and conditions.

    High availability/failover licensing

    The DB2 OLAP Server High Concurrency Option is not available for sale with DB2 OLAP Server Developer's Edition as it is already included in the purchase of the base Developer's Edition license. Therefore there is no High Availability or High Concurrency/failover option available for this edition.

    Software Maintenance Applies

    Volume Orders

    No

    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.

    Educational Allowance

    Education Allowance does not apply.

    Education Software Allowance does not apply.

    Special education prices are available for qualified customers through Passport Advantage.

    Announcement Countries

    All European, Middle Eastern and African Countries except:

    • Sudan
    • Iran
    • Lybian Arab Republic
    • Iraq
    • Syria

    The data in this letter is subject to the disclaimer in Letter ZS90-0112, which is available from the same IBM announcement letters database.

    This announcement is provided for your information only. For additional information, please contact your IBM Representative or IBM Business Partner as appropriate.

    ************ End of Document ************