Software Announcement 200-086
April 18, 2000

IBM DB2 OLAP Server Version 7.1 Extends Scalability, Usability, and Performance to Your Enterprise

 ENUS200-086.PDF (90KB)


At a Glance

DB2 OLAP Server Version 7.1 takes another major step toward providing an enterprise-level OLAP solution. It:

  • Opens new analytical application areas with increased data scalability
  • Strengthens data analysis at the attribute level
  • Allows you to create an application cube on relational or multidimensional store
  • Delivers significant performance and operational improvements
  • Offers the Integration Server for easy mapping of relational and OLAP data
  • Offers the Allocations Manager for easy creation of business allocation rules
  • Comes with a copy of DB2 Universal Database Version 7.1 and supports growth from its DB2 OLAP Server Starter Kit
  • Extends your spreadsheets with a powerful OLAP query capability
  • Comes in 17 national languages for international users

For ordering, contact:

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

Overview

The DB2® OLAP Server™ is a scalable, industrial-strength Online Analytical Processing (OLAP) software that enables you to build sophisticated decision support, planning, and analysis applications for your enterprise. DB2 OLAP Server provides a fast path to turn your warehouse data into business insight. It delivers "speed of thought" query performance to a large set of online users. It is built for e-business with tools to help you quickly deploy Web-based analytical applications.

DB2 OLAP Server Version 7.1, based on Hyperion Essbase 6.0, provides significant improvements, in the areas of functionality, scalability, performance, and usability, over the previous release, DB2 OLAP Server Version 1.1.

  • Attributes, such as colors and sizes can now be defined and analyzed easily. It lets you do detail analysis without increasing the size of your cube.
  • Overall performance of system is improved. A reduction of 20% of combined Load and Calc time has been observed in internal benchmarks based on a mixture of customer applications.
  • Flexibility in storage is extended to the application level. Depending on individual application needs, the cube can be stored in either DB2® for added flexibility of SQL access, or the multidimensional storage for optimal performance.
  • Improved scalability enables analysis at much finer levels of detail with:
    • Support of large outlines
    • Enhanced concurrent operations
    • Optimized I/O operations
    • Large data export capability
  • Richer calculation functions, including statistical, allocation and forecasting, and member set functions, are added to extend application capabilities.
  • New features in Spreadsheet Add-in include the new Essbase Query Designer and support of attributes to enhance your usability and productivity.
  • DB2 OLAP Integration Server, a new add-on product to DB2 OLAP Server Version 7.1, lets you map and transfer data from relational database to OLAP cubes quickly and easily.
  • DB2 OLAP Server Allocations Manager, another new add-on product, provides a graphical interface and several commonly employed allocation methods, to decrease development and maintenance time for complex business allocations.

DB2 OLAP Server Version 7.1 is shipped with a copy of the new DB2 Universal Database® Version 7.1, which contains significant functional enhancements, including the DB2 OLAP Server Starter Kit.

DB2 OLAP Server Version 7.1 operates on Windows NT™, Windows™ 2000, AIX®, Sun Solaris, and HP-UX servers across TCP/IP networks connected to Windows and UNIX® clients. Named Pipes are also supported for the Windows operating system.

Key Prerequisites

  • At least a Pentium™ processor, or equivalent, for Windows NT 4.0 or Windows 2000
  • RS/6000® with AIX Version 4.3.3, or later
  • Sun SPARC or ULTRASPARC with Solaris 2.6 or 2.7
  • HP PA-RISC for HP-UX 11.0

Planned Availability Date

June 30, 2000 (September 29, 2000, for DB2 OLAP Server Objects V7.1 and DB2 OLAP Server Objects for the Personal Edition V7.1)

Description

What's New in DB2 OLAP Server Version 7.1

DB2 OLAP Server Version 7.1 is based on Hyperion Essbase 6.0, and contains a number of significant improvements over DB2 OLAP Server Version 1.1.

Storage Flexibility at Application Level : DB2 OLAP Server Version 7.1 further extends the flexibility of data storage to satisfy your application processing requirements. Based on the individual application needs, the cube can be maintained in:

  • A DB2 UDB relational database for additional SQL access
    or
  • A multidimensional store for ultimate performance

The choice of storage is transparent to the Essbase API and to many vendor tools using this API.

Sophisticated, Economical Attribute Analysis: Attributes are characteristics of your data. For example, products can have attributes such as colors, sizes, or flavors.

DB2 OLAP Server Version 7.1 provides a number of attribute-related features that help you define and store attribute information and analyze attribute data in meaningful ways.

  • You can use attribute dimensions and members in the outline to define attributes. Attribute dimensions and members are Dynamic Calc. Therefore, attribute data is not stored in the database and outlines may be smaller.
  • Through the system-defined Attribute Calculations dimension, DB2 OLAP Server provides access to five consolidations of all attribute data:
    • Sums
    • Counts
    • Averages
    • Minimums
    • Maximums
  • Flexibility at retrieval time means that viewing attribute data is optional.
  • You can create meaningful summaries of the data through crosstabs. For example, you can see the total sales of grape-flavored soda packaged in 12-ounce cans.
  • You can selectively view just the data you want to see through type-based comparisons of:
    • Text
    • Numeric
    • Boolean
    • Data
  • Optionally, you can use numeric attributes to group and summarize attribute data by ranges of values. For example, you can analyze your data by population ranges such as 0 through 1000000, 1000001 through 2000000, and so on.
  • Three new attribute-related functions are added: :ATTRIBUTE, @WITHATTR, and @ATTRIBUTEVAL. In addition, all relevant functions are enhanced to support attribute processing or calculations.

Support for Large Outlines: DB2 OLAP Server Version 7.1 supports large outlines by improving performance for outline-related operations including the following:

  • Outline editing
  • Dimension building
  • Restructuring
  • Calculating

Enhanced Concurrency for Enterprise Operations

  • Users can now log into the OLAP server and load/unload multiple applications in parallel.
  • You can speed up parallel login processing by using a new command-line parameter, quicklogin, which caches the security file and writes it to disk at specified time intervals.
  • You can perform the following tasks simultaneously:
    • Starting multiple applications.
    • Stopping multiple applications.
    • Logging on multiple users. Users can log on when an application is loading or the database is recovering.

Optimized I/O Operations: When the multidimensional storage is used, the OLAP server employs direct I/O (input/output) and no-wait I/O on most server platforms and file systems. This means the server directly caches the index and data files (page files) and is able to perform asynchronous, overlapped I/Os, providing the following benefits:

  • Faster response time. A user waits less time for the server to return data.
  • Better scalability and predictability. It is easier to determine the optimal cache sizes for the cubes.

Richer Calculation Functions

  • Member set functions
  • Statistical functions
  • Allocation and forecasting functions
  • Relationship functions
  • Date and time functions
  • Calculation method function

New Features in the Spreadsheet Add-in

  • A More Powerful Interface to Create Queries

    A new Essbase Query Designer (EQD) replaces the Retrieval Wizard to create queries for reports. This feature enables you to:

    • Design a layout for the report
    • Select members (including attributes) for the report
    • Perform member filtering
    • Perform data filtering
    • Perform data sorting
  • Support for Attributes

    You can view attributes in reports by typing the name of the attribute directly in the spreadsheet, using member selection, or using the Essbase Query Designer. You can also apply styles to attributes to identify them in the spreadsheet.

  • New Client Platforms

    The Spreadsheet Add-in supports Microsoft™ Excel 2000 and Lotus® 1-2-3® Millennium Release 9 and 9.1.

Large Data Export Capability: DB2 OLAP Server Version 7.1 imposes no limitation on the size of data files you can export. The only limitations are the maximum file size and volume size allowed by your operating and file systems. Import file size remains limited to 2 GB.

DB2 OLAP Integration Server: DB2 OLAP Integration Server 7.1 is a new add-on product, which is an enhanced version of Hyperion Integration Server 1.0.

The Integration Server enables you to map and transfer the relevant data in a relational database to an OLAP database quickly and easily. Use the Integration Server to:

  • Create a logical OLAP model from tables, views, and columns in your relational database
  • Access the OLAP model to create a metaoutline containing the structure and rules required to generate an Essbase outline
  • Access the metaoutline to create and populate an OLAP cube
  • Drill from the summarized, calculated, and derived data managed by DB2 OLAP Server into detail data stored in relational databases

New in the Integration Server are usability enhancements:

  • Easy-to-Use Assistants — to step you through the process of creating or modifying an OLAP model and a metaoutline.
  • Assistant Inline Help — explains the purpose of each tab you encounter while creating OLAP models and metaoutlines.
  • Assistant Online Help — for more detailed information about assistant tabs and functions. Windows Help for this release appears in the new WinHelp 2000 format that resembles an HTML page.
  • Task and Conceptual Overviews — for conceptual information about OLAP models or metaoutlines or to view task flow information for the assistants.
  • New Preview Options — to view filters and transformations in a sample outline. You can view a sample outline for OLAP models and metaoutlines, or the results.
  • Prefix or Suffix — to generate unique member names from columns contained in a hierarchy.

Allocations Manager: DB2 OLAP Server Allocations Manager 7.1 is another new add-on product that assists enterprise-scale business analysis by managing the complex process of allocating revenues, costs, and capital expenditures across organizations, products, and customers.

The Allocations Manager provides a graphical interface and equips users with several commonly employed allocation methods to decrease development and maintenance time for complex business allocations, reducing the dependency of end users on technical staff and freeing them to focus more time on value-added business activities.

DB2 OLAP Server Allocations Manager 7.1 is based on Hyperion Allocations Manager 1.5.

A New Release of Objects: DB2 OLAP Server Objects 7.1, based on Hyperion Objects 2.0, is available with the following improvements:

  • Support of Attributes
  • Support of Essbase Query Designer
  • Support of Microsoft Visual Basic 6.0
  • Improved serviceability of grid and chart objects

DB2 OLAP Server Objects Version 7.1 will be available on September 29, 2000.

DB2 Universal Database Version 7.1: DB2 OLAP Server Version 7.1 is shipped with a copy of the new DB2 Universal Database Version 7.1, which contains significant functional enhancements, including the DB2 OLAP Server Starter Kit.

Functionally based on DB2 OLAP Server Version 7.1, the DB2 OLAP Server Starter Kit lets users of DB2 Universal Database Version 7.1 explore online analytical capabilities before acquiring the full product, DB2 OLAP Server Version 7.1, for more complex analysis or deployment to large groups of users. Applications developed by the DB2 OLAP Server Starter Kit can continue to be extended and used in the full product.

The Information Catalog Manager, a component of the DB2 Warehouse Manager in DB2 Universal Database Version 7.1, is also shipped with DB2 OLAP Server Version 7.1. The Information Catalog Manager can be used to publish OLAP and relational data objects to help end users and administrators understand what data and information resources are in the data warehouse.

Windows 2000 Readiness: DB2 OLAP Server Version 7.1 is Windows 2000 ready. You can now uninstall the OLAP Server from Windows platforms.

MERANT (Intersolv) ODBC Drivers: MERANT ODBC drivers Version 3.11 are provided with the SQL Interface and the Integration Server.

SQL Drill Through: SQL Drill Through, which was part of the DB2 OLAP Server Tools Bundle Version 1.1, will no longer be available in DB2 OLAP Server Version 7.1. For backward compatibility, you can use SQL Drill Through from DB2 OLAP Server Version 1.1 clients with patch 9, or later, and connect to DB2 OLAP Server Version 7.1.

Year 2000

This product does not have date dependencies and is therefore Year 2000 ready.

Product Positioning

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

  • Essbase-Ready ISV Products: Many ISV desktop tools and applications use the Hyperion Essbase API to access multidimensional data. As the same API is transparently supported by DB2 OLAP Server, these ISV tools can now seamlessly expand their products to the relational marketplace.
  • SQL Tools: When the relational storage manager is used, SQL Tools can query the star schema and can join the star schema with other relational tables. When used with the DataJoiner® product, joining of data can involve relational and non-relational operational sources.
  • DB2 Data Warehouse Center and DB2 Warehouse Manager: These warehouse management facilities in DB2 Universal Database Version 7.1 give you an integrated, managed environment to transform, create, and maintain data marts and data warehouses. It can automate the loading, updating, and recalculating of the star schema tables and multidimensional cubes in the DB2 OLAP Server from a variety of data sources. The Information Catalog Manager, part of the DB2 Warehouse Manager and shipped with DB2 OLAP Server Version 7.1, can also publish descriptions of the DB2 OLAP multidimensional models to end users.
  • DB2 OLAP Server Starter Kit: Functionally based on DB2 OLAP Server Version 7.1, the DB2 OLAP Server Starter Kit, shipped with DB2 Universal Database Version 7.1, allows the DB2 users to explore online analytical capabilities before acquiring the full product, DB2 OLAP Server Version 7.1, for more complex analysis or deployment to large groups of users. Applications developed by the DB2 OLAP Server Starter Kit can continue to be extended and used in the full product.
  • Hyperion WIRED for OLAP: Hyperion WIRED for OLAP is an OLAP-centric presentation, analysis, and reporting tool suite that gives you collaborative analytics, enterprise-wide deployability, and ease of use. It leverages the performance, scalability, and analytical power of DB2 OLAP Server, giving users point-and-click access to advanced features. It is enterprise-class, with a scalable three-tier architecture and a suite of four interoperable Windows and 100% Pure Java™ clients that allow organizations to deliver information to large user communities at a low cost of ownership.
  • DB2 Intelligent Miner™ for Data: IBM Intelligent Miner helps companies identify and extract high-value business intelligence from data assets. Through a process of "knowledge discovery," organizations can leverage hidden information in its data, uncovering associations, patterns, and trends that can lead to real competitive advantage.

    Customers can benefit from using DB2 Intelligent Miner for Data and DB2 OLAP server in the same solution.

    • Data mining can be used to enrich the information content available to an OLAP user and strengthen the analysis capabilities of those users. For example, market segmentation can be represented as a dimension of the cube, and the clustering algorithm used to discover that segmentation can shed light on significant attributes to be considered as additional dimensions. Once a predictive model produced by Intelligent Miner is used to score individual customers or prospects, those scores can be used to determine the clip level for the data to be included in a cube and appear as a dimension of the cube.
    • Data mining and business analysts alike can leverage the analytic capabilities of OLAP to better understand and analyze mining results.
    • As data mining results are integrated into the warehouse and OLAP cubes, a consistent business perspective is presented to a broader range of Business Intelligence (BI) users.

Trademarks

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

Additional Product Information

DB2 OLAP Server™

The DB2 OLAP Server Version 7.1 comes with a set of servers and optional application tools that help you provide a flexible, comprehensive OLAP solution.

DB2 OLAP Server is an enterprise-scale, online analytical processing system for a wide-range of multidimensional reporting, analysis, modeling, and planning applications. DB2 OLAP Server is based on Hyperion Essbase OLAP Server. It utilizes the Hyperion Essbase engine for:

  • Data access
  • Navigation
  • Application program interfaces (APIs)
  • Application design and management
  • Application partitioning
  • Data calculation

The DB2 OLAP Server 7.1 uniquely offers customers the choice of two data storage systems at the individual application level. The first is a standard relational database management system (RDBMS) using a star schema data structure. The second is the Essbase integrated multidimensional data store.

By utilizing a relational data store, DB2 OLAP Server uses DB2®, the industry-leading relational database, to store fact and dimension tables, which comprise the star schema, to meet your business requirement.

Parallel relational technology can be exploited to deliver improved access performance. The DB2 OLAP Server can be managed by familiar RDBMS system management, backup, and recovery tools allowing businesses to leverage their existing skill and technology investment.

DB2 OLAP Server also offers the advantage of providing access to data in the star schema using standard structure query language (SQL). Data in the DB2 OLAP Server can be leveraged by Essbase-Ready applications and the vast variety of generic SQL access tools. SQL tools can easily join the star schema with existing relational tables in the warehouse for additional reporting and analysis.

By using the Essbase integrated data store, DB2 OLAP Server provides a high-performance, multidimensional data store that is simple to implement.

Regardless of the type of data store used, DB2 OLAP Server can be used with 70-plus Essbase-ready tools provided by independent software vendors (ISVs). Application partitions can be stored across multiple OLAP Servers with different storage managers and be linked together.

DB2 OLAP Server can be used for a wide range of management, reporting, analysis, modeling, planning, and data warehousing applications. Typical applications include:

  • Sales
  • Profitability
  • Market share
  • Supplier analysis
  • Executive Information System (EIS)
  • Financial consolidations
  • Budgeting
  • Forecasting
  • Enterprise performance measurement

DB2 OLAP Server includes a comprehensive set of graphical tools for database management, security, and administration for deploying industrial-strength OLAP applications. DB2 OLAP Server includes Hyperion Essbase Spreadsheet Add-in and Hyperion Essbase Application Manager. The Spreadsheet Add-in is desktop software that merges seamlessly with Microsoft™ Excel or Lotus® 1-2-3®, turning your familiar spreadsheet into a tightly integrated OLAP client for DB2 OLAP Server. The Application Manager lets you easily build, modify, and maintain:

  • Analytical models
  • Calculations
  • Data access security
  • Data loading rules
  • Dimension building
  • System management functions

DB2 OLAP Server operates on Windows NT™, Windows 2000, AIX®, HP-UX, and Sun Solaris operating systems over all leading implementations of TCP/IP networks, and can create and manage star schemas automatically in DB2 databases.

DB2 OLAP Server can work with editions of the DB2 Universal Database® from the Personal Edition to the Enterprise — Extended Edition.

DB2 OLAP Server Application Tools

You can extend and enhance DB2 OLAP Server applications by utilizing a number of tools:

  • SQL Interface provides direct access to more than 20 PC and SQL relational databases such as DB2, Oracle, Sybase, Informix, and Microsoft SQL Server, and many leading middleware packages such as the IBM and MDI gateways. The SQL Interface moves data and business structures from diverse sources into the DB2 OLAP Server for access and analysis.

    Version 3.11 MERANT (Intersolv) ODBC drivers are provided with this new release.

  • Currency Conversion converts financial data using any currency exchange rate scenario. The Currency Conversion module lets you model the impact of exchange rates and perform ad hoc conversions directly from a spreadsheet or custom application.
  • Application Programming Interface lets you use standard tools to create custom DB2 OLAP Server applications that take advantage of the powerful data storage, retrieval, and analytical capabilities of DB2 OLAP Server. The Application Programming Interface supports Visual Basic, C, C++, and other application development environments, and works with Windows 95/98, Windows NT, Windows™ 2000, and UNIX®.
  • Extended Spreadsheet Toolkit includes more than 20 macros and Visual Basic (VBA) functions, letting you build custom Lotus 1-2-3 or Microsoft Excel applications that tightly integrate with DB2 OLAP Server.
  • Web Gateway gives you all the essential OLAP features including drill up/down/across, pivot, slice and dice, and full read/write capabilities from standard Web browsers. Web Gateway is Version 1.1 and unchanged from DB2 OLAP Server Version 1.1.
  • Partitioning Option provides a collection of powerful features that makes it easy to design and administer multidimensional databases (cubes) that span OLAP applications or servers. Functions can:
    • Integrate multiple physical cubes into a single logical cube
    • Centrally administer and share metadata
    • Allow connection of cubes with varying dimensionality
    • Allow partition replication between centralized and distributed cubes
  • Objects provide a set of open, ActiveX, OLAP-aware objects, letting users easily and rapidly develop customized OLAP applications on Windows 95/98, Windows NT, and Windows 2000 clients with minimal programming. Objects works with Microsoft Visual Basic and Microsoft C++.
  • Integration Server lets you map and transfer data from relational databases to OLAP cubes quickly and easily. It includes a set of graphical tools and a shared, enterprise OLAP metadata catalog that contains:
    • Reusable data mappings
    • Dimensions
    • Hierarchies
    • Calculation logic
    • Business rules

    End users and IT professionals can combine and customize objects stored in the OLAP catalog and then create new analytic applications tailored to satisfy specific business requirements from relational data sources.

    Version 3.11 MERANT (Intersolv) ODBC drivers are provided with the Integration Server.

  • Allocations Manager is an analytic application for managing the allocations of shared revenues, costs, and capital across organizations. Allocations Manager provides a graphical interface and offers several commonly employed allocation methods.

DB2 OLAP Server Products

DB2 OLAP Server Standard Edition comes with a full-function DB2 OLAP server and a restricted use copy of the DB2 Universal Database Enterprise Edition, Version 7.1. This special copy of the DB2 Universal Database may only be used in support of the DB2 OLAP Server Standard Edition.

Note: The DB2 OLAP Server Standard Edition also works with other editions of the DB2 Universal Database including the Enterprise — Extended Edition, Version 7.1.

DB2 OLAP Server Personal Edition provides a single-user DB2 OLAP system for the Windows NT or Windows 2000 environment and comes with a copy of the DB2 Universal Database Personal Edition Version 7.1. The client of the DB2 OLAP Server Personal Edition can connect to other DB2 OLAP Servers. The DB2 OLAP Server Personal Edition is only licensed with a DB2 OLAP Server Standard Edition.

DB2 OLAP Server Developer's Edition is licensed for one developer for development only. It contains a full-function DB2 OLAP Server, all the application tools, and a copy of the DB2 Universal Developer's Edition, Version 7.1.

DB2 OLAP Server Tools Bundle is licensed for use with a DB2 OLAP Server Standard Edition. It contains a copy of the following tools:

  • SQL Interface
  • Currency Conversion
  • Application Programming Interface
  • Extended Spreadsheet Tool

DB2 OLAP Server Tools Bundle for the Personal Edition is licensed for use with a DB2 OLAP Server Personal Edition. It contains a copy of the following tools:

  • SQL Interface
  • Currency Conversion
  • Application Programming Interface
  • Extended Spreadsheet Tool

DB2 OLAP Server Web Gateway is licensed for use with a DB2 OLAP Server Standard Edition.

DB2 OLAP Server Partitioning Option is licensed for use with a DB2 OLAP Server Standard Edition.

DB2 OLAP Server Partitioning Option for Personal Edition is licensed for use with a DB2 OLAP Server Personal Edition.

DB2 OLAP Server Objects is licensed for use with a DB2 OLAP Server Standard Edition.

DB2 OLAP Server Objects for Personal Edition is licensed for use with a DB2 OLAP Server Personal Edition.

DB2 OLAP Server Allocations Manager is licensed for use with a DB2 OLAP Server Standard Edition.

DB2 OLAP Integration Server is licensed for use with a DB2 OLAP Server Standard Edition.

DB2 OLAP Integration Server for Personal Edition is licensed for use with a DB2 OLAP Server Personal Edition.

Education Support

The following courses are offered by IBM Learning Services:

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

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

Visit the following Web site for additional information:

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

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

Offering Information

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

Publications

The following publication is shipped with the program package and with the documentation package. It may also be ordered separately.

                                                  Order
Title                                             Number
 
OLAP Setup and User's Guide (English)             SC27-0702

The following English publications are available for ordering:

                                                  Order
Title                                             Number
 
OLAP Integration Server                           SC27-0783
  Model User's Guide
OLAP Integration Server                           SC27-0784
  Metaoutline User's Guide
OLAP Spreadsheet Add-in                           SC27-0786
  User's Guide for Excel
OLAP Spreadsheet Add-in                           SC27-0785
  User's Guide for 1-2-3
OLAP Integration Server                           SC27-0787
  Administration Guide
OLAP Database Administrator's                     SC27-0788
  Guide, Volume 1
OLAP Database Administrator's                     SC27-0789
  Guide, Volume 2
OLAP Quick Technical Reference                    SC27-0790
OLAP SQL Interface Guide                          SC27-0791
OLAP Allocations Manager                          SC27-0792
  Installation Guide
OLAP Allocations Manager                          SC27-0793
  Administrator's Guide
OLAP Allocations Manager                          SC27-0794
  Quick Reference
Information Catalog Manager                       SC26-9995
  Administration Guide
Information Catalog Manager                       SC26-9996
  User's Guide
Information Catalog Manager                       SC26-9997
  Programming Guide and
  Reference

The following softcopy HTML documents are included with the media:

Title                                             Language
 
API Reference                                     English
Technical Reference                               English

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

Title                                             Language
 
OLAP Setup and User's Guide                       English
OLAP Integration Server                           English
  Model User's Guide
OLAP Integration Server                           English
  Metaoutline User's Guide
OLAP Spreadsheet Add-in                           English
  User's Guide for Excel
OLAP Spreadsheet Add-in                           English
  User's Guide for 1-2-3
OLAP Integration Server                           English
  Administration Guide
OLAP Database Administrator's                     English
  Guide, Volume 1
OLAP Database Administrator's                     English
  Guide, Volume 2
OLAP Quick Technical Reference                    English
OLAP SQL Interface Guide                          English
MERANT (Intersolv) DataDirect                     English
  Connect ODBC Installation
MERANT (Intersolv) DataDirect                     English
  Connect ODBC Reference
OLAP Allocations Manager                          English
  Installation Guide
OLAP Allocations Manager                          English
  Administrator's Guide
OLAP Allocations Manager                          English
  Quick Reference
Information Catalog Manager                       English
  Administration Guide
Information Catalog Manager                       English
  User's Guide
Information Catalog Manager                       English
  Programming Guide and
  Reference

Technical Information

Hardware Requirements: The DB2 OLAP Server supports the following server and client platforms. Except where noted, these are minimum requirements.

Server Platforms for the DB2 OLAP Server

  • Processor
    • At least a Pentium™, or equivalent, for Windows NT or Windows 2000
    • RS/6000® for AIX
    • Sun SPARC or ULTRASPARC for Solaris
    • HP PA-RISC for HP-UX
  • RAM — 64 MB, or more (128 MB, or more, for UNIX platforms)
  • Disk Space — 35-50 MB for the server and sample applications; 15-20 MB for the SQL Interface software and samples

PC Client Platforms

  • Processor
    • At least a Pentium, or equivalent, for Spreadsheet Add-in and for Application Manager
  • RAM
    • 16 MB, or more, for Spreadsheet Add-in and Application Manager
    • 32 MB, or more, for the Integration Server Desktop on Windows 95, Windows 98, Windows NT 4.0, or Windows 2000
  • Disk Space
    • 24 MB for Application Manager
    • 17.5 MB for Spreadsheet Add-in for 1-2-3
    • 16.7 MB for Spreadsheet Add-in for Excel
    • 9 MB for Essbase Runtime Client
    • 45 MB for the Integration Server Desktop
  • Display
    • Resolution of at least 640 x 480 (800 x 600, or more, recommended)

API Client Platforms

  • Processor
    • At least a Pentium, or equivalent, for Windows 95 or 98, Windows NT, or Windows 2000
    • RS/6000 for AIX
    • Sun SPARC or ULTRASPARC for Solaris
    • HP PA-RISC for HP-UX
  • RAM
    • 16 MB for Windows 95 or 98, Windows NT, or Windows 2000
    • 32 MB (64 MB, or more, recommended) for UNIX platforms
  • Disk Space
    • 15 MB for 32-bit Essbase API on Windows 95, Windows 98, Windows NT, or Windows 2000
    • 6 MB for all UNIX platforms

Server Platforms for the Integration Server

  • Processor
    • At least a Pentium, or equivalent, for Windows NT or Windows 2000
    • RS/6000 for AIX
    • Sun SPARC or ULTRASPARC for Solaris
    • HP PA-RISC for HP-UX
  • RAM — 64 MB or more
  • Disk Space — 32 MB for the server
  • 50 MB for the Metadata Catalog and sample applications

Web Gateway

  • Processor
    • At least a Pentium, or equivalent, for Windows NT or Windows 2000
    • Sun SPARC or ULTRASPARC for Solaris
  • Disk Space — 15 MB, or more

Objects

  • Processor
    • At least a Pentium, or equivalent
  • RAM — 32 MB, or more
  • Disk Space — 20 MB

Allocations Manager

  • Processor
    • At least a Pentium, or equivalent, for Windows 95, Windows 98, Windows NT, or Windows 2000
  • RAM — 48 MB, or more (64 MB recommended)
  • Disk Space — 25 MB for installation only
  • Display — Resolution of at least 800 x 600

Software Requirements

Server Platforms for the OLAP Server

  • Operating System
    • Windows NT 4.0 or Windows 2000
    • AIX Version 4.3.3, or later
    • Solaris 2.6 or 7
    • HP-UX 11.0
  • Communications
    • TCP/IP or Named Pipes

Relational Database Managers: For storing multidimensional data in relational cubes:

  • DB2 Universal Database Version 5.2, 6, or 7 on the DB2 OLAP Server machine or on a LAN

PC Client Platforms

  • Operating System
    • Windows 95
    • Windows 98
    • Windows NT 4.0
    • Windows 2000
  • Spreadsheet
    • Excel 97, Excel 2000
    • Lotus 1-2-3 Millennium R9 or R9.1
  • Communications
    • TCP/IP or Named Pipes (TCP/IP only for Windows 95, Windows 98, and the Integration Server Desktop)

API Client Platforms

  • Operating System
    • Windows 95 or Windows 98
    • Windows NT 4.0
    • Windows 2000
    • AIX Version 4.3.3, or later
    • Solaris 2.6 or 7
    • HP-UX 11.0

Server Platforms for the Integration Server

  • Operating System
    • Windows NT 4.0 or Windows 2000
    • AIX Version 4.3.3, or later
    • Solaris 2.6 or 7
    • HP-UX 11.0
  • Communications
    • TCP/IP

Web Gateway

  • Operating System for the Web Server
    • Windows NT Server Version 4.0, or later
    • Solaris 2.6 or 7
  • Communications
    • TCP/IP
  • Web Server qualified with Web Gateway for Solaris
    • Netscape Enterprise Server 3.0, or later
  • Web Server qualified with Web Gateway for NT
    • Microsoft Internet Information Server 3.0, for Windows NT, or later
    • Microsoft Merchant Server
    • Netscape Enterprise Server 3.0, or later
  • Web Browsers
    • Microsoft Internet Explorer 3.0, or later
    • Netscape 3.0, or later

Objects

  • Operating System
    • Windows 95 or 98
    • Windows NT 4.0
    • Windows 2000
  • Communications
    • TCP/IP or Named Pipes
  • Programming environment
    • Microsoft Visual Basic 5 or 6
    • Microsoft Visual C++ 4.2
  • Web Deployment
    • ActiveX compatible Web browsers

Allocations Manager

  • Operating System
    • Windows 95 or Windows 98
    • Windows NT 4.0
    • Windows 2000
  • Repository Manager
    • DB2 Universal Database Version 6.1 or later, for Windows NT and AIX
    • Microsoft SQL Server 7.0
    • Oracle8 Client

Planning Information

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

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

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

Refer to Software Announcement 200-089 , dated April 18, 2000, for terms and conditions and instructions for ordering additional installs and users and support services for the DB2 Universal Database.

The add-on programs, DB2 OLAP Server Objects Version 7.1 and DB2 OLAP Server Objects for the Personal Edition Version 7.1, will not be available until September 29, 2000. Until that time, the Version 1.1 level of these programs may be used. The DB2 OLAP Server Developer's Edition Version 7.1 will initially include DB2 OLAP Server Objects Version 1.1, which will be replaced by Version 7.1 after September 29, 2000. Customers with a Passport Advantage subscription for DB2 OLAP Server Objects, DB2 OLAP Server Objects for the Personal Edition, or DB2 OLAP Server Developer's Edition will receive automatically the Objects Version 7.1 Media pack on September 29, 2000.

In general, features in DB2 OLAP Server Version 7.1 are not compatible with the DB2 OLAP Server for OS/390®, Version 1.1. Customers with DB2 OLAP Server for OS/390, Version 1.1 must continue to use the DB2 OLAP Server Version 1.1 components.

Customer Responsibilities: The DB2 OLAP Server Standard Edition license includes an entitlement for one concurrent user. Entitlements for additional concurrent users are available, and you must order the appropriate entitlements for the maximum number of users who will be connected at any one time.

When deploying DB2 OLAP Server Standard Edition, there is no additional charge (users or processors) for the use of the restricted-copy of DB2 as long as its use is in support of DB2 OLAP Server Standard Edition. If you want to deploy an application that does not access the DB2 OLAP Server-managed data, then a full-use license of DB2 UDB, at the proper configuration for the operating system, processors, or users, must be acquired.

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

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

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

With this license, you may not authorize a third party to develop or significantly modify OLAP applications, unless such party is developing the applications on your behalf and at your expense.

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

Direct Customer Support: Direct customer support is provided by the Personal Systems and AIX Support Lines. This fee service enhances customers' productivity by providing voice and electronic access into the IBM support organization. The Personal Systems and AIX Support Lines will help answer questions pertaining to usage, and suspected software defects for eligible products.

The Personal Systems and AIX Support Lines for the included DB2 Universal Database product are available separately.

Installation and technical support is provided by Global Services. For more information call 800-IBM-4YOU (426-4968).

Packaging: Each of the DB2 OLAP Server products comes packaged with the following common contents:

  • IBM International Program License Agreement (IPLA) in multilanguage booklet
  • IPLA pointer sheet
  • License Information (LI) booklet
  • Service Information

Unless otherwise specified, the CD-ROM provided in the server packages contains all program components used in other add-on packages. Items unique to each product package are as follows:

DB2 OLAP Server Standard Edition

  • Publications
    • OLAP Setup and User's Guide
    • IBM DB2 Universal Database for Windows Quick Beginnings
    • IBM DB2 Universal Database for UNIX Quick Beginnings
    • IBM DB2 Universal Database Administration Guide: Planning
    • IBM DB2 SQL Getting Started
  • CD-ROMs for DB2 OLAP Server, and DB2 Universal Database Enterprise Edition Version 7.1
  • Proof of Entitlement (PoE) for 1 install and 1 concurrent user

DB2 OLAP Server Personal Edition

  • Publication
    • OLAP Setup and User's Guide
  • CD-ROM for DB2 OLAP Server
  • PoE for 1 install
  • DB2 Universal Database Personal Edition Version 7.1

DB2 OLAP Server Developer's Edition

  • Publication
    • OLAP Setup and User's Guide
  • CD-ROMs for DB2 OLAP Server, Web Gateway, Objects, and Allocations Manager
  • PoE for 1 install
  • DB2 Universal Developer's Edition Version 7.1

DB2 OLAP Server Tools Bundle

  • PoE

DB2 OLAP Server Tools Bundle for Personal Edition

  • PoE

DB2 OLAP Integration Server

  • PoE

DB2 OLAP Integration Server for Personal Edition

  • PoE

DB2 OLAP Server Web Gateway

  • CD-ROM
  • PoE

DB2 OLAP Server Partitioning Option

  • PoE

DB2 OLAP Server Partitioning Option for Personal Edition

  • PoE

DB2 OLAP Server Objects

  • CD-ROM
  • PoE

DB2 OLAP Server Objects for Personal Edition

  • CD-ROM
  • PoE

DB2 OLAP Server Allocations Manager

  • CD-ROM
  • PoE

Packaging of Media and Documentation Packages

DB2 OLAP Server Standard Edition

  • Media Package
    • CD-ROM for DB2 OLAP Server (includes Tools Bundle, Partitioning Option, and DB2 OLAP Integration Server)
    • CD-ROMs for DB2 Universal Database Enterprise Edition Version 7.1
  • Documentation Package
    • OLAP Setup and User's Guide
    • IBM DB2 Universal Database for Windows Quick Beginnings
    • IBM DB2 Universal Database for UNIX Quick Beginnings
    • IBM DB2 Universal Database Administration Guide: Planning
    • IBM DB2 SQL Getting Started

DB2 OLAP Server Personal Edition

  • Media Package
    • CD-ROM for DB2 OLAP Server
    • Media Package for DB2 Universal Database Personal Edition Version 7.1
  • Documentation Package
    • OLAP Setup and User's Guide
    • Documentation Package for DB2 Universal Database Personal Edition Version 7.1

DB2 OLAP Server Developer's Edition

  • Media Package
    • CD-ROMs for DB2 OLAP Server, Web Gateway, Objects, and Allocations Manager
    • Media Package for DB2 Universal Developer's Edition Version 7.1
  • Documentation Package
    • OLAP Setup and User's Guide
    • Documentation Package for DB2 Universal Developer's Edition Version 7.1

DB2 OLAP Server Web Gateway

  • Media Package
    • CD-ROM

DB2 OLAP Server Objects

  • Media Package
    • CD-ROM

DB2 OLAP Server Objects for Personal Edition

  • Media Package
    • CD-ROM

DB2 OLAP Server Allocations Manager

  • Media Package
    • CD-ROM

Security, Auditability, and Control

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

When the relational storage manager is used, before the star schema storing the multidimensional data can be accessed by SQL applications, proper authorization must be obtained through the relational database security features.

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

Ordering Information

DB2 OLAP Server Version 7.1 is available in three editions:

  • The DB2 OLAP Server Standard Edition Version 7.1, has two charge units based on the number of installations and on the number of concurrent users.
  • The DB2 OLAP Server Personal Edition Version 7.1 and the DB2 OLAP Server Developer's Edition Version 7.1, each has a single charge unit based on the number of installations.
  • The add-on products also have charge units based on the number of installations. The add-on products are licensed to a particular server, and can be accessed by all licensed users for that server.

Note: The DB2 OLAP Server Web Gateway add-on product remains unchanged at the Version 1.1 level.

DB2 OLAP Server Standard Edition Version 7.1: The program package for the Standard Edition includes entitlements for one install and one user.

                                                  Part
Description                                       Number
 
DB2 OLAP Server Standard Edition                  11K7908
  Version 7.1 Program Package --
  English

DB2 OLAP Server Standard Edition Version 7.1 — Use Entitlements

                                                  Part
Description                                       Number
 
DB2 OLAP Server Standard Edition                  11K7911
  Version 7.1 Entitlement for
  1 additional install
DB2 OLAP Server Standard Edition                  11K7912
  Version 7.1 Entitlement for
  1 additional concurrent user

DB2 OLAP Server Personal Edition Version 7.1: The program package for the Personal Edition includes an entitlement for one install. It is limited to a single user.

                                                  Part
Description                                       Number
 
DB2 OLAP Server Personal Edition                  11K6785
  Version 7.1 Program Package --
  English

DB2 OLAP Server Personal Edition Version 7.1 — Use Entitlement

                                                  Part
Description                                       Number
 
DB2 OLAP Server Personal Edition                  11K6787
  Version 7.1 Entitlement for
  1 additional install

Add-On Program for Personal Edition: The Add-on Program includes an entitlement for one install.

                                                  Part
Description                                       Number
 
DB2 OLAP Server Objects                           11K7618
  for the Personal Edition
  Version 7.1 Program Package --
  English (Available on
  September 29, 2000)

Add-On Programs for Personal Edition — Use Entitlements

                                                  Part
Description                                       Number
 
DB2 OLAP Server Objects                           11K7619
  for the Personal Edition
  Version 7.1 Entitlement
  for 1 additional install
DB2 OLAP Server Tools Bundle                      11K7914
  for the Personal Edition
  Version 7.1 Entitlement
  for 1 install
DB2 OLAP Server Partitioning Option               11K7913
  for the Personal Edition
  Version 7.1 Entitlement
  for 1 install
DB2 OLAP Integration Server                       11K6791
  for the Personal Edition
  Version 7.1 Entitlement
  for 1 install

DB2 OLAP Server Developer's Edition Version 7.1: The program package for the Developer's Edition includes an entitlement for one install. It is limited to a single user.

                                                  Part
Description                                       Number
 
DB2 OLAP Server Developer's Edition               11K8084
  Version 7.1 Program Package --
  English

DB2 OLAP Server Developer's Edition Version 7.1 — Use Entitlement

                                                  Part
Description                                       Number
 
DB2 OLAP Server Developer's Edition               11K8086
  Version 7.1 Entitlement
  for 1 additional install

Add-On Programs: Each Add-on Program includes an entitlement for one install.

                                                  Part
Description                                       Number
 
DB2 OLAP Server Web Gateway                       41L2583
  Version 1.1 Program
  Package -- English
DB2 OLAP Server Objects                           11K8357
  Version 7.1 Program
  Package -- English
  (Available on
  September 29, 2000)
DB2 OLAP Server Allocations                       11K8355
  Manager Version 7.1
  Program Package -- English

Add-On Programs — Use Entitlements

                                                  Part
Description                                       Number
 
DB2 OLAP Server Web Gateway                       41L2584
  Version 1.1 Entitlement
  for 1 additional install
DB2 OLAP Server Objects                           11K8358
  Version 7.1 Entitlement
  for 1 additional install
DB2 OLAP Server Allocations                       11K8356
  Manager Version 7.1
  Entitlement for
  1 additional install
DB2 OLAP Server Tools                             11K6790
  Bundle Version 7.1
  Entitlement for 1 install
DB2 OLAP Server Partitioning                      11K6789
  Option Version 7.1
  Entitlement for 1 install
DB2 OLAP Integration Server                       11K6788
  Version 7.1 Entitlement
  for 1 install

Passport Advantage Media and Documentation Packages

DB2 OLAP Server Standard Edition Version 7.1

                                                  Passport
                                                  Advantage
                                                  Part
Description                                       Number
 
DB2 OLAP Server Standard Edition                  BB6HNML
  Version 7.1 Media Package --
  Multilanguage
  Passport Advantage
DB2 OLAP Server Standard Edition                  BB6HPNA
  Version 7.1 Documentation
  Package -- English
  Passport Advantage

DB2 OLAP Server Personal Edition Version 7.1

                                                  Passport
                                                  Advantage
                                                  Part
Description                                       Number
 
DB2 OLAP Server Personal Edition                  BB6F9ML
  Version 7.1 Media Package --
  Multilanguage Passport Advantage
DB2 OLAP Server Personal Edition                  BB6FANA
  Version 7.1 Documentation
  Package -- English
  Passport Advantage

Add-On Program for Personal Edition

                                                  Passport
                                                  Advantage
                                                  Part
Description                                       Number
 
DB2 OLAP Server Objects                           11K7620
  for the Personal Edition
  Version 7.1 Media Package
  Passport Advantage

DB2 OLAP Server Developer's Edition Version 7.1

                                                  Passport
                                                  Advantage
                                                  Part
Description                                       Number
 
DB2 OLAP Server Developer's Edition               BB6KKML
  Version 7.1 Media Package --
  Multilanguage Passport Advantage
DB2 OLAP Server Developer's Edition               BB6KQNA
  Version 7.1 Documentation
  Package -- English
  Passport Advantage

Add-On Programs

                                                  Passport
                                                  Advantage
                                                  Part
Description                                       Number
 
DB2 OLAP Server Web Gateway                       BB6T5NA
  Version 1.1 Media Package
  Passport Advantage
DB2 OLAP Server Objects                           BB6KRNA
  Version 7.1 Media Package
  Passport Advantage
DB2 OLAP Server Allocations                       BB6KLNA
  Manager Version 7.1
  Media Package Passport Advantage

Other New Passport Advantage Part Numbers

                                                  Passport
                                                  Advantage
                                                  Part
Description                                       Number
 
DB2 OLAP Server Allocations Manager Version 7.1
 
Volume Purchase Option
 
VPO Instl DB2 Olap Server Allocations Mgr         D46SAML
  Install
VPO Instl/SW Sub DB2 Olap Server                  D46SCML
  Allocations Mgr Install 1 Year
VPO Instl/SW Sub DB2 Olap Server                  D46SGML
  Allocations Mgr Install 2 Years
VPO SW Sub Rnwl DB2 Olap Server                   E16SSML
  Allocations Mgr Install
VPO SW Sub DB2 Olap Server Allocations            D46SVML
  Mgr Install 1 Year
VPO SW Sub DB2 Olap Server Allocations            D46SXML
  Mgr Install 2 Years
 
Contract Option
 
CO Instl/SW Sub DB2 Olap Server                   D46SZML
  Allocations Mgr Install 1 Anniv
CO Instl/SW Sub DB2 Olap Server                   D46T7ML
  Allocations Mgr Install 2 Anniv
CO SW Sub Rnwl DB2 Olap Server                    E16TNML
  Allocations Mgr Install
CO SW Sub DB2 Olap Server Allocations             D46UBML
  Mgr Install 1 Anniv
CO SW Sub DB2 Olap Server Allocations             D46UDML
  Mgr Install 2 Anniv
CO Supt DB2 Olap Server Allocations               E16UFML
  Mgr Install 1 Anniv
CO Instl/SW Sub/Supt DB2 Olap Server              D46UGML
  Allocations Mgr Install 1 Anniv
CO Instl/SW Sub/Supt DB2 Olap Server              D46UHML
  Allocations Mgr Install 2 Anniv
CO SW Sub/Supt DB2 Olap Server                    D46UPML
  Allocations Mgr Install 1 Anniv
CO SW Sub/Supt Rnwl DB2 Olap Server               E16V2ML
  Allocations Mgr Install
 
DB2 OLAP Integration Server Version 7.1
 
Volume Purchase Option
 
VPO Instl DB2 Olap Integration Server             D46I7ML
  Install
VPO Instl/SW Sub DB2 Olap Integration             D46JKML
  Server Install 1 Year
VPO Instl/SW Sub DB2 Olap Integration             D46JUML
  Server Install 2 Years
VPO SW Sub Rnwl DB2 Olap Integration              E16NGML
  Server Install
VPO SW Sub DB2 Olap Integration Server            D46NAML
  Install 1 Year
VPO SW Sub DB2 Olap Integration Server            D46NBML
  Install 2 Years
 
                                                  Passport
                                                  Advantage
                                                  Part
Description                                       Number
 
Contract Option
 
CO Instl/SW Sub DB2 Olap Integration              D46NPML
  Server Install 1 Anniv
CO Instl/SW Sub DB2 Olap Integration              D46NVML
  Server Install 2 Anniv
CO SW Sub Rnwl DB2 Olap Integration               E16NXML
  Server Install
CO SW Sub DB2 Olap Integration Server             D46P9ML
  Install 1 Anniv
CO SW Sub DB2 Olap Integration Server             D46PCML
  Install 2 Anniv
CO Supt DB2 Olap Integration Server               E16PGML
  Install 1 Anniv
CO Instl/SW Sub/Supt DB2 Olap Integration         D46PHML
  Server Install 1 Anniv
CO Instl/SW Sub/Supt DB2 Olap Integration         D46PLML
  Server Install 2 Anniv
CO SW Sub/Supt DB2 Olap Integration               D46PMML
  Server Install 1 Anniv
CO SW Sub/Supt Rnwl DB2 Olap Integration          E16PTML
  Server Install
 
DB2 OLAP Integration Server for Personal Edition
Version 7.1
 
Volume Purchase Option
 
VPO Instl DB2 Olap Integration Sr                 D46SEML
  Personal Install
VPO Instl/SW Sub DB2 Olap Integration             D46SFML
  Sr Personal Install 1 Year
VPO Instl/SW Sub DB2 Olap Integration             D46SHML
  Sr Personal Install 2 Years
VPO SW Sub Rnwl DB2 Olap Integration              E16SJML
  Sr Personal Install
VPO SW Sub DB2 Olap Integration Sr                D46SLML
  Personal Install 1 Year
VPO SW Sub DB2 Olap Integration Sr                D46SQML
  Personal Install 2 Years
 
Contract Option
 
CO Instl/SW Sub DB2 Olap Integration              D46SRML
  Sr Personal Install 1 Anniv
CO Instl/SW Sub DB2 Olap Integration              D46STML
  Sr Personal Install 2 Anniv
CO SW Sub Rnwl DB2 Olap Integration               E16SUML
  Sr Personal Install
CO SW Sub DB2 Olap Integration Sr                 D46SWML
  Personal Install 1 Anniv
CO SW Sub DB2 Olap Integration Sr                 D46SYML
  Personal Install 2 Anniv

For other Passport Advantage part numbers carried forward from DB2 OLAP Server Version 1.1, refer to Software Announcement 299-200 , dated July 20, 1999.

Terms and Conditions

Licensing: IBM International Program License Agreement. Proofs of Entitlement (PoE) are required for all authorized use.

License Information Form Number: GC27-0795

Limited Warranty: Yes

Program Services: Available until March 31, 2002

Money-Back Guarantee: Two-month, money-back guarantee

Copy and Use on Home/Portable Computer: No

Volume Orders (IVO): No

Passport Advantage Applies: Yes

Passport Advantage Subscription Applies: Yes

Usage Restriction: Yes

The copy of the DB2 Universal Database available in the DB2 OLAP Server Standard Edition is restricted to use in support of DB2 OLAP Server Standard Edition.

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

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

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

With this license, you may not authorize a third party to develop or significantly modify OLAP applications, unless such party is developing the applications on your behalf and at your expense.

Support Line: Yes

AIX/UNIX Upgrade Protection Applies: No

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

AS/400® Software Subscription Applies: No

Variable Charges Apply: No

Educational Allowance: Not applicable

Charges

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

DB2 OLAP Server Standard Edition Version 7.1

                                   Part
Description                        Number             OTC(1)
 
DB2 OLAP Server Standard           11K7908           $28,000
  Edition Version 7.1
  Program Package --
  English
1
One-time charge

DB2 OLAP Server Standard Edition Version 7.1 — Use Entitlements

                                   Part
Description                        Number             OTC
 
DB2 OLAP Server Standard           11K7911           $27,950
  Edition Version 7.1
  Entitlement for
  1 additional install
DB2 OLAP Server Standard           11K7912             3,500
  Edition Version 7.1
  Entitlement for
  1 additional concurrent user

DB2 OLAP Server Personal Edition Version 7.1

                                   Part
Description                        Number             OTC
 
DB2 OLAP Server Personal           11K6785            $1,300
  Edition Version 7.1
  Program Package --
  English

DB2 OLAP Server Personal Edition Version 7.1 — Use Entitlement

                                   Part
Description                        Number             OTC
 
DB2 OLAP Server Personal           11K6787            $1,270
  Edition Version 7.1
  Entitlement for
  1 additional install

Add-On Program for Personal Edition

                                   Part
Description                        Number             OTC
 
DB2 OLAP Server Objects            11K7618              $400
  for the Personal Edition
  Version 7.1 Program
  Package -- English

Add-On Programs for Personal Edition — Use Entitlements

                                   Part
Description                        Number             OTC
 
DB2 OLAP Server Objects            11K7619            $  370
  for the Personal Edition
  Version 7.1 Entitlement
  for 1 additional install
DB2 OLAP Server Tools Bundle       11K7914             1,300
  for the Personal Edition
  Version 7.1 Entitlement
  for 1 install
DB2 OLAP Server Partitioning       11K7913               800
  Option for the Personal
  Edition Version 7.1
  Entitlement for 1 install
DB2 OLAP Integration Server        11K6791               100
  for the Personal Edition
  Version 7.1 Entitlement
  for 1 install

DB2 OLAP Server Developer's Edition Version 7.1

                                   Part
Description                        Number             OTC
 
DB2 OLAP Server Developer's        11K8084           $10,000
  Edition Version 7.1
  Program Package --
  English

DB2 OLAP Server Developer's Edition Version 7.1 — Use Entitlement

                                   Part
Description                        Number             OTC
 
DB2 OLAP Server Developer's        11K8086            $9,970
  Edition Version 7.1
  Entitlement for
  1 additional install

Add-On Programs

                                   Part
Description                        Number             OTC
 
DB2 OLAP Server Web Gateway        41L2583           $10,000
  Version 1.1 Program
  Package -- English
DB2 OLAP Server Objects            11K8357            10,000
  Version 7.1 Program
  Package -- English
DB2 OLAP Server Allocations        11K8355            15,000
  Manager Version 7.1
  Program Package --
  English

Add-On Programs — Use Entitlements

                                   Part
Description                        Number             OTC
 
DB2 OLAP Server Web Gateway        41L2584           $ 9,970
  Version 1.1 Entitlement
  for 1 additional install
DB2 OLAP Server Objects            11K8358             9,970
  Version 7.1 Entitlement
  for 1 additional install
DB2 OLAP Server Allocations        11K8356            14,970
  Manager Version 7.1
  Entitlement for
  1 additional install
DB2 OLAP Server Tools              11K6790            25,000
  Bundle Version 7.1
  Entitlement for 1 install
DB2 OLAP Server Partitioning       11K6789            15,000
  Option Version 7.1
  Entitlement for 1 install
DB2 OLAP Integration Server        11K6788            20,000
  Version 7.1 Entitlement
  for 1 install

Passport Advantage

Note: For Passport Advantage and charges, contact your Lotus representative or authorized Lotus Business Partner. Additional information is also available on the Passport Advantage URL:

Customer Financing: IBM Global Financing offers attractive financing to credit-qualified commercial and government customers and Business Partners in more than 40 countries around the world. IBM Global Financing is provided by the IBM Credit Corporation in the United States. Offerings, rates, terms, and availability may vary by country. Contact your local IBM Global Financing organization. Country organizations are listed on the Web at:

Order Now

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

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

Note: Shipments will begin after the planned availability date.

Trademarks

 
DB2 OLAP Server is a trademark of International Business Machines Corporation in the United States or other countries or both.
 
DB2, AIX, DB2 Universal Database, RS/6000, OS/390, and AS/400 are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Pentium is a trademark of Intel Corporation.
 
Microsoft, Windows NT, and Windows are trademarks of Microsoft Corporation.
 
UNIX is a registered trademark in the United States and other countries exclusively through X/Open Company Limited.
 
Lotus and 1-2-3 are registered trademarks of Lotus Development Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.