IBM United States
Software Announcement 203-278
October 14, 2003

IBM DB2 Universal Database Data Warehouse Editions V8.1.2 simplify install process

 ENUS203-278.PDF (76KB)


At a glance

New DB2 Data Warehouse Editions offer powerful and flexible BI features for real-time insight and decision making to achieve e-business on demand™. DWE builds on the strong warehousing and analytics engine of DB2.


    High-function analytics built in

  • Advanced statistical functions: Correlation, co-variance, and standard deviation
  • Complete family of linear regression functions
  • Industry-leading data mining features
  • Sliding windows functions; smooth-moving average and equi-height histogram


    Industry-leading support for ad hoc queries

  • Materialized query tables (MQTs) cache prejoined aggregates for fast reuse by common queries
  • Patented multidimensional clustering index and table structure speeds queries
  • Star Join optimizer algorithms enable faster star schema queries
  • Aggregate-aware cost-based optimizer with adjustable optimization levels
  • Single, consolidated system view for querying multiple databases
  • Uses SQL


    Proven scalability

  • Near-linear scalability of DB2 enabled by shared-nothing architecture
  • DB2 published 10 TB TPC-H benchmark

For ordering, contact:

Your IBM representative or the Americas Call Centers at 800-IBM-CALL (Reference: VE001).

Overview

DB2 Universal Database® (UDB) is the world's leading database platform for business intelligence (BI) solution deployments. DB2® Data Warehouse Edition (DWE) embodies IBM's vision for BI as a cornerstone of information on demand:

  • Build BI function into the database
  • Make it accessible solely through open, standard interfaces, as part of an integrated BI platform
  • Collaborate with partners for other layers of architecture

DB2 has been steadily progressing toward supporting BI functions inside the database. The latest release of DB2 DWE enables customers and partners to perform mining, Online Analytic Processing (OLAP), Extract, Transform and Load (ETL), and advanced analytics with a single unified engine operating on common data structures within a consolidated data warehouse. It combines a carefully selected set of IBM BI products to provide the essential infrastructure needed to extend the enterprise data warehouse as a platform for BI.

DB2 delivers the core strengths of scaling, platform portability, flexibility, extensibility, availability, and manageability. It also brings all the benefits of IBM's services, support, and customer partnership capabilities.

DB2 DWE leverages the full portfolio of partner tools, applications, and services, as well as IBM's own software portfolio (including Rational®, Tivoli®, Lotus®, and WebSphere®), to deliver full-function BI platforms for customer and partner solution development.

What's new?

Version 8.1.2 includes an Integrated Install feature that simplifies and streamlines the install process with a single GUI for installing products included with it. The Integrated Install feature offers support for:

  • Silent installation of DWE Enterprise Edition or DWE Standard Edition
  • Installation on Windows™, AIX®, Solaris, and Linux (Intel™) platforms
  • Both server and client environments

Key prerequisites

Refer to the Hardware requirements and Software requirements sections.

Planned availability dates

  • October 14, 2003 (electronic software delivery)
  • October 17, 2003 (media)

Description

DB2 UDB is the ideal database for your warehouse solution. DB2 scales easily across a range of server platforms and architectures, from 100 GB databases to 10 TB databases. Published 100 GB and 10 TB TPC-H benchmarks prove it. DB2 Data Warehouse Editions are available for Linux, Windows 2000/2003 servers, Solaris, and AIX.

DB2 UDB Data Warehouse Enterprise Edition V8.1.2 includes:

  • DB2 UDB Enterprise Server Edition V8.1
  • DB2 UDB Database Partitioning Feature V8.1
  • DB2 Cube Views V8.1
  • DB2 Intelligent Miner™ Modeling, Scoring and Visualization V8.1
  • DB2 Office Connect Enterprise Web Edition V4.0
  • DB2 Query Patroller V8.1
  • DB2 Warehouse Manager Standard Edition V8.1
  • DB2 Information Integrator Standard Edition V8.1 (restricted use for Relational ETL Sources)

DB2 UDB Data Warehouse Standard Edition V8.1.2 includes:

  • DB2 UDB Workgroup Server Unlimited Edition V8.1
  • DB2 Cube Views V8.1
  • DB2 Intelligent Miner Modeling, Scoring and Visualization V8.1
  • DB2 Office Connect Professional Web Edition V4.0

Data warehouse features include:

  • Shared-nothing partitioning feature that provides no-limits scaling
  • Simplified management of databases for all sizes
  • Multidimensional data clustering-optimized table and index structures
  • User-maintained materialized query tables for cube-like performance of select queries
  • Online table load and reorganization
  • Configuration Advisor, which provides automated out-of-box configuration tuned for data warehousing

Section 508 of the U.S. Rehabilitation Act

DB2 UDB Data Warehouse Editions, DB2 Warehouse Manager Standard Edition, DB2 Cube Views, DB2 Office Connect, and DB2 Query Patroller are capable, 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.

Product positioning

DB2 UDB Data Warehouse Enterprise Edition

This powerful and flexible business intelligence platform includes data partitioning, integrated OLAP, advanced data mining, enhanced ETL with federated sources, workload management, and support for Microsoft™ Excel. It is ideal for large data warehouses and other BI solutions that require best-of-breed scalability and manageability.

DB2 UDB Data Warehouse Standard Edition

Gives mid-market enterprises a complete data mart infrastructure product that includes DB2, integrated OLAP, advanced data mining, ETL, and support for Microsoft Excel. It is ideal for data marts and BI solutions that support single departments or lines of business and enterprise data warehouses where high-end scalability is not a concern.

Reference information

For details about the products and features, refer to Software Announcement 203-137 , dated May 13, 2003.

Trademarks

 
Intelligent Miner and e-business on demand are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2 Universal Database, DB2, Rational, Tivoli, Lotus, WebSphere, and AIX are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Intel is a trademark of Intel Corporation.
 
Windows and Microsoft are trademarks of Microsoft Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.

Offering information

Product information is available through:

Publications

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 or customer number. A large number of publications are available online in various file formats, and they can all be downloaded free of charge.

The IBM Publications Notification System:

The Publications Notification System (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.

Technical information

Hardware requirements

Memory requirements: The following table shows applicable recommended minimum memory requirements for installation prerequisites in megabytes (MB). The actual requirement depends on the applications the customer intends to run. Additional memory may be required to handle heavy workloads and large numbers of users. The following numbers are for reference only.

                 Solaris     AIX(R)    Windows(TM)  Linux
 
DB2(R) Cube        (1)        (1)         (1)        (1)
 Views
WHM                512        512         512        N/A
 Standard
 Edition (2)
WHM                256        256         256        N/A
 Standard
 Edition (3)
Intelligent        256        256         256        256
 Miner
 Modeling
Intelligent        256        256         256        256
 Miner
 Scoring
Intelligent        256        256         256        256
 Miner
 Visualization
Data              1536       1536        1536        768
 Warehouse
 Editions
1
The memory you allocate for your edition of DB2 Universal Database® is enough for DB2 Cube Views. For additional installation information, including disk and memory requirements, refer to the DB2 Cube Views Installation Notes for your operating system. This document is available on the Cube Views CD.
2
Development environment: Heavy GUI usage, minimal DWC server and default agent work.
3
Production environment: Minimal GUI usage, heavy DWC server usage, minimal default agent work.

Disk space requirements: The following table shows applicable recommended minimum disk space for a typical install in MB. The actual space required may vary depending on the customers' file system and the components installed. The following numbers are for reference only.

                 Solaris      AIX       Windows     Linux
 
DB2 Cube           (4)        (4)         (4)        (4)
 Views
Office             N/A        N/A         200        N/A
 Connect
WHM               1000       1000        1000       1000
 Standard
 Edition
Intelligent         65         60          90         45
 Miner
 Modeling
Intelligent         60         60          40         60
 Miner
 Scoring
Intelligent        110         10          50         10
 Miner
 Visualization
Data              1235       1130        1380       1115
 Warehouse
 Editions
4
The disk space required for DB2 Cube Views depends on the type of installation you choose. When you install the product using the DB2 Setup wizard, the installation program dynamically provides size estimates based on the type of installation and components you select.

Software requirements

Total software requirements for the DB2 UDB Data Warehouse Enterprise Editions are approximately the sum of the requirements for all installed components.

For links to information about DB2 Data Warehouse Edition and DB2 Warehouse Manager, visit:

DB2 Cube Views V8.1

  • Microsoft™ Windows — Windows 2000 32-bit
  • AIX — AIX V5.1, AIX V5.2 32-bit, AIX V5.1, AIX V5.2 64-bit
  • Linux — Linux Red Hat 8 (kernel 2.4.18/glibc 2.2.93-5) 32-bit, or Linux SuSE 8.0 (kernel 2.4.18/ glibc 2.2.5) 32-bit. For the latest information on distribution and kernel levels supported by DB2, visit:
  • Sun Solaris — Solaris 8 32-bit or Solaris 9 32-bit
  • Client component: Windows 2000
  • DB2 Universal Database V8.1 FixPak 2
  • Optional: Office Connect Analytics Edition 4.0

To use Office Connect Analytics Edition, you need Microsoft Excel 2000 (Office 2000 with Service Pack 1, or later) or Microsoft Excel XP (Office XP with Service Pack 1, or later).

For links to information about DB2 Cube Views, visit:

DB2 Query Patroller

DB2 Query Patroller server requirements

DB2 UDB Enterprise Server Edition (V8.1.2, or later) must be installed in order to install the Query Patroller server component.

You need Java™ Runtime Environment (JRE) V1.3.1 to run Query Patroller server, the Query Patroller Java-based tools (such as the Query Patroller Center), and to create and run Java applications, including stored procedures and user-defined functions.

Netscape 6.2 or Microsoft Internet Explorer 5.5 is required to view the online installation help.

  • AIX — AIX V5.1.0 with maintenance level 2, or later, APARs IY22844, IY31254, IY32217, IY32905, IY29345, and IY33023 (32-bit)
  • Solaris
    • Solaris 8 (32-bit) Recommended and Security Patches: 108921-12, 108940-24, 108434-03, and 108528-12
    • Solaris 9 (32-bit)

  • Linux — For the latest information on supported Linux distribution and kernel levels, visit:

  • Microsoft Windows
    • Windows 2000 (Service Pack 2 is required for Windows Terminal Server)
    • Windows Server 2003 (32-bit)

DB2 Query Patroller client requirements

A DB2 product (V8.1.2, or later) must be installed on the computer that you will install the Query Patroller client tools on. The following products are appropriate prerequisites:

  • Any DB2 client product (for example, DB2 Run-Time client or DB2 Application Development client)
  • Any DB2 Connect® product (for example, DB2 Connect Personal Edition or DB2 Connect Enterprise Server Edition)
  • Any DB2 server product (for example, DB2 UDB Enterprise Server Edition or DB2 UDB Workgroup Server Edition)

You need a JRE V1.3.1 to run the Query Patroller Java-based tools, such as the Query Patroller Center, and to create and run Java applications, including stored procedures and user-defined functions.

Netscape 6.2 or Microsoft Internet Explorer 5.5 is required to view the online installation help.

AIX — AIX V5.0, or later. The following AIX file sets are required to install or run Query Patroller in languages other than English:

  • X11.fnt.ucs.ttf (AIX Windows Unicode TrueType Fonts)
  • xlC.rte 5.0.2.x

For Asian languages, the following file sets are also required:

  • X11.fnt.ucs.ttf_CN (for zh_CN or Zh_CN)
  • X11.fnt.ucs.ttf_KR (for ko_KR)
  • X11.fnt.ucs.ttf_TW (for zh_TW or Zh_TW)

On AIX V5.x the following file set is required:

  • xlC.aix50.rte 5.0.2.x

AIX filesets can be downloaded from:

  • Solaris — Solaris V2.7, or later

    The following patches are required for the Solaris Operating Environment V2.7:

    • Solaris Operating Environment 8 (32-bit) patch 108434-01 + 108528-12

    The following software is required to install Query Patroller on Solaris Operating Environment:

    • SUNWlibC

  • Linux — For the latest information on supported Linux distribution and kernel levels, visit:

  • Microsoft Windows
    • Windows 2000
    • Windows XP (32-bit)
    • Windows Server 2003 (32-bit)

DB2 Office Connect V4.0

The computer on which you install the DB2 Office Connect product (usually your development computer) requires:

  • Microsoft Excel, Version 97 or later, with Service Pack 1, or later
  • Microsoft Internet Explorer, V5.5 with Service Pack 1, or later
  • Microsoft Data Access Components (ADO), V2.5 with Service Pack 2, or later (included with the Office Connect install)
  • If you connect to an DB2 server, you need the following:
    • DB2 JDBC driver JDK V1.3, or later
    • DB2 Client 7.01.0041, or later
    • Java 2 SDK, V1.3, or later, on your local computer
  • To set up a server machine as the middle-tier server where you install and configure the Office Connect servlet, the following is required:
    • Java 2 SDK 1.3, or later
  • A Web Server, which can be one of the following:
    • WebSphere®, V4.0, or later
    • Jakarta Tomcat, V3.2.x
    • Apache Web Server V1.3.x, with Jakarta Tomcat, V3.2.x
  • JDBC drivers for all the databases used (including the repository)

DB2 Intelligent Miner™ products

The offerings in this announcement require JRE 1.3.1 operating system.

Provides information about DB2 Intelligent Miner Modeling, Scoring, and Visualization.

Platform Matrix: These DB2 product and component acronyms are used in the table that follows:

  • DB2 Intelligent Miner Scoring (IMSC)
  • DB2 Intelligent Miner Modeling (IMMO)
  • DB2 Intelligent Miner Visualization (IMVI)
  • DB2 Office Connect (OC)
  • DB2 Cube Views (CV)
  • DB2 UDB Workgroup Server Unlimited Edition (WSUE)
  • DB2 UDB Enterprise Server Edition (ESE)

Support for operating systems by DB2 products and components:

                           IMSC IMMO IMVI OC CV WSUE ESE QP
 
Windows 2000                Y    Y    Y   Y  Y   Y    Y  Y
Windows XP Home             Y    Y    Y   N  N   N    N  Y(5)
Windows XP Professional     Y    Y    Y   Y  N   Y    N  Y(5)
Windows XP 64-bit           N    N    N   N  N   N    N  Y(5)
Windows Server 2003         Y    Y    Y   N  N   Y    Y  Y
Windows Server 2003 64-bit  N    N    N   N  N   N    Y  Y
AIX V5.1 and V5.2 32-bit    Y    Y    Y   N  Y   Y    Y  Y
AIX V5.1 and V5.2 64-bit    N    N    N   N  Y   N    Y  N(6)
Solaris 32-bit              Y    Y    Y   N  Y   Y    Y  Y
Solaris 64-bit              N    N    N   N  N   N    Y  N(6)
Linux 32-bit                Y    Y    Y   N  Y   Y    Y  Y
Linux Itanium 64-bit        N    N    N   N  N   N    Y  N(6)
5
DB2 Query Patroller Client only.
6
IBM intends to provide 64-bit support for DB2 Query Patroller.

These Warehouse Manager (ETL) product and component acronyms are used in the table that follows:

  • Warehouse Agent and Transformers (WAT)
  • Information Catalog Manager Metadata (ICMM)
  • Data Warehouse Center Metadata (DWCM)
  • Information Catalog Center GUI (ICC)
  • Data Warehouse Center GUI (DWC)
  • Warehouse Server (WS)

Platform                  WAT ICMM  DWCM  ICC  DWC  WS
 
Windows 2000               Y    Y    Y     Y    Y    Y
Windows XP Home            N    N    N     Y    Y    N
Win XP Professional        N    N    N     Y    Y    N
Windows XP 64              N    N    N     N    N    N
Win Server 2003            Y    Y    Y     Y    Y    Y
Win Server 2003 64         N    N    N     N    N    N
AIX V5.1 and V5.2 32-bit   Y    Y    Y     Y    Y    Y
AIX V5.1 and V5.2 64-bit   N    N    N     N    N    N
Solaris 32-bit             Y    Y    Y     Y    Y    N
Solaris 64-bit             N    N    N     N    N    N
Linux 32                   Y    Y    Y     Y    N    N
Linux Itanium 64           N    N    N     N    N    N

Planning information

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

For additional information, contact your IBM representative or IBM Business Partner, or refer to the IBM software support Web site at:

Packaging

DB2 UDB Data Warehouse Enterprise Edition

Media

  • DB2 UDB Enterprise Server Edition V8.1
  • DB2 UDB Database Partitioning Feature V8.1
  • DB2 Cube Views V8.1
  • DB2 Intelligent Miner Modeling V8.1
  • DB2 Intelligent Miner Visualization V8.1
  • DB2 Intelligent Miner Scoring V8.1
  • DB2 Information Integrator Standard Edition V8.1
  • IBM Office Connect Enterprise Web Edition V4.0
  • DB2 Query Patroller V8.1
  • DB2 Warehouse Manager Standard Edition V8.1

DB2 UDB Data Warehouse Standard Edition

Media

  • DB2 UDB Workgroup Server Unlimited Edition V8.1
  • DB2 Cube Views V8.1
  • DB2 Intelligent Miner Modeling V8.1
  • DB2 Intelligent Miner Visualization V8.1
  • DB2 Intelligent Miner Scoring V8.1
  • IBM Office Connect Professional Web Edition V4.0

Security, auditability, and control

The IBM products listed in this announcement use the security and auditability features of the host 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 information

Licensed
function                Product              Product
title                   group                category
 
DB2 Query Patroller     IBM DATABASE 2(TM)   DB2 Universal
                                              Database
DB2 Cube Views          IBM Database 2       DB2 Tools
DB2 UDB DATA            IBM Database 2       DB2
 Warehouse Enterprise
 Edition
DB2 UDB DATA            IBM Database 2       DB2
 Warehouse Standard
 Edition
IBM Office Connect      Informix(TM)         Informix Office
 Prof Web Edition        Application          Connect
                         Dvpmt Tools
IBM Office Connect      Informix             Informix Office
 Ent Web Edition         Application          Connect
                         Dvpmt Tools
DB2 Warehouse           IBM Information      IBM Information
 Manager Standard        Integrator           Integrator
 Edition

Product                              Metrics
 
DB2 UDB Data Warehouse               Processor
 Enterprise Edition
DB2 UDB Data Warehouse Standard      Processor
 Edition

Metric descriptions

Processor

A processor license must be obtained for each processor attached or available to Web servers or application servers. Charges are not based on the number of servers or processors attached or available to the program itself.

Registered user

A registered user of a program is a specific individual authorized by you to use the program. Such an individual is a registered user whether or not they are actually using the program.

Passport Advantage licensing

DB2 UDB Data Warehouse Standard Edition

                                                  Part
Program name/description                          number
 
DB2 UDB DW Std Ed Proc License                    D5290LL
 and SW Maint, 12 mo
DB2 UDB DW Std Ed Proc Annual SW                  E00PNLL
 Maint Renewal., PA
DB2 UDB DW Std Ed Proc SW Maint                   D5292LL
 Reinstatement, 12 mo
DB2 UDB DW Std Ed Proc Upg Fr                     D5293LL
 DB2 UDB Workgroup Ed

DB2 UDB Data Warehouse Enterprise Edition

                                                  Part
Program name/description                          number
 
DB2 UDB DW Ent Ed Proc License                    D5298LL
 and SW Maint, 12 mo
DB2 UDB DW Ent Ed Proc Annual SW                  E00PVLL
 Maint Renewal
DB2 UDB DW Ent Ed Proc SW Maint                   D529ALL
 Reinstatement, 12 mo
DB2 UDB DW Ent Ed Proc Upg Fr                     D529BLL
 DB2 UDB ESE Lic and Maint 12 mo

Passport Advantage supply

                                                  Part
Program name/description                          number
 
DB2 UDB DW STD ED V8.1.2
 
Media Pack Multilingual (French,                  BB0INML
 Spanish, Brazilian Portuguese,
 German, English U.S., Italian)
 Windows 2000, Windows XP,
 Solaris (Sun Microsystems),
 Windows Server 2003, AIX V5.x,
 Linux for x86 Series Intel(TM)-based
 servers CD-ROM Digital Disk --
 ISO 9660 Standard V8.1.2
 
                                                  Part
Program name/description                          number
 
DB2 UDB DW ENT ED V8.1.2
 
Media Pack Multilingual (French,                  BB0IMML
 Spanish, Brazilian Portuguese,
 German, English U.S., Italian)
 Windows 2000, Windows XP,
 Solaris (Sun Microsystems),
 Windows Server 2003, AIX V5.x,
 Linux for x86 Series Intel-based
 servers CD-ROM Digital Disk --
 ISO 9660 Standard V8.1.2

Passport Advantage customer: media pack Entitlement details

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

DB2 UDB DW Std Ed V8.1.2

Entitled maintenance     Media packs              Part
offerings description    description              number
 
DB2 UDB Data             DB2 UDB DW Std Ed        BB0INML
 Warehouse                Multilingual (French,
 Standard                 Spanish, Brazilian
 Edition Bundle           Portuguese, German,
                          English U.S., Italian)
                          Windows 2000,
                          Windows XP,
                          Solaris
                          (Sun Microsystems),
                          Windows Server 2003,
                          AIX V5.x, Linux for
                          x86 Series Intel-based
                          servers CD-ROM
                          Digital Disk --
                          ISO 9660 Standard

DB2 UDB DW Ent Ed V8.1.2

Entitled maintenance     Media packs              Part
offerings description    description              number
 
DB2 UDB Data             DB2 UDB DW Ent Ed        BB0IMML
 Warehouse                Multilingual (French,
 Enterprise               Spanish, Brazilian
 Edition Bundle           Portuguese, German,
                          English U.S., Italian)
                          Windows 2000,
                          Windows XP, Solaris
                          (Sun Microsystems),
                          Windows Server 2003,
                          AIX V5.x, Linux for
                          x86 Series Intel-based
                          servers CD-ROM
                          Digital Disk --
                          ISO 9660 Standard

Withdrawal of previous Passport Advantage part numbers: The following Media Pack part numbers will be withdrawn on November 13, 2003:

                                                  Part
Product name      V.R.M     Description           number
 
DB2 UDB Data      V8.1      English Media         BB0HENA
 Warehouse                   Pack
 Enterprise
 Edition
DB2 UDB Data      V8.1      French Media          BB0HEFR
 Warehouse                   Pack
 Enterprise
 Edition
DB2 UDB Data      V8.1      Spanish Media         BB0HIES
 Warehouse                   Pack
 Enterprise
 Edition
DB2 UDB Data      V8.1      Brazilian             BB0HIBP
 Warehouse                   Portuguese
 Enterprise                  Media Pack
 Edition
DB2 UDB Data      V8.1      German Media          BB0HEDE
 Warehouse                   Pack
 Enterprise
 Edition
DB2 UDB Data      V8.1      Italian Media         BB0HIIT
 Warehouse                   Pack
 Enterprise
 Edition
DB2 UDB Data      V8.1      Japanese Media        BB0HEJA
 Warehouse                   Pack
 Enterprise
 Edition
DB2 UDB Data      V8.1      Korean Media          BB0HEKO
 Warehouse                   Pack
 Enterprise
 Edition
DB2 UDB Data      V8.1      Traditional           BB0HITC
 Warehouse                   Chinese Media
 Enterprise                  Pack
 Edition
DB2 UDB Data      V8.1      English Media         BB0HFNA
 Warehouse                   Pack
 Standard
 Edition
DB2 UDB Data      V8.1      French Media          BB0HFFR
 Warehouse                   Pack
 Standard
 Edition
DB2 UDB Data      V8.1      Spanish Media         BB0HJES
 Warehouse                   Pack
 Standard
 Edition
DB2 UDB Data      V8.1      Brazilian             BB0HJBP
 Warehouse                   Portuguese
 Standard                    Media Pack
 Edition
DB2 UDB Data      V8.1      German Media          BB0HFDE
 Warehouse                   Pack
 Standard
 Edition
DB2 UDB Data      V8.1      Italian Media         BB0HJIT
 Warehouse                   Pack
 Standard
 Edition
DB2 UDB Data      V8.1      Japanese Media        BB0HFJA
 Warehouse                   Pack
 Standard
 Edition
 
                                                  Part
Product name      V.R.M     Description           number
 
DB2 UDB Data      V8.1      Korean Media          BB0HFKO
 Warehouse                   Pack
 Standard
 Edition
DB2 UDB Data      V8.1      Traditional           BB0HJTC
 Warehouse                   Chinese Media
 Standard                    Pack
 Edition

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.

Terms and conditions

Licensing: IBM International Program License Agreement (IPLA). 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

                                                  License
Program                     Program               information
name                        number                form number
 
DB2 UDB DW Standard         5724-E35              L-VACA-5NVPKY
 Edition
DB2 UDB DW Enterprise       5724-E34              L-VACA-5NVPKY
 Edition

Limited warranty: Yes

Warranty: This program has program services for a minimum of one year from the date of notification of an end to support for this product.

Program technical support: Technical Support of a program product will be available for a minimum of three years from the general availability date, as long as your Software Maintenance is in effect. This Technical Support allows you to obtain assistance (via telephone or electronic means) from IBM for product-specific, task-oriented questions regarding the installation and operation of the program product. Software Maintenance also provides you with access to updates, releases, and versions of the program. Customers will be notified, via announcement letter, of discontinuance of support with 12 months' notice. If you require additional technical support from IBM, including an extension of support beyond the discontinuance date, contact your IBM representative or Business Partner. This extension may be available for a fee.

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

                                                  Copy and use on
Product                                           home/portable
name                                              computer?
 
DB2 UDB DW Standard Edition                       No
DB2 UDB DW Enterprise Edition                     No

Volume orders (IVO): No

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

Usage restriction: Yes

The DB2 UDB Warehouse Standard Edition V8.1.2 and the DB2 UDB Data Warehouse Enterprise Edition V8.1.2 (DWE 8.1.2) each consist of a number of packaged components. The program-unique terms of this DWE 8.1.2 license supersede and replace the terms of the program unique terms for each of the individual components comprising this program.

The following program-unique terms apply to DB2 UDB Data Warehouse Standard Edition V8.1.2.

DB2 UDB Data Warehouse Standard Edition V8.1.2 includes the following components:

  • DB2 UDB Workgroup Server Unlimited Edition V8.1
  • DB2 Cube Views V8.1
  • DB2 Intelligent Miner Modeling, Scoring, and Visualization V8.1
  • DB2 Office Connect Professional Web Edition V4.0

The use-based charges described here supersede any use-based charges that may appear in the licenses for each of these components.

However, all other terms or restrictions described in licenses for the above components apply unless otherwise modified below.

Usage Restriction — Use as program bundle only

This program is comprised of various components and the components are licensed for use solely in combination with the packaged components. None of the included components may be used, transferred, sublicensed, or redistributed individually or in any combination of components other than as a complete package consisting of each and all of the components listed above.

Use-based charges — Resources

Charges for this program are based on the number of processors that are attached or available to the DB2 server on which it is licensed. The total number of processors attached or available may not exceed the number authorized by the applicable PoEs or authorized by each program authorization acquired under Passport Advantage. If the total number exceeds the quantity in your PoEs or exceeds your product authorizations acquired under Passport Advantage, you must notify IBM or its reseller as stated in the IPLA.

The IBM Office Connect Professional Edition component of this program is licensed on a per-user basis. Each PoE or product authorization for the program includes a license to IBM Office Connect Professional Edition for use by up to five users.

Resource and use restriction

The following restrictions or exceptions apply to the use of the program:

Processor limit

Use of this program is restricted to servers with up to four processors.

64-bit server restriction

This program does not support the creation of 64-bit DB2 server instances.

Single server only

All components provided with the program can only be installed and used on the DB2 Server for which this program is licensed, unless otherwise authorized in the license for the individual component.

Use With DB2 UDB Workgroup Server Unlimited Edition

Any prohibition in the individual license of any included components preventing use with DB2 UDB Workgroup Server Unlimited V8.1 does not apply. All of the components of DB2 UDB Data Warehouse Standard Edition V8.1.2 are excepted from such restriction as long as the other restrictions specified in these program-unique terms are observed.

Limited platform support

If the program is acquired under the terms of an IBM offering for limited platform support (for instance, the program is acquired for use on a single platform or less than all available platforms), then that program is licensed only for installation and use on the specific platforms or operating systems as designated by the offering terms and conditions.

High availability/failover licensing

In Idle Standby or Active Standby, you must acquire the correct number of product authorizations:

  • In Idle Standby, you must license the program for one processor on the Idle Standby server.
  • In Active Standby, you must license the program for the number of processors attached or available to the Active Standby server.

The following program-unique terms apply to DB2 Universal Database Data Warehouse Enterprise Edition V8.1.2:

DB2 UDB Data Warehouse Enterprise Edition V8.1.2 includes the following components:

  • DB2 UDB Enterprise Server Edition V8.1
  • DB2 UDB Data Partitioning Feature V8.1
  • DB2 Cube Views V8.1
  • DB2 Intelligent Miner Modeling, Scoring, and Visualization V8.1
  • DB2 Query Patroller V8.1
  • DB2 Warehouse Manager Standard Edition V8.1
  • DB2 Office Connect Enterprise Web Edition V4.0
  • DB2 Information Integrator Standard Edition V8.1

The use-based charges described here supersede any use-based charges that may appear in the licenses for each of these components. However, all other terms or restrictions described in licenses for these components continue to apply unless otherwise modified here.

Usage Restriction — Use as program bundle only

This program is comprised of various components, and the components are licensed for use solely in combination with the packaged components. None of the included components may be used, transferred, sublicensed or redistributed individually or in any combination of components other than as a complete package consisting of each and all of the components listed here.

Use-based charges — Resources

Charges for this program are based on the number of processors that are attached or available to the DB2 server on which it is licensed. A DB2 server is defined as a single database image across a single SMP or multiple server configuration. The total number of processors attached or available may not exceed the number authorized by the applicable PoEs or authorized by each program authorization acquired under Passport Advantage. If the total number exceeds the quantity in your PoEs or exceeds your product authorizations acquired under Passport Advantage, you must notify IBM or its reseller as stated in the IPLA.

Resource and use restriction

Single server only

All components provided with the program can only be installed and used on the DB2 Server for which this program is licensed, unless otherwise authorized in the license for the individual components.

DB2 Information Integrator Standard Edition — Limited use only

The copy of DB2 Information Integrator Standard Edition that is provided with the program may only be used in conjunction with DB2 Warehouse Manager Standard Edition V8.1 to provide native connectors for accessing data from Oracle databases, Teradata databases, Sybase databases, and Microsoft SQL server databases. Each DB2 Information Integrator Standard Edition PoE includes four DB2 Information Integrator Connector PoEs. If additional connections are required, additional DB2 Information Integrator Connector program entitlements must be acquired.

Limited platform support

If the program is acquired under the terms of an IBM offering for limited platform support (for instance, the program is acquired for use on a single platform or less than all available platforms), then that program is licensed only for installation and use on the specific platforms or operating systems as designated by the offering terms and conditions.

High availability/failover licensing

In Idle Standby or Active Standby, you must acquire the correct number of product authorizations:

  • In Idle Standby, you must license the program for one processor on the Idle Standby server.
  • In Active Standby, you must license the program for the number of processors attached or available to the Active Standby server.

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 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 Software Announcement 203-029 , dated February 4, 2003, or visit the Passport Advantage Web site at:

IBM Operational Support Services — Support Line: No

iSeries™ Software Subscription applies: No

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 the following Web site:

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

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

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 the Web at:

Use the Select a Country menu to find a contact in your location (or country).

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:

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:      The Americas Call Centers
            Dept. VE001
            P.O. Box 2690
            Atlanta, GA  30301-2690
 
 Reference: VE001

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

 
Intelligent Miner, DATABASE 2, Informix, iSeries, and Electronic Service Agent are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Passport Advantage, AIX, DB2, DB2 Universal Database, DB2 Connect, WebSphere, 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 and Microsoft are trademarks of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
Other company, product, and service names may be trademarks or service marks of others.