IBM DB2 Universal Database Data Warehouse Edition, V8.2 offers key building blocks for on demand business

IBM United States Software Announcement 204-293
December 7, 2004

 

 ENUS204-293.PDF (99KB)

Table of contents   Document options  
TOC link At a glance TOC link Offering information
TOC link Overview TOC link Publications
TOC link Key prerequisites TOC link Technical information
TOC link Description TOC link Ordering information
TOC link Product positioning TOC link Terms and conditions
TOC link Statement of direction TOC link IBM Electronic Services
TOC link Reference information TOC link Prices
TOC link Education support TOC link Order now
 
Printable version Printable version

 
At a glance

New DB2 UDB DWE provides improved performance and usability of BI features, for real-time insight and decision making to achieve e-business on demand™. DWE continues to build on the scalable, extensible warehousing and analytics engine of DB2. Even before adding on the OLAP, mining, and ETL capabilities of DWE, the enhanced DB2 V8.2 engine provides:

Advanced analytics built in

  • Sophisticated statistical functions: correlation, co-variance, and standard deviation
  • Complete family of linear regression functions
  • Sliding window functions; smooth-moving average and equi-height histogram
  • Bernoulli randomized sampling at row and page level

Industry-leading support for decision-support queries

  • Materialized query tables (MQTs) that cache pre-joined aggregates for fast reuse by common queries
  • Patented multidimensional clustering to speed queries
  • Star Join optimizer algorithms, which enable faster star schema queries
  • Aggregate-aware cost-based optimizer with adjustable optimization levels and improved query re-write
  • Single, consolidated system view for querying multiple databases

For ordering, contact:

Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: VE001).
 
Back topBack to top
 

Overview

DB2 Universal Database® (UDB is the premier database platform for Business Intelligence (BI) data warehousing solution deployments). DB2® UDB Data Warehouse Edition (DWE) builds on DB2 and embodies IBM's vision for BI as a cornerstone of information on demand. With DWE, you can:

  • 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 moving down a path of supporting increasing BI function inside the database. The latest release of DB2 DWE further empowers customers and partners to perform mining, online analytical 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. DB2 DWE combines the same 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 can be leveraged by a full portfolio of partner tools, applications, and services to deliver full-function BI platforms for customer and partner solution development. DWE V8.2 is another incremental step towards delivering the vision of a fully-integrated BI platform based on DB2 and providing first-class data mining, OLAP, ETL, and reporting capabilities.

What's new?

DWE V8.2 delivers key usability enhancements in two vital areas:

  • OLAP — New federation capabilities allow DB2 Cube Views to accelerate queries from many data sources, including eServer iSeries™, IBM eServer zSeries®, and third-party databases. DB2 Cube Views V8.2 also includes enhancements to allow DBAs to create smaller, more efficient summary tables.
  • Data mining — Continuing to focus on Easy Mining, DWE 8.2 introduces a new, highly accurate algorithm from IBM Research that requires no input parameters makes numeric prediction with DB2 faster and more effective. New Easy Mining procedures make developing powerful applications with built-in data mining fast and simple. All of the algorithms for data mining are now more robust, and model quality information is easily accessible.

IBM introduces DB2 UDB Data Warehouse Base Edition which is designed to offer mid- and large-scale enterprises data warehouse and datamart infrastructure that includes DB2 and integrated OLAP capability for superior scalability and performance.
 
Back topBack to top
 

Key prerequisites

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

Description

Planned availability dates

  • December 7, 2004: Electronic software delivery
  • December 10, 2004: Media and documentation

DB2 UDB Data Warehouse Edition

DB2 UDB Data Warehouse Edition (DWE) is the business intelligence platform for flexible, scalable, and integrated data warehouse and analytical applications. DWE starts with DB2 UDB as its core engine, and extends it with a carefully chosen set of analytic capabilities to provide a comprehensive development and runtime platform for Business Intelligence. DB2 UDB scales easily across a range of server platforms and architectures, from 10 GB to 10 TB databases. A long and continuing track-record of published TPC-H benchmarks attests to the scaling efficiency, ultimate scalability thresholds, and platform portability of DB2. DB2 UDB Data Warehouse Standard Edition, DB2 UDB Data Warehouse Base Edition, and DB2 UDB Data Warehouse Enterprise Edition are available for AIX®, Linux™, Solaris, and Windows™ operating systems.

DB2 UDB Enterprise Server Edition, V8.2 and its DB2 Database Partitioning Feature are included with Data Warehouse Enterprise Edition. DB2 UDB Enterprise Server Edition, V8.2 is included in DB2 UDB Data Warehouse Base Edition. DB2 UDB Workgroup Server Unlimited Edition, V8.2 is provided with DB2 UDB Data Warehouse Standard Edition.

Data warehouse features in DB2 UDB, V8.2 include:

  • Database Partitioning Feature for massive scalability
  • Autonomic Management for DBA productivity, for databases of all sizes
  • Multidimensional data clustering — optimized storage option for data used in OLAP and other queries
  • Materialized query tables that provide cube-like performance for warehouse queries
  • Online Utilities to help maintain a real-time warehouse
  • Design Advisor, which makes it easy to design the optimal set of warehouse objects (including MQT, index, partitioning, and MDC) for high performance analytical workloads
  • Built-in functions for advanced analytics including regression, co-variance, histograms, moving windows
  • Sampling function with row-level and page-level options
  • Advanced optimization techniques including star-join algorithm with dynamic bitmap indexing
  • Compression of default values (for example, trailing blanks in large character field), which provides an effective, low-overhead technique for reducing the disk requirements of large warehouses

Find out more about DB2 UDB Enterprise Server Edition here

OLAP acceleration

DB2 Cube Views, V8.2

DB2 Cube Views, V8.2 works together with partner BI tools to accelerate OLAP queries in DB2. With V8.2, queries from many data sources supported by DB2 Information Integrator can be accelerated by DB2 Cube Views. DB2 Cube Views works by using cube metadata to design specialized summary tables containing critical dimensions and levels — or slices — of the cube. The DB2 optimizer re-writes incoming queries, transparently routing eligible queries to the appropriate summary tables for significantly faster query performance. The Cube Views created summary tables can accelerate all SQL-based queries into the data warehouse, not just those using a particular tool or interface.

Besides performance benefits, Cube Views metadata and tooling allow cube models to be defined once in DB2 and used in many partner BI tools, or alternatively, imported into DB2 from the partner tool. Either way, productivity of OLAP administrators and developers is improved. Because the shared common metadata includes aggregation formulas and calculations, users benefit from greater consistency of analytical results across the enterprise.

Office Connect Analytics Edition is no longer part of DB2 Cube Views but is available "as is" to customers licensed for Cube Views V8.1 or Cube Views V8.2 and is available for download.

Web Services for DB2 Cube Views

Office Connect Analytics

    ftp://service.software.ibm.com/ps/products /db2md/v82/oca401

Read more about DB2 Cube Views here

Data Mining in the warehouse

DB2 Intelligent Miner™ for Scoring, Modeling, and Visualization, V8.2

DB2 UDB Data Warehouse Editions include IBM's mature, proven, data mining technology now in use by many business intelligence application developers. Building modeling and scoring functions right into the data warehouse means that enterprises can glean critical business insights without having to extract data from the warehouse, and apply those insights directly to relevant warehouse data populations (such as customers at risk for fraud). Data mining capabilities in DB2 are standards-based, using XML/PMML and SQL, which makes it easy to learn and use. Data mining models, generated by DB2 Intelligent Miner Modeling, including the new IBM Research developed prediction algorithm, can be visualized using DB2 Intelligent Miner Visualization. These models, along with any PMML-expressed model from partner tools, can be stored in DB2 and integrated into real-time data warehouse and business intelligence applications using DB2 Intelligent Miner Scoring. As with all DB2-based analytic functions, DB2 Intelligent Miner Scoring harnesses the underlying parallelism, scalability, and manageability of the database.

Web services are now available for DB2 data mining. For more information, see

Workload and query management

DB2 Query Patroller, V8.2 is included with DB2 UDB Data Warehouse Enterprise Edition. The workload management and warehouse administration features of Query Patroller let you control your data warehouse, enabling you to:

  • Manage query response time and throughput
  • Limit the impact of large or complex queries on the system
  • Share cached query results
  • Report on warehouse usage
  • Eliminate the runaway query syndrome
  • Improve end-user satisfaction by allocating warehouse resources according to defined service levels

Query Patroller improves data warehouse scalability so that hundreds of users can safely submit queries, even on databases that contain several terabytes of data. Query Patroller allows an administrator to automatically manage and control all aspects of query submission, acting as agents on behalf of the end user. It prioritizes and schedules queries so that query completion is more predictable and computing resources are efficiently used. Administrators can establish user groups with varying resource limits so that high priority users will be assured of reasonable system response times, even when the overall system load experiences radical spikes in demand. Additionally, Query Patroller can be set to passively monitor the database query environment so that administrators can graph and analyze database and user community characteristics.

Query Patroller uses the DB2 Optimizer to predict query costs, then schedules or dispatches the query to an appropriate queue for balanced workload. It provides an easy-to-use graphical interface similar to the DB2 Control Center, and integrates DB2 query-governing functionality. Query Patroller is completely server-based with no client software required. This allows it to provide global span-of-control, seeing all queries regardless of client application.

Database and system administrators implementing data warehouses, data marts, or any database where query response time is an issue will find the functionality provided by DB2 Query Patroller indispensable.

Find out more about DB2 Query Patroller here

Tightly integrated ETL

DB2 Warehouse Manager Standard Edition, V8.2 provides an integrated and flexible tool for designing, populating, and managing data warehouses. DB2 Warehouse Manager Standard Edition ETL tool allows you to define transformations with the SQL-based stored procedure language of DB2, and leverages DB2 itself as the underlying transformation engine. DB2 Warehouse Manager Standard Edition has a flexible architecture that allows remote agents to perform the transformation function on the optimal platform: source, target, or dedicated hub.

DB2 Warehouse Manager Standard Edition is included with Data Warehouse Enterprise Edition. Also included is Information Integrator Standard Edition (solely for use with Warehouse Manager ETL), which provides native connections to Oracle, Teradata, Microsoft™ SQL Server and Sybase databases.

Get the full story about DB2 Warehouse Manager Standard Edition here

DB2 Office Connect securely connects your data warehouse to Microsoft Excel spreadsheets as a light query and reporting tool for BI. With the granular security offered by DB2 Office Connect controls, business users see only the data you want them to see.

DB2 Office Connect also lets you:

  • Create on demand reports that change data in the data warehouse
  • Perform ad hoc, assisted query of the warehouse
  • Share your analysis across your organization by enabling Microsoft Excel users to write back their analysis results to the data warehouse
  • Easily drag-and-drop database contents into spreadsheets
  • Retrieve and update database content
  • Bind spreadsheet cells to database fields
  • Generate Select, Update, Insert, and Delete SQL statements

DB2 Office Connect Enterprise Web Edition V4.0 is included with DB2 UDB Data Warehouse Enterprise Edition. DB2 Office Connect Professional Web Edition V4.0 is included with DB2 UDB Data Warehouse Standard Edition.

Read all about DB2 Office Connect here

DB2 UDB Data Warehouse Enterprise Edition, V8.2 includes:

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

DB2 UDB Data Warehouse Standard Edition, V8.2 includes:

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

DB2 UDB Data Warehouse Base Edition, V8.2 includes:

  • DB2 UDB Enterprise Server Edition, V8.2
  • DB2 Cube Views, V8.2

Find out more about DB2 UDB Data Warehouse Edition here

Section 508 of the U.S. Rehabilitation Act

When used in accordance with IBM's associated documentation, DB2 UDB Data Warehouse Editions, DB2 Cube Views, and DB2 Office Connect are capable, as of December 10, 2004, 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 topBack to top
 

Product positioning

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

DB2 UDB Data Warehouse Base Edition provides mid- to large-scale enterprises with a data warehouse and data mart infrastructure that includes DB2 and integrated OLAP capability that can support departmental warehouses or lines of business, or enterprise data warehouses where there is a need for scalability and performance.

DB2 UDB Data Warehouse Standard Edition provides mid-market enterprises with 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.
 
Back topBack to top
 

Statement of direction

In future releases of DB2 UDB Data Warehouse Edition (DWE), DB2 Alphablox technology will be integrated into the DB2 UDB Data Warehouse Edition platform for Business Intelligence. DB2 Alphablox is currently available only as a standalone product, announced in Software Announcement 204-172 , dated July 16, 2004. In the future, it will be available as a standalone product, as well as part of DWE.

DWE Standard Edition and Enterprise Edition pricing and packaging will be updated at the time that DB2 Alphablox functionality is incorporated.

Alphablox empowers you to leverage analytics as part of your existing business processes. Its integrated platform of components delivers rapid incorporation of sophisticated analytics that can leverage your new and existing data infrastructure, whether that is relational, multidimensional, or both.

DB2 Alphablox technology will add new capabilities to the IBM business intelligence platform, a key foundation for our on demand capabilities. It will:

  • Add a set of components, based on open standards, that allows you to implement the vision of integrated analytics
  • Enable you to broaden and deepen business performance management capabilities across organizations
  • Provide dynamic insight into your business environment
  • Allow you to quickly take advantage of new opportunities and overcome challenges, while you still have the opportunity to make significant adjustments

All statements regarding IBM's plans, directions, and intent are subject to change or withdrawal without notice.
 
Back topBack to top
 

Reference information

Refer to Software Announcement 203-278 , dated October 14, 2003.

Trademarks

 
iSeries, e-business on demand, and Intelligent Miner, are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
The e-business logo, DB2 Universal Database, DB2, zSeries, AIX, and AlphaWorks are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows and Microsoft are trademarks of Microsoft Corporation.
 
Linux is a trademark of Linus Torvalds in the United States, other countries or both
 
Other company, product, and service names may be trademarks or service marks of others.

 
Back topBack to top
 
Education support

The following educational offerings are available as listed below:

Course title            Course number          Course type
 
Implementing Cube       DW650                  Classroom
 Views in Your Data
 Warehouse
DB2(R) UDB Data         DW350                  Classroom
 Warehouse Edition
 Components
DB2 UDB Data            DW350                  Classroom
 Warehouse Edition
 Components

IBM Global Services, IT Education Services, provides education to support many IBM offerings. Descriptions of courses for IT professionals and managers are on the IBM IT Education Services Web site

Refer to the IBM IT Education Services Web site for information on course locations and availability dates.

Call IBM IT Education Services at 800-IBM-TEACH (426-8322) for catalogs, schedules, and enrollments.
 
Back topBack to top
 

Offering information

Product information is available via the Offering Information Web site

Also, visit the Passport Advantage® Web site


 
Back topBack to top
 
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 (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)

PNS enables subscribers to set up profiles of interest by order number/product number. PNS subscribers automatically receive e-mail notifications of all new publications defined in their profiles. These may then be ordered/downloaded from the Publications Center.

The PNS site is available in English and Canadian French.

The following translated publications will be available:

Publication title        Language            Form number
 
IBM DB2 Universal        English             GC18-7459-01
 Database Data
 Warehouse Edition
 Getting Started
IBM DB2 Universal        English             SC27-1124-01
 Database Data
 Warehouse Center
 Application
 Integration Guide
IBM DB2 Query            English             GC09-7658-01
 Patroller Guide:
 Installation,
 Administration and
 Usage
IBM DB2 Warehouse        English             SC27-1125-01
 Manager Information
 Catalog Center
 Administration Guide
IBM DB2 Universal        English             SC27-1123-01
 Database Data
 Warehouse Center
 Administration Guide
IBM DB2 Warehouse        English             GC27-1122-01
 Manager Installation
 Guide
IBM DB2 Installing       English             SH12-6802-00
 the Intelligent Miner(TM)
 Products

 
Back topBack to top
 
Technical information

Specified operating environment

Hardware requirements

  • For DB2 products running on 32-bit Intel™ systems, a Pentium™ central processing unit (CPU), or higher is required.
  • For 32-bit AMD systems, an Athlon CPU is required.
  • For DB2 products running on Solaris, CPUs prior to UltraSparc are not supported.
  • For DB2 products on all other systems, the CPU requirements are determined by the operating system being used. Refer to the information for operating systems support.

Memory requirements: The following table shows applicable recommended minimum memory requirements for installation prerequisites in megabytes (MB). The actual requirement depends on the applications you intend 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(TM)  HP-UX IPF
 
DB2 Cube      (1)       (1)        (1)         (1)        256
 Views
Warehouse     512       512        512         NA         NA
 Manager
 Standard
 Edition(2)
Warehouse     256       256        256         NA         NA
 Manager
 Standard
 Edition(3)
Intelligent   256       256        256         256        NA
 Miner
 Modeling
Intelligent   256       256        256         256        NA
 Miner
 Scoring
Intelligent   256       256        256         256        NA
 Miner
 Visualiza
Data          1,536     1,536      1,536       768        NA
 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 your file system and the components installed. The numbers below are for reference only.

              Solaris   AIX        Windows     Linux      HP-UX IPF
 
DB2 Cube      (1)       (1)        (1)         (1)        30
 Views
Office        NA        NA         200         NA         NA
 Connect
Warehouse     1,000     1,000      1,000       1,000      NA
 Manager
 Standard
 Edition
Intelligent   65        60         90          45         140
 Miner
 Modeling
Intelligent   60        60         40          60         110
 Miner
 Scoring
Intelligent   110       10         50          10         95
 Miner
 Visualiza
Data          1235      1,130      1,380       1,115      NA
 Warehouse
 Editions

1
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

The operating system support level for various DB2 and DWE products is frequently updated. To obtain the current information for supported software levels, including recommended maintenance levels, refer to

JRE 1.4.1 is required for developing and running applications and tools in all platforms. Minimal requirements for operating systems at the time of announcement are:

Operating           Minimum
Systems             prerequisites                  CPU
 
Windows Client
 Platforms
2000                SP(TM) 4           32          x86
 Professional
 Edition
XP Professional     SP 1               32          x86
 Edition
Windows Server
 Platforms
2000 Standard,      SP 4               32          x86
 Advanced,
 Datacenter
 Editions
2003 Standard,                         32          x86
 Enterprise,
 Datacenter
 Editions
AIX
 5.1                ML 6               32, 64      POWER(TM)
 5.2                ML 3               32, 64      POWER
Sun
 Solaris 8          Recommended        32          SPARC
                    and Security
                    Patches
                    from:
                    Refer to (1), (2)
Solaris 9                              32          SPARC
Linux (Intel)
Red Hat             Update 2           32          x86
 Enterprise
 Linux (RHEL) 3
 AS/ES/WS
SUSE LINUX          SP3                32          x86
 Enterprise
 Server (SLES) 8
HP-UX 11i V1.6      B.11.22            32          CPU
 (Only                                              architecture is
 applicable to                                      Explicitly
 Office Connect)                                    Parallel
                                                    Instruction
                                                    Computing
                                                    (EPIC)
1
http://sunsolve.sun.com
2
Patches: 108921-12, 108940-24, 108434-03, 108528-12

The validation status for new Linux kernels and distributions is frequently updated. To obtain the current information for supported Linux software levels, refer to

For more information, refer to the installation prerequisites in the documentation accompanying each product.

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 IBM DB2 server, you need the following:

  • IBM DB2 JDBC driver JDK V1.3, or later
  • IBM 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:
    • IBM 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 Warehouse Manager Standard Edition

The Warehouse Manager (ETL) product included with DWE has certain components which do not support the full set of platforms listed for DWE overall. These are listed in the table that follows:

Warehouse Manager (ETL) product and component acronyms:

  • 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 Software Subscription and Technical Support, is included in the Passport Advantage Agreement. Installation and technical support is provided by the Software Maintenance offering of the IBM International Passport Advantage Agreement. This fee service enhances customer productivity, with voice and electronic access into IBM support organizations.

Packaging

DB2 UDB Data Warehouse Enterprise Edition Media

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

DB2 UDB Data Warehouse Standard Edition Media

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

DB2 UDB Data Warehouse Base Edition Media

  • DB2 UDB Enterprise Server Edition, V8.2
  • DB2 Cube Views, V8.2

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.

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


 
Back topBack to top
 

Ordering information

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

Product information

Licensed function
title                   Product group             Product category
 
IBM Office Connect      Informix(TM) Application  DB2 Office Connect
 Prof Web Edition        Dvpmt Tools
IBM Office Connect      Informix Application      DB2 Office Connect
 Ent Web Edition         Dvpmt Tools
IBM DB2 Cube Views      IBM Database 2(TM)        DB2 Tools
DB2 UDB Data            IBM Database 2            DB2
 Warehouse Enterprise
 Edition
DB2 Data Warehouse      IBM Database 2            DB2 Universal
 Base Edition                                      Database
DB2 UDB Data            IBM Database 2            DB2
 Warehouse Standard
 Edition

Product                                 Metrics
 
DB2 UDB Data Warehouse                  Processor
 Enterprise Edition
DB2 UDB Data Warehouse Standard         Processor
 Edition
DB2 UDB Data Warehouse Base             Processor
 Edition
DB2 Query Patroller                     Processor
DB2 Warehouse Manager Standard          Processor
 Edition
DB2 Cube Views                          Processor
DB2 Office Connect Enterprise           Processor
 Web Edition
DB2 Office Connect Professional         Registered User
 Web Edition
DB2 Intelligent Miner Scoring           Processor
DB2 Intelligent Miner Modeling          Install
DB2 Intelligent Miner                   Install
 Visualization
DB2 UDB Workgroup Server                Processor
 Unlimited Edition
DB2 UDB Enterprise Server               Processor
 Edition
DB2 Information Integrator              Processor
 Standard 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.

Install

Each installation of the program must have a separate entitlement. Refer to the Usage restriction section for details.

Passport Advantage program licenses

DB2 Cube Views
 
Part description                        Part number
 
IBM DB2 Cube Views
DB2 Cube Views PA Per Proc SW           D525KLL
 Maint Reinstatem
DB2 Cube Views PA Per Proc              E00NLLL
 Annual SW Maint Renewal
DB2 Cube Views PA Per Proc              D525ILL
 License & SW Maint
 
DB2 Office Connect
 
IBM Office Connect Prof Web
 Edition
DB2 Office Connect Registered           D52AFLL
 User PA Per Use, License & SW
 Maint, 12 month
DB2 Office Connect Registered           E00Q9LL
 User PA Per Use, Annual SW Maint
 Renewal.
DB2 Office Connect Registered           D52AGLL
 User PA Per Use, SW Maint
 Reinstatement, 12 m
 
DB2 Office Connect
 
IBM Office Connect Ent Web
 Edition
DB2 Office Connect WE Proc              E2DC4LL
 Annual SW Maint Renewal.
DB2 Office Connect WE Proc SW           D6DC5LL
 Maint Reinstatement, 12 Mo
DB2 Office Connect WE Proc              D6DC2LL
 License & SW Maint, 12 Mo
 
DB2 UDB DW Enterprise Edition
 
DB2 Data Warehouse Base Edition
DB2 UDB DW Base Ed Per Processor        D54RDLL
 SW Maint Reinstatement 12 Mo
DB2 UDB DW Base Ed Per Processor        E01NJLL
 SW Maint Annual Renewal
DB2 UDB DW Base Ed Per Processor        D54RCLL
 License & SW Maintenance 12
 Months
 
DB2 UDB DW Enterprise Edition
 
DB2 UDB Data Warehouse
 
 Enterprise Edition
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 & Maint 12 mo
DB2 UDB DW Ent Ed Proc Annual SW        E00PVLL
 Maint Renewal
DB2 UDB DW Ent Ed Proc License &        D5298LL
 SW Maint, 12 mo
 
DB2 UDB DW Standard Edition
 
DB2 UDB Data Warehouse Standard
 Edition
DB2 UDB DW Std Ed Proc Annual SW        E00PNLL
 Maint Renewal., PA
DB2 UDB DW Std Ed Proc License &        D5290LL
 SW Maint, 12 mo
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

For ordering information on DB2 Query Patroller, DB2 Warehouse Manager Standard Edition, DB2 Intelligent Miner Modeling, DB2 Intelligent Miner Scoring and DB2 Intelligent Miner Visualization, refer to Software Announcement 204-185 , dated August 17, 2004.

Passport Advantage supply

Program name/description                Part number
 
DB2 Cube Views V8.2.0
Media Pack Multilingual (French,        BB0JRML
 Danish, Russian, Korean, Chinese
 -- Simplified, Spanish, Norwegian
 Bokmal, Brazilian Portuguese,
 German, Swedish, Japanese,
 Chinese -- Traditional, English
 US, Czech, Italian, Finnish,
 Polish) Windows 2000, AIX V4.x,
 Windows XP, Solaris (Sun
 Microsystems), Windows Server
 2003, Windows NT(TM), AIX V5.x,
 HP-UX 11.x, Linux for x86 Series
 Intel-based servers CD-ROM
 Digital Disk -- ISO 9660 Standard
 V8.2.0
DB2 Office Connect V4.0.0
Media Pack Multilingual (French,        BB0H8ML
 Danish, Russian, Korean, Chinese
 -- Simplified, Spanish, Norwegian
 Bokmal, Brazilian Portuguese,
 German, Swedish, Japanese,
 Chinese -- Traditional, English
 US, Italian, Finnish, Polish)
 Windows 2000, Windows XP,
 Windows 98, Windows NT CD-ROM
 Digital Disk -- ISO 9660 Standard
 V4.0.0
 
Program name/description                Part number
 
DB2 UDB DW Base Ed V8.2.0
Media Pack Multilingual (French,        BB0MYML
 Spanish, Brazilian Portuguese,
 German, English US, 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.2.0
DB2 UDB DW Ent Ed V8.2.0
Media Pack Multilingual (French,        BB0K1ML
 Spanish, Brazilian Portuguese,
 German, English US, 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.2.0
DB2 UDB DW Std Ed V8.2.0
Media Pack Multilingual (French,        BB0K0ML
 Spanish, Brazilian Portuguese,
 German, English US, 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.2.0

For ordering information on DB2 Query Patroller, DB2 Warehouse Manager Standard Edition, DB2 Intelligent Miner Modeling, DB2 Intelligent Miner Scoring, and DB2 Intelligent Miner Visualization, refer to Software Announcement 204-185 , dated August 17, 2004.

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.

For ordering information on DB2 Query Patroller, DB2 Warehouse Manager Standard Edition, DB2 Intelligent Miner Scoring, DB2 Intelligent Miner Modeling and DB2 Intelligent Miner Visualization, refer to Software Announcement 204-185 , dated August 17, 2004.

DB2 Cube Views V8.2.0
 
Entitled maintenance       Media packs                 Part
offerings description      description                 number
 
DB2 Cube Views             DB2 Cube Views              BB0JRML
Processor                   Multilingual (French,
                            Danish, Russian,
                            Korean, Chinese --
                            Simplified, Spanish,
                            Norwegian Bokmal,
                            Brazilian Portuguese,
                            German, Swedish,
                            Japanese, Chinese --
                            Traditional, English
                            US, Czech, Italian,
                            Finnish, Polish)
                            Windows 2000, AIX
                            V4.x, Windows XP,
                            Solaris (Sun
                            Microsystems),
                            Windows Server 2003,
                            Windows NT, AIX V5.x,
                            HP-UX 11.x, Linux for
                            x86 Series Intel-based
                            servers CD-ROM
                            Digital Disk -- ISO
                            9660 Standard
 
DB2 Office Connect V4.0.0
 
Entitled maintenance       Media packs                 Part
offerings description      description                 number
 
DB2 Office Connect         DB2 Office Connect          BB0H8ML
 Professional Reg Web       Multilingual (French,
 User                       Danish, Russian,
                            Korean, Chinese --
                            Simplified, Spanish,
                            Norwegian Bokmal,
                            Brazilian Portuguese,
                            German, Swedish,
                            Japanese, Chinese --
                            Traditional, English
                            US, Italian, Finnish,
                            Polish) Windows 2000,
                            Windows XP, Windows
                            98, Windows NT CD-ROM
                            Digital Disk -- ISO
                            9660 Standard
DB2 Office Connect         DB2 Office Connect          BB0H8ML
 Web Ed Processor           Multilingual (French,
                            Danish, Russian,
                            Korean, Chinese --
                            Simplified, Spanish,
                            Norwegian Bokmal,
                            Brazilian Portuguese,
                            German, Swedish,
                            Japanese, Chinese --
                            Traditional, English
                            US, Italian, Finnish,
                            Polish) Windows 2000,
                            Windows XP, Windows
                            98, Windows NT CD-ROM
                            Digital Disk -- ISO
                            9660 Standard
 
DB2 UDB DW Base Ed V8.2.0
 
Entitled maintenance       Media packs                 Part
offerings description      description                 number
 
DB2 Data Warehouse         DB2 UDB DW Base Ed          BB0MYML
Edition Base Edition        Multilingual (French,
Processor                   Spanish, Brazilian
                            Portuguese, German,
                            English US, Italian)
                            Windows 2000, Windows
                            XP, Solaris (Sun
                            Microsystems),
                            Windows Server 2003,
                            AIX V5.x, Linux for
                            x86Series Intel-based
                            servers CD-ROM
                            Digital Disk -- ISO
                            9660 Standard
 
DB2 UDB DW Ent Ed V8.2.0
 
Entitled maintenance       Media packs                 Part
offerings description      description                 number
 
DB2 UDB Data               DB2 UDB DW Ent Ed           BB0K1ML
Warehouse Enterprise        Multilingual(French,
Edition Bundle              Spanish, Brazilian
                            Portuguese, German,
                            English US, Italian)
                            Windows 2000, Windows
                            XP, Solaris (Sun
                            Microsystems),
                            Windows Server 2003,
                            AIX V5.x, Linux for
                            x86Series Intel-based
                            servers CD-ROM
                            Digital Disk -- ISO
                            9660 Standard
 
DB2 UDB DW Std Ed V8.2.0
 
Entitled maintenance       Media packs                 Part
offerings description      description                 number
 
DB2 UDB Data               DB2 UDB DW Std Ed           BB0K0ML
Warehouse Standard          Multilingual(French,
Edition Bundle              Spanish, Brazilian
                            Portuguese, German,
                            English US, Italian)
                            Windows 2000, Windows
                            XP, Solaris (Sun
                            Microsystems),
                            Windows Server 2003,
                            AIX V5.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.

                                                        Withdrawal
                                                        from
Program       Program       Part             Part       marketing
name          number        description      number     date
 
DB2 Cube      5724-E15      DB2 Cube         BB0GPML    January 14,
 Views                       Views V8.1                  2005
 V8.1.0                      MP ML
DB2 UDB DW    5724-E34      DB2 UDB DW       BB0IJTC    January 14,
 Enterprise                  Ent Ed V                    2005
 Edition                     8.1.2 Trad
 V8.1.2                      Chinese
                             Media Pack
DB2 UDB DW    5724-E34      DB2 UDB DW       BB0IJJA    January 14,
 Enterprise                  Ent Ed                      2005
 Edition                     V8.1.2
 V8.1.2                      Japanese
                             Media Pack
DB2 UDB DW    5724-E34      DB2 UDB DW       BB0IJKO    January 14,
 Enterprise                  Ent Ed                      2005
 Edition                     V8.1.2
 V8.1.2                      Korean Media
                             Pack
DB2 UDB DW    5724-E34      DB2 UDB DW       BB0IMML    January 14,
 Enterprise                  Ent Ed                      2005
 Edition                     V8.1.2 ML
 V8.1.2                      Media Pack
DB2 UDB DW    5724-E35      DB2 UDB DW       BB0IKJA    January 14,
 Standard                    Std Ed                      2005
 Edition                     V8.1.2
 V8.1.2                      Japanese
                             Media Pack
DB2 UDB DW    5724-E35      DB2 UDB DW       BB0IKKO    January 14,
 Standard                    Std Ed                      2005
 Edition                     V8.1.2
 V8.1.2                      Korean Media
                             Pack
DB2 UDB DW    5724-E35      DB2 UDB DW       BB0INML    January 14,
 Standard                    Std Ed                      2005
 Edition                     V8.1.2 ML
 V8.1.2                      Media Pack
DB2 UDB DW    5724-E35      DB2 UDB DW       BB0IKTC    January 14,
 Standard                    Std Ed                      2005
 Edition                     V8.1.2 Trad
 V8.1.2                      Chinese
                             Media Pack
 
                                                        Withdrawal
                                                        from
Program       Program       Part             Part       marketing
name          number        description      number     date
 
DB2 Cube      5724-E15      IBM DB2 Cube     ASQ35LL    January 14,
 Views                       Views                       2005
                             Processor
                             Day OOCoD
                             Temp Use
                             Chrg
DB2 UDB       5724-J20      DB2 HADR Per     D53ZDLL    January 14,
 High Avail.                 Processor                   2005
 Disaster                    Per Use-DAY,
 Recovery                    On Off
 V8.2.0                      Capacity on
                             demand
                             Temporary Us
DB2           5724-F36      DB2 IMSC Per     ASPM1LL    January 14,
 Intelligent                 Processor                   2005
 Miner                       Per Use-DAY,
 Scoring                     On Off
                             Capacity on
                             demand
                             Temporary Us
DB2           5724-B93      DB2 IMFD Per     ASPL8LL    January 14,
 Intelligent                 Processor                   2005
 Miner for                   Per Use-DAY,
 Data                        On Off
                             Capacity on
                             demand
                             Temporary Us

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

DB2 UDB Data Warehouse Enterprise Edition
 
                                               Part
                        Part description       number
 
IBM DB2 Data            PROC DAY OOCoD TEMP    D53ZLLL
Warehouse Enterprise    USE CHRG
Ed
 
DB2 UDB Data Warehouse Standard Edition
 
                                               Part
                        Part description       number
 
IBM DB2 Data            Proc Day OOCoD Temp    D53ZKLL
Warehouse Standard      Use Chrg
Edition


 
Back topBack 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 (PoE) are required for all authorized use.

Part number products only, offered outside of Passport Advantage, where applicable, are license only and do not include Software Maintenance.

This software license includes Software Maintenance, previously referred to as Software Subscription and Technical Support.

License information form numbers

                            Program
Program name                number      Form number
 
DB2 Office Connect          5724-E37    L-AWAD-5GQSLR
DB2 Cube Views              5724-E15    L-JGIN-5WM2J3
DB2 UDB DW Enterprise       5724-E34    L-VACA-5T7KR5
 Edition
DB2 UDB DW Standard         5724-E35    L-VACA-5T7KR5
 Edition

Limited warranty applies: Yes

Warranty: This program has warranty for a minimum of one year from acquisition from IBM or authorized IBM Business Partner. The warranty provided to the customer, for at least one year from acquisition, is access to databases (read Web sites) for program information and FAQs, including any known fixes to defects, which the customer can download or obtain otherwise and install at leisure.

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 IBM 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
                                        home/portable
Product name                            computer?
 
DB2 Office Connect                      No
DB2 Cube Views                          Yes
DB2 UDB DW Enterprise Edition           Yes
DB2 UDB DW Standard Edition             Yes

Volume orders (IVO): No

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

Usage restriction: Yes

The IBM DB2 Universal Database Data Warehouse Standard Edition, V8.2 and the IBM DB2 Universal Database Data Warehouse Enterprise Edition, V8.2 (DWE 8.2) each consist of a number of packaged components. The program unique terms of this DWE 8.2 license supersede and replace the terms of the program unique terms for each of the individual components comprising the program.

IBM DB2 UDB Data Warehouse Standard Edition, V8.2 includes the following components:

  • IBM DB2 UDB Workgroup Server Unlimited Edition, V8.2
  • IBM DB2 Cube Views, V8.2
  • IBM DB2 Intelligent Miner Scoring, V8.2
  • IBM DB2 Intelligent Miner Modeling, V8.2
  • IBM DB2 Intelligent Miner Visualization, V8.2
  • IBM DB2 Office Connect Professional Web Edition, V4.00.TC2

The following program unique terms apply to IBM DB2 Universal Database Data Warehouse Standard Edition, V8.2:

The use-based charges described in this LI 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 processors that are attached or available to the DB2 Universal Database (UDB) Server to which it is licensed. The total number of processors attached or available may not exceed the number authorized by the applicable Proofs of Entitlement or authorized by each product authorization acquired under Passport Advantage. If the total number exceeds the quantity in your Proofs of Entitlement 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 Proof of Entitlement 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:

  • Use of this program is restricted to servers with up to four (4) processors per server
  • High Availability Disaster Recovery is not available on DB2 Universal Database Workgroup Server Unlimited Edition
  • Maximum memory per server is 32G

Use with DB2 UDB Workgroup Server Unlimited Edition

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

IBM DB2 Cube Views

The program includes DB2 Cube Views, V8.2. You are authorized to install and use one copy of the DB2 Cube Views components. You are authorized to install and use these components only with and on the same server as DB2 UDB Data Warehouse Edition.

IBM DB2 Intelligent Miner Modeling

The program includes DB2 Intelligent Miner Modeling, V8.2. You are authorized to install and use one copy of the DB2 Intelligent Miner Modeling components. You are authorized to install and use these components only with and on the same server as DB2 UDB Data Warehouse Edition.

IBM DB2 Intelligent Miner Scoring

The program includes DB2 Intelligent Miner Scoring, V8.2. You are authorized to install and use one copy of the DB2 Intelligent Miner Scoring components. You are authorized to install and use these components only with and on the same server as DB2 UDB Data Warehouse Edition.

IBM DB2 Intelligent Miner Visualization

The program includes DB2 Intelligent Miner Visualization, V8.2. You are authorized to install and use one copy of the DB2 Intelligent Miner Visualization components. You are authorized to install and use these components only on a client system connected to the same server as DB2 UDB Data Warehouse Edition.

IBM DB2 Office Connect Professional Web Edition

The program includes DB2 Office Connect Professional Web Edition, V4.00.TC2. You are authorized to install and use one copy of the DB2 Office Connect components. You are authorized to install and use these components only on a Windows client system connected to the same server as DB2 UDB Data Warehouse Edition.

High availability/Failover licensing

After the server is licensed, it can be used to service user workload. In high availability scenarios this server is called a Primary server; Additional servers acting as backups are called Standby servers that may be deployed in Active or Idle configurations.

In Active Standby or Idle Standby, you must acquire correct number of processors entitlements in addition to the processor entitlements you obtained for the primary server.

In an Active Standby configuration, the program is operational on all servers to service user transactions or queries. Because each of the Active Standby servers is used to operate the program for user transactions or queries before or after a failure, the program must be fully licensed. In Active Standby, you must license the program for the number of processors attached or available to the active standby servers. For example, consider an environment with three servers, one primary server with four processors and the other two are Active Standby servers with two processors each. This environment must be licensed for eight processors (four for primary and two + two for Active Standby).

In an Idle Standby configuration, Idle Standby servers have the program installed, however, they do not have the program operational to service user transactions or query workloads. A server is considered "idle" if it is used exclusively for administrative actions that assist in failover scenarios such as having a database in rollforward pending state to support log shipping, or in making a flash copy of a DB2 database and then performing a database backup of this copy on another server. In Idle Standby, you must license the program for one processor per idle server only, regardless of the number of processors attached or available to the server. For example, consider an environment with three servers, one primary server with four processors and the other two are idle standby servers with two processors each. This environment must be licensed for six processors (four for primary and one + one for idle standby).

Program components

The program contains components which are provided to support your authorized use of the program on server machines within your enterprise. If you want to perform multiple installations and/or distribution of these components you must contact IBM or its reseller to obtain the appropriate licenses. The following are the exceptions:

  • DB2 clients. Multiple DB2 clients are provided with this program. You may make copies of these clients and documentation in support of your authorized use of the program within your enterprise.

IBM DB2 UDB Data Warehouse Enterprise Edition, V8.2 includes the following components:

  • IBM DB2 UDB Enterprise Server Edition, V8.2
  • DB2 UDB Data Partitioning Feature, V8.2
  • IBM DB2 Cube Views, V8.2
  • IBM DB2 Intelligent Miner Scoring, V8.2
  • IBM DB2 Intelligent Miner Modeling, V8.2
  • IBM DB2 Intelligent Miner Visualization, V8.2
  • IBM DB2 Query Patroller, V8.2
  • IBM DB2 Warehouse Manager Standard Edition, V8.2
  • IBM DB2 Office Connect Enterprise Web Edition, Version 4.00.TC2
  • IBM DB2 Information Integrator Standard Edition, V8.2

The following program unique terms apply to IBM DB2 Universal Database Data Warehouse Enterprise Edition, V8.2:

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

Usage restriction — Use as program bundle only

The following program unique terms apply to IBM DB2 Universal Database Data Warehouse Enterprise Edition, V8.2: 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

The following program unique terms apply to IBM DB2 Universal Database Data Warehouse Enterprise Edition, V8.2: Charges for this program are based on the processors that are attached or available to the DB2 Server or Servers on which it is licensed. The total number of processors attached or available may not exceed the number authorized by the applicable Proof(s) of Entitlement or authorized by each product authorization acquired under Passport Advantage. If the total number exceeds the quantity in your Proof(s) of Entitlement 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

The following restrictions or exceptions apply to the use of IBM DB2 Universal Database Data Warehouse Enterprise Edition V8.2.

Usage restriction — Database Partitioning Feature

The following program unique terms apply to IBM DB2 Universal Database Data Warehouse Enterprise Edition, V8.2. You are only authorized to use the database partitioning feature of the DB2 Universal Database Enterprise Server Edition (ESE) to create multiple database partitions on a single server or across multiple servers, only if you have acquired the applicable number of entitlements for the DB2 UDB ESE separately chargeable database partitioning feature.

The Database Partitioning Feature may also be used without charge with the development use copy of ESE that is available in the DB2 Universal Developer's Edition for the purposes of evaluating, demonstrating, testing, and developing application programs.

Usage restriction — Geodetic Extender Feature

You are authorized to use the Geodetic Extender Feature of the DB2 Universal Database Enterprise Server Edition (ESE) only if you have acquired the applicable number of entitlements for the DB2 Geodetic Extender Feature.

The Geodetic Feature may also be used without charge with the development use copy of ESE that is available in the DB2 Universal Developer's Edition for the purposes of evaluating, demonstrating, testing, and developing application programs.

IBM DB2 Cube Views

The program includes DB2 Cube Views, V8.2. You are authorized to install and use one copy of the DB2 Cube Views components. You are authorized to install and use these components only with and on the same server as DB2 UDB Data Warehouse Edition.

IBM DB2 Intelligent Miner Modeling

The program includes DB2 Intelligent Miner Modeling, V8.2. You are authorized to install and use one copy of the DB2 Intelligent Miner Modeling components. You are authorized to install and use these components only with and on the same server as DB2 UDB Data Warehouse Edition.

IBM DB2 Intelligent Miner Scoring

The program includes DB2 Intelligent Miner Scoring, V8.2. You are authorized to install and use one copy of the DB2 Intelligent Miner Scoring components. You are authorized to install and use these components only with and on the same server as DB2 UDB Data Warehouse Edition.

IBM DB2 Intelligent Miner Visualization

The program includes DB2 Intelligent Miner Visualization, V8.2. You are authorized to install and use one copy of the DB2 Intelligent Miner Visualization components. You are authorized to install and use these components only on a client system connected to the same server as DB2 UDB Data Warehouse Edition.

IBM DB2 Query Patroller

The program includes DB2 Query Patroller, V8.2. You are authorized to install and use one copy of the DB2 Query Patroller components. You are authorized to install and use these components only with and on the same server as DB2 UDB Data Warehouse Edition.

IBM DB2 Warehouse Manager Standard Edition

The program includes DB2 Warehouse Manager Standard Edition, V8.2. You are authorized to install and use one copy of the DB2 Warehouse Manager Standard Edition components. You are authorized to install and use these components only with and on the same server as DB2 UDB Data Warehouse Edition, or else on a separate server that is a dedicated Extract, Load and Transform (ETL) Warehouse Server with the restrictions described below for Warehouse Server.

IBM DB2 Office Connect Enterprise Web Edition

The program includes DB2 Office Connect Enterprise Web Edition, V4.00.TC2. You are authorized to install and use one copy of the DB2 Office Connect components. You are authorized to install and use these components only on a Windows client system connected to the same server as DB2 UDB Data Warehouse Edition.

IBM DB2 Information Integrator Standard Edition — Limited use only

The copy of IBM DB2 Information Integrator Standard Edition, that is provided with the program, may only be used in conjunction with IBM DB2 Warehouse Manager Standard Edition, V8.2 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 Proof of Entitlement includes four DB2 Information Integrator Connector Proofs of Entitlement. If additional connections are required, additional DB2 Information Integrator Connector program entitlements must be acquired.

High availability/Failover licensing

After the server is licensed, it can be used to service user workload. In high availability scenarios this server is called a Primary server; Additional servers acting as backups are called Standby servers that may be deployed in Active or Idle configurations.

In Active Standby or Idle Standby, you must acquire correct number of processors entitlements in addition to the processor entitlements you obtained for the primary server.

In an Active Standby configuration, the program is operational on all servers to service user transactions or queries. Because each of the Active Standby servers is used to operate the program for user transactions or queries before or after a failure, the program must be fully licensed. In Active Standby, you must license the program for the number of processors attached or available to the Active Standby servers. For example, consider an environment with three servers, one primary server with four processors and the other two are active standby servers with two processors each. This environment must be licensed for eight processors (four for primary and two + two for Active Standby).

In an Idle Standby configuration, Idle Standby servers have the program installed, however, they do not have the program operational to service user transactions or query workloads. A server is considered idle if it is used exclusively for administrative actions that assist in failover scenarios such as having a database in rollforward pending state to support log shipping, or in making a flash copy of a DB2 database and then performing a database backup of this copy on another server. In Idle Standby, you must license the program for one processor per idle server only, regardless of the number of processors attached or available to the server. For example, consider an environment with three servers, one primary server with four processors and the other two are idle standby servers with two processors each. This environment must be licensed for six processors (four for primary and one + one for Idle Standby).

DB2 UDB program components

The program contains components which are provided to support your authorized use of the program on server machines within your Enterprise. If you want to perform multiple installations and/or distribution of these components you must contact IBM or its reseller to obtain the appropriate licenses.

The following are the exceptions for ESE only:

  • A separately chargeable database partitioning feature of DB2 UDB ESE provides the ability to create multiple database partitions on a single server or across multiple servers, while preserving a single database image of the data. An entitlement to this feature, licensed on per processor basis for every processor in the single database image across a single or multiple server configuration, must be acquired separately before operating the feature.
  • Entitlement to a separately chargeable geodetic feature of DB2 UDB ESE, licensed on per processor basis for every processor, must be acquired separately before installing or operating the feature.
  • Use of the DB2 Connect® component is limited to five registered users per server. This product contains DB2 Connect component to provide connectivity, DB2 for z/OS® for OS/390®, DB2 Server for VSE and VM and DB2 for iSeries™ database servers. If additional users need to connect to any of the above mentioned database servers, a separate DB2 Connect program must be acquired.

IBM program components for IBM DB2 Universal Database Data Warehouse Standard Edition, V8.2 and IBM DB2 Universal Database Data Warehouse Enterprise Edition V8.2

The program contains components which are provided to support your authorized use of the program on server machines within your enterprise. If you want to perform multiple installations and/or distribution of these components you must contact IBM or its reseller to obtain the appropriate licenses. The following are the exceptions:

  • DB2 clients. Multiple DB2 clients are provided with this program. You may make copies of these clients and documentation in support of your authorized use of the program within your enterprise.

The Warehouse Server component of DB2 Universal Database supports the operation of the Data Warehouse Center. If the Warehouse Server is installed on a server that is different from your intended database server, then a restricted license is installed on the same server as the warehouse server. You are entitled to use this restricted license DB2 server to manage one or more of the following types of data:

  • Warehouse control database
  • Scheduler and/or information catalog metadata in a DB2 tools catalog
  • Sample databases that are created by DB2 V8.2 products or components

Any other use requires a full unrestricted license.

The program includes the mobility on demand component. Your use of the mobility on demand component is limited to use in support of your licensed use of the program. The sync server component of mobility on demand must co-exist on the same server as the licensed DB2 UDB program. The mobility on demand component may not be used for any other purpose.

The program is accompanied by an embedded version of IBM WebSphere Application Server — Express (embedded Application Server — Express). Your use of the embedded Application Server — Express components is limited to use in support of your licensed use of the program. The embedded Application Server — Express components may not be used for any other purpose.

Software Maintenance applies: Yes

Software Maintenance, previously referred to as Software Subscription and Technical Support, is included in the Passport Advantage Agreement. Installation and technical support is provided by the Software Maintenance offering of the IBM International Passport Advantage Agreement. This fee service enhances customer productivity, with voice and electronic access into 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

iSeries Software Subscription applies: No

Educational allowance available: Not applicable.

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 for iSeries and pSeries® Temporary Capacity On Demand — Software — must be signed prior to use.
 
Back topBack 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 topBack to top
 
Prices

Passport Advantage

For Passport Advantage information and charges, contact your IBM representative or authorized IBM Business Partner. Additional information is also available at


 
Back topBack to top
 
Order now
To order, contact the Americas Call Centers, your local IBM representative, or your IBM Business Partner.

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

 Phone:     800-IBM-CALL (426-2255)
 Fax:       800-2IBM-FAX (242-6329)
 Internet:  ibm_direct@vnet.ibm.com
 Mail:      IBM Americas Call Centers
            Dept:  IBM CALL, 11th Floor
            105 Moatfield Drive
            North York, Ontario
            Canada M3B 3R1
 
 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, SP, POWER, Informix, Database 2, iSeries, and Electronic Service Agent are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, Passport Advantage, AIX, DB2 Universal Database, Notes, WebSphere, DB2 Connect, OS/390, z/OS, pSeries, and eServer are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Intel and Pentium are trademarks of Intel Corporation.
 
Windows, Microsoft, and Windows NT are trademarks of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
Linux is a trademark of Linus Torvalds in the United States, other countries or both
 
Other company, product, and service names may be trademarks or service marks of others.

Back to topBack to top
 

 
Printable version Printable version