IBM United States
Software Announcement 203-075
March 25, 2003
IBM DB2 OLAP Server for z/OS, V8.1 Delivers Numerous Performance and Ease-of-Use Improvements
(Corrected on April 2, 2003) Added paragraph to Software Requirements section
regarding Integration Server feature restriction.
At a Glance
DB2 OLAP Server for z/OS, V8.1:
For ordering, contact:
Your IBM representative, an IBM Business Partner, or the Americas Call Centers at 800-IBM-CALL (Reference: YE001).
DB2 OLAP Server for z/OS, V8.1 helps you analyze and transform data on your zSeries or S/390® into business insights, without having to move data to other platforms. Based on Hyperion Essbase 6.5.1, DB2 OLAP Server for z/OS, V8.1 delivers significant functionality, scalability, performance, usability, and administration enhancements.
Hybrid Analysis for Cube Scalability: A logical cube can now be defined to include, in lower portions of the cube, cells whose values physically reside in a relational database. This saves space and combines the efficiency of mass data scalability with the sophisticated data analysis.
Improved Parallelism for Performance and Throughput: Critical operations such as calculation, data load, and export can now be parallelized by running them in multithreaded mode, to give you huge performance benefits.
Improvements via zFS: By using zFS, this release delivers significant performance improvements for load and calculation processing. It also brings you ease of data set maintenance.
Integration Server Improvements: Support for Hybrid Analysis, multiple data source connections, formula verification, and z/OS and OS/390® specific enhancements such as support for multiple ports and the ability for users in a group to share metadata are added to this release.
OLAP Miner for Deviation Discovery: OLAP Miner combines the powerful IBM data mining technologies with OLAP technologies to empower users to discover anomalies, special segments, and notable fluctuations in critical business data.
Installation and Documentation Improvements: A more comprehensive Installation and Administration Guide streamlines the installation process. Client installation can now be done over the network. A code-page conversion utility is included to simplify installation.
Security Enhancements: Users can now change their RACF® password through the Application Manager interface or the Spreadsheet interface.
Administration Enhancements: This release brings you improvements to production workflow and productivity. Several new templates and scripts are shipped, which can be customized to automate OLAP processes. Users can capture and route statistics and other information to STDOUT and STDERROR. In addition, the new MEMCHECK utility can be used to protect from memory related failures.
Add-Ons: Several add-on1 products and entitlements can be ordered for use with DB2 OLAP Server for z/OS, V8.1.
DB2 OLAP Server for z/OS, V8.1, based on Hyperion Essbase 6.5.1, runs on UNIX® System Services of z/OS and OS/390 and takes advantage of these operating system platforms to bring you functionality previously made available on UNIX and Windows® platforms via DB2 OLAP Server V8.1 (Workstation) and on the iSeries platform via DB2 OLAP Server for iSeries, V8.1. Windows clients are connected to the DB2 OLAP Server for z/OS TCP/IP.
DB2 OLAP Server for z/OS, V8.1 comes with host components. In addition, components and add-on programs that are available with DB2 OLAP Server V8.1 (Workstation), can now be ordered for use with DB2 OLAP Server for z/OS, V8.1. A complete configuration for DB2 OLAP Server for z/OS, V8.1 involves components from this announcement and components from the announcement for DB2 OLAP Server V8.1 (Workstation).
For information on DB2 OLAP Server V8.1 (Workstation) and its optional
add-on programs, refer to Software Announcement
, dated April 9, 2002, and Software Announcement
, dated July, 16, 2002.
What's New in DB2 OLAP Server for z/OS, V8.1
DB2 OLAP Server for z/OS, V8.1 is based on Hyperion Essbase 6.5.1 and also integrates a number of enhancements from Hyperion Essbase 6.2 and 6.1. The OLAP Miner feature is included in DB2 OLAP Server for z/OS, V8.1. In addition, this release introduces a number of z/OS and OS/390 specific enhancements. Major enhancements available in DB2 OLAP Server for z/OS, V8.1 include:
Hybrid Analysis for Cube Scalability: The administrator can now define a multidimensional cube where the lower level members can reside on a relational database and the higher level members reside on the multidimensional store. The OLAP Server will access the relational source, prepare the cells, and return to the calling application as if data natively resides on the multidimensional store. The OLAP Server can therefore access lower level data in a relational database seamlessly. It:
The Hybrid Analysis function in DB2 OLAP Server for z/OS, V8.1 essentially has extended the OLAP Server:
DB2 OLAP Integration Server is required for data description tasks of Hybrid Analysis.
Parallelism to Improve Performance and Throughput: Previously the Essbase mode performed tasks serially. With DB2 OLAP Server for z/OS, V8.1, parallelism is extended to help exploit the modern hardware and to improve system performance and throughput.
Integration Server Improvements: DB2 OLAP Integration Server is based on Essbase Integration Services 6.5.1.
Integration Server Improvements Specific to z/OS and OS/390:
Improvements via zFS: With this release, the product no longer uses VSAM/Media Manager, but instead uses zFS (zSeries File System), a UNIX file system for z/OS and OS/390, with improved performance and function. This provides customers with numerous benefits, including the following:
Note: It is recommended that compatibility mode aggregates be used for the initial deployment of zFS.
OLAP Miner for Deviation Discovery: DB2 OLAP Server Miner is a no-charge feature of DB2 OLAP Server. OLAP Miner combines the powerful IBM data mining technologies with OLAP technologies.
OLAP Miner enables you to examine your OLAP cubes (multidimensional databases) more thoroughly and easily by finding atypical or deviant values automatically. Instead of searching through your data manually to find data values that might be higher or lower than you expected, OLAP Miner can do this work for you. The OLAP Miner algorithm is optimized so that it can be deployed on large OLAP cubes.
You can search specific areas (subcubes) of your cubes by creating deviation detection definitions, which specify the way in which OLAP Miner examines the data that you selected for the subcube. OLAP Miner gives you an easy-to-use wizard that helps you create deviation detection definitions.
After you create a deviation detection definition, OLAP Miner applies a deviation detection algorithm to the data to find deviations. After the mining run is finished, you can view a simple list of deviations or view the deviations in the Deviation Viewer. From the Deviation Viewer, you can see the deviations in the context of other surrounding values. You can also view deviations in a standard spreadsheet application. If you have the DB2 OLAP Server spreadsheet add-in, you can use all of the features of that product to view or report deviations.
Documentation Improvements: A more comprehensive Installation and Administration Guide streamlines the installation process, resulting in significant usability improvements. It provides planning, installation, and configuration information for the product.
Client Deployment Enhancement: Client installation can now be done over the network, thus making it much easier to deploy the client for multiple users.
Server Installation Improvements Specific to z/OS and OS/390: include a code-page conversion utility (an ESSCONV program supplied with the product), which is required for all systems that do not use IBM-1047 as the server code page, to simplify the installation and make it easier to prevent text files from containing invalid characters.
Security Enhancements Specific to z/OS and OS/390:
Administration Improvements Specific to z/OS and OS/390:
Other Improvements: There are numerous other improvements in DB2 OLAP Server for z/OS, V8.1 that are described in product documentation. A few are listed below:
Relational Storage Manager Replaced with Better Approach:
With the introduction of Hybrid Analysis, which provides a better approach to integrate relational
data with OLAP data, the Relational Storage Manager option will no longer be available in DB2 OLAP
Server for z/OS, V8.1. Current customers who have cubes in Relational Storage Manager will migrate
to Multidimensional Storage Manager while installing V8.1, using instructions in existing
Components of DB2 OLAP Server for z/OS, V8.1
DB2 OLAP Server for z/OS, V8.1 running on z/OS or OS/390
DB2 OLAP Server is an enterprise-scale, online, analytical processing system for a wide range of multidimensional reporting, analysis, modeling, and planning applications. DB2 OLAP Server is based on Hyperion's Essbase OLAP Server. It utilizes the Hyperion Essbase engine for:
DB2 OLAP Server for z/OS, V8.1 can be used for a wide range of applications:
Client Support on 32-bit Windows is included with the DB2 OLAP Server for z/OS, V8.1 product. DB2 OLAP Server for z/OS, V8.1 also includes a comprehensive set of graphical tools for database Management, Security, and administration for deploying OLAP applications. It also includes the Essbase Spreadsheet Add-in and Essbase Application Manager. The Spreadsheet Add-in is desktop software that merges with Microsoft Excel or Lotus® 1-2-3®, turning your familiar Spreadsheet into a tightly integrated OLAP client for DB2 OLAP Server for z/OS, V8.1. The Application Manager lets you easily Build, modify, and maintain:
Partitioning Option provides a collection of powerful functions that make it easy to design and administer multidimensional databases, commonly known as cubes, that span OLAP applications or servers. The Partitioning Option allows you to:
Integration Server lets you map and transfer the relevant data in a relational database to an OLAP database quickly and easily. It includes a set of graphical tools and a shared, enterprise OLAP metadata catalog and lets you:
The Integration Server runs on OS/390 and z/OS in support of DB2 OLAP Server for z/OS, V8.1. It can
access DB2 databases on OS/390 and z/OS and connected Distributed Relational Database
Architecture (DRDA®) data sources.
Components from DB2 OLAP Server V8.1 (Workstation)
Many of the components that can be ordered with DB2 OLAP Server V8.1 (Workstation) can now be ordered for use with DB2 OLAP Server for z/OS, V8.1. Orderable components include:
Note that the Partitioning Option and Integration Server Options, available as add-on programs with DB2 OLAP Server V8.1 (Workstation), are not available for use with DB2 OLAP Server for z/OS, V8.1, as they are both directly available as priced features of DB2 OLAP Server for z/OS, V8.1.
Note also that the DB2 OLAP Server Enterprise Services, the High Concurrency priced feature and the DB2 OLAP Server Administration Services priced feature from the DB2 OLAP Server V8.1 (Workstation) are not available for use with DB2 OLAP Server for z/OS, V8.1.
For details about ordering add-on products from DB2 OLAP Server V8.1 (Workstation) refer to:
Section 508 of the U.S. Rehabilitation Act
DB2 OLAP Server for z/OS, V8.1 is capable as of March 28, 2003, when used in accordance with IBM's associated documentation, of satisfying the applicable requirements of Section 508 of the Rehabilitation Act, provided that any assistive technology used with the product properly interoperates with it.
Hardware and Software Support Services
SmoothStart and Installation Services are not provided.
The following self-study courses are available.
IBM Learning Services courses for OLAP:
Visit the following Web site for additional information:
For performance reasons, the following are minimum recommendations:
Space required for different libraries:
Library type Total space required Target 270 blocks Distribution 16,770 blocks HFS or zFS 170 MB. One 95 MB HFS for product files (executable files); one 75 MB or more zFS for operational files (application related files). This is the minimum configuration to support sample applications. Client Hardware Microprocessor Pentium(R), or better, or equivalent Display resolution of at least 640 x 480 (800 x 600 recommended) RAM 16 MB for DB2 OLAP Server Spreadsheet Add-in and Application Manager 32 MB for the Runtime Client 64 MB for the DB2(R) OLAP Integration Server Desktop Disk space -- 24 MB for Application Manager 18 MB for the Spreadsheet Add-in for Lotus(R) 1-2-3(R) 17 MB for the Spreadsheet Add-in for Excel 9 MB for the Runtime Client 45 MB for the DB2 OLAP Integration Server Desktop Console 75 MB for the documentation, if you install all of it Network protocol TCP/IP
DB2 OLAP Server for z/OS, V8.1 requires either OS/390 V2R10 or z/OS V1R1, or later levels, with zFS support. For zFS support, you must obtain the PTFs shipped under APAR OW51780:
Minimum software levels needed to run various functions:
Minimum VRM/Service Level Function DB2 UDB for OS/390, V7.1 with DB2 PTFs UQ55777, UQ63282, and UQ73878 DB2 UDB for OS/390, V6.1 with DB2 PTFs UQ52715, and UQ63281 Java(TM) V1.3.0 Java
Crimson V1.1.3 XML parser
JDBC V1.2 DB2 UDB for JDBC OS/390 and z/OS, V7 Application Programming Guide and Reference for Java
The system requirements of the Application Manager, the Runtime Client, the Spreadsheet Add-ins for Excel and Lotus 1-2-3, and the OIS Essbase Integration Services Console:
Microsoft(TM) XP Windows(R) ME 2000 NT 4.0; Service Pack 5 is required by DB2 OLAP Integration Server. 98 The client for DB2 OLAP Server Miner supports Windows 95, Windows 98, Windows ME, Windows XP, Windows NT(R) 4.0, and Windows 2000. Windows NT 3.5.1 is not supported. Microsoft Excel Excel 2000, Excel XP Lotus 1-2-3 Lotus 1-2-3 97, plus 9.7, 9.6, and 9.5
The Integration Server feature cannot presently be used with DB2 databases built with a multibyte character code set (such as Japanese IBM-930 EBCDIC). Removal of this restriction is planned, and will be made available with a program temporary fix (PTF). For availability status refer to this Web site:
Direct Customer Support: Direct customer support is provided by IBM Operational Support Services Support Line. This fee service can enhance your productivity by providing voice and electronic access into the IBM support organization. IBM Operational Support Services Support Line will help answer questions pertaining to usage, how to and suspected software defects for eligible products.
Installation and technical support is provided by IBM Global Services. For more information on services, call 800-IBM-4YOU (426-4968).
Security, Auditability, and Control
The announced program uses the security and auditability features of the host hardware or operating system software. The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.
Orders for new licenses can be placed now.
Unless a later date is specified, orders entered before the planned availability date will be assigned a schedule date of one week following availability.
Orders entered after the planned availability date will be assigned a schedule date for the week following order entry.
New users of DB2 OLAP Server for z/OS, V8.1 should specify:
Machine Type Model 5655 H81
Entry Support License (ESL): To order an ESL license, specify the program number, feature number 9001 for asset registration, and the applicable ESL one-time charge (OTC) feature number. Also specify the feature number of the desired distribution medium.
ESL OTC Feature Program Number/Description Number 5655-H81/DB2 OLAP Server for z/OS, V8.1 0075 5655-H81/Integration Server Feature 0094 5655-H81/Partitioning Option Feature 0113
ESL machines can be determined by referring to the IBM Entry End User/390 Attachment (Z125-4379).
Parallel Sysplex® License Charge (PSLC) Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. Specify the PSLC Base feature. If applicable, specify the PSLC Level A and PSLC Level B, and PSLC Level C, and PSLC Level D features and quantity.
If there is more than one program copy in a Parallel Sysplex, the charge for all copies is associated to one license by specifying the applicable PSLC feature numbers and quantity represented by the sum of the Service Units in Millions (MSUs) in your Parallel Sysplex. For all other program copies, specify the PSLC No-Charge (NC) Identifier feature on the licenses.
Also, specify the feature number of the desired distribution medium.
PSLC PSLC Basic License Machine Feature MLC(1) Feature MSU Capacity Number Description DB2 OLAP Server for z/OS, V8.1 1 0058 PSLC Base, 1 MSU 2 0059 PSLC Base, 2 MSUs 3 0060 PSLC Base, 3 MSUs 4 -- 45 0061 PSLC Level A, 1 MSU 0062 PSLC Level A, 42 MSUs 46 -- 175 0063 PSLC Level B, 1 MSU 0064 PSLC Level B, 10 MSUs 0065 PSLC Level B, 50 MSUs 176 -- 315 0066 PSLC Level C, 1 MSU 0067 PSLC Level C, 10 MSUs 0068 PSLC Level C, 50 MSUs 316, or more 0069 PSLC Level D, 1 MSU 0070 PSLC Level D, 50 MSUs NA 0071 PSLC NC Identifier Integration Server Feature 1 0077 PSLC Base, 1 MSU 2 0078 PSLC Base, 2 MSUs 3 0079 PSLC Base, 3 MSUs 4 -- 45 0080 PSLC Level A, 1 MSU 0081 PSLC Level A, 42 MSUs 46 -- 175 0082 PSLC Level B, 1 MSU 0083 PSLC Level B, 10 MSUs 0084 PSLC Level B, 50 MSUs 176 -- 315 0085 PSLC Level C, 1 MSU 0086 PSLC Level C, 10 MSUs 0087 PSLC Level C, 50 MSUs 316, or more 0088 PSLC Level D, 1 MSU 0089 PSLC Level D, 50 MSUs NA 0090 PSLC NC Identifier Partitioning Option Feature 1 0096 PSLC Base, 1 MSU 2 0097 PSLC Base, 2 MSUs 3 0098 PSLC Base, 3 MSUs 4 -- 45 0099 PSLC Level A, 1 MSU 0100 PSLC Level A, 42 MSUs 46 -- 175 0101 PSLC Level B, 1 MSU 0102 PSLC Level B, 10 MSUs 0103 PSLC Level B, 50 MSUs 176 -- 315 0104 PSLC Level C, 1 MSU 0105 PSLC Level C, 10 MSUs 0106 PSLC Level C, 50 MSUs 316, or more 0107 PSLC Level D, 1 MSU 0108 PSLC Level D, 50 MSUs NA 0109 PSLC NC Identifier
Workload License Charge (WLC) Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. Also, specify the feature number of the desired distribution medium.
Flat Workload License Charge (FWLC) Features
FWLC FWLC Feature Feature Description Number WLC / DB2 OLAP Server for z/OS, V8.1 0076 WLC / Integration Server Feature 0095 WLC / Partitioning Option Feature 0114
Growth Opportunity License Charge (GOLC): To order GOLC software, specify the program number, feature number 9001 for asset registration, and the GOLC monthly charge feature number from the table below. Also, specify the feature number for the desired distribution medium.
GOLC GOLC Feature Category Number DB2 OLAP Server for z/OS, V8.1 H30 0072 H50 0073 H70 0074 Integration Server Feature GOLC GOLC Feature Category Number H30 0091 H50 0092 H70 0093 Partitioning Option Feature GOLC GOLC Feature Category Number H30 0110 H50 0111 H70 0112
IBM zSeries Entry License Charge (zELC): To order zELC software, specify the program number, feature number 9001 for asset registration, and the zELC monthly charge feature number from the table below. Also, specify the feature number for the desired distribution medium.
zELC Feature z800 Models Number DB2 OLAP Server for z/OS, V8.1 0E1 -- 1 engine 0117 0A1 -- 1 engine 0118 0B1 -- 1 engine 0119 0C1 -- 1 engine 0120 0X2 -- 1 engine 0121 001 -- 1 engine 0122 0A2 -- 2 engines 0123 002 -- 2 engines 0124 003 -- 3 engines 0125 004 -- 4 engines 0126 Integration Server Feature zELC Feature z800 Models Number 0E1 -- 1 engine 0129 0A1 -- 1 engine 0130 0B1 -- 1 engine 0131 0C1 -- 1 engine 0132 0X2 -- 1 engine 0133 001 -- 1 engine 0134 0A2 -- 2 engines 0135 002 -- 2 engines 0136 003 -- 3 engines 0137 004 -- 4 engines 0138 Partitioning Option Feature zELC Feature z800 Models Number 0E1 -- 1 engine 0141 0A1 -- 1 engine 0142 0B1 -- 1 engine 0143 0C1 -- 1 engine 0144 0X2 -- 1 engine 0145 001 -- 1 engine 0146 0A2 -- 2 engines 0147 002 -- 2 engines 0148 003 -- 3 engines 0149 004 -- 4 engines 0150
Single Version Charging: To elect single version charging, the customer must notify and identify to IBM the prior program and replacement program and the designated machine the programs are operating on.
Feature Distribution Environment Number Medium DB2 OLAP Server 5812 3480 Uncomp English, ENU DB2 OLAP Server 6000 4-mm 2 GB Mod English, ENU
Example: If publications are not desired for the initial order, specify feature number 3470 to ship media only. For future updates, specify feature number 3480 to ship media updates only. If, in the future, publication updates are required, order an MES to remove feature number 3480; then, the publications will ship with the next release of the program.
Feature Description Number Initial Shipments Serial number only (suppresses shipment 3444 of media and documentation) Ship media only (suppresses initial 3470 shipment of documentation) Ship documentation only (suppresses 3471 initial shipment of media) Satellite Electronic Delivery 3450 Update Shipments Ship Media updates only (suppresses 3480 update shipment of documentation) Ship documentation only (suppresses 3481 update shipment of media) Suppress updates (suppresses update 3482 shipment of media and documentation) Expedite Shipments Local IBM office expedite 3445 (for IBM use only) Customer expedite process charge 3446 ($30 charge for each product)
Expedite shipments will be processed to receive 72-hour delivery from the time IBM Software Delivery and Fulfillment (SDF) receives the order. SDF will then ship the order via overnight air transportation.
A memo and program directory are supplied automatically with the basic machine-readable material.
The following optional publication is available immediately:
Order Title Number DB2 OLAP Server for z/OS, V8.1 SC18-7280 Installation and Administration Guide for z/OS
Subsequent updates (technical newsletters or revisions between releases) to the publications shipped
with the product will be distributed to the user of record for as long as a license for this
software remains in effect. A separate publication order or subscription is not needed.
Most product media is shipped only via Customized Offerings (for example, CBPDO, ServerPac, Systempac®). Non-customized items (CDs, diskettes, source media, media kits) will continue to be shipped via the stand-alone product.
Terms and Conditions
Replaced Program Replacement Program Program Program Program Program Number Name Number Name 5655-OLP DB2 OLAP Server 5655-H81 DB2 OLAP Server for OS/390,V7.1 for z/OS,V8.1 5655-H81 DB2 OLAP Server To a follow-on, if any for z/OS,V8.1
IBM Electronic Services
IBM Global Services has transformed its delivery of hardware and software support services to put you on the road to higher systems availability. IBM Electronic Services is a Web-enabled solution that provides you with an exclusive, no-additional-charge enhancement to the service and support on the IBM eServer. You should benefit from greater system availability due to faster problem resolution and preemptive monitoring. IBM Electronic Services comprises two separate but complementary elements: IBM Electronic Services news page and IBM Electronic Service Agent.
IBM Electronic Services news page provides you with a single Internet entry point that replaces the multiple entry points traditionally used by customers to access IBM Internet services and support. By using the news page, it enables you to gain easier access to IBM resources for assistance in resolving technical problems.
The IBM Electronic Service Agent is a no-additional charge software that resides on your IBM eServer system that is designed to proactively monitor events and transmit system inventory information to IBM on a periodic customer-defined timetable. The IBM Electronic Service Agent tracks system inventory, hardware error logs, and performance information. If the server is under a current IBM maintenance service agreement or within the IBM Warranty period, the Service Agent automatically reports hardware problems to IBM. Early knowledge about potential problems enables IBM to provide proactive service that maintains higher system availability and performance. In addition, information collected through the Service Agent will be made available to IBM service support representatives when they are helping answer your questions or diagnosing problems.
To learn how IBM Electronic Services can work for you, visit:
To order, contact the Americas Call Centers, your local IBM representative, or your IBM Business Partner.
To identify your local IBM representative or IBM Business Partner, call 800-IBM-4YOU (426-4968).
Phone: 800-IBM-CALL (426-2255) Fax: 800-2IBM-FAX (242-6329) Internet: firstname.lastname@example.org Mail: The Americas Call Centers Dept. YE001 P.O. Box 2690 Atlanta, GA 30301-2690 Reference: YE001
The Americas Call Centers, our national direct marketing organization, can add your name to the mailing list for catalogs of IBM products.
Note: Shipments will begin after the planned availability date.