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

IBM United States Software Announcement 204-173
July 27, 2004

 

 ENUS204-173.PDF (166KB)

Table of contents   Document options  
At a glance Offering information
Overview Publications
Key prerequisites Technical information
Planned availability dates Ordering information
Description Terms and conditions
Education support Prices
 
Printable version

(Corrected on August 13, 2004)

Corrected three part numbers in the Passport Advantage program licenses section (D50WWLL, E007XLL, D50WSLL).
 

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.
 
Back to top
 

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 key 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.
 
Back to top
 

Key prerequisites

For information about all hardware and software prerequisites and systems supported, refer to the Hardware requirements and Software requirements sections.
 
Back to top
 

Planned availability dates
  • Globalized, English-only version
    • July 30, 2004 (for electronic download)
    • August 27, 2004 (physically available)
  • Fully localized version
    • September 30, 2004 (for electronic download)
    • November 12, 2004 (physically available)

 
Back to top
 
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, multiuser 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 multidimensional 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

  • ASO — 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 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 e-mail 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.
    • New API function that verifies the Rules file.
    • 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 spreadsheet add-in changes — With V8.2, DB2 OLAP Server adds 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 add-in 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 later, spreadsheet add-in client in conjunction with DB2 OLAP Server V8.2.

DB2 OLAP Server Administration Services

A robust, cross-platform GUI 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 multiserver 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 auto-complete 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 Servers remotely — Administrators can now start and stop DB2 OLAP Servers remotely. This is supported for DB2 OLAP Server V8.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 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 is not 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 eight 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 the X Window System 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. The X Window System is still needed to run the Administration Services installer on UNIX computers.
  • Additional platform support — With V8.2, DB2 OLAP Server Administration Services adds 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) — A suite of graphical tools and scalable data integration services that 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, multitier 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 DB2 Cube Views so that you 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, shipment 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:
    • DB2 OLAP Server name
    • DB2 OLAP Server application name
    • DB2 OLAP Server database name
    • 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 (DTD) documents — V8.2 of DB2 OLAP Integration Server provides two new documents that give details on OLAP model and metaoutline XML Import/Export 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:
    • Element name in full
    • Description of element, including its function
    • Explanation of parameters for element
    • Any special notes for element, if applicable
  • Additional platform support — With V8.2, DB2 OLAP Integration Server adds 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) — 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 failover ensure applications are available 24 x 7 x 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 multitier 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 a DB2 OLAP Server cluster that serves 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 a DB2 OLAP Server cluster that serves 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 Common Security Services (CSS))
  • 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 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
  • 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 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.

Trademarks

 
DB2 OLAP Server is a trademark of International Business Machines Corporation in the United States or other countries or both.
 
DB2, WebSphere, AIX, Lotus, 1-2-3, OS/390, and z/OS are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Intel is a trademark of Intel Corporation.
 
Windows and Microsoft are trademarks of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
UNIX is a registered trademark of the Open Company in the United States and other countries.
 
Linux is a trademark of Linus Torvalds in the United States, other Countries or both
 
Other company, product, and service names may be trademarks or service marks of others.

 
Back to top
 
Education support

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

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

Call IBM IT Education Services at 800-IBM-TEACH (426-8322) for catalogs, schedules, and enrollments.
 
Back to top
 

Offering information

Product information is available via the Offering Information Web site

Also, visit the Passport Advantage® Web site


 
Back to top
 
Publications

No publications are shipped with this product.

The IBM Publications Center

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)

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.

                                        Form
Title                                   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)

 
Back to top
 
Technical information

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 Java Archive (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 (JRE)) (server)
    • UNIX and Linux: 50 MB (including server software, API, sample applications and documentation, DB2 OLAP Server libraries and JRE) (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 JRE) (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
    • Red Hat Linux AS 2.1
  • Network protocol: TCP/IP
  • Java platform: JRE 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
    • Red Hat 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 system:
    • 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)
    • Red Hat Linux AS 2.1 (server only)
  • Network protocol: TCP/IP
  • RDBMS:
    • DB2 7.2/8.1
    • Oracle 8i and 9i
  • Application server:
    • WebSphere® 5.1
    • Apache Tomcat Server 4.1.30
    • BEA WebLogic Server 8.1
  • JRE 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
    • Red Hat 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 V1.4.1 (Build 2)
  • Spreadsheet support: Excel 2003, Excel 2002 (Office XP), Excel 2000 and Lotus® 9.7 (only when using 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)
    • Red Hat 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 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 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 system:
    • 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
    • Red Hat Linux AS 2.1
    • Red Hat Linux AS/ES/WS 2.1 for Intel (middle tier)

DB2 OLAP Server Miner Platforms

  • Operating system (server):
    • Windows 2000 and Windows XP Professional
    • AIX 5L (V5.1/V5.2)
  • Operating system (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), visit

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 Administration 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 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

Direct customer support: Direct customer support is provided by IBM Operational Support Services — Support Line. This fee service enhances customers' productivity by providing voice and electronic access into the IBM support organization. IBM Operational Support Services — Support Line will help answer questions pertaining to usage and suspected software defects for eligible products.

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

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

Packaging

Media packs:

  • Standard Edition

    Multilanguage (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

    Multilanguage (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

    Multilanguage (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

    Multilanguage (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.
 
Back to top
 

Ordering information

Product information

Licensed function
title                    Product group     Product category
 
DB2 OLAP Integration     IBM Database      IBM Database
 Server                   Management;       Management;
                          Other             Other
DB2 OLAP Server High     IBM Database      IBM Database
 Concurrency Standard     Management;       Management;
 Edition                  Other             Other
DB2 OLAP Server Tools    IBM Database      IBM Database
 Bundle Standard          Management;       Management;
 Edition                  Other             Other
DB2 OLAP Server          IBM Database      IBM Database
 Standard Edition         Management;       Management;
                          Other             Other
DB2 OLAP Server          IBM Database      IBM Database
 Partitioning Option      Management;       Management;
 Standard Edition         Other             Other
DB2 OLAP Server          IBM Database      IBM Database
 Partitioning Option      Management;       Management;
 Developer Ed             Other             Other
DB2 OLAP Server          IBM Database      IBM Database
 Developers Edition       Management;       Management;
                          Other             Other
DB2 OLAP Server          IBM Database      IBM Database
 Integration Server       Management;       Management;
 for Developer's          Other             Other
 Edition
DB2 OLAP Server Tools    IBM Database      IBM Database
 Bundle Personal          Management;       Management;
 Edition                  Other             Other
DB2 OLAP Integration     IBM Database      IBM Database
 Server Personal          Management;       Management;
 Edition                  Other             Other
DB2 OLAP Server          IBM Database      IBM Database
 Personal Edition         Management;       Management;
                          Other             Other
DB2 OLAP Server          IBM Database      IBM Database
 Partitioning Option      Management;       Management;
 Personal Edition         Other             Other
DB2 OLAP Server          IBM Database      IBM Database
 Spreadsheet Services     Management;       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                                  number
 
DB2 OLAP INTEGRATION SERVER
 PERSONAL EDITION
DB2 OLAP Svr Personal Ed                     D5B3CLL
 Integration Server Install Lic &
 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 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 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 &
 SW Maint 12 Mo
DB2 OLAP Developer Ed                        D50X5LL
 Integration Svr Install SW Maint
 Reinstatement 12 Mo
 
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
 
                                             Part
Description                                  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 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 DEVELOPERS
 EDITION
DB2 OLAP Server Developer                    D50WWLL
 Edition Conc User SW Maint
 Reinstatement 12 Mo
DB2 OLAP Server Developer                    D50YXLL
 Edition Install SW Maint
 Reinstatement 12 Mo
DB2 OLAP Server Developer                    E007XLL
 Edition Concurrent User SW Maint
 Annual Renewal
DB2 OLAP Server Developer                    D50WSLL
 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 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 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
 
                                             Part
Description                                  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 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 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 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

                                             Part
Program name/description                     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
 
                                             Part
Program name/description                     number
 
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
 
                                             Part
Program name/description                     number
 
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
offerings description       description                  number
 
OPTION SVR INSTL            Ed 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
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
 
Entitled maintenance        Media packs                  Part
offerings description       description                  number
 
DB2 OLAP DEVELOPER          DB2 OLAP Server Dev          BB0JXNA
 ED 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          DB2 OLAP Server Dev          BB0JUML
 ED 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 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
 
Entitled maintenance        Media packs                  Part
offerings description       description                  number
 
DB2 OLAP                    DB2 OLAP Server Dev          BB0JXNA
 INTEGRATION                 Ed English US Windows
 SVR SVR INSTL               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                    DB2 OLAP Server Dev          BB0JUML
 INTEGRATION                 Ed
 SVR SVR INSTL               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
offerings description       description                  number
 
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
 
Entitled maintenance        Media packs                  Part
offerings description       description                  number
 
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 ED            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 ED            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
offerings description       description                  number
 
DB2 OLAP SVR STD            DB2 OLAP Server Std          BB0JZNA
 ED INTEGRATION              Ed English US Windows
 SVR                         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            DB2 OLAP Server Std          BB0JWML
 ED INTEGRATION              Ed
 SVR                         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 HIGH               DB2 OLAP Server Std          BB0JZNA
 CONCURRENCY SVR             Ed English US Windows
 INSTL                       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             Ed
 INSTL                       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
 
Entitled maintenance        Media packs                  Part
offerings description       description                  number
 
DB2 OLAP TOOLS              DB2 OLAP Server Std          BB0JZNA
 BNDL                        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              DB2 OLAP Server Std          BB0JWML
 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, 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 Server Std          BB0JZNA
 STD 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             DB2 OLAP Server Std          BB0JWML
 STD 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
 
Entitled maintenance        Media packs                  Part
offerings description       description                  number
 
DB2 OLAP SERVER             DB2 OLAP Server Std          BB0JZNA
 STD EDITION                 Ed English US Windows
 INSTALL                     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 Server Std          BB0JWML
 STD EDITION                 Ed
 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
DB2 OLAP                    DB2 OLAP Server Std          BB0JZNA
 PARTITION                   Ed English US Windows
 OPT                         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                    DB2 OLAP Server Std          BB0JWML
 PARTITION                   Ed
 OPT                         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
offerings description       description                  number
 
DB2 OLAP Server             DB2 OLAP Svr Sprdsht         BB0K7NA
 Spreadsheet                 Svc English US
 Services 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                 Svc
 Services 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                 Svc English US
 Services                    Windows 2000, Windows
 Server Install              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                 Svc
 Services                    Multilingual (French,
 Server Install              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 November 12, 2004.

                                             Part
Description                                  number
 
DB2 OLAP Server V8.1.0 (5724-OLP)
 
DB2 OLAP                                     BB00MJA
 SERVER
 DEVELOPER
 EDITION 8.1
 DOC PACK JPN
DB2 OLAP                                     BB00NJA
 SERVER
 PERSONAL
 EDITION 8.1
 DOC PACK JPN
DB2 OLAP                                     BB00LJA
 SERVER
 EDITION V8.1
 JAPANESE DOC
 PACK
DB2 OLAP                                     BB00IJA
 SERVER
 DEVELOPER
 EDITION 8.1
 PA CD MEDIA
 PACK JPN
DB2 OLAP                                     BB00IKO
 SERVER
 DEVELOPER
 EDITION 8.1
 PA CD MEDIA
 PACK KOR
DB2 OLAP                                     BB00ISC
 SERVER
 DEVELOPER
 EDITION 8.1
 PA CD MEDIA
 PACK SCH
DB2 OLAP                                     BB00IML
 SERVER
 DEVELOPER
 EDITION V8.1
 MEDIA PACK
 MULTILINGUAL
DB2 OLAP                                     BB00ITC
 SERVER
 DEVELOPER
 EDITION V8.1
 PA CD MEDIA
 PACK TCH
DB2 OLAP                                     BB00JJA
 SERVER
 PERSONAL
 EDITION 8.1
 PA CD MEDIA
 PACK JPN
DB2 OLAP                                     BB00JKO
 SERVER
 PERSONAL
 EDITION 8.1
 PA CD MEDIA
 PACK KOR
DB2 OLAP                                     BB00JSC
 SERVER
 PERSONAL
 EDITION 8.1
 PA CD MEDIA
 PACK SCH
 
                                             Part
Description                                  number
 
DB2 OLAP                                     BB00JTC
 SERVER
 PERSONAL
 EDITION 8.1
 PA CD MEDIA
 PACK TCH
DB2 OLAP                                     BB00JML
 SERVER
 PERSONAL
 EDITION V8.1
 MEDIA PACK
 MULTILINGUAL
DB2 OLAP                                     BB0GVNA
 SERVER
 SPREADSHEET
 SERVICES 8.1
 MEDIA PACK
 ENGLISH
DB2 OLAP                                     BB00HJA
 SERVER
 STANDARD
 EDITION 8.1
 PA CD MEDIA
 PACK JPN
DB2 OLAP                                     BB00HKO
 SERVER
 STANDARD
 EDITION 8.1
 PA CD MEDIA
 PACK KOR
DB2 OLAP                                     BB00HSC
 SERVER
 STANDARD
 EDITION 8.1
 PA CD MEDIA
 PACK SCH
DB2 OLAP                                     BB00HTC
 SERVER
 STANDARD
 EDITION 8.1
 PA CD MEDIA
 PACK TCH
DB2 OLAP                                     BB00HML
 SERVER
 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.
 
Back to top
 

Terms and conditions

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

Agreement: 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.

License information form number

                          Program            Form
Program name              number             number
 
DB2 OLAP Server           5724-OLP           L-JGIN-5VLSCP

Limited warranty applies: 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.

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

Copy and use on home/portable computer: No

Volume orders (IVO): No

Passport Advantage applies: Yes and through the Passport Advantage Web site at

Usage restriction: Yes

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 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 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 multidimensional 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 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 business partners who wish to purchase additional components (features) in conjunction with their development and 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 multidimensional 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 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 multidimensional 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:

IBM Operational Support Services — Support line: Yes

iSeries™ Software Subscription applies: No
 
Back to top
 

Prices

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

Passport Advantage

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

To order, contact the Americas Call Centers, your local IBM representative, or your IBM Business Partner.

To identify your local IBM Business Partner or IBM representative, call 800-IBM-4YOU (426-4968).

Trademarks

 
DB2 OLAP Server and iSeries are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Passport Advantage, AIX, RS/6000, DB2, PowerPC, WebSphere, SP2, Lotus, and DB2 Universal Database are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Pentium and Intel are trademarks of Intel Corporation.
 
Windows and Microsoft are trademarks of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
UNIX is a registered trademark of the Open Company in the United States and other countries.
 
Linux is a trademark of Linus Torvalds in the United States, other Countries or both
 
Other company, product, and service names may be trademarks or service marks of others.

Back to top
 

 
Printable version