IBM Red Brick Warehouse Server V6.30 enhances query performance, improves ease of use, and delivers new platform support

IBM United States Software Announcement 204-064
April 13, 2004

 ENUS204-064.PDF (69KB)

Table of contents   Document options  
At a glance Publications
Overview Technical information
Key prerequisites Ordering information
Planned availability dates Terms and conditions
Description IBM Electronic Services
Product positioning Prices
Reference information Order now
Offering Information  
 
Printable version

 
At a glance

Red Brick Warehouse is a lean SQL standard relational database for business intelligence applications.

  • Provides efficient processing of large data sets and delivers outstanding performance for the most complex business solutions
  • Handles thousands of concurrent SQL queries, hundreds of concurrent users, and terabytes of data
  • Provides an ideal foundation for any third-party decision support solution
  • Reduces deployment time and hardware and maintenance costs
  • Is designed to be a "hands off" database engine

For ordering, contact:

Your IBM representative or IBM Americas Call Centers at 800-IBM-CALL (Reference: YE001).
 
Back to top
 

Overview

Red Brick™ Warehouse Server V6.30, an SQL standard relational database designed for business intelligence applications, delivers support for more SQL functions, improved query execution and optimization, ease-of-use improvements, Table Management Utility (TMU) loader tuning and functionality enhancements, and new platform support.

It is available in two configuration options:

  • Workgroup Edition V6.30 is ideal for small to medium size businesses and departmental solutions that require the power of an enterprise database on a system with up to two processors.
  • Enterprise Edition V6.30 provides all of the features of the Workgroup Edition for SMP systems with three or more processors.

The following IBM Data Management Red Brick Gold Programs are updated:

  • IBM Data Management Red Brick Gold Analytic Bundle for Enterprise
  • IBM Data Management Red Brick Gold Analytic Bundle for SMB

The Gold Program offerings give you the flexibility to install either Red Brick or DB2® products. These solutions offer you a choice of IBM products without a license switching cost.
 
Back to top
 

Key prerequisites

Refer to the Hardware requirements and Software requirements sections.
 
Back to top
 

Planned availability dates
  • April 13, 2004 (electronic software delivery), Red Brick Enterprise Edition and Red Brick Workgroup Edition (English)
  • May 11, 2004 (electronic software delivery), Red Brick Enterprise Edition and Red Brick Workgroup Edition (Japanese), IBM Data Management Gold Program Red Brick Analytic Bundle for SMB and IBM Data Management Gold Program Red Brick Analytic Bundle for Enterprise
  • April 16, 2004 (media), Red Brick Enterprise Edition and Red Brick Workgroup Edition (English)
  • May 25, 2004 (media), Red Brick Enterprise Edition and Red Brick Workgroup Edition (Japanese), IBM Data Management Gold Program Red Brick Analytic Bundle for SMB and IBM Data Management Gold Program Red Brick Analytic Bundle for Enterprise

 
Back to top
 
Description

Red Brick Warehouse Server V6.30 includes the following enhancements:

  • Performance enhancements
  • Ease-of-use improvements
  • New platform support

Performance enhancements

  • Dynamic segment elimination: Complementing compile-time "SmartScan" optimizations, the server also supports run-time or dynamic segment elimination. This further optimizes data access for table scans and TARGETjoins that use local indexes. Segment elimination is factored when determining the correct query plan to choose.
  • Memory mapping for queries: To optimize access to dimension tables and their primary-key indexes. These objects are partially or wholly memory-mapped during query execution.
  • TARGETjoin performance improvements: The performance of TARGETjoin queries is optimized, and single-column B-TREE indexes can now participate in TARGETjoin plans.
  • Optimizer directives: The server supports SET commands for controlling the availability of specific STAR indexes for single and multifact joins and for adjusting thresholds that influence the overall choice of STARjoin and TARGETjoin plans.
  • Vista Enhancement: Precomputed views grouped by nullable columns can now be maintained incrementally.
  • Table Management Utility (TMU): Loader enhancements are made in memory usage and tuning.

Ease-of-use improvements

  • Alter Table with working segment: You can add or drop table columns into a predefined "working segment." This option provides greater reliability and recoverability than other ALTER TABLE modes.
  • Additional SQL OLAP functions: The server supports additional functions for analytic queries: PERCENT_RANK, CUME_DIST, PERCENTILE_CONT, and PERCENTILE_DISC. The server also supports the ROUND scalar function.
  • Expression support: You can define arithmetic expressions and conditional CASE expressions for input columns inside the TMU control file.
  • Shrink System catalog: To improve performance, you can use the rb_syscompact utility to reduce the size of the database system catalog.
  • Allow 3 GB address space on the Microsoft™ Windows™ platform: To improve scalability and performance, Red Brick executables can use up to 3 GB of virtual address space on the Windows platform.
  • Multicharacter delimiter support: To extend delimiter support in the Table Management Utility (loader) and Export.
  • Nested XML namespace support: To extend definition of XML data for loading.
  • Support for .NET applications through the ODBC.NET data provider: Applications can use Microsoft's ODBC.NET provider and the .NET Framework 1.1 with the Red Brick ODBC driver to access data from Red Brick Data Warehouse.

New platform support

  • HP-UX 11i operating system for the Intel™ 64-bit platform (Itanium)
  • Microsoft Windows Server 2003 (32-bit)

IBM Data Management Gold Program Red Brick Analytic Bundle for Enterprises

  • Red Brick Warehouse Server V6.30 Enterprise Edition
  • DB2 UDB Enterprise Server Edition V8.1
  • DB2 Warehouse Manager Standard Edition V8.1
  • DB2 Information Integrator Standard Edition V8.1
  • DB2 Universal Developer's Edition (up to five user licenses)

With the addition of DB2 Information Integrator in the bundle, IBM Red Brick customers can now federate data between Red Brick and other DB2 UDB or Informix™ IDS/XPS database instances.

IBM Data Management Gold Program Red Brick Analytic Bundle for SMB

  • Red Brick Warehouse Server V6.30 Workgroup Edition
  • DB2 UDB Workgroup Server Unlimited Edition V8.1
  • DB2 Universal Developer's Edition (up to five user licenses)

Note: Customers of the Data Management Gold Programs must purchase at least one of the following bundles to receive the "bundles" product CD-ROM media packs listed for each offering: Red Brick or DB2.

Section 508 of the U.S. Rehabilitation Act

Red Brick Warehouse V6.3 is capable as of April 16, 2004, 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.
 
Back to top
 

Product positioning

Red Brick Warehouse Server is best positioned in:

  • Star schema data marts where referential integrity is enforced and which are experiencing poor data loading performance, poor detail-level query performance, or expensive hardware upgrades to achieve acceptable performance.
  • Complementing an e-business environment with an easy to install, easy to use, easy to administer, and very low cost of ownership Red Brick data mart and data warehouse.
  • A Global Mid-market Business (GMB) that has a requirement for a simple application that does not require a full-time DBA. Red Brick's ease of use makes it a strong solution for the GMB market.
  • Value-Added Resellers (VARs) or IBM Solutions Provider Business Partners that want to embed a data mart into their application.

 
Back to top
 
Reference information

Refer to Software Announcement 202-244 , dated October 1, 2002.

Trademarks

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

 
Back to top
 
Offering Information

Product information is available through the Offering Information Web site at

Product information is also available through the Passport Advantage® Web site at


 
Back to top
 
Publications

No publications are shipped with these products.

The IBM Publications Center:

The Publications Center is a worldwide central repository for IBM product publications and marketing material with a catalog of 70,000 items. Extensive search facilities are provided. Payment options for orders are via credit card (in the U.S.) or customer number for 50 countries. A large number of publications are available online in various file formats, and they can all be downloaded by all countries free of charge.

The IBM Publications Notification System (PNS):

The PNS enables subscribers to set up profiles of interest by order number/product number. PNS subscribers automatically receive notifications by e-mail of all new publications defined in their profiles. These may then be ordered/downloaded via the Publications Center. The site is available in English and Canadian French.
 
Back to top
 

Technical information

Hardware requirements

Red Brick™ Warehouse V6.30

Minimum hard disk and memory requirements (one of the following):

  • UNIX®
    • 300 MB hard disk space
    • 64 MB RAM (at least 128 MB preferred for large-system configurations supporting 20 or more concurrent users)
  • Windows NT™:
    • 120 MB hard disk space
    • 64 MB of RAM plus an additional 1.5 MB for each concurrent user

Software requirements

Red Brick Warehouse V6.30

Minimum software requirements (one of the following):

  • AIX® 5.1 or 5.2 (64 bit)
  • Sun Solaris 8 or 9 (64 bit)
  • HP PA-RISC 11.0 or 11i (64 bit)
  • HP Itanium 11i V2 (64 bit)
  • HP Tru64 UNIX — Digital UNIX 5.1b
  • Red Hat Enterprise Linux 3.0 (32 bit)
  • Microsoft™ Windows™ 2000 Server (32 bit) with SP4 or Windows Server 2003 (32 bit)

Client platforms:

  • Windows 2000 Professional (32 bit) with SP4, or Windows XP (32 bit) with SP1®

Notes

  • Red Brick Warehouse V6.30 is the last version to support Red Brick 32-bit ODBC client libraries and ODBC driver as well as the Red Brick 32-bit client utilities (RISQL™, risqlrpt, and rb_ctmu) on UNIX.
  • Red Brick Warehouse V6.20 is the last version to support 32-bit UNIX platforms and Microsoft Windows NT.

Planning information

Direct customer support: 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 is provided by the Software Maintenance offering of the IBM International Passport Advantage Agreement. This fee service enhances customer productivity by providing voice and electronic access into the IBM support organizations.

Packaging

Data Management Gold Program Red Brick Analytic Bundle for SMB contains the following products:

DB2® UDB Workgroup Server Unlimited Edition V8.1 (PID 5765-F43)

Publications

  • DB2 Universal Database® Quick Beginnings for DB2 Servers

Media

  • Workgroup Server Unlimited Edition Windows 32-bit CD
  • Workgroup Server Unlimited Edition AIX V4 32-bit CD
  • Workgroup Server Unlimited Edition AIX V5 32-bit CD
  • Workgroup Server Unlimited Edition HP-UX 32-bit CD
  • Workgroup Server Unlimited Edition Linux Intel™ 32-bit CD
  • Workgroup Server Unlimited Edition Solaris 32-bit CD
  • Administration Client Windows 32-bit CD
  • Administration Client AIX V4 32-bit CD
  • Administration Client AIX V5 32-bit CD
  • Administration Client HP-UX 32- and 64-bit CD
  • Administration Client Linux Intel 32-bit CD
  • Administration Client Solaris 32- and 64-bit CD
  • Runtime Client Windows 32-bit CD
  • Runtime Client AIX V4 32-bit CD
  • Runtime Client AIX V5 32-bit CD
  • Runtime Client HP-UX 32- and 64-bit CD
  • Runtime Client Solaris 32- and 64-bit CD
  • Runtime Client Linux Intel 32-bit CD
  • IBM Developer Kit, Java™ Technology Edition for HP-UX and Solaris
  • IBM Developer Kit, Java Technology Edition for AIX
  • HTML Documentation CD
  • PDF Documentation CD

Complimentary products

  • QMF™ for Windows 60-day Trial Version 
  • WebSphere® Studio Site Developer Advanced Trial Version 4.0.3
  • WebSphere MQSeries® V5.3

DB2 Universal Developer's Edition V8.1 (5765-F34)

Publications

  • DB2 Application Development Guide: Building and Running Applications

Media

  • Personal Edition Windows 32-bit CD
  • Personal Edition Linux 32-bit CD
  • Workgroup Server Edition Windows 32-bit CD
  • Workgroup Server Edition AIX V4 32-bit CD
  • Workgroup Server Edition AIX V5 32-bit CD
  • Workgroup Server Edition HP-UX 32-bit CD
  • Workgroup Server Edition Linux Intel 32-bit CD
  • Workgroup Server Edition Solaris 32-bit CD
  • Enterprise Server Edition Windows 32-bit CD
  • Enterprise Server Edition AIX V4 32-bit CD
  • Enterprise Server Edition AIX V5 32- and 64-bit CD
  • Enterprise Server Edition HP-UX 32- and 64-bit CD
  • Enterprise Server Edition Linux Intel 32-bit CD
  • Enterprise Server Edition Linux for S/390® and zSeries® 32-bit CD
  • Enterprise Server Edition Solaris 32- and 64-bit CD
  • Connect Personal Edition Windows 32-bit CD
  • Connect Personal Edition Linux Intel 32-bit CD
  • Connect Enterprise Edition Windows 32-bit CD
  • Connect Enterprise Edition AIX V4 32-bit CD
  • Connect Enterprise Edition AIX V5 32- and 64-bit CD
  • Connect Enterprise Edition HP-UX 32- and 64-bit CD
  • Connect Enterprise Edition Linux Intel 32-bit CD
  • Connect Enterprise Edition Linux for S/390 and zSeries 32-bit CD
  • Connect Enterprise Edition Solaris 32- and 64-bit CD
  • Data Links Manager Windows 32-bit CD
  • Data Links Manager AIX V4 32-bit CD
  • Data Links Manager AIX V5 32-bit CD
  • Data Links Manager Solaris 32-bit CD
  • Warehouse Manager Standard Edition Windows 32-bit CD (not shipped in China)
  • Warehouse Manager Standard Edition AIX V4 32-bit CD (not shipped in China)
  • Warehouse Manager Standard Edition AIX V5 32-bit CD (not shipped in China)
  • Warehouse Manager Standard Edition Linux Intel 32-bit CD (not shipped in China)
  • Warehouse Manager Standard Edition Solaris 32-bit CD (not shipped in China)
  • Warehouse Manager Standard Edition iSeries™ CD (not shipped in China)
  • Net Search Extender Windows/AIX/Solaris 32-bit CD
  • Spatial Extender Windows 32-bit CD
  • Spatial Extender AIX 32-bit CD
  • Spatial Extender Linux Intel 32-bit CD
  • Spatial Extender Linux for S/390 and zSeries 32-bit CD
  • Spatial Extender HP-UX 32- and 64-bit CD
  • Spatial Extender Solaris 32- and 64-bit CD
  • Geocoder Data CD
  • ESRI Map Data CDs
  • Administration Client Windows 32-bit CD
  • Administration Client AIX V4 32-bit CD
  • Administration Client AIX V5 32- and 64-bit CD
  • Administration Client HP-UX 32- and 64-bit CD
  • Administration Client Linux Intel 32-bit CD
  • Administration Client Linux for S/390 and zSeries 32-bit CD
  • Administration Client Solaris 32- and 64-bit CD
  • Runtime Client Windows 32-bit CD
  • Runtime Client AIX V4 32-bit CD
  • Runtime Client AIX V5 32- and 64-bit CD
  • Runtime Client Linux 32-bit CD
  • Runtime Client Linux for S/390 and zSeries 32-bit CD
  • Runtime Client HP-UX 32- and 64-bit CD
  • Runtime Client Solaris 32- and 64-bit CD
  • Application Development Client Windows 32-bit CD
  • Application Development Client AIX V4 32-bit CD
  • Application Development Client AIX V5 32- and 64-bit CD
  • Application Development Client HP-UX 32- and 64-bit CD
  • Application Development Client Linux Intel 32-bit CD
  • Application Development Client Linux for S/390 and zSeries 32-bit CD
  • Application Development Client Solaris 32- and 64-bit CD
  • Intelligent Miner™ Scoring Windows/AIX/Solaris/Linux 32-bit CD
  • Intelligent Miner Modeling Windows/AIX/Solaris/Linux 32-bit CD
  • Intelligent Miner Visualization Windows/AIX/Solaris/Linux 32-bit CD
  • IBM Developer Kit, Java Technology Edition for HP-UX and Solaris
  • IBM Developer Kit, Java Technology Edition for AIX
  • DM Tools:
    • DB2 Table Editor for Multiplatforms V4.3 (Full-Function Unrestricted) CD (not shipped in China)
    • DB2 Web Query Tool for Multiplatforms V1.3 (Full-Function Unrestricted) CD (not shipped in China)
  • DB2 Everyplace™ Enterprise Edition
  • DB2 Everyplace SDK CD
  • HTML Documentation CD
  • PDF Documentation CD

Complimentary products:

  • QMF for Windows for DB2 Workstation Databases (unlimited version)
  • WebSphere Application Server V4.0, Advanced Developer Edition
  • WebSphere Studio Site Developer, Advanced Trial Version 4.0.3
  • WebSphere MQSeries V5.3

Red Brick Workgroup Edition

Publications

  • Red Brick Warehouse RMF™ 6.30

Media

  • Red Brick Warehouse Linux xSeries® 32-bit CD
  • Red Brick Warehouse AIX 5.1 and 5.2; Solaris 8 and 9 (Sun Sparc); HP-UX 11 (PA-RISC) 11.0 and 11i, HP-UX Itanium 11i v2; Digital Unix 5.1b 64-bit CD
  • Red Brick Warehouse Windows 2000, Windows Server 2003 32-bit CD
  • PDF Documentation CD

IBM Data Management Gold Program Red Brick Analytic Bundle for Enterprise contains the following products:

DB2 Universal Developer's Edition (5-user license) (refer to previous list for components).

DB2 UDB Enterprise Server Edition

Media

  • Enterprise Server Edition Windows 32-bit CD
  • Enterprise Server Edition AIX V4 32-bit CD
  • Enterprise Server Edition AIX V5 32- and 64-bit CD
  • Enterprise Server Edition Linux Intel 32-bit CD
  • Enterprise Server Edition Linux for S/390 and zSeries 32-bit CD
  • Enterprise Server Edition HP-UX 32- and 64-bit CD
  • Enterprise Server Edition Solaris 32- and 64-bit CD
  • Administration Client Windows 32-bit CD
  • Administration Client Windows 64-bit CD
  • Administration Client AIX V4 32-bit CD
  • Administration Client AIX V5 32- and 64-bit CD
  • Administration Client HP-UX 32- and 64-bit CD
  • Administration Client Solaris 32- and 64-bit CD
  • Administration Client Linux Intel 32-bit CD
  • Administration Client Linux for S/390 and zSeries 32-bit CD
  • Runtime Client Windows 32-bit CD
  • Runtime Client Windows 64-bit CD
  • Runtime Client AIX V4 32-bit CD
  • Runtime Client AIX V5 32- and 64-bit CD
  • Runtime Client HP-UX 32- and 64-bit CD
  • Runtime Client Solaris 32- and 64-bit CD
  • Runtime Client Linux Intel 32-bit CD
  • Runtime Client Linux for S/390 and zSeries 32-bit CD
  • IBM Developer Kit, Java Technology Edition for HP-UX and Solaris
  • IBM Developer Kit, Java Technology Edition for AIX
  • DM Tools
    • DB2 Web Query Tool (Try & Buy) CD
    • DB2 Table Editor (Try & Buy) CD
    • DB2 High Performance Unload (Try & Buy) CD
    • Recovery Expert V1.1 (Try & Buy) CD
    • Performance Expert V1.1 (Try & Buy) CD
  • HTML Documentation CD
  • PDF Documentation CD

Complimentary products

  • QMF for Windows 60-day Trial Version 
  • WebSphere Studio Site Developer Advanced Trial Version 4.0.3
  • WebSphere MQSeries V5.3

DB2 Warehouse Manager Standard Edition

Publications

  • DB2 Warehouse Manager Installation Guide

Media

  • Warehouse Manager Standard Edition Windows 32-bit CD
  • Warehouse Manager Standard Edition AIX V4 32-bit CD
  • Warehouse Manager Standard Edition AIX V5 32-bit CD
  • Warehouse Manager Standard Edition Solaris 32-bit CD
  • Warehouse Manager Standard Edition Linux Intel 32-bit CD
  • Warehouse Manager iSeries CD
  • Enterprise Server Edition Windows 32-bit CD
  • Enterprise Server Edition AIX V4 32-bit CD
  • Enterprise Server Edition AIX V5 32-bit CD
  • Java Application Development and Web Administration Tools Supplement for DB2 Version 8.1 for HP-UX and Solaris
  • Java Application Development and Web Administration Tools Supplement for DB2 Version 8.1 for AIX
  • HTML Documentation CD
  • PDF Documentation CD

DB2 Information Integrator Standard Edition

Publications

  • DB2 Information Integrator V8.1 Installation Guide

Media

  • DB2 Information Integrator Standard Edition Windows 32-bit CD
  • DB2 Information Integrator Standard Edition AIX V4 32-bit CD
  • DB2 Information Integrator Standard Edition AIX V5 32- and 64-bit CD
  • DB2 Information Integrator Standard Edition Linux 32-bit CD
  • DB2 Information Integrator Standard Edition HP-UX 32- and 64-bit CD
  • DB2 Information Integrator Standard Edition Solaris 32- and 64-bit CD

Red Brick Warehouse Enterprise Edition

Publications

  • Red Brick Warehouse RMF 6.30

Media

  • Red Brick Warehouse Linux xSeries 32-bit CD
  • Red Brick Warehouse AIX 5.1 and 5.2; Solaris 8 and 9 (Sun Sparc); HP-UX 11 (PA-RISC) 11.0 and 11i , HP-UX Itanium 11i v2; Digital Unix 5.1b 64-bit CD
  • Red Brick Warehouse Windows 2000, Windows Server 2003 32-bit CD
  • PDF Documentation CD

Security, auditability, and control

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

Ordering information

Product information

Licensed
function                Product group        Product category
title
 
Red Brick               Informix(TM)         Informix
 Warehouse
 Enterprise
 Edition
 
Red Brick               Informix             Informix
 Warehouse
 Workgroup
 Edition
 
IBM Data                Informix Bundles     Gold Red Brick Anl
 Management                                   Bdl Enterprises
 Gold Program
 Red Brick
 Analytic
 Bundle for
 Enterprises
 
IBM Data                Informix Bundles     Gold Red Brick Anl
 Management                                   Bdl Sm Med Busn
 Gold Program
 Red Brick
 Analytic
 Bundle
 for Small
 and Medium
 Business

Red Brick Warehouse V6.30 is available through IBM's Passport Advantage offering. The charge structure (level of use) of this program is specified by the following:

Processor: "Processor" means a processor that forms part of the server on which the program is installed or executed. You must acquire a use authorization for each such processor.

In addition, the programs in this announcement are part of the recently announced IBM On/Off Capacity on Demand pricing, which allows eligible customers to pay a fee to enable and use temporary server capacity (Processor Day charge unit). Refer to Software Announcement 203-202 , dated August 12, 2003, for details.

Red Brick Warehouse Workgroup Edition

The following restriction applies only to Red Brick Warehouse Workgroup Edition:

  • Server limitation: You may not install or use the program on a server that has more than two processors.

IBM Data Management Gold Program Red Brick Analytic Bundles

The charge unit is per processor under the dual license for either DB2 or Informix. Note that each CPU available to the installed software must have a separate entitlement that can be either DB2 or Informix.

When you purchase a single license (right to copy), you are authorized to install either Red Brick or DB2, but not both. If you purchase 10 licenses of the Red Brick Gold Analytic Bundle, you may install 10 copies of Red Brick or 10 copies of DB2, or five copies each of Red Brick and DB2. You can also order, if needed, either the DB2 products media package and documentation or the Red Brick media package. The appropriate media package will be shipped directly to you with the operating system of your choice.

Passport Advantage program licenses

Gold Analytic Bundle Enterprise V8.x

                                                       Part
Part description                                       number
 
IBM Data Management Gold Program
Red Brick Analytic Bundle for Enterprises
 
IBM Data Mgmt Gold Prog Red                            E00MXLL
 Brick Anl Bdl Ent Proc ANNUAL SW
 MAINT RNWL
IBM Data Mgmt Gold Prog Red                            D523ALL
 Brick Anl Bdl Ent Proc LIC+SW
 MAINT 12 MO
IBM Data Mgmt Gold Prog Red                            D523CLL
 Brick Anl Bdl Ent Proc SW MAINT
 REINSTATE 12 MO
DM Gold RB Anl Bndl Ent Proc fr                        D53L1LL
 Red Brk Ent Proc TRDUP LIC+SW
 MAINT 12 MO

Gold Analytic Bundle SMB V8.x

                                                       Part
Part description                                       number
 
IBM Data Management Gold Program
Red Brick Analytic Bundles for small
and medium business
 
IBM Data Mgmt Gold Prog                                E00MYLL
 Red Brick Anl Bdl SMB Proc
 Annual SW Maint Rnwl
IBM Data Mgmt Gold Prog                                D523DLL
 Red Brick Anl Bdl SMB Proc
 Lic+SW Maint 12 months
IBM Data Mgmt Gold Prog                                D523HLL
 Red Brick Anl Bdl SMB Proc
 SW Maint Reinstate 12 months

Red Brick V6.X

                                                       Part
Part description                                       number
 
Informix Red Brick Warehouse
 
Red Brick Workgroup Edition                            D6DAPLL
 Processor Lic+
 SW Maint 12 months
Red Brick Workgroup Edition                            D6DASLL
 Processor SW Maint
 Reinstate 12 months
 
                                                       Part
Part description                                       number
 
Red Brick Workgroup Edition                            E2DARLL
 Processor Annual
 SW Maint Rnwl
 
Red Brick V6.X Informix
Red Brick Warehouse
 
Red Brick Enterprise                                   E2DAILL
 Edition Processor
 Annual SW Maint Rnwl
Red Brick Enterprise                                   D6DAGLL
 Edition Processor
 Lic+SW Maint 12 months
Red Brick Enterprise                                   D6DAJLL
 Edition Processor
 SW Maint Reinstate
 12 months

Passport Advantage supply

                                                       Part
Program name/description                               number
 
Red Brick Analytic Bundle SMB V8.1.3
 
Media Pack U.S. English                                BB0KWNA
 Windows 2000, Digital UNIX,
 Sun Solaris/SPARC,
 Windows Server 2003,
 Itanium, AIX V5.x, HP-UX
 11.x, Linux for x86Series
 Intel-based servers CD-ROM
 Digital Disk -- ISO 9660
 Standard V8.1.3
Media Pack Multilingual (French,                       BB0L2ML
 Danish, Russian, Spanish,
 Norwegian Bokmal, Brazilian
 Portuguese, German, Swedish,
 U.S. English, Italian, Finnish,
 Polish) Windows 2000, AIX V4.x,
 Digital UNIX, Windows XP, Sun
 Solaris/SPARC, Windows Server
 2003, Linux for zSeries
 Enterprise Servers (Mainframes),
 Windows 98, Itanium, Windows NT,
 AIX V5.x, Windows Me, IRIX
 (Silicon Graphics), HP-UX 11.x,
 Linux for x86Series Intel-based
 servers CD-ROM Digital Disk --
 ISO 9660 Standard V8.1.3
 
Red Brick Enterprise Edition V6.30.0
 
Media Pack U.S. English                                BB0KTNA
 Windows 2000, Digital UNIX,
 Sun Solaris/SPARC,
 Windows Server 2003,
 Itanium, AIX V5.x,
 HP-UX 11.x,
 Linux for x86Series
 Intel-based servers CD-ROM
 Digital Disk -- ISO 9660
 Standard V6.30.0
 
                                                       Part
Program name/description                               number
 
Red Brick Workgroup Edition V6.30.0
 
Media Pack U.S. English                                BB0KUNA
 Windows 2000, Digital UNIX,
 Sun Solaris/SPARC,
 Windows Server 2003,
 Itanium, AIX V5.x,
 HP-UX 11.x,
 Linux for x86Series
 Intel-based servers CD-ROM
 Digital Disk -- ISO 9660
 Standard V6.30.0
 
Red Brick Analytic Bundle Enterprise V8.1.3
 
Media Pack U.S. English                                BB0KVNA
 Windows 2000, Digital UNIX,
 Sun Solaris/SPARC,
 Windows Server 2003,
 Itanium, AIX V5.x,
 HP-UX 11.x,
 Linux for x86Series
 Intel-based servers CD-ROM
 Digital Disk -- ISO 9660
 Standard V8.1.3

Passport Advantage customer: Media pack entitlement details

Customers with active maintenance or subscription for the following products are entitled to receive the corresponding media pack.

 
Entitled
maintenance
offerings                Media packs                   Part
description              description                   number
 
Red Brick Analytic Bundle SMB V8.1.3
 
Red Brick                Red Brick Analytic            BB0KWNA
 Analytic                 Bndl SMB U.S. English
 Bndl SMB                 Windows 2000,
                          Digital UNIX,
                          Sun Solaris/SPARC,
                          Windows Server 2003,
                          Itanium, AIX V5.x,
                          HP-UX 11.x, Linux for
                          x86Series Intel-based
                          servers CD-ROM
                          Digital Disk --
                          ISO 9660 Standard
 
Entitled
maintenance
offerings                Media packs                   Part
description              description                   number
 
Red Brick                Red Brick Analytic            BB0L2ML
 Analytic                 Bndl SMB
 Bndl SMB                 Multilingual (French,
                          Danish, Russian,
                          Spanish, Norwegian
                          Bokmal, Brazilian
                          Portuguese, German,
                          Swedish, U.S. English,
                          Italian, Finnish,
                          Polish) Windows 2000,
                          AIX V4.x, Digital
                          UNIX, Windows XP, Sun
                          Solaris/SPARC,
                          Windows Server 2003,
                          Linux for zSeries
                          Enterprise Servers
                          (Mainframes), Windows
                          98, Itanium, Windows
                          NT, AIX V5.x, Windows
                          Me, IRIX (Silicon
                          Graphics), HP-UX
                          11.x, Linux for
                          x86Series Intel-based
                          servers CD-ROM
                          Digital Disk --
                          ISO 9660 Standard
 
Red Brick Enterprise Edition V6.30.0
 
Red Brick                Red Brick Enterprise          BB0KTNA
 Enterprise               Edition U.S. English
 Ed Processor             Windows 2000,
                          Digital UNIX,
                          Sun Solaris/SPARC,
                          Windows Server 2003,
                          Itanium, AIX V5.x,
                          HP-UX 11.x, Linux for
                          x86Series Intel-based
                          servers CD-ROM
                          Digital Disk --
                          ISO 9660 Standard
 
Red Brick Workgroup Edition V6.30.0
 
Red Brick                Red Brick Workgroup           BB0KUNA
 Workgroup                Edition U.S. English
 Ed Processor             Windows 2000,
                          Digital UNIX,
                          Sun Solaris/SPARC,
                          Windows Server 2003,
                          Itanium, AIX V5.x,
                          HP-UX 11.x, Linux for
                          x86Series Intel-based
                          servers CD-ROM
                          Digital Disk --
                          ISO 9660 Standard
 
Entitled
maintenance
offerings                Media packs                   Part
description              description                   number
 
Red Brk Analytic Bundle Enterprise V8.1.3
 
Red Brick                Red Brk Anlytc Bndl           BB0KVNA
 Anlytc Bndl              Entrps U.S. English
 Entrps                   Windows 2000,
                          Digital UNIX,
                          Sun Solaris/SPARC,
                          Windows Server 2003,
                          Itanium, 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
name               number          description       number
 
Withdrawal from marketing date:  July 13, 2004
 
Gold               5724-E20        IBM DATA          BB0G5NA
 Analytic                           MGMT GOLD
 Bundle                             PRG-RED
 Enterprise                         BRICK
 V8.x                               ANLYTIC BNDL
 V6.20.0                            ENTRPRS RB
                                    ENT EDT 6.20
                                    ENG
Gold               5724-E20        IBM DATA          BB0G5JA
 Analytic                           MGMT GOLD
 Bundle                             PRG-RED
 Enterprise                         BRICK
 V8.x                               ANLYTIC BNDL
 V6.20.0                            ENTRPRS RB
                                    ENT EDT 6.20
                                    JA
Gold               5724-E21        IBM DATA          BB0G6JA
 Analytic                           MGMT GOLD
 Bundle SMB                         PRG-RED
 V8.x V8.1.0                        BRICK ANLYTC
                                    BNDL-SMB DB2
                                    V8.1 JA
Gold               5724-E21        IBM DATA          BB0G6KO
 Analytic                           MGMT GOLD
 Bundle SMB                         PRG-RED
 V8.x V8.1.0                        BRICK ANLYTC
                                    BNDL-SMB DB2
                                    V8.1 KOREAN
Gold               5724-E21        IBM DATA          BB0G6ML
 Analytic                           MGMT GOLD
 Bundle SMB                         PRG-RED
 V8.x V8.1.0                        BRICK ANLYTC
                                    BNDL-SMB DB2
                                    V8.1 MULTI
Gold               5724-E21        IBM DATA          BB0G6SC
 Analytic                           MGMT GOLD
 Bundle SMB                         PRG-RED
 V8.x V8.1.0                        BRICK ANLYTC
                                    BNDL-SMB DB2
                                    V8.1 S.CHINESE
 
Program            Program         Part              Part
name               number          description       number
 
Gold               5724-E21        IBM DATA          BB0G6TC
 Analytic                           MGMT GOLD
 Bundle SMB                         PRG-RED
 V8.x V8.1.0                        BRICK ANLYTC
                                    BNDL-SMB DB2
                                    V8.1 T.CHINESE
Gold               5724-E21        IBM DATA          BB0G7NA
 Analytic                           MGMT GOLD
 Bundle SMB                         PRG-RED
 V8.x                               BRICK
 V6.20.0                            ANLYTIC
                                    BNDL-SMB RB
                                    WRKGRP EDT
                                    6.20 ENG
Gold               5724-E21        IBM DATA          BB0G7JA
 Analytic                           MGMT GOLD
 Bundle SMB                         PRG-RED
 V8.x                               BRICK
 V6.20.0                            ANLYTIC
                                    BNDL-SMB RB
                                    WRKGRP EDT
                                    6.20 JA

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.

On/Off Capacity on Demand

                                                     Part
Part description                                     number
 
IBM Data Management Gold Program Red Brick
Analytic Bundle for Enterprises
 
DM Gold Prog Red Brick Analytic                      D53L3LL
 Bndl Enterprise Processor Day
 OOC0D TUC
 
IBM Data Mgmt Gold Prog Red Brick
Analytic Bundle for Small and Med Busns
 
DM Gold Prog Red Brick Analytic                      D53L6LL
 Bundle SMB Processor Day
 OOC0D TUC
 
Informix Red Brick Warehouse
 
Red Brick Workgroup Edition                          ASPW7LL
 Processor Day OOCOD TUC
 
Informix Red Brick Warehouse
 
Red Brick Enterprise Edition                         ASPW4LL
 Processor Day OOCOD TUC

 
Back to top
 
Terms and conditions

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

Agreement: IBM International Program License Agreement. Proofs of Entitlement 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 numbers

                                   Program           Form
Program name                       number            number
 
Red Brick V6.X                     5724-C18          CT1HSML
Gold Analytic Bundle               5724-E20          CT2UYML
 Enterprise V8.x
Gold Analytic Bundle               5724-E21          CT2UZML
 SMB V8.x

Limited warranty: Yes

Warranty: This program has warranty for a minimum of one year from acquisition from IBM or authorized 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, FAQs, including any known fixes to defects, which the customer can download or obtain otherwise and install at leisure.

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

Copy and use on home/portable computer: No

Volume orders (IVO): No

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

Usage restriction: Yes

Red Brick Warehouse V6.30

Level of use

Your use of the program may not exceed the level defined by the number of use authorizations you have acquired. The level of use of a program is specified by processors. "Processor" means the number of processors which are attached or available to the server on which the program is installed or executed. You must acquire a use authorization for each such processor.

You may, without requiring additional processor use authorizations, install and use the Client Connector component on additional machines in support of your authorized use of the program within your enterprise.

Red Brick Workgroup Edition Restriction

The following restriction applies only to Red Brick Workgroup Edition:

Server limitation

You may not install or use the program, except for the Client Connector component, on a server that has more than two processors.

Third-party code

The program contains, and future updates and fix packs to the program may contain, certain third-party components which are provided to you under terms and conditions which are different from this agreement, or that required IBM to provide you with certain notices and/or information. For each such third-party component, either IBM will identify such third-party component in the program's "README" file (or in an updated "README" file accompanying a fix pack or update), or in a file or files referenced in such "README" files (and shall include any associated license agreement, notices, and other related information therein), or the third-party component will contain or be accompanied by its own license agreement (for example, provided when installing or starting such component, or accompanying such component in a file entitled "README," "COPYING," "LICENSE," or a substantially similar title, or included among the program's paper documentation, if any). Your use of each third-party component that contains or is accompanied by its own license agreement, or for which IBM has identified a license agreement in one of the above "README" files (or in a file or files referenced therein), will be subject to the terms and conditions of such other license agreement, and not this agreement. By using and not uninstalling such third-party components after the initial installation of such third-party components (thereby giving you access to the applicable license agreements, notices and information), you acknowledge and agree to all such license agreements, notices, and information, including those provided only in the English language. You agree to review any updated "README" file which accompanies updates or fix packs to the program.

Excluded components

Notwithstanding the terms and conditions of any other agreement you may have with IBM or any of its related or affiliated companies (collectively "IBM") or with any of the third parties that provide IBM products ("Third Parties"), the following terms and conditions apply to all "Excluded Components" identified below: (a) all Excluded Components are provided on an "AS IS" basis; (b) IBM AND THIRD PARTIES DISCLAIM ANY AND ALL EXPRESS AND IMPLIED WARRANTIES AND CONDITIONS INCLUDING, BUT NOT LIMITED TO, THE WARRANTY OF NON-INFRINGEMENT OR INTERFERENCE AND THE IMPLIED WARRANTIES AND CONDITIONS OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE; (c) IBM and Third Parties will not be liable to you or indemnify you for any claims related to the Excluded Components; and (d) IBM and Third Parties will not be liable for any direct, indirect, incidental, special, exemplary, punitive, or consequential damages with respect to the excluded components.

The following are excluded components:

  • quicksort
  • op
  • XML4C 5.0
  • Microsoft Visual C++
  • Microsoft Visual J++ Libraries

IBM Data Management Gold Program Red Brick Analytic Bundle for SMB V8.1.3 and IBM Data Management Gold Program Red Brick Analytic Bundle for Enterprise V8.1.3

When you purchase a single license (right to copy), you are authorized to install either Red Brick products or DB2 products, but not both. If you purchase multiple licenses, you may install all Red Brick products, all DB2 products, or a combination of both, up to a maximum of the number of licenses acquired. For example, if you purchase 10 licenses, you may install 10 copies of Red Brick, 10 copies of DB2, or five copies each of Red Brick and DB2.

If you purchase the DB2 media pack, all of the products listed in the offering will be shipped. If you purchase the Red Brick media pack, you will be contacted and the appropriate software version, platform, and language pack will be shipped.

  • DB2 products are subject to the terms and conditions of the IBM license agreement shipped with DB2 products, as well as these additional terms.
  • Red Brick products are subject to the terms and conditions of the Red Brick license agreement shipped with Red Brick products, as well as these additional terms.

Use of the product is subject to the terms and conditions of the products installed, except:

  • DB2 Universal Developer's Edition, which allows up to five individual users instead of the usual one user
  • DB2 Relational Connect, which allows connection to Informix data source only

By using, installing, or starting a product, you agree to the applicable terms and conditions for that product, as well as these additional terms.

The limited use only copy of DB2 Information Integrator Standard Edition that is provided with this offering can only be used in conjunction with Red Brick databases to provide access to data held in DB2 Universal Databases, other Red Brick databases, or IBM Informix Extended Parallel Server databases.

Each DB2 Information Integrator Standard Edition Proof of Entitlement (PoE) includes five DB2 Information Integrator Connector PoEs for accessing ODBC sources. Each Connector PoE entitles you to access a single database instance of a Red Brick database or data warehouse, where a "database instance" is a single copy of all the data in the database or data warehouse and the catalog to support it. Access to additional database instances or types will require that you purchase a DB2 Information Integrator PoE equal to the number of processors attached to DB2 Information Integrator and additional DB2 Information Integrator Connector PoEs.

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 is 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 one year of Software Maintenance with the initial license acquisition of each program acquired. The initial period of Software Maintenance can be extended by the purchase of a renewal option that is available.

While your Software Maintenance is in effect, IBM provides you assistance for your routine, short duration installation and usage (how-to) questions and 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 the design and development of applications, your use of programs in other than their specified operating environment, or 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

Complimentary products: IBM provides licensed copies of complimentary products in our product boxes. The complimentary products are not upgradeable through the originally ordered product. They are only upgradeable separately as individual products. If a fully licensed product is required, contact IBM or your reseller. In addition, complimentary products do not entitle customers to receive service support.

IBM operational support services — Support line: No

iSeries software subscription applies: No

On/Off capacity on demand

To be eligible for On/Off Capacity on Demand pricing, customers must be enabled for temporary capacity on the corresponding hardware, and the required contract — Z125-6907, Amendment or iSeries and pSeries® Temporary Capacity On Demand — Software — must be signed before use.
 
Back to top
 

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 is comprised of 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 no-additional charge software that resides on your IBM eServer system. It 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


 
Back to top
 
Prices

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

Passport Advantage

For Passport Advantage information and charges, contact your IBM representative or authorized IBM Business Partner. For additional information about the Passport Advantage offering, visit

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

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

IBM Global Financing

IBM Global Financing offers competitive financing to credit-qualified customers to assist them in acquiring IT solutions. 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

IBM Global Financing offerings are provided through IBM Credit LLC in the United States and other IBM subsidiaries and divisions worldwide to qualified commercial and government customers. Rates are based on a customer's credit rating, financing terms, offering type, equipment type, and options, and may vary by country. Other restrictions may apply. Rates and offerings are subject to change, extension, or withdrawal without notice.
 
Back to top
 

Order now

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

To identify your local IBM representative, 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:      IBM Americas Call Centers
            Dept:  IBM CALL, 6th Floor
            105 Moatfield Drive
            North York, Ontario
            Canada M3B 3R1
 
 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

 
Red Brick, RISQL, QMF, iSeries, Intelligent Miner, Everyplace, RMF, Informix, and Electronic Service Agent are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Passport Advantage, AIX, SP1, DB2, DB2 Universal Database, WebSphere, MQSeries, S/390, zSeries, xSeries, pSeries, and eServer are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Intel is a trademark of Intel Corporation.
 
Windows NT, Windows, and Microsoft are trademarks of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
UNIX is a registered trademark of the Open Company in the United States and other countries.
 
Other company, product, and service names may be trademarks or service marks of others.

Back to top
 

 
Printable version