IBM United States
Software Announcement 203-067
March 11, 2003

IBM Informix MetaCube ROLAP Option V4.21 Now Supports Windows XP and Later Releases of UNIX and Informix Databases

 ENUS203-067.PDF (33KB)


At a Glance

  • Open, extensible relational online analytical processing (ROLAP) solution
  • Tools for predefined reporting and ad-hoc analysis: tables, charts, drilling, pivoting, and slice-and-dice with interactive graphical interfaces
  • Scalable performance by optimizing summary tables and sampling
  • Robust analytics: derived measures, buckets, relative time series, and filters
  • Flexible interfaces for client/server, Web, and Excel configurations

For ordering, contact:

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

Overview

Informix™ MetaCube™ relational online analytical processing (ROLAP) Option V4.21

IBM Informix MetaCube helps you make better business decisions based on the intelligence it enables you to obtain from your data. The business benefits are:

  • Provides an intelligent view of the data within your datamart or data warehouse via reports and charts that match your intuitive thinking about your business.
  • Supports an open multi-platform architecture that allows both the integration of third-party tools and analytical applications, and the development of custom applications. Your decision-support environment can be customized to meet your specific needs.
  • Integrates Web and ROLAP scalability allowing you to perform the most advanced OLAP functions such as: drill anywhere, drag-and-drop query building, charting, and bucketing within your standard Web browser-based environment.
  • Delivers high performance data access through smarter data manipulation to expedite the creation of new business opportunities.
  • Provides a suite of advanced tools designed to simplify and automate the optimization of datamarts and data warehouses, thereby reducing the cost of database administration.

Key Prerequisites

  • Web Browsers for MetaCube Web Explorer:
    • Netscape: Version 4.7
    • Microsoft™ Internet Explorer: Version 6.0
    • If MetaCube Web Explorer is to be deployed, then a Web server (any) is required
  • Connectivity and Database Software:

    Informix:
                                  Supported
    Informix                      Informix
    Connect                       Databases
     
    2.70                          7.31
                                  8.40
                                  9.30
     
    Red Brick(TM) Warehouse:
     
    Supported
    Client                        Supported
    Connector Pak                 Red Brick WH
     
    2.11                          6.11
    
  • Microsoft Office 2000:
    • Excel 2000 (9.0)
    • Access 2000 (9.0)
  • Middle Tier Requirements for 3-Tier Configuration:
    • Microsoft Transaction Server, Version 2.0 or higher

Planned Availability Date

March 14, 2003

Description

Features of Informix MetaCube ROLAP Option V4.21 include:

  • MetaCube Explorer: A decision support tool for end-user data access and analysis, MetaCube Explorer provides data warehouse and data mart access, reporting, charting, and application integration through a sophisticated, user-friendly drag-and-drop interface. MetaCube Web Explorer brings all of the MetaCube's analysis capabilities to the intranet via integration with popular Web servers and Web browsers.
  • MetaCube Warehouse Manager: The advanced administration tool delivers sophisticated graphical metadata administration providing logical, user-friendly management of dimensional metadata.
  • MetaCube Secure Warehouse: Secure Warehouse provides slice-level security for data warehouses and data marts and includes:
    • Mandatory filters for controlling slice-level access
    • Secure column and hierarchy-level access
    • Mandatory QueryBack for controlling date and time of access
    • Secure PDQ priorities for controlling the levels of database resources available to each user
  • MetaCube Agent Administrator: Schedules MetaCube Agents to maintain the data warehouse/data mart daily, weekly, monthly, or at specific times. This tool can also schedule a variety of jobs to execute:
    • MetaCube queries
    • SQL queries
    • OS jobs

    It may also be used to create and schedule "sets" of jobs with user-defined interdependencies and priorities.

  • MetaCube for Excel: This Excel Add-In provides a wizard-based interface for creating and executing MetaCube queries from an Excel worksheet. Excel worksheets are populated with MetaCube query results. Users have full access to create/use filters, schedule queryback jobs, and generate tabular, graphical, or pivot table reports.
  • MetaCube Warehouse Optimizer: This tool automatically monitors MetaCube query patterns and recommends the most optimal aggregates and indexes according to disk utilization/query performance trade-off.

Section 508 of the U.S. Rehabilitation Act

When used in accordance with IBM's associated documentation, Informix MetaCube ROLAP Option V4.21 is capable, as of March 14, 2003, of satisfying the applicable requirements of Section 508 of the Rehabilitation Act, provided that any assistive technology used with the product interoperates with it properly.

Trademarks

 
Informix, MetaCube, and Red Brick are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Microsoft is a trademark of Microsoft Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.

Offering Information

Product information will be available on day of announcement through Offering Information (OITOOL) at:

and through the Passport Advantage Web site at:

Publications

Informix™ MetaCube™ ROLAP Option V4.21

The following publication is shipped with the Media Pack:

Installation and Configuration Guide IBM Informix MetaCube ROLAP Option 4.2

The following publications are included in the Doc Packs, and are also offered in displayable soft copy form on the media CD-ROMs:

  • Explorer User's Guide IBM Informix MetaCube ROLAP Option 4.1 for IBM Informix Dynamic Server
  • IBM Informix MetaCube for Excel User Guide 4.1 IBM Informix MetaCube ROLAP Option (000-5220A)
  • Data Warehouse Administrator Guide 4.1 IBM Informix MetaCube ROLAP Option for IBM Informix Dynamic Server
  • SQL Optimizer User's Guide 4.1 IBM Informix MetaCube ROLAP Option for IBM Informix Dynamic Server
  • SDK for Snap-Ins Programmer's Manual 4.1 IBM Informix MetaCube ROLAP Option for IBM Informix Dynamic Server
  • Application Programmers Manual 4.1 IBM Informix MetaCube ROLAP Option for IBM Informix Dynamic Server
  • Introduction to New Features IBM Informix MetaCube ROLAP Option 4.x

Technical Information

Specified Operating Environment

Hardware Requirements

For MetaCube Middle-Tier:

  • IBM or IBM-compatible Pentium®, 200MHz or more
  • At least 3-4 MB of RAM for each simultaneous client user
  • At least 25 MB of disk space

For MetaCube Client-Tier:

  • IBM or IBM-compatible Pentium, 200MHz or more
  • At least 24 MB of RAM
  • At least 25 MB of disk space

MetaCube Server Tier:

  • One of:
    • IBM or IBM-compatible Pentium, 200MHz or more
    • IBM RS/6000® or compatible
    • HP 9000 or compatible
    • Sun4 Sparc or compatible
    • DEC Alpha or compatible
    • Silicon Graphics IP-class or compatible
  • 4MB RAM per MetaCube Agent thread

Software Requirements

Middle Tier:

  • Windows NT® 4.0 with SP3, or later
  • Windows® 2000 with SP1®, or later
  • Windows XP

Two-Tier Client:

  • Windows 98
  • Windows NT 4.0 with SP3, or later
  • Windows 2000 with SP1, or later
  • Windows XP

Three Tier Client:

  • Windows 98
  • Windows NT 4.0 with SP3, or later
  • Windows 2000 with SP1, or later
  • Windows XP

NT Agents:

  • Windows NT 4.0 with SP3, or later
  • Windows 2000 with SP1, or later
  • Windows XP

UNIX® Agents:

  • IBM AIX® 5.1
  • Sun Solaris 8
  • Hewlett Packard HP-UX 11i or HP-UX 11.0
  • Compaq Tru64 5.1
  • Silicon Graphics Irix 6.5

With the exception of Compaq Tru64 (64 bit only), all UNIX ports are both 32-bit and 64-bit compatible. Note that only Agents support a 64-bit platform.

Performance Considerations: A multi-CPU machine is recommended for Middle Tier in a three-tier configuration.

Planning Information

Packaging

Each of the three Media Packs contain the following:

  • Passport Advantage Customer Letter
  • License Information (LI) Booklet
  • IPLA IBM International Program License Agreement
  • Installation and Configuration Guide IBM Informix MetaCube ROLAP Option 4.2
  • Assembly of six CD-ROMs

Each of the three DOC Packs contain the following:

Security, Auditability, and Control

Informix MetaCube ROLAP Option V4.21 uses the security and auditability features of the host hardware or software.

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 is only available via Passport Advantage. It is not available as shrinkwrap.

Product Group: MetaCube
 Product Identifier Description (PID)
  IBM METACUBE ROLAP OPT (DIR CLI)                5724-C52
  IBM METACUBE ROLAP OPT (INDIR CLI)              5724-C52
  IBM METACUBE ROLAP OPT (SVR AGENTS)             5724-C52
 
Product Category: METACUBE ROLAP OPT

Informix MetaCube ROLAP Option V4.21 — Agents has a single charge unit of Processors.

Informix MetaCube ROLAP Option V4.21 — Indirect Clients has a single charge unit of Concurrent Sessions.

Informix MetaCube ROLAP Option V4.21 — Direct Clients has a single charge unit of Concurrent Sessions.

Informix MetaCube ROLAP Option V4.21

Media and Documentation Packs

                                                            Part
Program Name/Description                                    Number
 
Informix MetaCube ROLAP Option V4.21                        BB0ENNA
 -- Agents Media Pack
 
Informix MetaCube ROLAP Option V4.21                        BB0ERNA
 -- Agents Doc Pack
 
Informix MetaCube ROLAP Option V4.21                        BB0EMNA
 -- Indirect Clients Media Pack
 
Informix MetaCube ROLAP Option V4.21                        BB0EQNA
 -- Indirect Clients Doc Pack
 
Informix MetaCube ROLAP Option V4.21                        BB0ELNA
 -- Direct Clients Media Pack
 
Informix MetaCube ROLAP Option V4.21                        BB0EPNA
 -- Direct Clients Doc Pack

Previously Announced Passport Advantage Part Numbers: Informix MetaCube ROLAP Option

                                                            Passport
                                                            Advantage
                                                            Part
Program Name/Description                                    Number
 
Informix MetaCube ROLAP Option Agents
 
Informix MetaCube ROLAP Option Agents                       D6DICLL
 Processor LIC/SW Maint 1 Anniv
Informix MetaCube ROLAP Option Agents                       D6DIDLL
 Processor LIC/SW Maint 2 Anniv
Informix MetaCube ROLAP Option Agents                       E2DIELL
 Processor SW Maint RNWL 1 Anniv
Informix MetaCube ROLAP Option Agents                       D6DIFLL
 Processor SW Maint AFT LIC 1 Anniv
 
Informix MetaCube ROLAP Option Indirect Clients
 
Informix MetaCube ROLAP Opt Indir                           D6DIKLL
 Clients CS LIC/SW Maint 1 Anniv
Informix MetaCube ROLAP Opt Indir                           D6DILLL
 Clients CS LIC/SW Maint 2 Anniv
Informix MetaCube ROLAP Opt Indir                           E2DIMLL
 Clients CS SW Maint RNWL 1 Anniv
Informix MetaCube ROLAP Opt Indir                           D6DINLL
 Clients CS SW Maint AFT LIC 1 Anniv
 
Informix MetaCube ROLAP Option Direct Clients
 
Informix MetaCube ROLAP Opt Dir                             D6DITLL
 Clients CS LIC/SW Maint 1 Anniv
Informix MetaCube ROLAP Opt Dir                             D6DIULL
 Clients CS LIC/SW Maint 2 Anniv
Informix MetaCube ROLAP Opt Dir                             E2DIVLL
 Clients CS SW Maint RNWL 1 Anniv
Informix MetaCube ROLAP Opt Dir                             D6DIWLL
 Clients CS SW Maint AFT LIC 1 Anniv

Passport Advantage Customer: Media Pack Entitlement Details

Customers with active subscriptions on the products listed below are entitled to receive the corresponding media packs.

Entitled Maintenance Offerings
Description
 
IBM METACUBE ROLAP OPT (SVR AGENTS)
 
 
                                                            Part
Media Packs Description                                     Number
 
Informix MetaCube ROLAP Option V4.21
 -- Agents Media Pack                                       BB0ENNA
 
Entitled Maintenance Offerings
Description
 
IBM METACUBE ROLAP OPT (INDIR CLI)
 
                                                            Part
Media Packs Description                                     Number
 
Informix MetaCube ROLAP Option V4.21                        BB0EMNA
 -- Indirect Clients Media Pack
 
Entitled Maintenance Offerings
Description
 
IBM METACUBE ROLAP OPT (DIR CLI)
 
                                                            Part
Media Packs Description                                     Number
 
Informix MetaCube ROLAP Option V4.21                        BB0ELNA
 -- Direct Clients Media Pack

Withdrawal of Previous Passport Advantage Part Numbers: The following IPLA software part numbers are being replaced or obsoleted by this announcement. The effective withdrawal date is April 15, 2003.

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.

Withdraw from Marketing Information
 
                                                            Part
Program Name/Description                                    Number
 
IBM Informix MetaCube ROLAP Option V4.20
    Agents Clients   -- Media Pack                          BB086NA
                     -- Doc Pack                            BB088NA
    Indirect Clients -- Media Pack                          BB081NA
                     -- Doc Pack                            BB083NA
    Direct Clients   -- Media Pack                          BB07TNA
                     -- Doc Pack                            BB07UNA
 
New Release Information
 
                                                            Part
Program Name/Description                                    Number
 
IBM Informix MetaCube ROLAP Option V4.21
    Agents Clients   -- Media Pack                          BB0ENNA
                     -- Doc Pack                            BB0ERNA
    Indirect Clients -- Media Pack                          BB0EMNA
                     -- Doc Pack                            BB0EQNA
    Direct Clients   -- Media Pack                          BB0ELNA
                     -- Doc Pack                            BB0EPNA

Terms and Conditions

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

Licensing: IBM International Program License Agreement. Proofs of Entitlement (PoEs) are required for all authorized use. Part number products only, offered outside of Passport Advantage, where applicable, are license only and do not include Software Maintenance.

License Information Form Number

  • CT1RVML for Informix MetaCube ROLAP Option V4.21 — Agents
  • CT1RUML for Informix MetaCube ROLAP Option V4.21 — Indirect Clients
  • CT1RTML for Informix MetaCube ROLAP Option V4.21 — Direct Clients

Limited Warranty Applies: Yes

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

Copy and Use on Home/Portable Computer: No

Volume Orders (IVO): No

Passport Advantage Applies

Yes and through the Passport Advantage Web site at:

Usage Restriction: Yes

Software Maintenance Applies: Yes

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

IBM includes Software Maintenance with each program acquired during the coverage period which begins on the date you acquire the program and continues to the first or second anniversary date, depending on whether you acquired coverage for one or two anniversaries. The coverage period for Software Maintenance acquired in the two months preceding an anniversary date will be extended to the next applicable anniversary date.

While your Software Maintenance is in effect, IBM provides you assistance for your (1) routine, short duration installation and usage (how-to) questions; and (2) code-related questions. IBM provides assistance via telephone and, if available, electronic access, only to your information systems (IS) technical support personnel during the normal business hours (published prime shift hours) of your IBM support center. (This assistance is not available to your end users.) IBM provides Severity 1 assistance 24 hours a day, every day of the year. For additional details, consult your IBM Software Support Guide at:

Software Maintenance does not include assistance for (1) the design and development of applications, (2) your use of programs in other than their specified operating environment, or (3) failures caused by products for which IBM is not responsible under this agreement.

For more information, about the Passport Advantage Agreement, refer to the IBM International Passport Advantage Agreement Software Announcement 201-202 , dated July 10, 2001, or visit the Passport Advantage Web site at:

IBM Operational Support Services — Support Line: No

AIX/UNIX Upgrade Protection Applies: No

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

iSeries™ Software Subscription Applies: No

Variable Charges Apply: No

Educational Allowance Available: Not applicable

Prices

This is a Passport Advantage Product with no shrinkwrap version.

Passport Advantage

For Passport Advantage and charges, contact your authorized IBM Lotus® Business Partner. Additional information is also available on the Passport Advantage Web site:

Global Financing

IBM Global Financing offers competitive financing to credit-qualified customers to assist them in acquiring IT solutions. Our offerings include financing for IT acquisition, including hardware, software, and services, both from IBM and other manufacturers or vendors. Offerings (for all customer segments: small, medium, and large enterprise), rates, terms, and availability can vary by country. Contact your local IBM Global Financing organization or visit the Web at:

Order Now

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:  ibm_direct@vnet.ibm.com
 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.

Trademarks

 
Informix, MetaCube, and iSeries are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
RS/6000, SP1, and AIX are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Pentium is a registered trademark of Intel Corporation.
 
Windows NT and Windows are registered trademarks of Microsoft Corporation.
 
UNIX is a registered trademark of the Open Company in the United States and other countries.
 
Lotus is a registered trademark of Lotus Development Corporation and/or IBM Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.