DB2 OLAP Server V8.2 delivers powerful capabilities built on Essbase V7.1 technology
IBM Europe Middle East Africa - Last revised on August 10, 2004
Table of Contents
IBM Announcement Letter No. ZP04-0172 dated July 27, 2004.
IBM Announcement Letter No. ZP04-0172 dated July 27, 2004.
Last revised on August 10, 2004.
See final section for details of availability and limitations,
if applicable.
Title
DB2 OLAP Server V8.2 delivers powerful capabilities built on Essbase V7.1 technologyOverview
The DB2 OLAP Server product family delivers services to provide insightful information to stakeholders responsible for managing business performance. A shared approach to business intelligence and performance management is critical to informed decision making and thus the success of your company. The DB2 OLAP Server product family provides the critical foundation technology that creates the shared information you need to manage your business Version 8.2 brings you powerful capabilities and support on Linux across the product family.
DB2 OLAP Server is the engine that provides the analytical processing power, scalability, performance, manageability, and security needed for delivering information to a broad class of users. Version 8.2 delivers significant and exciting enhancements including massive dimensional scalability and reduction in aggregation time for sparse databases; the ability to more easily engage in global development; greater flexibility in accessing multidimensional data and metadata; the ability to more easily customize the end-user experience; the ability to quickly zoom in on relevant portions of the cube; and performance and administration enhancements.
DB2 OLAP Server Administration Services , a robust, GUI component of DB2 OLAP Server, provides rich capabilities to make administration tasks and comprehensive life-cycle management easy to perform. Version 8.2 delivers key enhancements to support the new DB2 OLAP Server capabilities; an expanded set of deployment options with support for WebSphere, WebLogic, DB2 UDB and Oracle; richer interfaces to manage your outlines; easier monitoring and charting of information from a log view; a new MDX Script Editor; and many other improvements that collectively ease administration activities.
DB2 OLAP Integration Server
, an option of DB2 OLAP Server, is a suite of graphical tools and data integration services that dramatically reduce the cost of creating, deploying, and managing tailored DB2 OLAP Server applications, while providing a vital link to detailed data stored in relational databases. Version 8.2 delivers key improvements including support for the new DB2 OLAP Server capabilities; integration with DB2 Cube Views; drill-through reporting enhancements; hybrid analysis enhancements; shared user-defined members; and incremental loads.
DB2 OLAP Server Deployment Services
, a component of DB2 OLAP Server, provides a set of middle-tier services that enable broad deployment of business intelligence solutions to large user communities in distributed environments by extending the scalability, reliability, and availability of analytic applications. Version 8.2 delivers significant enhancements including connection pooling; several new Java APIs for custom-defined functions and for managing security access privileges; querying using MDX; Veritas Cluster Server on Windows; and support for the new DB2 OLAP Server capabilities.
DB2 OLAP Server Spreadsheet Services provides a highly intuitive, user-friendly, thin-client spreadsheet environment for OLAP analysis with DB2 OLAP Server through integration into Excel. Enhancements in Version 8.2 include an improved query designer; an improved look and feel throughout the product; enhanced member selection dialog box; lightweight installation for client software; hybrid analysis support; support for current and many new VBA functions; and support for the new DB2 OLAP Server capabilities.
Key Prerequisites
The DB2 OLAP Server supports these operating systems:
- IBM AIX
- Hewlett-Packard HP-UX
- Sun Solaris
- Microsoft Windows
- Linux for Intel
For additional information about all hardware and software prerequisites for the DB2 OLAP Server , refer to the Hardware requirements and Software requirements sections.
At a Glance
DB2 OLAP Server lets you extract more value out of your operational, transactional and Business Intelligence data. Improvements in this release of DB2 OLAP Server including...
- Aggregate Storage Option (ASO) support for Sparse Data
- Enhanced Analytical Processing
- Improved Scalability and Performance
- Easier Administration and Maintenance
- Improved Deployment
- Improved Interfaces
- Enhanced Platform Coverage
...allow your business to stay fast, focused, and flexible, while ensuring that your IT infrastructure remains streamlined and connected to improvements in business results.
Planned availability dates:
The Globalized, English-only version of DB2 OLAP Server V8.2 will be available for electronic download on July 30, 2004. It will be physically available on August 27, 2004.
A fully Localized version of DB2 OLAP Server V8.2 will be available for electronic download on September 30, 2004. It will be physically available on November 12, 2004.
See the complete letter for globalization details.
Description
DB2 OLAP Server Product Family
The DB2 OLAP Server product family delivers services to access and integrate data from a wide range of sources, generate insightful information, and deliver that information to every stakeholder, within and outside the enterprise, who is responsible for managing business performance. How quickly and how well your company performs is directly related to the power and integration of your business intelligence and business performance management solutions.
To improve profitability and business performance, you need insight into and accountability across every business activity. Employees need to understand how decisions in one department or division affect other areas of the company. They need to make time-critical, insightful decisions that lower costs, increase revenues, and improve collaboration. No company today succeeds without a shared approach to performance management. That approach requires powerful analytical processing. Analytical processing is the critical foundation technology that creates the shared information you depend on for business performance management.
DB2 OLAP Server
DB2 OLAP Server provides the processing power, scalability, performance, manageability, and security needed for delivering information to a broad class of users. From Line-of-Business executives to operational managers to front-line workers, DB2 OLAP Server can power insight and action across your extended enterprise.
Powerful analytics. Rich functionality, including more than 250 sophisticated algorithms out-of-the-box, attributes, multi-user write-back, procedural logic, and custom-defined functions and macros to enable businesses to leverage deep insight from their Business Performance Management applications.
Massive Scalability. Features such as cross-platform support, database partitioning, distributed processing, the ability to combine both relational and multi-dimensional data storage, and the brand new ability to support an optional aggregate storage kernel for huge, sparse databases enable DB2 OLAP Server to support communities as large as tens of thousands of users, while accessing massive volumes of information.
Superior Performance. Parallel processing, caching, direct I/O and other features enable DB2 OLAP Server to deliver superior load, calculate, query and update performance for enterprise wide deployments. End users benefit from speed-of-thought query response even when performing the most sophisticated analytics.
Easy Manageability. Features such as graphical interfaces, process automation and reusable dimensions, hierarchies and business rules enable DB2 OLAP Server to deliver an environment that offers the control and cost efficiency of centralization, while enabling departments and business units latitude in how resources are used.
Robust Security. Tight control of user access down to the individual cell level enables DB2 OLAP Server to safeguard sensitive information. Group-and role-based security models provide flexibility in allowing users access to the information they need to drive breakthrough performance.
DB2 OLAP Server V8.2 Highlights
- Aggregate Storage Option
- Support for aggregate storage databases (provided by a new
aggregate storage kernel) enables dramatic scalability improvements
in both database aggregation time and dimensional scalability. The
aggregate storage kernel does not replace the current block storage
kernel. Aggregate storage databases typically address read-only,
"rack and stack" applications that have large dimensionality, such as
the following applications:
- Customer analysis - data is analyzed from any dimension and there are potentially millions of customers
- Procurement analysis - many products are tracked across many vendors
- Logistics analysis - near real-time updates of product shipments
Aggregate storage databases with many dimensions calculate (aggregate) in minutes.
- Outline Paging - Aggregate storage databases may have outlines with millions of members. Support for outline paging significantly reduces memory usage, enhancing the end-user experience. Depending on the operating system and available memory, you can create outlines with up to 20 million members.
- Unicode (UTF8) Enabled Server - DB2 OLAP Server now supports a single database with data from multiple locales, through new Unicode support. Customers can now more easily engage in global development and easily provide all users access to data, regardless of their location and locale preference. DB2 OLAP Server will have two modes, non-Unicode and Unicode. Each DB2 OLAP Server application is designated as a non-Unicode-mode application (the default), or a Unicode-mode application. Administration Services, MaxL, and the API enable the migration of non-Unicode-mode applications to Unicode mode. Alias Tables will be available so that users can access views of information in their choice of language. Unicode support also extends to the following features: MDX, Query Logging, Hybrid Analysis, Triggers, and Data Mining.
- Metadata Security - Many customers wish to filter metadata members so that they can restrict the ability of users to view these members. DB2 OLAP Server currently filters the data values, but not the member names and aliases. This release of DB2 OLAP Server now adds the ability for administrators to set security on metadata members to provide tailored metadata views to end-users. This will greatly enhance the customer's ability to customize the end-user experience and to deliver extranet applications to their vendors, suppliers, and end customers over the web.
- Remote Authentication Module
- The Remote Authentication Module is an optional component of the
DB2 OLAP Server security platform. The security platform is a
framework that provides DB2 OLAP Server applications with external
authentication and single sign-on capabilities. The Remote
Authentication Module is applicable to the following circumstances:
- DB2 OLAP Server is deployed in a UNIX environment with authentication occurring against a Windows domain.
- DB2 OLAP Server is deployed in a Windows environment, and users must log in to more than one Windows domain without changing the trust relationships.
- Triggers on Write Operations
- This release adds support for triggers based on write and load
operations. Triggers can be used to track certain types of state
changes, create constraints to watch for over a cube area, and track
if the constraints are violated during updates (events) in the area.
If a violation is detected, triggers enable the administrator to
proactively send email alerts or wireless messages, or spool violated
cells into a known file for further action. DB2 OLAP Server V8.2
supports several new trigger features:
- On-update triggers and after-update triggers are now supported. The new after-update triggers fire only after all updates to the database are complete for a specific transaction.
- In MaxL, create trigger statements are supported as well as the existing create or replace trigger statements.
- For on-update triggers, you can now choose to add both old and new data values to the trigger spool file.
- You can set triggers for databases in Unicode-mode applications.
- MaxL Enhancements:
With DB2 OLAP Server V8.2, MaxL now includes the following
enhancements:
- MaxL DML (XML for Analysis) - DB2 OLAP Server now enables access to multidimensional data and metadata through MaxL DML (data-manipulation language). MaxL DML is based on MDX, the XML for Analysis specification and is a robust language and expression syntax for creating and querying cube data. You can use either the MaxL Shell (essmsh) or MDX Editor in Administration Services to execute MDX queries.
- MaxL support for Data Definition Language (DDL) operations such as creation, deletion, updating of users, applications, databases, and database objects.
- New grammar to support aggregate storage application and database operations.
- MaxL support of Unicode
- Addition to the display object statement, for displaying only locked objects.
- Additions to the alter session statement: one addition for setting MDX display options, and one addition enabling compression of the security file.
- Additions to the create trigger statement, for specifying on-update triggers (the default) or after-update triggers. After-update triggers are supported only in traditional block-storage mode.
- Ability to view and delete data-monitoring logs (logs created by triggers) from within the MaxL Shell
- Filter Enhancements: Lines can be added to filter definitions using alter filter. A new level of filter access is added to create filter and alter filter statements
- Improved STDOUT, STDIN, STDERR: Errors can be redirected to STDERR. STDERR and STDOUT can be redirected to a MaxL output log.
- Improved Database-Related Grammar: The text of database notes is displayed as part of display database. Database free-space recovery is available using alter database statement. Explicit restructuring is available in alter database.
- Display Location Aliases per Application
- Display Port Information
- Full ESSCMD Functionality Available in MaxL
- Attribute and drill-through support for Hybrid members - DB2 OLAP Server now enables Hybrid stored members to have attributes associated with them. This greatly enhances the types of applications that DB2 OLAP Server can support. For instance, a DB2 OLAP Server application can now include a large customer dimension stored in the relational data store and have demographics information associated with this customer dimension as attribute dimensions. In addition, drill-through support is now extended to Hybrid members and attribute dimensions. This means that Hybrid levels and attribute dimensions can now be present in a drill-through reports intersection level.
- Data Mining Java Framework - DB2 OLAP Server now includes a data-mining framework. Users can now leverage data mining algorithms using DB2 OLAP Server and their existing analytical data. A number of data mining algorithms are supported out of the box and additional algorithms can be added to the framework through customization.
- Reduced Security-File Fragmentation - Fragmentation of the essbase.sec file can gradually develop when DB2 OLAP Server entities such as users, groups, applications, or databases are removed or changed. This can slow down security-related performance. With this release, the security file is compacted each time the Agent is shut down. Additionally, you can compact the security file without shutting down the Agent.
- API
- DB2 OLAP Server V8.2 provides new features and enhancements for
improved API functionality to support:
- Aggregate Storage Databases
- Various Trigger Functions
- C Outline API Function
- Performance improvements for querying members
- A new API function that verifies the Rules file.
- A new API function that can verify a formula during an outline edit session.
- An upgrade of the Member Information structure to include additional information. Because this structure is retained locally during a client session, several time-consuming retrievals can be eliminated, saving the client session significant time.
- New capability that enables you to issue MDX statements from an application program.
- Many functions added to the DB2 OLAP Server Visual Basic API that provide the same capabilities present in the DB2 OLAP Server C API.
- Performance
- DB2 OLAP Server provides performance improvements in the following
areas:
- Query Performance for Transparent Partitions - Query performance has been improved for transparent partitions containing outlines that have a time dimension with Dynamic Time Series members.
- Performance for Large Outlines - Data load times and overall index size have been improved for large outlines.
- Improved Data Compression - In some instances, compression of the database has been improved. The most significant impact can occur on databases with large block sizes, where the blocks are highly sparse.
- Calculation
- DB2 OLAP Server V8.2 includes the following calculation
enhancements:
- More Control of Currency Conversions after Loading Data
- Calculation Script Control over the Create Blocks on Equation Feature
- Calculation Script Control Over #MISSING Block Creation
- Dimension Build
- DB2 OLAP Server V8.2 includes the following rules file enhancements
for building dimensions:
- Changes to Existing Member Storage Properties
- Replacement of UDA Values
- Dimension Arrangement for Optimal Performance
- Metadata Sampling - DB2 OLAP Server is a multidimensional database engine that provides support for ad hoc analysis. Such analysis is entirely driven by the intuition of the analyst and can be time-consuming as data volume increases. Large cubes tend to have more dimensions and sometimes more levels, making hierarchical navigation very cumbersome. DB2 OLAP Server V8.2 now includes support for metadata sampling, which enables you to analyze on large cubes with a focus on data trends or approximate information in the initial stages. Because you query on a sample of your data, retrieval is quick. Metadata sampling enables you to zoom in on a portion of the vast amount of data in your database in a fraction of the time that it usually takes to analyze the whole database. You can view many samples in a small amount of time and make early decisions. Later, you can follow with organized data exploration. With the introduction of Hybrid Analysis, you can store part of a DB2 OLAP Server cube in a relational database. Metadata sampling enables you to zoom in on all the data that you specify, whether it is in Analytic Services or in an underlying relational database.
- Monitoring Data Changes: Triggers - The DB2 OLAP Server V8.2 triggers feature enables you to monitor data changes in a database efficiently. If data breaks the rules that you have specified, DB2 OLAP Server can send an e-mail (to a user or system administrator) or log the information in a file. You can create and delete triggers using MaxL statements.
- Administration
- DB2 OLAP Server V8.2 provides additional or improved administration
functionality in the following areas:
- Application Log Enhancements
- Multiple Agent Enhancements
- Optimize Outline for Batch Calculation
- Explicit Restructure Command
- Delayed Free Space Recovery
- Improvements have been made to the free space recovery process,
which is the most expensive part of database recovery. Database
recovery takes place any time you load an application that ends
abnormally. Changes have been made to the free space recovery
process, as follows:
- Performance has been improved significantly.
- Free space recovery, which happened automatically before, is now delayed by default. The user must explicitly trigger free space recovery. A configuration option has been added to specify whether or not to delay free space recovery by default.
- Explicit free space recovery has been added with a new MaxL grammar for alter database.
- The GETDBSTATS command adds two lines of information about free space recovery.
- If free space is recoverable, the block counters are estimates and do not necessarily match the number of existing blocks.
- A new C API function, EssRecoverDbFreeSpace, has been added.
- The ESB_DBSTATS_T structure has been changed.
- Server Threads Specified by Application - Previously, the SERVERTHREADS configuration setting could only specify a single server thread value for all applications, meaning each application on the server had to use the same value. Now, users can choose to specify a different number of server threads for certain applications.
- Additional Platform Support and Speadsheet-addin changes - With V8.2, DB2 OLAP Server adds IBM AIX 5.2, Red Hat Linux AS 2.1, Microsoft Windows 2003, and Sun Solaris 9 (Sun OS 5.0.9) to its list of supported platforms. For a complete list of supported operating systems, refer to the Software Requirements section. Spreadsheet-addin for Lotus 1-2-3 is not shipped with DB2 OLAP Server V8.2. Support for Lotus 1-2-3 Release 9.7 is available with the DB2 OLAP Server V8.1 FP5 or higher spreadsheet-addin client in conjunction with DB2 OLAP Server V8.2.
DB2 OLAP Server Administration Services
DB2 OLAP Server Administration Services is a robust, cross-platform graphical user interface that makes administration tasks easy to perform. Administrators can simultaneously view and edit properties for multiple applications, databases, users, scripts and other objects from a single intuitive view. The Administration Services Console also provides wizards, editors, dynamic menus and other tools to help you implement, monitor, and maintain Business Intelligence solutions.
Personalized Multi-Server Administration - Makes it easier for administrators to view and access only the servers, applications, databases, and users they are responsible for managing
Drag-and-drop Creation of Complex Business Logic - Users can rapidly and easily create application models and outlines, calculations, end user profiles and other application metadata
Powerful Scripting Functionality - Enables batch processing of routine administration tasks, enhancing end user productivity and enabling centralized process management
Interactive Administration Editors - Key word color coding and syntax auto-completion make it easy to build and validate administration, calculation, and report creation scripts
Comprehensive Life-cycle Management - Administrators can easily and reliably migrate applications, from development to test to production
Messages Panel and Log Analysis - Users can view, search, filter and analyze information about application and server status, and perform usage analysis by end-user, application and servers
DB2 OLAP Server Administration Services V8.2 Highlights
DB2 OLAP Server Administration Services V8.2 extends the power of DB2 OLAP Server in many ways:
- Support for DB2 OLAP Server enhancements
-
- Aggregate Storage Support: Manage and maintain Aggregate Storage databases. Wizards for migrating Block Storage outline to Aggregate Storage outline
- Metadata security: Adds a layer of security for metadata (dimensions and members) in outlines, similar to read-only security for data cells. In Filter Editor, a new Access type called MetaRead can be applied to dimensions or members in filter definitions to restrict access to them when retrieving an outline in a report.
- Unicode (UTF-8) support: Administration Services fully supports the new DB2 OLAP Server Unicode feature, which enables sharing of database information across computers that are set up for different character sets.
- Data mining framework: To support the new DB2 OLAP Server data mining framework, Administration Services provides a Data Mining menu and a Mining Wizard to help you find hidden relationships and patterns in a database.
- Multiple agent enhancements: The process for a client to connect to multiple Agents on a single machine has been simplified.
- Rules file enhancements for dimension builds: Data Prep Editor supports rules file enhancements for dimension builds, such as arranging dimensions in an hourglass shape and allowing UDA changes.
- Outline optimization: You can optimize an outline for calculation performance either from a right-click menu in Enterprise View or from the Actions menu.
- Extended Functionality in Outline Editor and Outline
Viewer
- Outline Viewer, the fast-loading option for viewing outlines, now
matches the Outline Editor display of all outline and member
properties, including member formulas, aliases, attributes, UDAs, and
so on. Outline Viewer also provides a search facility to locate
specific members in the outline. Outline Editor provides significant
performance improvements, including better performance when opening
large outlines and when drilling down on members with large numbers
of children. The Outline Editor and Outline viewer provide the
following additional improvements:
- Significant performance improvement when drilling down on members with large numbers of children (for example, 50,000 members or more).
- Enhancements in expanding and collapsing outlines (expand entire outline, expand to children, expand to descendants, and collapse to ancestor).
- Ability to undo most operations in the current outline editing session, even after saving the outline. This includes the ability to undo multiple operations at one time.
- Ability to update an outline using a rules file while the outline is open in Outline Editor.
- Ability to search and replace in Outline Editor.
- New options to disable confirmation prompts when deleting or moving members.
- Improved Deployment Options - with support for additional Application Servers and Relational Databases - Deployment options for Administration Services have been increased by adding support for WebSphere and WebLogic as application servers as well as DB2 and Oracle as relational databases
- Administration Server Management
- This release provides the following improvements in Administration
Server management:
- Ability to add multiple Administration Servers to Enterprise View, and to remove Administration Servers from Enterprise View.
- Ability to disconnect from and reconnect to Administration Servers from Enterprise View.
- Ability to check the status of Administration Servers from Enterprise View (Running, Connected, Stopped, or Unknown).
- New Log Viewer and Log Analyzer - Administrators can now easily monitor and chart information from a DB2 OLAP Server log view. Using the new Log Viewer, you can view DB2 OLAP Server logs and application logs. Log Viewer displays up to 5 megabytes (MB) of log information. If the log contains more information, Log Viewer displays the most recent information in the log. You can also specify a starting date from which to view log information, and you can search the log for specific text. You can use the new Log Analyzer to filter, search, and analyze DB2 OLAP Server logs and application logs. Based on filters you choose or create, you can view robust graphical charts for a log.
- New MDX Script Editor - An MDX Script Editor with autocomplete functionality makes it easy to quickly use the power and flexibility of the MDX query language
- Auto-Completion in Script Editors - This release adds auto-completion of script syntax to Calculation Script Editor and Report Script Editor. As you start to type command and function names, a drop-down list is displayed so that you can select the command or function from the list instead of typing it manually. Auto-completion is also available in MaxL Script Editor and MDX Script Editor.
- Rules File Printing - Administrators can now print the content of a rules file, making it easier to debug a rules file
- Management of Database Triggers - You can use the Administration Services Console to view, create, modify, delete, enable, or disable triggers. Triggers are rules that create areas of the database that are monitored during all write operations to the database. When specified conditions are met, certain actions are performed on behalf of the user.
- Users and Groups in Tabular Display - DB2 OLAP Server users and groups are now displayed in a tabular format. This format provides a better overall view of users and groups, and provides greater flexibility and ease in user and group management tasks. From the Users or Groups table, you can perform operations on multiple users and groups at one time.
- Accessibility - The Administration Services Console provides accessibility features, such as keyboard shortcuts, keyboard navigation for tree controls, default focus and default action buttons in dialog boxes and windows, logical tabbing order, keyboard scrolling, tooltips for UI elements, and an accessible help system.
- Start/Stop DB2 OLAP Server Servers Remotely - Administrators can now start and stop DB2 OLAP Server servers remotely. This is supported for DB2 OLAP Server 8.2 and V8.1
- Administration of DB2 OLAP Server Deployment Servers - The Administration Services Console provides an interface to manage DB2 OLAP Server Deployment Servers from the Enterprise View tree. Some DB2 OLAP Server Deployment Server features are activated through a separately licensed DB2 OLAP Server option (High Concurrency option). These features are available only if a valid license is installed that enables the DB2 OLAP Server Deployment Server High Concurrency option. The High Concurrency option enables you to cluster multiple DB2 OLAP Server servers to create a fault-tolerant and load-balancing DB2 OLAP Server configuration. In addition, this option enables connection pooling across multiple named users to provide more efficient use of DB2 OLAP Server connections.
- Export and Import Selection Rules for Partition Areas - To help with creating area mappings in partitions, you can export and import member selection rules. This feature enables you to import selection rules that were previously exported from Application Manager. (Application Manager is a component of DB2 OLAP Server V8.1 that's no longer available with DB2 OLAP Server V8.2).
- Data Preview Grid - Administrators can now navigate data directly from the Administration Services Console
- Database Properties in Tabular Display - Database properties for all databases on Analytic Server can now be viewed from a single table. You can rearrange and sort the items in the table, and you can print and e-mail the contents of the table.
- Extended Administration Services Functionality Using Java Plug-in Components - Administration Services enables you to extend the functionality of the product by developing Java plug-in components. A Developer's Guide explains the concepts, procedures, and examples needed to extend functionality, and a Java API Reference provides descriptions of the classes, interfaces, and methods that a plug-in author implements.
- Reduced Number of Nodes in Enterprise View - The Enterprise View tree now includes fewer nodes. Nodes are no longer duplicated under servers, applications, and databases. These changes facilitate navigation through the tree.
- Migration Wizard Enhancements - Migration Wizard (added in Release 6.5.1) steps you through the process of migrating (copying) applications and databases across Analytic Servers. Several enhancements have been made to Migration Wizard.
- Extended Functionality in Partitioning - Improvements have been made to the partitioning interface, including: You can now import area definitions for partitions from an external text file instead of creating the area definitions manually, and you can use the new Subset dialog box to apply additional rules to a subset of members when defining areas in partitions.
- Support for Long File Names - File names for Analytic Services objects are no longer restricted to 8 characters.
- New Output Options for Reports - When you execute a report script, you can now output the report directly to a console window, a printer, or to a file.
- Text Mode Agent for Administration Server - To facilitate running Administration Server as a Windows service and to eliminate the need to use XWindows on UNIX computers, Administration Server now runs in a text-mode Agent process or DOS window. The previous server user interface has been moved to Administration Services Console. To view Administration Server properties in Enterprise View, right-click the Administration Server node and select Edit properties. Note that XWindows is still needed to run the Administration Services installer on UNIX computers.
- Additional Platform Support - With V8.2, DB2 OLAP Server Administration Services adds IBM AIX 5.2, Red Hat Linux AS 2.1, Microsoft Windows 2003, and Sun Solaris 9 (Sun OS 5.0.9) to its list of supported platforms. For a complete list of supported operating systems, refer to the Software Requirements section.
DB2 OLAP Integration Server (an option of DB2 OLAP Server)
DB2 OLAP Integration Server is a suite of graphical tools and scalable data integration services that will dramatically reduce the time and expense required to create, deploy, and manage tailored applications. DB2 OLAP Integration Server provides a vital link between tailored-made applications based on DB2 OLAP Server and detailed data stored in relational databases.
A centralized OLAP Metadata repository simplifies tailored application administration, promotes reusability of dimensions, calculations, and business rules and facilitates delivery of business-focused applications driving insight across the enterprise. Use DB2 OLAP Integration Server with DB2 OLAP Server to achieve rapid development and deployment of performance management applications that support a wide range of business needs. Built on a flexible, multi-tier architecture, DB2 OLAP Integration Server easily scales to accommodate changing requirements and delivers scalability, performance, and reliability at a low total cost of ownership.
DB2 OLAP Integration Server V8.2 Highlights:
- Support for Aggregate Storage and Block Storage databases - Integration Server V8.2 now includes support for Aggregate Storage and Block Storage databases.
- Unicode (UTF-8) Support - With V8.2, DB2 OLAP Integration Server provides Unicode support for both data sources and OLAP Metadata Catalogs, enabling you to use multiple languages within your business environment. DB2 OLAP Integration Server supports both native and Unicode Text Format (UTF-8) data sources. It also supports separate catalogs for native and UTF-8 applications. When you connect to a catalog and data source, DB2 OLAP Integration Server determines the encoding that you use and ensures that any DB2 OLAP Server applications that you use are in the same encoding. Unicode support is available on both Microsoft Windows and UNIX-based platforms. Hybrid Analysis also now supports Unicode.
- DB2 Cube Views Support - DB2 OLAP Integration Server V8.2 supports IBM DB2 Cube Views so that you that can import and export OLAP model and metaoutline metadata objects between DB2 Cube Views and DB2 OLAP Integration Server. To take advantage of this capability, you first export your models or metaoutlines to an XML file. The XML file maps DB2 OLAP Integration Server metadata objects with DB2 Cube Views metadata objects. The XML file is then used to import the metadata objects between the DB2 catalog and the DB2 OLAP Integration Server metadata catalog.
- Support for DB2 UDB for OS/390 and z/OS V7 - With V8.2, DB2 OLAP Integration Server now includes support for DB2 UDB for OS/390 and z/OS V7.
- Hybrid Analysis Enhancements - With V8.2, Hybrid Analysis is enhanced to include support for Unicode (UTF-8), Dynamic Time Series, and DB2 UDB for OS/390 and z/OS V7.
- Drill through Reporting to Web Sites - DB2 OLAP Integration Server expands the options for drill-through reports by giving you the capability of specifying a Web site as the data source. To take advantage of this option, you can easily customize the drill-through SQL template by replacing the relational data source with an HTML source. DB2 OLAP Integration Server passes the Web site to DB2 OLAP Spreadsheet Services, (or another drill-through client), which then launches the Web site in a browser.
- Drill-through to a Secondary Data Source - In addition to enabling you to drill-through to a Web site as described earlier, DB2 OLAP Integration Server V8.2 gives you an additional option for drill-through reports by giving you the capability of replacing your primary data source with any secondary data source for the report.
- Drill-through Reporting with Attribute Dimensions - In V8.2 of DB2 OLAP Integration Server, drill-through reporting capabilities are greatly expanded for attributes. Now you can select attribute dimensions and attribute members as OLAP intersections.
- Drill-through Reporting with Hybrid Analysis Members - In V8.2 of DB2 OLAP Integration Server, drill-through reporting capabilities are greatly expanded for Hybrid Analysis members. Now you can select hybrid analysis dimensions and hybrid analysis member columns as OLAP intersections.
- Attribute Support for Hybrid Analysis Members - V8.2 of DB2 OLAP Integration Server gives you the option of associating attributes to Hybrid Analysis members. In earlier versions, attributes could not be tagged as Hybrid Analysis enabled hierarchies.
- Alternate Hierarchy Support for Hybrid Analysis - As mentioned earlier, V8.2 of DB2 OLAP Integration Server expands the functionality of Hybrid Analysis by giving you the option of associating Hybrid Analysis members to attribute dimensions and selecting Hybrid Analysis member columns as intersections. DB2 OLAP Integration Server V8.2 further expands the functionality of Hybrid Analysis by supporting alternate hierarchies within your Hybrid Analysis data.
- Shared User-Defined Members
- In V8.2 of DB2 OLAP Integration Server, you can designate your own
user-defined members as shared members. This option enables
user-defined members to share storage space with other members of the
same name.
- Managing different versions of XML models and metaoutlines
- Restoring a past version of an XML model or metaoutline to the current version
- Extended Prefix and Suffix Aliases Functionality
- Several business environments require multiple versions of data.
For example, many companies keep track of order dates, ship dates,
payment-due dates, as well as multiple locations such as order-origin
city and destination city. This data often uses both original names
and code names; for example, Los Angeles and LA. To make tracking
such data easier and more efficient, DB2 OLAP Integration Server V8.2
enables you to attach prefixes and suffixes to aliases when you
perform member loads and data loads. The attached prefixes and
suffixes can take several forms:
- Member names
- Numeric values
- Text values
- Mix of numeric and text values
- Time-based Incremental Loads/Updates
- Using DB2 OLAP Integration Server V8.2, you can perform incremental
updates, loading only data that has changed or been added since your
last data load. To help you monitor data loads, DB2 OLAP Integration
Server keeps track of data load information and displays it in your
Metaoutline Properties dialog box. You can take advantage of this new
feature if your fact table has a time-stamp column. The following
information is updated each time you perform a data load:
- The DB2 OLAP Server name
- The DB2 OLAP Server application name
- The DB2 OLAP Server database name
- The date-time stamp of the last data load
- Enhanced Logging
- To assist you in verifying that data loads are being performed
correctly, DB2 OLAP Integration Server V8.2 creates two files:
- dataloadrecord.txt file containing the first 1,000 successfully loaded records
- hisdld.rul file containing the names of the dimensions loaded followed by the leaf node number of each dimension and member
- Additional DB2 OLAP Server Settings Support
- DB2 OLAP Integration Server V8.2 increases the number of DB2 OLAP
Server settings that can be loaded from a database column during a
data load. These settings are loaded from a database column in the
same way as a Consolidation attribute and a UDA are loaded.
- Comments
- Currency Name attribute
- Currency Category attribute
- Updated Sample Applications
- With V8.2, DB2 OLAP Integration Server updates its sample
applications database to demonstrate several new features and
functionality. Among the features demonstrated in the new sample
applications are the following:
- SQL drill-through
- SQL data load override
- Pass-through SQL
- Use of multiple data sources
- Automatic Migration to V8.2 - When you create or update an OLAP Metadata Catalog for the first time within a new release of DB2 OLAP Integration Server, a set of scripts is automatically run which enable you to migrate to the current release of DB2 OLAP Integration Server from an earlier release.
- New XML Data Type Definition Documents
- V8.2 of DB2 OLAP Integration Server provides two new documents that
give details on OLAP model and metaoutline XML Import/Export data
type definitions (DTDs). The two new documents, XMLImport/Export OLAP
Model DTD and XML Import/Export OLAP Metaoutline DTD are included in
the standard documentation set. Each DTD element is described in
detail:
- The element name in full
- Description of the element, including its function
- Explanation of the parameters for the element
- Any special notes for the element, if applicable
- Additional Platform Support - With V8.2, DB2 OLAP Integration Server adds IBM AIX 5.2, Red Hat Linux AS 2.1, Microsoft Windows 2003, and Sun Solaris 9 (Sun OS 5.09) to its list of supported platforms. For a complete list of supported operating systems, refer to the Software Requirements section.
DB2 OLAP Server Deployment Services (a component of DB2 OLAP Server)
DB2 OLAP Server Deployment Services provides a set of middle-tier services that enables broad deployment of business performance management solutions to large user communities in distributed environments. DB2 OLAP Server Deployment Services extend the scalability and reliability of analytic applications and supports thousands of concurrent users in distributed environments with Web-based architectures. Connection pooling, database clustering, load balancing, and fail over ensure applications are available 24x7x 365.
DB2 OLAP Server Deployment Services also supports the creation and deployment of powerful web oriented analytical applications. Applications written as Java servlets, Java applets, Enterprise Java Beans (EJB) or stand-alone Java applications can easily be deployed using the multi-tier Web-based Deployment Services framework.
Connection Pooling - Enables client requests to share database connections, which improves query response times and conserves software, server and network resources.
High Availability - Enables the creation of an DB2 OLAP Server cluster that serve as a single data source for applications, increasing the availability of analytic data for end user queries. For example, applications can continue to service requests with no user impact when one or more servers within the cluster fails or is taken off-line for update.
Web Optimized - Supports scalable web deployments and can extend seamlessly to the entire extended enterprise. Complements Developer Workbench and Analysis Studio by providing the underlying J2EE based foundation and a full set of Java APIs.
Horizontal Scalability - Enables the creation of an DB2 OLAP Server cluster that serve as a single data source for applications allowing end user requests to be distributed across multiple physical machines, increasing user scalability and ensuring consistent query response times.
DB2 OLAP Server Deployment Services V8.2 Highlights
- Several new Java APIs for custom-defined functions and macros, and for managing security access privileges
- New Java API capabilities for listing calculation functions
- Support for querying DB2 OLAP Server using MDX (new Java API support for MDX); XMLA support
- Supports better password control
- Zero maintenance option for tools users
- Zero maintenance option that enables automated addition of new user information to the DB2 OLAP Server Deployment Services server
- Administrators can now manage DB2 OLAP Server Deployment Services using the DB2 OLAP Server Administration Services Console, as DB2 OLAP Server Deployment Services administration has been integrated into DB2 OLAP Server Administration Services
- Veritas Cluster Server support for DB2 OLAP Server on Windows platform
- Ability to identify and halt specific DB2 OLAP Server requests
- Unicode (UTF-8) support
- Metadata security support
- Ability to perform an Integration Server Drill-Through on a range of cells
- Ability to perform a Drill-Across on a range of cells
- Support for connection pooling with com.essbase.api.metadata and com.essbase.api.datasource
- Support for the DB2 OLAP Server security platform (also referred to as CSS - Common Security Services)
- Support for External Authentication
- Outline caching support for member selection queries
- Backward compatibility with DB2 OLAP Server V8.1
- Additional Platform Support: With V8.2, DB2 OLAP Server Deployment Services adds IBM AIX 5.2, Red Hat Linux AS 2.1, Microsoft Windows 2003, and Sun Solaris 9 (Sun OS 5.0.9) to its list of supported platforms. For a complete list of supported operating systems, refer to the Software Requirements section.
DB2 OLAP Server Spreadsheet Services
DB2 OLAP Server Spreadsheet Services provides a user-friendly spreadsheet environment for OLAP analysis with DB2 OLAP Server. By integrating directly into Excel, users can complete powerful ad-hoc analysis through an already familiar environment. This highly intuitive, ultra-thin spreadsheet client provides full functionality via the Web, and its Web services architecture runs securely across networks and seamlessly through firewalls.
DB2 OLAP Server Spreadsheet Services V8.2 Highlights:
- The new DB2 OLAP Server Query Designer allows DB2 OLAP Server Spreadsheet Services clients to create, save, and open queries, allows access to queries on the open worksheet, and can export queries to report scripts.
- Improved look and feel throughout the product
- Ability for spreadsheet users to change passwords
- Enhanced Member Selection dialog box - dialogs are now modeless and resizable
- Connection and disconnection from servers is now available from the client
- Lightweight installation for client software (MSI client)
- Allow Setting Global and sheet specific Options
- Cascading Reports
- Support for Linked Reporting Objects
- Support for Formula Fill and Formula Preservation
- Unicode (UTF-8) support
- Metadata security support
- DB2 OLAP Integration Server drill-through support
- Hybrid Analysis support
- Backward compatibility with DB2 OLAP Server V8.1
- Support for Sheet Level Options using defined names
- Support for substitution variables
- Support for named ranges
- Support for Dynamic Time Series
- Lock and Send Menu item
- Support for current and many new VBA functions
- Support for localization
- Excel 2003 support
- Additional Platform Support: With V8.2, DB2 OLAP Spreadsheet Services adds IBM AIX 5.2, Red Hat Linux AS 2.1, Microsoft Windows 2003, and Sun Solaris 9 (Sun OS 5.09) to its list of supported platforms. For a complete list of supported operating systems, refer to the Software Requirements section.
DB2 OLAP Server Documentation Installation Improvements
Starting with DB2 OLAP Server V8.2, all DB2 OLAP Server documentation is installed separately from the software product installation.
Program Number
Program name Program number --------------------------------- --------------------------------- DB2 OLAP Server 5724-OLP
Availability of National Languages
Product Language Electronic Physical description Availability Availability date date ---------------- ---------------- ---------------- ---------------- DB2 OLAP Server English US July 30, 2004 August 27, 2004 Dev Ed V8.2.0 DB2 OLAP Server Multilingual(Fre September 30, November 12, Dev Ed V8.2.0 nch, Danish, 2004 2004 Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Chinese - Traditional, Japanese, Hungarian, English US, Czech, Italian, Finnish, Polish) DB2 OLAP Server English US July 30, 2004 August 27, 2004 Pers Ed V8.2.0 DB2 OLAP Server Multilingual(Fre September 30, November 12, Pers Ed V8.2.0 nch, Danish, 2004 2004 Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Chinese - Traditional, Japanese, Hungarian, English US, Czech, Italian, Finnish, Polish) DB2 OLAP Server English US July 30, 2004 August 27, 2004 Std Ed V8.2.0 DB2 OLAP Server Multilingual(Fre September 30, November 12, Std Ed V8.2.0 nch, Danish, 2004 2004 Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Chinese - Traditional, Japanese, Hungarian, English US, Czech, Italian, Finnish, Polish) DB2 OLAP Svr English US July 30, 2004 August 27, 2004 Sprdsht Svc V8.2.0 DB2 OLAP Svr Multilingual(Fre September 30, November 12, Sprdsht Svc nch, Danish, 2004 2004 V8.2.0 Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Chinese - Traditional, Japanese, Hungarian, English US, Czech, Italian, Finnish, Polish)
Education Support
The following educational offerings are available as listed below:
IBM Learning Services courses for OLAP:
- DW600 - DB2 OLAP Server: Up and Running
- DW620 - DB2 OLAP Server: Administration, Tuning, and Partitioning
IBM Global Services, IT Education Services, provides education to support many IBM offerings. Descriptions of courses for IT professionals and managers are on the IBM Learning Services Web site:
http://www-3.ibm.com/services/learning/
Refer to the IBM IT Education Services Web site for information on course locations and availability dates.
Contact your IBM representative for course information.
Offering Information
Product information is available via the Offering Information Web site
http://www.ibm.com/common/ssi
Also, visit the Passport Advantage Web site
http://www.ibm.com/software/passportadvantage
Publications
No publications are shipped with this product.The IBM Publications Center
http://www.ibm.com/shop/publications/order
The Publications Center is a worldwide central repository for IBM product publications and marketing material with a catalog of 70,000 items. Extensive search facilities are provided. Payment options for orders are via credit card (in the U.S.) or customer number for 50 countries. A large number of publications are available online in various file formats, and they can all be downloaded by all countries free of charge.
The IBM Publications Notification System (PNS)
http://service5.boulder.ibm.com/pnsrege.nsf/messages/welcome
PNS enables subscribers to set up profiles of interest by order number/product number. PNS subscribers automatically receive e-mail notifications of all new publications defined in their profiles. These may then be ordered/downloaded from the Publications Center.
The PNS site is available in English and Canadian French.
Title Form Number --------------------------------- --------------------------------- DB2 OLAP Server Installation SC18-9205 Guide (for English-only GA; also, will be updated to -01 level for NLV GA) OLAP Miner User's Guide SC27-1611 (Reshipping the V8.1 edition, but OLAP Miner itself is being called "V8.1.2." Analytical Services New Features SC18-9206 Analytical Services Spreadsheet SC18-9207 Add-in User's Guide for Excel Analytical Services Database SC18-9208 Administrator's Guide. Analytical Services SQL SC18-9209 Interface Guide Integration Services New SC18-9210 Features Integration Services SC18-9211 Administration Guide Integration Services Data SC18-9212 Preparation Guide Integration Services XML SC18-9213 Import/Export OLAP Model DTD definition Integration Services XML SC18-9214 Import/Export OLAP Metaoutline DTD definition Administration Services SC18-9215 Installation Guide Deployment Services Installation SC18-9216 Guide Spreadsheet Services SC18-9276 Installation Guide Analytical Services Technical Reference (html only) Analytical Services Message Reference (html only) Analytical Services API Reference (html only)
Technical Information
Specified Operating Environment
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
- Total disk space required:
- Disk space (console and shell clients only):
- 42 MB total (20 MB for console and common files + 22 MB for Java and Jar files
- 4 MB for Integration Server PDF documentation
DB2 OLAP Server Administration Services - Platforms
- Processor/Version/Platform
- Pentium, or higher, computers for Windows 2000 and Windows 2003 - server only
- Pentium, or higher, computers for Windows 2000, Windows XP and Windows 2003 - client only
- AIX 5L (V5.1, V5.2) on RS/6000 Power PC computers - server only
Note: AIX 5L ML1 and ML4 are not supported - HP-UX 11.0/11i on PA-RISC computers - server only
- Red Hat Linux AS 2.1 for Intel - server only
- Sun Solaris 8/9 (Sun OS 5.8/5.9) - server only
- RAM (server):
- Startup memory: 38 MB (16 MB initial heap + 22 MB for code)
- Working memory: 32 MB * maximum number of request processing threads
in Administration Server
- Note: The default maximum number of processors is 10.
- Outline memory: 1 KB per member for outlines open for editing (This memory is used by the outline API cache when outlines are opened in Outline Editor)
- -Xmx parameter in adminsvr.lax; the default value is 128 MB (Recommended value = initial heap memory + working memory)
- RAM (client):
- Startup memory: 57 MB (consists of 32 MB initial heap + 25 MB for code)
- Working memory: 64 MB per connected DB2 OLAP Server
- Outline memory: 1 KB per visible member (A member is visible if its parent is expanded in Outline Editor or Outline Viewer)
- -Xmx parameter in admincon.lax. The default value is 256 MB (Recommended value = initial heap memory + working memory)
- Disk space:
- 180 MB minimum (server)
- 90 MB minimum (includes Java Development Kit) (client)
DB2 OLAP Server Spreadsheet Services - Platforms
- Processor/Version/Platform
- Pentium, or higher, computers for Windows 2000 and Windows 2003 - server only
- Pentium, or higher, computers for Windows 2000 and Windows XP - client only
- AIX 5L (V5.1, V5.2) on RS/6000 Power PC computers - server only Note: AIX 5L ML1 and ML4 are not supported
- HP-UX 11i on PA-RISC computers - server only
- Red Hat Linux AS 2.1 for Intel - server only
- Sun Solaris 8/9 (Sun OS 5.8/5.9) - server only
- RAM (Server):
- Windows: 128 MB (16 MB initial heap + 22 MB for code)
- UNIX and Linux: 128 MB
- Disk Space:
- Windows: 70 MB (including server software, API, sample applications and documentation, DB2 OLAP Server libraries and Java Runtime Environment) (server)
- UNIX and Linux: 50 MB (including server software, API, sample applications and documentation, DB2 OLAP Server libraries and Java Runtime Environment) (server)
DB2 OLAP Server Deployment Services Platforms
- Processor/Version/Platform
- Pentium, or higher, computers for Windows 2000 and Windows 2003 - server only
- Pentium, or higher, computers for Windows 2000 and Windows XP - client only
- AIX 5L (V5.1, V5.2) on RS/6000 Power PC computers - server only
Note: AIX 5L ML1 and ML4 are not supported - HP-UX 11i on PA-RISC computers - server only
- Red Hat Linux AS 2.1 for Intel - server only
- Sun Solaris 8/9 (Sun OS 5.8/5.9) - server only
- RAM: 128 MB
- Disk space: 148 MB (including server software, API, sample applications and documentation, DB2 OLAP Server libraries and Java Runtime Environment) (server)
DB2 OLAP Server Spreadsheet Add-in for Excel and Runtime Client - Platforms
- Processor: Pentium, or higher, computers for Windows 2000, Windows XP, and Windows 2003
- RAM:
- 16 MB for Spreadsheet Add-in
- 32 MB for Runtime Client
- Disk space:
- 16.7 MB for Spreadsheet Add-In
- 14 MB for Runtime client
DB2 OLAP API Client Development Platforms
- Processor
- Pentium, or higher, computers for Windows 2000 and Windows 2003
- PowerPC computers, including RS/6000 for AIX 5L (V5.1/V5.2)
- Sun SPARC or ULTRASPARC computers for Sun Solaris 8/9 (Sun OS 5.8/5.0)
- HP PA-RISC for HP-UX 11.0/11i
- Red Hat Enterprise Linux AS 2.1 for Intel Microprocessor based computers
- RAM:
- 64 MB (128 MB, or more, recommended) for Windows XP and Windows 2000
- Physical memory: 64 MB (256 MB recommended) for AIX, HP-UX, and Solaris platforms
- Disk space:
- 15 MB for 32-bit DB2 OLAP API on Windows XP and Windows 2000
- 14 MB for AIX, HP-UX, and Solaris platforms
Before installing the product components, you should refer to the Installation Guides for detailed requirements.
DB2 OLAP Server Support
- Operating system
- Windows 2000 SP3 and Windows 2003
- Windows XP Professional (Personal DB2 OLAP Server only)
- AIX 5L (V5.1/V5.2)
Note: AIX 5L ML1 and ML4 are not supported - Sun Solaris 8/9 (Sun OS 5.8/5.9)
- HP-UX 11.0/11i
- RedHat Linux AS 2.1
- Network protocol: TCP/IP
- Java Platform: Java Runtime Environment V1.4.1
DB2 OLAP Integration Server Platforms
- Operating System
- Windows 2000 sp3, Windows XP and Windows 2003 - server and clients
- AIX 5L (V5.1/V5.2) - server only
- Sun Solaris 8/9 (Sun OS 5.8/5.9) - server only
- HP-UX 11i (Note: DB2 OLAP Integration Server is a 32-bit application) - server only
- RedHat Linux AS 2.1 - server only
- Network protocol: TCP/IP
- Java Platform (server only)
- JRE 1.3.1 is shipped with AIX and is required for the XML import export feature only
- JRE 1.4.1 is shipped with HPUX, Solaris and Linux platforms and is required for the XML import export feature only
DB2 OLAP Server Administration Services Platforms
- Operating Systems
- Windows 2000 sp3 and Windows 2003 (server only)
- Windows 2000 sp3, Windows XP and Windows 2003 (console only)
- AIX 5L (V5.1/V5.2) (server only)
- Sun Solaris 8/9 (Sun OS 5.8/5.9) (server only)
- HP-UX 11.0/11i (server only)
- RedHat Linux AS 2.1 (server only)
- Network protocol: TCP/IP
- RDBMS:
- IBM DB2 7.2/8.1
- Oracle 8i and 9i
- Application server:
- IBM Websphere 5.1
- Apache Tomcat Server 4.1.30
- BEA WebLogic Server 8.1
- JRE: Java Runtime Environment V1.4.1
DB2 OLAP Server Spreadsheet Services Platforms
- Operating System (Middle Tier)
- Windows 2000 SP3 and windows 2003
- AIX 5L (V5.1/V5.2)
- Sun Solaris 8/9 (Sun OS 5.8/5.9)
- HP-UX 11i
- RedHat Linux AS/ES/WS 2.1 for Intel
- Operating System (Client)
- Windows 2000 SP3 and Windows XP Professional
- Application Server Support
- Websphere 5.0 (5.0.1 for Solaris) / 5.1
- Weblogic Server 7.0 sp2, 8.1 sp2
- Apache Tomcat 4.1.30
- Sun ONE 7.0
- Network Protocol: HTTP/1.1 and HTTPS
- JRE: Java Runtime Environment V1.4.1 (Build 2)
- Spreadsheet Support: Excel 2003, Excel 2002 (OFfice XP), Excel 2000 and Lotus 9.7 (only when using version V8.1 FP4 (Hyperion 6.5.5.3) or, later, of add-in)
DB2 OLAP Server Deployment Services Platforms
- Operating System
- Windows 2000 sp3 and Windows 2003 (client only)
- Windows 2000 sp3 and Windows XP (middle tier)
- AIX 5L (V5.1/V5.2) (middle tier)
- Sun Solaris 8/9 (Sun OS 5.8/5.9) (middle tier)
- HP-UX 11i (middle tier)
- RedHat Linux AS/ES/WS 2.1 for Intel (middle tier)
- Application Server Support
- Websphere 5.0 (5.0.1 for Solaris) / 5.1
- Weblogic Server 7.0 sp2 and 8.1
- Apache Tomcat 4.1.30
- Sun ONE 7.0
- Network Protocol: TCP/IP, HTTP/1.1 and HTTPS
- JRE: Java Runtime Environment V1.4.1
- RDBMS:
- DB2 UDB 7.2 Fix Pack 7 and DB2 UDB V8.1
- Oracle 9.2.0.1 and 8.1.7
DB2 OLAP Server Spreadsheet Add-in for Excel and Runtime Client Support
- Operating system:
- Windows 2000, Windows XP and Windows 2003
- Spreadsheet version (for Spreadsheet Add-in)
- Excel 2003
- Excel 2002 (Office XP)
- Excel 2000
- Lotus 9.7 (only when using version V8.1 FP4 (Hyperion 6.5.5.3) or, later, of add-in)
- Network protocol: TCP/IP
DB2 OLAP Server API Client Development Platforms
- Operating Systems:
- Windows 2000 sp3 and Windows 2003
- AIX 5L (V5.1/V5.2)
- Sun Solaris 8/9 (Sun OS 5.8/5.9)
- HP-UX 11.0/11i
- RedHat Linux AS 2.1
- RedHat Linux AS/ES/WS 2.1 for Intel (middle tier)
DB2 OLAP Server Miner Platforms
- Operating Systems (server):
- Windows 2000, Windows XP Professional
- AIX 5L (V5.1/V5.2)
- Operating Systems (client):
- Windows 2000, and Windows XP Professional
Compatibility
DB2 OLAP Server
DB2 OLAP Server V8.2 is backward-compatible with V8.1 (including Spreadsheet Add-in, Application Manager), with the following restrictions:
- V8.1 clients must be installed on a different computer from the computer on which DB2 OLAP Server V8.2 is installed
- V8.1 clients must be at the V8.1 Fix pack 2, or later, level
- V8.1 clients can connect only to V8.2 non-Unicode applications
- DB2 OLAP Server Application Manager V8.1 cannot edit non-Unicode V8.2 rules files
- DB2 OLAP Server Application Manager V8.1 does not work with aggregate storage
- Supported API Versions:
- Programs compiled with DB2 OLAP Server V8.2 API do not work with DB2 OLAP Server V8.1.
- DB2 OLAP Server API programs compiled with header files from a specific release must use the libraries from the same release.
For information regarding compatibility between DB2 OLAP Server V8.2
and DB2 OLAP Analyzer V8.1 (as well as DB2 OLAP Server Analyzer
Windows Client V8.1), refer to
http://www.ibm.com/software/data/db2/db2olap/fixpacks.html.
DB2 OLAP Integration Server
DB2 OLAP Server Integration Server V8.2 is backward-compatible with
DB2 OLAP Server V8.1, Fix Pack 3, or later, with the following
restriction: to use the current Hybrid Analysis features or Unicode,
you must connect to DB2 OLAP Server V8.2.
DB2 OLAP Administration Services
DB2 OLAP Server Adminstration Services V8.2 is backward-compatible with DB2 OLAP Server V8.1 Fix pack 1 or later, including Fix Pack 1, Refresh#2 (the Linux platform release for DB2 OLAP Server V8.1), with the following restrictions:
- Although you can connect to an earlier release of DB2 OLAP Server, you cannot use features introduced in later releases of DB2 OLAP Server.
- When you upgrade to a new release of DB2 OLAP Server Administration Services, you must upgrade both the Administration Server and Administration Services Console.
DB2 OLAP Server Spreadsheet Services
DB2 OLAP Server Spreadsheet Services V8.2 is backward-compatible with
DB2 OLAP Server V8.1.
DB2 OLAP Server Deployment Services
DB2 OLAP Server Deployment Services V8.2 is backward-compatible with
DB2 OLAP Server V8.1.
DB2 UDB
DB2 OLAP Server V8.2 and its components are interoperable with Fix
Pack 2 and higher levels of DB2 UDB V8.1.
Websphere Application Server
DB2 OLAP Server V8.2 and its components are interoperable with WebSphere Application Server, V5.0 (5.0.1 for Solaris) and WebSphere 5.1.
Limitations
DB2 OLAP Server V8.2 for English (and the related English-Only features/functions/components) will be Generally Available electronically on July 30, 2004, and physically on August 27, 2004. Customers who desire the Localization version, for use in any other language, will need to wait until the Localization version is Generally Available electronically on September 30 2004. The Localization version will be become Generally Available physically on November 12, 2004.
Planning Information
Customer Responsibilities
The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.
Only the English-language version of DB2 OLAP Server will be available until September 30, 2004. Therefore customers who would like to download, order or install the Globalization version of DB2 OLAP Server, should wait until September 30, 2004 before purchasing or upgrading to DB2 OLAP Server V8.2.
Installability
When upgrading to the latest version of DB2 OLAP Server, keep the following in mind:
DB2 OLAP Server, V8.2 includes a copy of DB2 Universal Database V8 for use only with DB2 OLAP Server. If you want to use this version of DB2 UDB with DB2 OLAP Server, you must apply a fix pack: Fix Pack 2 (or later) of DB2 UDB, V8. You can download this fix pack from the following Web site: http://www.ibm.com/cgi-bin/db2www/data/db2/udb/winos2unix/support/down load.d2w/report
Software Maintenance, previously referred to as Subscription and Technical Support, is now included in the Passport Advantage Agreement. Installation and technical support for the product(s) announced in this letter are provided by the Software Maintenance offering of the IBM International Passport Advantage Agreement. This fee service enhances customer productivity by providing voice and/or electronic access into the IBM support organizations.
Packaging
Media Packs:
- Standard Edition
- Multi Language (including English) CD-ROMs with license information
and documentation for the server and for the four optional programs:
- DB2 OLAP Server Integration Server for Standard Edition V8.2
- DB2 OLAP Server Partitioning Option for Standard Edition V8.2
- DB2 OLAP Server High Concurrency Option for Standard Edition V8.2
- DB2 OLAP Server Tools Bundle for Standard Edition V8.2
- Multi Language (including English) CD-ROMs with license information
and documentation for the server and for the four optional programs:
- Developer's Edition
- Multi Language (including English) CD-ROMs with license information
and documentation for the server and for the two optional programs:
- DB2 OLAP Server Integration Server for Developer's Edition V8.2
- DB2 OLAP Server Partitioning Option for Developer's Edition V8.2
- Multi Language (including English) CD-ROMs with license information
and documentation for the server and for the two optional programs:
- Personal Edition
- Multi Language (including English) CD-ROMs with license information
and documentation for the server and for the three optional programs.
- DB2 OLAP Server Integration Server for Personal Edition V8.2
- DB2 OLAP Server Partitioning Option for Personal Edition V8.2
- DB2 OLAP Server Tools Bundle for Personal Edition V8.2
- Multi Language (including English) CD-ROMs with license information
and documentation for the server and for the three optional programs.
- Spreadsheet Services
- Multi Language (including English) CD-ROMs with license information and documentation for the server.
This program, when downloaded from a Web site, contains the applicable IBM license agreement and License Information (LI), if appropriate. It will be presented for acceptance at the time of installation of the program. The license and LI will be stored in a directory such as LICENSE.TXT for future reference.
Security, Auditability and Control
The DB2 OLAP Administration Server, which is included with DB2 OLAP Server, provides a comprehensive, multilayered security system. There are security elements and tasks associated with the DB2 OLAP data. The DB2 OLAP Security Manager manages DB2 OLAP user access to specific DB2 OLAP applications, cubes, individual data cells, and now members.
The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.
Ordering Information
This product can only be ordered by part numbers. The preferred customer ordering route for IBM WorkStation Software is via remarketers. Refer to Announcement Letters ZA99-0208 and ZA99-0231 for more information on the ordering process for IBM WorkStation Software.
For ordering information on this product, consult your authorized IBM Business Partner or refer to the information on the following IBM Web site
http://www.lotus.com/services/passport.nsf/WebDocs/Passport_Advantage_ Home
Product information
Licensed function Product group Product category title ---------------------- ---------------------- --------------------- DB2 OLAP Integration IBM Database Database Management Server Management Other Other DB2 OLAP Server High IBM Database Database Management Concurrency Standard Management Other Other Edition DB2 OLAP Server Tools IBM Database Database Management Bundle Standard Management Other Other Edition DB2 OLAP Server IBM Database Database Management Standard Edition Management Other Other DB2 OLAP Server IBM Database Database Management Partitioning Option Management Other Other Standard Edition DB2 OLAP Server IBM Database Database Management Partitioning Option Management Other Other Developer Ed DB2 OLAP Server IBM Database Database Management Developers Edition Management Other Other DB2 OLAP Server IBM Database Database Management Integration Server Management Other Other for Developer's Edition DB2 OLAP Server Tools IBM Database Database Management Bundle Personal Management Other Other Edition DB2 OLAP Integration IBM Database Database Management Server Personal Management Other Other Edition DB2 OLAP Server IBM Database Database Management Personal Edition Management Other Other DB2 OLAP Server IBM Database Database Management Partitioning Option Management Other Other Personal Edition IBM DB2 OLAP Server IBM Database Database Management Spreadsheet Services Management Other Other
DB2 OLAP Server V8.2 is available in three editions, plus Spreadsheet Services:
- DB2 OLAP Server Standard Edition V8.2 has two charge units for
"installs" and "concurrent users".
It has four optional components each with a single charge unit of "installs". - DB2 OLAP Server Developer's Edition V8.2 has two charge units for
"installs" and "concurrent users".
It has two optional components each with a single charge unit of "installs". - DB2 OLAP Server Personal Edition V8.2 has one charge unit for
"installs".
It has three optional components each with a single charge unit of "installs". - DB2 OLAP Server Spreadsheet Services has two charge units for "installs" and "users".
Passport Advantage program licenses
DB2 OLAP Server
Part description Part number --------------------------------- --------------------------------- DB2 OLAP INTEGRATION SERVER PERSONAL EDITION DB2 OLAP Svr Personal Ed D5B3CLL Integration Server Install Lic 1 SW Maint 12 Mo DB2 OLAP Svr Pers Ed Integration D5B3FLL Svr Install SW Maint Reinstatement 12 Mo DB2 OLAP Svr Personal Ed E1B3ELL Integration Server Install SW Maint Annual Renewal
DB2 OLAP Server
Part description Part number --------------------------------- --------------------------------- DB2 OLAP SERVER TOOLS BUNDLE PERSONAL EDITION DB2 OLAP Personal Edition Tools E1B36LL Bundle Install SW Maint Annual Renewal DB2 OLAP Personal Edition Tools D5B34LL Bundle Install Lic & SW Maint 12 Mo DB2 OLAP Personal Edition Tools D5B37LL Bundle Install SW Maint Reinstatement 12 Mo
DB2 OLAP Server
Part description Part number --------------------------------- --------------------------------- DB2 OLAP SERVER INTEGRATION SERVER FOR DEVELOPER'S EDITION DB2 OLAP Developer Ed E0080LL Integration Server Install SW Maint Annual Renewal DB2 OLAP Developer Edition D50X3LL Integration Server Install Lic 1 SW Maint 12 Mo DB2 OLAP Developer Ed D50X5LL Integration Svr Install SW Maint Reinstatement 12 Mo
DB2 OLAP Server
Part description Part number --------------------------------- --------------------------------- IBM DB2 OLAP SERVER SPREADSHEET SERVICES DB2 OLAP Server Spreadsheet D526TLL Services User SW Maint Reinstatement 12 Mo DB2 OLAP Server Spreadsheet D526QLL Services Install SW Maint Reinstatement 12 Mo DB2 OLAP Server Spreadsheet E00P0LL Services User SW Maint Annual Renewal DB2 OLAP Server Spreadsheet D526RLL Services User Lic & SW Maint 12 Mo DB2 OLAP Server Spreadsheet D526NLL Services Install Lic & SW Maint 12 Mo DB2 OLAP Server Spreadsheet E00NZLL Services Install SW Maint Annual Renewal
DB2 OLAP Server
Part description Part number --------------------------------- --------------------------------- DB2 OLAP SERVER PARTITIONING OPTION PERSONAL EDITION DB2 OLAP Personal Ed E1B2QLL Partitioning Option Install SW Maint Annual Renewal DB2 OLAP Personal Ed D5B2NLL Partitioning Option Install Lic & SW Maint 12 Mo DB2 OLAP Pers Ed Partitioning D5B2RLL Option Install SW Maint Reinstatement 12 Mo
DB2 OLAP Server
Part description Part number --------------------------------- --------------------------------- DB2 OLAP SERVER PERSONAL EDITION DB2 OLAP Server Personal Edition E1B2YLL Install SW Maint Annual Renewal DB2 OLAP Server Personal Edition D5B2WLL Install Lic & SW Maint 12 Mo DB2 OLAP Server Personal Edition D5B2ZLL Install SW Maint Reinstatement 12 Mo
DB2 OLAP Server
Part description Part number --------------------------------- --------------------------------- DB2 OLAP SERVER DEVELOPERS EDITION DB2 OLAP Server Developer D5B1LLL Edition Conc User SW Maint Reinstatement 12 Mo DB2 OLAP Server Developer D50YXLL Edition Install SW Maint Reinstatement 12 Mo DB2 OLAP Server Developer E1B1KLL Edition Concurrent User SW Maint Annual Renewal DB2 OLAP Server Developer D5B1ILL Edition Conc User Lic & SW Maint 12 Mo DB2 OLAP Server Developer D50YVLL Edition Install Lic & SW Maint 12 Mo DB2 OLAP Server Developer E008KLL Edition Install SW Maint Annual Renewal
DB2 OLAP Server
Part description Part number --------------------------------- --------------------------------- DB2 OLAP SERVER TOOLS BUNDLE STANDARD EDITION DB2 OLAP Server Tools Bundle Std E1B4BLL Ed Install SW Maint Annual Renewal DB2 OLAP Server Tools Bundle D5B49LL Standard Ed Install Lic & SW Maint 12 Mo DB2 OLAP Server Tools Bundle Std D5B4CLL Ed Install SW Maint Reinstatement 12 Mo
DB2 OLAP Server
Part description Part number --------------------------------- --------------------------------- DB2 OLAP SERVER HIGH CONCURRENCY STANDARD EDITION DB2 OLAP Server High Concurrency E007WLL Std Ed Install SW Maint Annual Renewal DB2 OLAP Server High Concurrency D50WPLL Standard Ed Install Lic & SW Maint 12 Mo DB2 OLAP Server High Concurrency D50WRLL Std Ed Install SW Maint Reinstatemnt 12 Mo
DB2 OLAP Server
Part description Part number --------------------------------- --------------------------------- DB2 OLAP INTEGRATION SERVER DB2 OLAP Server Integration E1B1TLL Server Std Ed Install SW Maint Annual Renewal DB2 OLAP Server Integration D5B1RLL Server Std Ed Install Lic & SW Maint 12 Mo DB2 OLAP Svr Integration Svr Std D5B1ULL Ed Installs SW Maint Reinstatement 12 Mo
DB2 OLAP Server
Part description Part number --------------------------------- --------------------------------- DB2 OLAP SERVER PARTITIONING OPTION DEVELOPER ED DB2 OLAP Developer Ed D50X0LL Partitioning Option Install Lic & SW Maint 12 Mo DB2 OLAP Dev Ed Partitioning D50X2LL Option Install SW Maint Reinstatement 12 Mo DB2 OLAP Dev Ed Partitioning E007ZLL Option Install SW Maint Annual Renewal
DB2 OLAP Server
Part description Part number --------------------------------- --------------------------------- DB2 OLAP SERVER PARTITIONING OPTION STANDARD EDITION DB2 OLAP Svr Partitioning Option E1B29LL Std Ed Install SW Maint Annual Renewal DB2 OLAP Server Partitioning D5B27LL Option Std Ed Install Lic & SW Maint 12 Mo DB2 OLAP Svr Partitioning Option D5B2ALL Std Ed Install SW Mnt Reinstatement 12 Mo
DB2 OLAP Server
Part description Part number --------------------------------- --------------------------------- DB2 OLAP SERVER STANDARD EDITION DB2 OLAP Server Standard Edition D5B3KLL Install Lic & SW Maint 12 Mo DB2 OLAP Server Standard Edition E1B3MLL Install SW Maint Annual Renewal DB2 OLAP Server Standard Edition E1B3VLL Conc User SW Maint Annual Renewal DB2 OLAP Server Standard Edition D5B3TLL Conc User Lic & SW Maint 12 Mo DB2 OLAP Server Standard Edition D5B3WLL Conc User SW Maint Reinstatement 12 Mo DB2 OLAP Server Standard Edition D5B3NLL Install SW Maint Reinstatement 12 Mo
Passport Advantage supply
Program name/description Part number --------------------------------- --------------------------------- DB2 OLAP SERVER DEV ED V8.2.0 Media Pack English US Windows BB0JXNA 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard V8.2.0 Media Pack Multilingual(French, BB0JUML Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x CD-ROM Digital Disk - ISO 9660 Standard V8.2.0 DB2 OLAP SERVER PERS ED V8.2.0 Media Pack English US Windows BB0JYNA 2000, Windows XP, Windows Server 2003 CD-ROM Digital Disk - ISO 9660 Standard V8.2.0 Media Pack Multilingual(French, BB0JVML Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Windows Server 2003 CD-ROM Digital Disk - ISO 9660 Standard V8.2.0 DB2 OLAP SERVER STD ED V8.2.0 Media Pack English US Windows BB0JZNA 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard V8.2.0 Media Pack Multilingual(French, BB0JWML Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard V8.2.0 DB2 OLAP SVR SPRDSHT SVC V8.2.0 Media Pack English US Windows BB0K7NA 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard V8.2.0 Media Pack Multilingual(French, BB0K7ML Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard V8.2.0
Passport Advantage customer: media pack entitlement details
Customers with active maintenance or subscription for the products listed are entitled to receive the corresponding media pack.
DB2 OLAP Server Dev Ed V8.2.0
Entitled Maintenance Media Packs Part Number Offerings Description Description ---------------------- ---------------------- --------------------- DB2 OLAP PARTITION DB2 OLAP Server Dev BB0JXNA OPTION SVR INSTL Ed English US Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP PARTITION DB2 OLAP Server Dev BB0JUML OPTION SVR INSTL Ed Multilingual(French, Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP DEVELOPER DB2 OLAP Server Dev BB0JXNA EDITION CONC USR Ed English US Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP DEVELOPER DB2 OLAP Server Dev BB0JUML EDITION CONC USR Ed Multilingual(French, Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP DEVELOPER ED DB2 OLAP Server Dev BB0JXNA SVR INSTALL Ed English US Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP DEVELOPER ED DB2 OLAP Server Dev BB0JUML SVR INSTALL Ed Multilingual(French, Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP INTEGRATION DB2 OLAP Server Dev BB0JXNA SVR SVR INSTL Ed English US Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP INTEGRATION DB2 OLAP Server Dev BB0JUML SVR SVR INSTL Ed Multilingual(French, Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x CD-ROM Digital Disk - ISO 9660 Standard
DB2 OLAP Server Pers Ed V8.2.0
Entitled Maintenance Media Packs Part Number Offerings Description Description ---------------------- ---------------------- --------------------- DB2 OLAP PERS ED DB2 OLAP Server Pers BB0JYNA TOOLS BNDL Ed English US Windows 2000, Windows XP, Windows Server 2003 CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP PERS ED DB2 OLAP Server Pers BB0JVML TOOLS BNDL Ed Multilingual(French, Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Windows Server 2003 CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP PERS ED DB2 OLAP Server Pers BB0JYNA INTEGRATION SVR Ed English US Windows 2000, Windows XP, Windows Server 2003 CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP PERS ED DB2 OLAP Server Pers BB0JVML INTEGRATION SVR Ed Multilingual(French, Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Windows Server 2003 CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP PERS EDITION DB2 OLAP Server Pers BB0JYNA Ed English US Windows 2000, Windows XP, Windows Server 2003 CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP PERS EDITION DB2 OLAP Server Pers BB0JVML Ed Multilingual(French, Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Windows Server 2003 CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP PERS ED DB2 OLAP Server Pers BB0JYNA PARTITION OPT Ed English US Windows 2000, Windows XP, Windows Server 2003 CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP PERS ED DB2 OLAP Server Pers BB0JVML PARTITION OPT Ed Multilingual(French, Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Windows Server 2003 CD-ROM Digital Disk - ISO 9660 Standard
DB2 OLAP Server Std Ed V8.2.0
Entitled Maintenance Media Packs Part Number Offerings Description Description ---------------------- ---------------------- --------------------- DB2 OLAP HIGH DB2 OLAP Server Std BB0JZNA CONCURRENCY SVR INSTL Ed English US Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP HIGH DB2 OLAP Server Std BB0JWML CONCURRENCY SVR INSTL Ed Multilingual(French, Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP TOOLS BNDL DB2 OLAP Server Std BB0JZNA Ed English US Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP TOOLS BNDL DB2 OLAP Server Std BB0JWML Ed Multilingual(French, Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP SVR STD ED DB2 OLAP Server Std BB0JZNA INTEGRATION SVR Ed English US Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP SVR STD ED DB2 OLAP Server Std BB0JWML INTEGRATION SVR Ed Multilingual(French, Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP SERVER STD DB2 OLAP Server Std BB0JZNA EDITION USER Ed English US Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP SERVER STD DB2 OLAP Server Std BB0JWML EDITION USER Ed Multilingual(French, Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP SERVER STD DB2 OLAP Server Std BB0JZNA EDITION INSTALL Ed English US Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP SERVER STD DB2 OLAP Server Std BB0JWML EDITION INSTALL Ed Multilingual(French, Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP PARTITION DB2 OLAP Server Std BB0JZNA OPT Ed English US Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP PARTITION DB2 OLAP Server Std BB0JWML OPT Ed Multilingual(French, Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard
DB2 OLAP Svr Sprdsht Svc V8.2.0
Entitled Maintenance Media Packs Part Number Offerings Description Description ---------------------- ---------------------- --------------------- DB2 OLAP Server DB2 OLAP Svr Sprdsht BB0K7NA Spreadsheet Services Svc English US User Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP Server DB2 OLAP Svr Sprdsht BB0K7ML Spreadsheet Services Svc User Multilingual(French, Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP Server DB2 OLAP Svr Sprdsht BB0K7NA Spreadsheet Services Svc English US Server Install Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard DB2 OLAP Server DB2 OLAP Svr Sprdsht BB0K7ML Spreadsheet Services Svc Server Install Multilingual(French, Danish, Russian, Korean, Chinese - Simplified, Spanish, Norwegian Bokmal, Brazilian Portuguese, German, Swedish, Japanese, Chinese - Traditional, Hungarian, English US, Czech, Italian, Finnish, Polish) Windows 2000, Windows XP, Solaris (SUN Microsystems), Windows Server 2003, AIX V5.x, HP-UX 11.x, Linux for x86Series Intel-based servers CD-ROM Digital Disk - ISO 9660 Standard
Withdrawal of Previous Passport Advantage Part Numbers
IBM will withdraw from marketing the following parts licensed under the IBM International Program License Agreement on the dates specified.
Program Program Part Part number Withdrawal name number description from marketing date ------------ ------------- ------------- ------------- ------------ DB2 OLAP 5724-OLP DB2 OLAP BB00MJA 11/12/04 Server SERVER V8.1.0 DEVELOPER EDITION 8.1 DOC PACK JPN DB2 OLAP 5724-OLP DB2 OLAP BB00NJA 11/12/04 Server SERVER V8.1.0 PERSONAL EDITION 8.1 DOC PACK JPN DB2 OLAP 5724-OLP DB2 OLAP BB00LJA 11/12/04 Server SERVER V8.1.0 EDITION V8.1 JAPANESE DOC PACK DB2 OLAP 5724-OLP DB2 OLAP BB00IJA 11/12/04 Server SERVER V8.1.0 DEVELOPER EDITION 8.1 PA CD MEDIA PACK JPN DB2 OLAP 5724-OLP DB2 OLAP BB00IKO 11/12/04 Server SERVER V8.1.0 DEVELOPER EDITION 8.1 PA CD MEDIA PACK KOR DB2 OLAP 5724-OLP DB2 OLAP BB00ISC 11/12/04 Server SERVER V8.1.0 DEVELOPER EDITION 8.1 PA CD MEDIA PACK SCH DB2 OLAP 5724-OLP DB2 OLAP BB00IML 11/12/04 Server SERVER V8.1.0 DEVELOPER EDITION V8.1 MEDIA PACK MULTILINGUAL DB2 OLAP 5724-OLP DB2 OLAP BB00ITC 11/12/04 Server SERVER V8.1.0 DEVELOPER EDITION V8.1 PA CD MEDIA PACK TCH DB2 OLAP 5724-OLP DB2 OLAP BB00JJA 11/12/04 Server SERVER V8.1.0 PERSONAL EDITION 8.1 PA CD MEDIA PACK JPN DB2 OLAP 5724-OLP DB2 OLAP BB00JKO 11/12/04 Server SERVER V8.1.0 PERSONAL EDITION 8.1 PA CD MEDIA PACK KOR DB2 OLAP 5724-OLP DB2 OLAP BB00JSC 11/12/04 Server SERVER V8.1.0 PERSONAL EDITION 8.1 PA CD MEDIA PACK SCH DB2 OLAP 5724-OLP DB2 OLAP BB00JTC 11/12/04 Server SERVER V8.1.0 PERSONAL EDITION 8.1 PA CD MEDIA PACK TCH DB2 OLAP 5724-OLP DB2 OLAP BB00JML 11/12/04 Server SERVER V8.1.0 PERSONAL EDITION V8.1 MEDIA PACK MULTILINGUAL DB2 OLAP 5724-OLP DB2 OLAP BB0GVNA 11/12/04 Server SERVER V8.1.0 SPREADSHEET SERVICES 8.1 MEDIA PACK ENGLISH DB2 OLAP 5724-OLP DB2 OLAP BB00HJA 11/12/04 Server SERVER V8.1.0 STANDARD EDITION 8.1 PA CD MEDIA PACK JPN DB2 OLAP 5724-OLP DB2 OLAP BB00HKO 11/12/04 Server SERVER V8.1.0 STANDARD EDITION 8.1 PA CD MEDIA PACK KOR DB2 OLAP 5724-OLP DB2 OLAP BB00HSC 11/12/04 Server SERVER V8.1.0 STANDARD EDITION 8.1 PA CD MEDIA PACK SCH DB2 OLAP 5724-OLP DB2 OLAP BB00HTC 11/12/04 Server SERVER V8.1.0 STANDARD EDITION 8.1 PA CD MEDIA PACK TCH DB2 OLAP 5724-OLP DB2 OLAP BB00HML 11/12/04 Server SERVER V8.1.0 STANDARD EDITION V8.1 MEDIA PACK MULTILINGUAL
Orders for these part numbers will not be accepted after the stated effective date of withdrawal, nor will normal marketing activities or educational support be available unless previous agreement exists between the customer and IBM.
Integrated Technology Services (IBM Global Services)
Contact your IBM Representative for the list of selected services available in your country, either as standard or customized offerings for the efficient installation, implementation and/or integration of this product.
Pricing
Passport Advantage
For Passport Advantage information and charges, contact your IBM representative or authorized IBM Business Partner. Additional information is also available at
http://www.ibm.com/software/passportadvantage
Terms and Conditions
This product is only available via Passport Advantage. It is not available as shrinkwrap.
Licensing
IBM International Program License Agreement (IPLA). Proofs of Entitlement (PoE) are required for all authorized use.
Part number products only, offered outside of Passport Advantage, where applicable, are license only and do not include Software Maintenance.
Passport Advantage applies
Yes and through the Passport Advantage Web site at
http://www.ibm.com/software/passportadvantage
AS/400 Software Subscription applies
No
Limited Warranty
Yes
Warranty: This program has warranty for a minimum of one year from acquisition from IBM or authorized IBM Business Partner. The warranty provided to the customer, for at least one year from acquisition, is access to databases (read Web sites) for program information and FAQs, including any known fixes to defects, which the customer can download or obtain otherwise and install at leisure.
Usage Restriction
Yes
Microsoft Development Network: This Program may contain elements of the Microsoft Development Network. IBM's license with Microsoft prohibits users of this Program from externally distributing commercial products created with this Program and containing such elements without first obtaining a separate license from Microsoft.
OLAP functionality modification: You may not authorize or permit any other party, as part of a service offering or otherwise, to access the Program or any component thereof, for the purpose of allowing such party to use the Program or any component thereof, to develop or significantly modify OLAP applications, for example, an application that creates or modifies dimensions or calculations at the server, unless such party is developing such applications on your behalf and at your cost and expense.
Warranty: This program has program services for a minimum of one year from the date of notification of an end to support for this Program.
Program technical support: Technical Support of the program will be available for a minimum of three years from the general availability date, as long as your Software Maintenance is in effect. This Technical Support allows you to obtain assistance (via telephone or electronic means) from IBM for program-specific, task-oriented questions regarding the installation and operation of the program. Software Maintenance also provides you with access to updates, releases, and versions of the program. Customers will be notified, via announcement letter, of discontinuance of support with 12 months' notice. If you require additional technical support from IBM, including an extension of support beyond the discontinuance date, contact your IBM representative or Business Partner. This extension may be available for a fee.
The DB2 OLAP Server Standard Edition V8.2, DB2 OLAP Server Personal Edition V8.2, and DB2 OLAP Server Developer's Edition V8.2 each consist of a number of packaged components as well as optional features that can be purchased separately. The program-unique terms of the DB2 OLAP Server V8.2 license supersede and replace the terms of the program unique terms for each of the individual components comprising this program.
** The following program-unique terms apply to DB2 OLAP Server Standard Edition V8.2:
DB2 OLAP Server Standard Edition V8.2 includes the following components:
- DB2 OLAP Server V8.2
- DB2 OLAP Server Administration Services V8.2
- DB2 OLAP Server Deployment Services V8.2 (requisite for, but does not include High-Concurrency Option)
- DB2 Universal Database Enterprise Server Edition for Linux, UNIX, and Windows V8
The use-based charges described here supersede any use-based charges that may appear in the licenses for each of these components. However, all other terms or restrictions described in licenses for these components continue to apply unless otherwise modified here.
In addition, for customers and Business Partners who want to purchase additional components (features) in conjunction with their development or production use of DB2 OLAP Server, the following additional components are available:
- DB2 OLAP Server Integration Server for Standard Edition V8.2
- DB2 OLAP Server Partitioning Option for Standard Edition V8.2
- DB2 OLAP Server High Concurrency Option for Standard Edition V8.2
- DB2 OLAP Server Tools Bundle for Standard Edition V8.2 which includes
the following subcomponents:
- OLAP API
- SQL API
- CSLSQL API
- Spreadsheet Add-in (Macros)
- Currency Conversion
- DB2 OLAP Server Spreadsheet Services
Usage Restriction -- Use as program bundle only
This program is comprised of various components, and the components are licensed for use solely in combination with the packaged components. None of the included components may be used, transferred, sublicensed, or redistributed individually or in any combination of components other than as a complete package consisting of each and all of the components listed here.
Use-based charges -- Resources
Charges for this Program are based on server install, plus the number of concurrent users that are attached or available to the DB2 OLAP Server on which it is licensed. A DB2 OLAP Server is defined as a single OLAP multi-dimensional database image across a single SMP (regardless of the number of virtual partitions) or multiple server configuration. The total number of concurrent users may not exceed the number authorized by the applicable PoEs or authorized by each program authorization acquired under Passport Advantage. If the total number exceeds the quantity in your PoEs or exceeds your program authorizations acquired under Passport Advantage, you must notify IBM or its reseller as stated in the IPLA.
Resource and use restriction
Single server only
All components provided with the Program can only be installed and used with the DB2 OLAP Server for which this Program is licensed, unless otherwise authorized in the license for the individual components.
DB2 Universal Database V8 -- Limited use only
The copy of DB2 Universal Database V8 that is provided with the Program may only be used in conjunction with DB2 OLAP Server V8.2 to provide data warehouse/retention capability related to production and development use. If additional use is required, by programs other than DB2 OLAP Server and its associated components, additional DB2 Universal Database V8 program entitlements must be acquired.
Limited platform support
If the Program is acquired under the terms of an IBM offering for limited platform support (for instance, the program is acquired for use on a single platform or less than all available platforms), then the Program is licensed only for installation and use on the specific platforms or operating systems as designated by the offering terms and conditions.
High availability/failover licensing
In Idle Standby or Active Standby, you must acquire the correct number of program authorizations:
- An idle standby server has DB2 OLAP Server installed on it, but that DB2 OLAP Server is not processing any end-user transactions or query workloads. The DB2 OLAP server is considered "idle" if it is used exclusively for administrative actions that assist in failover scenarios. In Idle Standby, you must license the program for one (1) server install on the Idle Standby server; no concurrent user licenses are required.
- An active standby server has an independent, operational DB2 OLAP Server that services user transactions and queries. Because the active standby machine is used for user transactions and queries before or after a failure, it must be fully licensed. In Active Standby, you must license the Program for the server, as well as the maximum number of concurrent user connections that can be associated with the active standby server.
Software maintenance applies: Yes
** The following program-unique terms apply to DB2 OLAP Server Personal Edition V8.2:
DB2 OLAP Server Personal Edition V8.2 includes the following components:
- DB2 OLAP Server V8.2
- DB2 OLAP Server Administration Services V8.2
- DB2 Universal Database Personal Edition for Linux, UNIX, and Windows V8
DB2 OLAP Server Personal Edition is only licensed to customers who have already licensed DB2 OLAP Server Standard Edition.
The use-based charges described here supersede any use-based charges that may appear in the licenses for each of these components. However, all other terms or restrictions described in licenses for these components continue to apply unless otherwise modified here.
In addition, for customers and/or business partners who wish to purchase additional components (features) in conjunction with their development and/or production use of DB2 OLAP Server, the following additional components are available:
- DB2 OLAP Server Integration Server for Personal Edition V8.2
- DB2 OLAP Server Partitioning Option for Personal Edition V8.2
- DB2 OLAP Server Tools Bundle for Personal Edition V8.2 which includes
the following subcomponents:
- OLAP API
- SQL API
- CSLSQL API
- Spreadsheet Add-in (Macros)
- Currency Conversion
Usage Restriction -- Use as program bundle only
This program is comprised of various components which are licensed for use solely in combination with the packaged components. None of the included components may be used, transferred, sublicensed or redistributed individually or in any combination of components other than as a complete package consisting of each and all of the components listed here.
Use-based charges -- Resources
Charges for this program are based on portable/workstation install only. A DB2 OLAP Server is defined as a single OLAP multi-dimensional database image across a single portable PC or workstation (regardless of the number of virtual partitions).
Resource and use restriction
Single portable/workstation only
All components provided with the program can only be installed and used with the DB2 OLAP Server for which this program is licensed, unless otherwise authorized in the license for the individual components.
DB2 Universal Database V8 -- Limited use only
The copy of DB2 Universal Database Personal Edition V8 that is provided with the program may only be used in conjunction with DB2 OLAP Server V8.2 to provide data warehouse/retention capability related to production and development use. If additional use is required, by programs other than DB2 OLAP Server and its associated components, additional DB2 Universal Database V8 program entitlements must be acquired.
Limited platform support
If the program is acquired under the terms of an IBM offering for limited platform support (for instance, the program is acquired for use on a single platform or less than all available platforms), then that program is licensed only for installation and use on the specific platforms or operating systems as designated by the offering terms and conditions.
High availability/failover licensing
The DB2 OLAP Server High Concurrency Option is not available for DB2 OLAP Server Personal Edition. Therefore there is no High Availability or High Concurrency/failover option available for this edition.
** The following program-unique terms apply to DB2 OLAP Server Developer's Edition V8.2:
DB2 OLAP Server Developer's Edition V8.2 includes the following components:
- DB2 OLAP Server V8.2
- DB2 OLAP Server Administration Services V8.2
- DB2 OLAP Server Deployment Services V8.2 (Requisite for, but does not include High-Concurrency Option)
- DB2 OLAP Server High Concurrency Option
- DB2 OLAP Server Tools Bundle which includes the following
subcomponents:
- OLAP API
- SQL API
- CSLSQL API
- Spreadsheet Add-in (Macros)
- Currency Conversion
- DB2 Universal Database for Linux, UNIX and Windows V8
DB2 OLAP Server Developer's Edition is licensed for installation and use only for the purpose of evaluating, demonstrating, testing, and developing application programs.
The use-based charges described here supersede any use-based charges that may appear in the licenses for each of these components. However, all other terms or restrictions described in licenses for these components continue to apply unless otherwise modified here.
In addition, for customers and/or business partners who wish to purchase additional components (features) in conjunction with their development use of DB2 OLAP Server, the following additional components are available:
DB2 OLAP Server Integration Server for Developer's Edition V8.2
DB2 OLAP Server Partitioning Option for Developer's Edition V8.2
DB2 OLAP Server Spreadsheet Services V8.2
Usage Restriction -- Use as program bundle only
This program is comprised of various components, and the components are licensed for use solely in combination with the packaged components. None of the included components may be used, transferred, sublicensed or redistributed individually or in any combination of components other than as a complete package consisting of each and all of the components listed here.
Use-based charges -- Resources
Charges for this program are based on server install, plus the number of concurrent users that are attached or available to the DB2 OLAP Server on which it is licensed. A DB2 OLAP Server is defined as a single OLAP multi-dimensional database image across a single SMP (regardless of the number of virtual partitions) or multiple server configuration. The total number of concurrent users may not exceed the number authorized by the applicable PoEs or authorized by each program authorization acquired under Passport Advantage. If the total number exceeds the quantity in your PoEs or exceeds your program authorizations acquired under Passport Advantage, you must notify IBM or its reseller as stated in the IPLA.
Resource and use restriction
Single server only
All components provided with the program can only be installed and used with the DB2 OLAP Server for which this program is licensed, unless otherwise authorized in the license for the individual components.
DB2 Universal Database V8 Limited use only
The copy of DB2 Universal Database Developer's Edition V8 that is provided with the program may only be used in conjunction with DB2 OLAP Server Developer's Edition V8.2 to provide data warehouse/retention capability related to production and development use. If additional use is required, by programs other than DB2 OLAP Server and its associated components, additional DB2 Universal Database V8 program entitlements must be acquired.
Limited platform support
If the program is acquired under the terms of an IBM offering for limited platform support (for instance, the program is acquired for use on a single platform or less than all available platforms), then that program is licensed only for installation and use on the specific platforms or operating systems as designated by the offering terms and conditions.
High availability/failover licensing
The DB2 OLAP Server High Concurrency Option is not available for sale with DB2 OLAP Server Developer's Edition as it is already included in the purchase of the base Developer's Edition license. Therefore there is no High Availability or High Concurrency/failover option available for this edition.
Software Maintenance Applies
Volume Orders
No
Guarantee
If for any reason you are dissatisfied with the program, return it within 30 days from the invoice date, to the party (either IBM or its reseller) from whom you acquired it, for a refund. This applies only to your first acquisition of the program.
Educational Allowance
Education Allowance does not apply.
Education Software Allowance does not apply.
Special education prices are available for qualified customers through Passport Advantage.
Announcement Countries
All European, Middle Eastern and African Countries except:
- Sudan
- Iran
- Lybian Arab Republic
- Iraq
- Syria
The data in this letter is subject to the disclaimer in Letter ZS90-0112, which is available from the same IBM announcement letters database.
This announcement is provided for your information only. For additional information, please contact your IBM Representative or IBM Business Partner as appropriate.