Eliminating the barriers with IBM DB2 Warehouse V9.5

IBM United States Software Announcement 207-257
October 16, 2007

 

 ENUS207257.PDF (83KB)

 

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 Planned availability dates TOC link Software Services
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 Availability of national languages TOC link Order now
TOC link Education support  
 
Printable version Printable version

 
At a glance

IBM DB2 Warehouse V9.5 is an integrated package of components and capabilities that provides a data repository and the tools needed to help create a data warehouse.

V9.5 includes three key new data warehouse capabilities; Cubing Services, Workload Management, and Unstructured Text Analysis. In addition, several products have been extensively enhanced including DB2, Alphablox, and SQL Warehouse Tool. The focus of this release is to:

  • Add a DB2 based multidimensional, data analysis capability with a wide assortment of tools and applications
  • Provide robust workload management enabling better control over an operational data warehouse
  • Give the IT staff the ability to manage workload based on service levels
  • Provide analysis capability for unstructured text data
  • Improve data load and execution with parallel control flow capability
  • Simplify warehouse management through the integration of its tooling framework
  • Expand the usage and desirability of Alphablox by making it easier to build applications
  • Extend the ability to easily capture data from remote sources

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

IBM DB2® Warehouse V9.5, formally known as IBM DB2 Data Warehouse Edition, offers an integrated data warehouse solution by providing new functions to enable organizations to build robust decision systems that grow with their organizational needs. Today's leading-edge decision systems need the scalability and speed of a massively parallel system coupled with the reliability and availability of a high volume transaction system.

The combination of mission-critical operational applications and strategic reporting and analysis is driving increasingly mixed workload environments. This is being driven by requests that are more numerous and sophisticated, with rising data volumes, growing number of users, and expanding types of users: employees, customers, and suppliers. DB2 Warehouse was designed to address these issues.

DB2 Warehouse V9.5 continues to be available in the six previous editions: Starter, Intermediate, Advanced, Base, Enterprise, and Developer's Edition.

DB2 Warehouse V9.5 is focused on three critical areas:

Simplicity

  • Simplify warehouse management through the integration of its tooling framework
  • Expand the usage and desirability of Alphablox by making it easier to build applications
  • Extend the ability to easily capture data from remote sources

Reliability and performance

  • Provide robust workload management enabling better control over an operational data warehouse
  • Give the IT staff the ability to manage based on service levels

Extended insight

  • Add a DB2-based multidimensional, data analysis capability with a wide assortment of tools and applications
  • Provide analysis capability for unstructured text data

DB2 Warehouse V9.5 includes three key new data warehouse capabilities: Cubing Services, Workload Management, and Unstructured Text Analysis. In addition, several products have been extensively enhanced including Design Studio, Administration Console, and SQL Warehouse Tool.

In addition to these features, you will also find significant enhancements to both Alphablox and DB2, which are outlined in Software Announcement 207-255 , dated October 16, 2007, IBM DB2 Alphablox V9.5 and Software Announcement 207-261 , dated October 16, 2007, IBM DB2 V9.5.

For details regarding Data Warehouse Edition V9.1.2, refer to Software Announcement 207-042 , dated March 13, 2007.
 
Back topBack to top
 

Key prerequisites

Refer to the Hardware and software requirements section.


 
Back topBack to top
 

Planned availability dates

Electronic software delivery

  • October 31, 2007: All supported platforms except HP-UX
  • January 25, 2008: Support for HP-UX

Physical media and documentation

  • December 14, 2007: All supported platforms except HP-UX
  • February 22, 2008: Support for HP-UX

 
Back topBack to top
 
Description

Mixed workload environments, along with the constantly changing needs of the different business constituents, require the next generation of data warehouses.

From self-service reporting to complex decision systems, IBM DB2 Warehouse V9.5 provides a set of integrated components that enable organizations to easily model, define, build, analyze, mine, and administer data warehouses and data marts. DB2 Warehouse V9.5 is the base for information on demand, enabling organizations to reengineer their business with enterprise-wide, factual information. It can help you maximize the value of information assets by delivering business insight to the right people at the point of decision.

Cubing Services provides a robust multidimensional analytics capability embedded in the DB2 Warehouse platform. It empowers users to ask intuitive and complex ad hoc questions about their enterprise, such as, "What is my product's profitability for this quarter across my territory?" This type of business query requires the grouping, aggregation, and calculation of information across various business dimensions, such as time, product, customer, and supplier. Cubing Services is designed to resolve just this type of multidimensional query, known as Online Analytical Processing (OLAP). Cubing Services provides industry-standard APIs to support a number of first class business intelligence reporting and analytics tools, enabling users to leverage this powerful analytic capability through the end user tool of their choice.

Built into the DB2 Warehouse V9.5 platform, Cubing Services can lead to substantial cost savings and time-to-value reduction over traditional outboard cubing technologies. Leveraging data directly from the DB2 Warehouse, Cubing Services does not require the overhead of copying data into a third-party technology. Fully integrated into the DB2 Warehouse design and administrative tooling, Cubing Services provides the ability to achieve lower design and maintenance costs over external cubing solutions.

Workload management enables you to enforce and monitor the business service levels for users across your data warehouse. It empowers users to provide explicit allocation of CPU priority for executing work, controlling "rogue" queries, and monitoring of database activity. It also enables the database execution environment to match the business priorities and allocations of resources to the active work. Workload management enables mixed mode environments with predictable results. It provides the ability to track the performance of work. It enables control of unexpected resource consumption and offers a viable, alternate workload management solution to that offered by Query Patroller and DB2 Governor.

Unstructured Text Analysis provides the ability to correlate non-relational data such as contracts, letters, and service logs (Unstructured Text Data) with relational structured data. It identifies key words and relationships, and transforms that information into structured data that can be analyzed with existing warehouse structured data using existing warehouse tools. When correlated with relational structured data, this information provides for the analysis to better understand customer interactions, voice of the customer, voice of the employee, and product opportunities.

Some additional changes

  • SQL Warehousing Tool enhancements
    • DB2 Linux™, UNIX®, and Windows™ features enablement
      • Row compression: automate schedule row compression and decompression with control flows, check compression ratios
      • Range partition: automate roll-in and roll-out operations with control flows, specify range boundaries for staged tables in data flows
    • Flow enhancements
      • Java™ Database Connectivity (JDBC) batch size tuning for Data Flow remote source and targets
      • Load flat files from server
      • Staging table tuning: creating indexes, range partition, runstats
      • Order by "get first n rows"
      • Flow debugging and execution visual enhancements
      • Online and offline modes of flow designing
      • Virtual columns, expressions sorting, filtering enhancements
    • SQW runtime enhancements
      • Parallel execution in control flows
      • Sub process modularizations
      • Delta deployment
      • Variable enhancements, reserved system variables
      • Activity skip during execution
      • Enhanced diagnostics (user control with file write operator), logging
      • DB2 warehouse common resources repository integration
    • DB2 Warehouse V9.5 enhancements
      • Design Studio base upgrade: built on DB2 Workbench V9.5 and WebSphere® Federation Server V7 Fix Pack 3
      • Meta Integration Model Bridge: included tooling for exchanging data models
      • WebSphere Federation Server Relational Wrappers packaged: connectors are now an installable option for the user
    • Workload management scheme modeling and deployment
      • Reverse engineering
        • Pre-existing workload management solution from a database into Design Studio
        • Operating system services classes from AIX®
      • Configurators: guided creation of workload management solutions resource sharing
        • Enforcing limits for activities
        • Enforcing limits for concurrent activities
      • Simplified visualization and update of workload management entities
        • Tree view — hierarchical outline of workload management solution, workload management entity relationship modeling
        • Design monitoring and control using simplified rules
      • Robust deployment
        • Compare merge, delta deploy
        • Generate and, or execute Data Definition Language (deploy workload management scheme)
          • "Offline" mode: allows users to save and manually execute (say by authorized database administrator) Data Definition Language
          • "Online" mode: deploy workload management scheme from Design Studio
            • Wait for drain of database activity prior to updating workload management scheme
            • Robust error recovery — rollback to original workload management scheme on error
  • Administrative Console

      The Administration Console provides a Web-based administration facility for DB2 Warehouse V9.5. It is one of its key components and is your front end for DB2 Warehouse production and runtime environment.
      • Integrated Solution Console integration, for example, integration of the Administration Console into IBM's Integrated Solution Console framework allowing the use of multiple administration consoles of the DB2 Warehouse stack from a single unified console
      • Cubing Services Administration replacing Cube Views® Administration
  • Design Studio

      The Eclipse-based SQL data warehouse workbench makes it easier to model, design, and implement analytic structures in the warehouse, and also helps populate and maintain them. This workbench can be extended by both you and your Business Partners with simple-to-build Eclipse-based plug-ins that enable a data warehouse control point that is tailored to your unique needs. The SQL data warehouse workbench provides for the optional IBM Rational® plug-in for logical database design and includes the plug-in for physical database design. The SQL data warehouse workbench provides a schema to a screen set of capabilities including:
      • Easy-to-use SQL data warehouse workbench
        • Flexible, extensible (plug-ins), easy-to-use eclipse environment
        • Design
          • Logical Entity Relationship design with Rational Data Architect plug-in (optionally available from Rational)
          • Physical design
        • Extract, load, and transform
        • Data movement and transformation
        • Scripting
        • Cube and Materialized Query Table
        • Data mining
        • Debugging and testing
      • A Web-based capability for monitoring and managing the warehouse
        • Resources
        • Data warehouse applications
        • Processes
        • Troubleshooting
        • History and statistics
        • Logs and traces

In some editions of DB2 Warehouse V9.5, the tools are included to perform predictive analytics (data mining) and Design Studio directly on the data inside the warehouse, without extracting data to specialized analytic silos.

With the analytic development environment Alphablox, you can quickly build analytic information-based applications such as dashboards and scorecards. In addition, you can use Alphablox to provide warehouse-based information to broad-based deployed operational applications that provide context-sensitive information for both fact-based decisions and root cause analysis. Alphablox can enable you to capitalize on both multidimensional analysis and data mining to provide insights that are fact based, up to the moment, and in context.

IBM Non-Data Warehouse Edition Connector (Alphablox Connectors) is a separately priced feature that provides entitlement for Alphablox connectivity to non-DB2 relational data sources or multidimensional data sources.

The following table describes the available editions of DB2 Warehouse V9.5 and identifies the characteristics of each.

                     Inter-
Product    Starter   mediate   Advanced  Base      Enterprise  Developer
 
           (Linux,   (Linux,   (Linux)   (Linux,   (Linux,     (Linux,
            Windows) Windows)            UNIX,     UNIX,       UNIX,
                                         Windows)  Windows)    Windows
Limit      200 PVU   400 PVU   1,000      No        No          Developer
            4 GB of   32 GB     PVU       Limita-   Limita-     Use
            instance  of        2 TB      tion      tion        Only
            memory    instance  Warehouse
                      memory    size
DB2 ESE    Included  Included  Included  Included  Included    Included
 (See
 note
 below)
SQL        Included  Included  Included  Included  Included    Included
 Warehous-
 ing
 Tool
Inte-      Included  Included  Included  Included  Included    Included
 grated
 Instal-
 ler
Admin      Included  Included  Included  Included  Included    Included
 Console
Design     Included  Included  Included  Included  Included    Included
 Studio
Cubing     Included  Included  Included  Included  Included    Included
 Services
Database   Included  Included  Included  Included  Included    Included
 Parti-
 tioning
Perfor-    Not       Not       Included  Optional  Included    Included
 mance      available available
 Optimization
 Feature
DB2        Not       Not       Included  Optional  Included    Included
 Storage    available available
 Optimiza-
 tion
 Feature
Alphablox  Not       Not       Optional  Not       Included    Included
            available available           available
Intelli-   Not       Not       Not       Not       Included    Included
 gent       available available available available
 Miner
Alphablox  Not       Not       Optional  Not       Included    Included
            available available           available
 Connectors
Unstruc-   Not       Not       Not       Not       Included    Included
 tured      available available available available
 Text
 Analysis

Note: DB2 Enterprise Server Edition

For a detailed description of the prior release, Data Warehouse Edition V9.1.2, refer to Software Announcement 207-042 , dated March 13, 2007.

For more on the built-in analytic and warehouse administration benefits of Data Warehouse Edition, visit

IPLA and Subscription and Support considerations

IPLA licenses can be transferred from one machine to another within, but not limited to an enterprise. You may aggregate the capacity for all the processors the product is operated on to achieve a more economic price. This will result in a single Proof of Entitlement (PoE). It is your responsibility to manage the distribution of Value Units within the limits of the entitlement of the product license.

Subscription and Support must cover the same capacity as the product license entitlement. Subscription and Support will be available in the country in which the agreement is made.
 
Back topBack to top
 

Product positioning

DB2 Warehouse V9.5 extends IBM's integrated data warehouse solution by providing new functions to enable organizations to build robust decision systems that grow with their organizational needs. DB2 Warehouse continues to be available in the six editions: Starter, Intermediate, Advanced, Base, Enterprise, and Developer Edition.

DB2 Warehouse offers a wide array of offerings that enable you to start small and grow big. From Starter Edition to Enterprise Edition, DB2 Warehouse is ideal for small to very large data marts and data warehouses that require scalability and manageability along with a complete range of analytic capabilities.

DB2 Warehouse is a set of offerings that are built on a base warehousing set of components. They include a set of tooling and infrastructure to extend the core DB2 engine into a complete business intelligence platform with built-in data partitioning. All editions now include Database Partitioning Feature, the SQL Warehousing Tool, Install, Administration Console, and Cubing Services. All editions also include range partitioning and multidimensional clustering. This tool set enables users to design, define, populate, and execute the required activities through a single GUI. The SQL data warehouse workbench SQL Warehouse Tool provides design, data movement, scripting, query definition, and workload management definition to easily manage small to large data warehouses.

DB2 Warehouse Starter Edition is targeted at small and medium businesses with requirements for 50 GB to 350 GB of user data and 10 users to 60 users — first-time data warehouse customers who require the ability to transform data into reliable and consistent business insights in a single-node environment.

DB2 Warehouse Intermediate Edition is targeted at larger small and medium businesses and departmental customers with data warehouses that scale from 50 to 200 users and 500 GB to 1 TB of data and works with partner business intelligence (BI) applications and analytic tools in a 400 processor Value Unit (PVU) environment, in single or multiple nodes.

Starter and Intermediate Editions are now available in Linux (both Red Hat and SUSE) and Windows, providing a wide choice of options for introducing data warehouses and data marts.

DB2 Warehouse Base Edition provides medium to large-scale enterprises with a data warehouse and data mart infrastructure. It includes a basic set of tooling and infrastructure to extend the core DB2 engine into a complete BI platform with built-in data partitioning. With its SQL data warehouse workbench that enables design, data modeling, data movement, and scripting, DB2 Warehouse Base Edition can support departmental data warehouses or enterprise data warehouses where there is a need for scalability and performance.

Enterprise Edition is the flagship, all-inclusive platform for warehouse-based analytics and simplified warehouse management. It includes the full set of tooling and in-warehouse data mining, and the new Cubing Services (Design Studio), the new Workload Management, Performance and Storage Optimization, the new Unstructured Text Analysis and a custom analytic application development platform for inline analytics. The Enterprise Edition sets the mark in integrated tooling.

DB2 Warehouse Developer's Edition has the same content and functionality as the DB2 Warehouse Enterprise Edition, licensed with terms and conditions for the purposes of evaluating, demonstrating, testing, and developing application programs. The product is targeted at developers and is for non-production use.

DB2 Warehouse Advanced Edition is a controlled offering and is targeted at larger small and medium businesses, enterprises, and departmental customers with data warehouses on Linux with requirements for up to 2 TB of data that works with partner BI applications and analytic tools in a 1,000 PVU environment, in single or multiple nodes.
 
Back topBack to top
 

Statement of direction

The following functions are planned to be available in early 2008:

  • Cubing Services will support multiple standards-based protocols for communicating with client applications. These will include object linking and embedding database (OLE DB) for OLAP (ODBO), which will provide direct connectivity with client applications such as Microsoft™ Excel.
  • Support for LDAP in Alphablox.
  • Improved security for Cubing Services.
  • The operating systems AIX V6.1 and the next release of Microsoft Windows 64 bit will be supported.

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 207-042 , dated March 13, 2007
  • Software Announcement 207-261 , dated October 16, 2007
  • Software Announcement 207-255 , dated October 16, 2007

 
Back topBack to top
 
Availability of national languages

Product description  Language                     GA date
 
IBM DB2 Warehouse    Multilingual (French,        12/14/2007
 Base Edition         Korean, Chinese --
 V9.5.0               Simplified, Spanish,
                      Portuguese-Brazilian,
                      German, Japanese, Chinese
                      -- Traditional, English
                      U.S., Italian)
 
IBM DB2 Warehouse    Multilingual (French,        12/14/2007
 Developer Edition    Korean, Chinese --
 V9.5.0               Simplified, Spanish,
                      Portuguese-Brazilian,
                      German, Japanese, Chinese
                      -- Traditional, English
                      U.S., Italian)
 
IBM DB2 Warehouse    Multilingual (French,        12/14/2007
 Enterprise Edition   Korean, Chinese --
 V9.5.0               Simplified, Spanish,
                      Portuguese-Brazilian,
                      German, Japanese, Chinese
                      -- Traditional, English
                      U.S., Italian)
 
IBM DB2 Warehouse    Multilingual (French,        12/14/2007
 Advanced Edition     Korean, Chinese --
 V9.5.0               Simplified, Spanish,
                      Portuguese-Brazilian,
                      German, Japanese, Chinese
                      -- Traditional, English
                      U.S., Italian)
 
IBM DB2 Warehouse    Multilingual (French,        12/14/2007
 Intermediate         Korean, Chinese --
 Edition V9.5.0       Simplified, Spanish,
                      Portuguese-Brazilian,
                      German, Japanese, Chinese
                      -- Traditional, English
                      U.S., Italian)
 
IBM DB2 Warehouse    Multilingual (French,        12/14/2007
 Starter Edition      Korean, Chinese --
 V9.5.0               Simplified, Spanish,
                      Portuguese-Brazilian,
                      German, Japanese, Chinese
                      -- Traditional, English
                      U.S., Italian)

Trademarks

 
DB2, WebSphere, AIX, Cube Views, and Rational 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.
 
Java is a trademark of Sun Microsystems, Inc.
 
UNIX is a registered trademark of the Open Company in the United States and other countries.
 
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

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

Call IBM training at 800-IBM-TEACH (426-8322) for catalogs, schedules, and enrollments.

The following courses are currently available. Check with your country's Information Management Training and Education Web site or contact person to determine exactly when the new course material will be available.

Information Management Training is now offering some of our most popular courses in a new learning format, instructor-led online (ILO). With this new format, you get the benefits of being in a classroom with the convenience and cost savings of online training!

The following educational offerings are available:

               Course
Category       code     Course title         Course type
 
Introduction   DW03     Changing             Classroom
 courses                 Business with
                         Data Insight
               3W03     Changing             Instructor Led
                         Business with        Online
                         Data Insight
               DW11     Architecting         Classroom
                         the Data
                         Warehouse
Intermediate   DW35     DB2(R) Data          Classroom
 courses                 Warehouse 9
                         Components
               3W35     DB2 Data             Instructor Led
                         Warehouse 9          Online
                         Components
               L130     DB2 Alphablox        Classroom
                         Essentials
               DW65     Implementing         Classroom
                         Cube Views(R)
                         in Your Data
                         Warehouse
Advanced       DW12     Advanced Data        Classroom
 courses                 Warehousing
                         Workshop:
                         Multi-Dimensional
                         Modeling

           IBM form
Category   number         Title
 
Redbooks   SG24-7418-00   Dynamic Warehousing:
                           Data Mining Made Easy
           SG24-7138-00   Dimensional Modeling:
                           In a Business Intelligence
                           Environment
           SG24-7002-00   DB2 Cube Views:  A Primer
           SG24-7274-00   Leveraging DB2 Data Warehouse
                           Edition for Business Intelligence
           SG24-7104-00   Moving Forward with that On Demand
                           Real-time Enterprise
           SG24-2238-00   Data Modeling techniques for Data
                           Warehousing
           SG24-5174-00   From Multiplatform Operational
                           Data to Data Warehousing and
                           Business Intelligence

 
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

No hardcopy publications are shipped with this product. Documents shipped with this product are in electronic format only.

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

The DB2 Warehouse Installation Guide is available at:

The DB2 Warehouse V9.5 Information Center is combined with the DB2 V9.5 Information Center.

The following publications are available for this product:

                                                   Form
Description                                        number
 
IBM DB2 Warehouse Installation Guide               GC18-9800
IBM DB2 Warehouse Tutorial                         SC18-9801
IBM DB2 Warehouse Mining in the Design Studio      SC19-1259
IBM DB2 Warehouse Cubing Services                  SC19-1258
 User's Guide and Reference
IBM DB2 Warehouse SQL Warehousing                  SC19-1257
 Tool User's Guide
IBM DB2 Warehouse Workload                         SC19-1261
 Management User's Guide
IBM DB2 Warehouse Visualizing Mining Results       SH12-6840
IBM DB2 Warehouse Applying Mining                  SH12-6839
 Models with IM Scoring
IBM DB2 Warehouse Creating Mining                  SH12-6838
 Models with IM Modeling
IBM DB2 Warehouse Data Mining                      SH12-6837
 with Easy Mining Procedures
IBM DB2 Warehouse Creating Web                     SC18-9805
 Applications with Miningblox
IBM Alphablox Administering Alphablox              SC19-1262
IBM Alphablox Getting Started Guide                SC19-1263
IBM Alphablox Developing with Analytics APIs       SC19-1264
IBM Alphablox Developing Reporting                 SC19-1265
 Applications with ReportBlox
IBM Alphablox Developing Analytic                  SC19-1266
 Applications with Blox Builder
IBM Alphablox JSP Tag Libraries                    SC19-1267
IBM Alphablox Troubleshooting and Support          SC19-1268
IBM Alphablox Installation Guide                   GC19-1269
IBM Alphablox Cube Server Administration Guide     SC19-1270

 
Back topBack to top
 
Technical information

Specified operating environment

Hardware and software requirements

DB2 Warehouse is a distributed product and its components are arranged into three logical groups. Typically, you install these groups on three different computers, but you can install them on a single computer. These groups are:

  • Warehousing Server: This group includes the server components of DB2, Query Patroller, Cubing Services, and Intelligent Miner™.
  • Application Server: This group includes WebSphere® Application Server and applications that run on WebSphere: the DB2 Warehouse Administration Console, and run-time services for the Data Server Client, the SQL Warehousing Tool, and Alphablox. It also includes Cubing Services code.
  • Client: This group includes the Design Studio, the Data Server Client front end, the Design Studio Center for Cubing Services, Intelligent Miner, and Query Patroller Center.

Requirements for DB2 Warehouse Server

The following documents the required hardware and software for the computer on which you install DB2 Warehouse. This includes the installation requirements for both the database server and the clients for installing all of the components in the DB2 Warehouse Starter Edition, Intermediate Edition, Advanced Edition, Base Edition, Enterprise Edition, or Developer Edition.

Server operating systems

Linux™

  • Red Hat Enterprise Linux (RHEL) 4 and 5 on 64-bit AMD and Intel® x86-64 systems
  • SUSE Linux Enterprise Server (SLES) 9 and 10 on 64-bit AMD and Intel x86-64 systems

Windows™

  • Windows 2003 Standard, Enterprise, and Datacenter Editions 32 bit and 64 bit

AIX®

  • AIX V5.3 (64 bit only)

HP-UX

  • HP-UX for 64-bit HP Integrity servers (Itanium-based systems)

Solaris

  • Solaris 9 for UltraSPARC servers (64 bit only)
  • Solaris 10 for UltraSPARC servers (64 bit only)

Client operating systems

Linux

  • Red Hat Enterprise Linux (RHEL) 4 on 32-bit AMD and Intel x86 systems
  • SUSE Linux Enterprise Server (SLES) 9 on 32-bit AMD and Intel x86 systems

Windows

  • Windows XP Professional Edition 32 bit
  • Windows Vista Business, Enterprise and Ultimate Editions 32 bit

Disk space

Temporary space for installable images of DB2 Warehouse components:

  • If you download images from the IBM Web site, 8 GB of free disk space is required to store and unpackage the product components.

Temporary space for running the installation program:

  • Approximately 500 MB of disk space is recommended.

Permanent space for the installed components:

  • On Windows, approximately 1 GB of disk space is recommended for the data server.
  • On Linux and UNIX®, approximately 1.5 GB of disk space is recommended for the installed product.

Memory

Memory for installing the product: Approximately 1 GB of memory is needed by the DB2 Warehouse installation program to install all the DB2 Warehouse Server components.

Memory for running the product:

  • A minimum of 1 GB of memory is recommended to run the DB2 Warehouse Server components alone. If you run the Application Server components on the same computer, 2 GB is recommended.
  • If you add more DB2 Warehouse components to the same computer, you must have more memory to run them in addition to the memory reserved for the Application Server.

Requirements for the DB2 Warehouse Application Server

You can install Application Server components only if you purchased the DB2 Warehouse Starter Edition, Intermediate Edition, Advanced Edition, Base Edition, Enterprise Edition, or Developer Edition.

The following documents the required hardware and software for the computer on which you install the Application Server for DB2 Warehouse V9.5.

For detailed information about supported hardware and software for WebSphere, visit

Linux

  • Red Hat Enterprise Linux (RHEL) 4 and 5 on 64-bit AMD and Intel x86-64 systems
  • SUSE Linux Enterprise Server (SLES) 9 and 10 on 64-bit AMD and Intel x86-64 systems

Windows

  • Windows 2003 Standard, Enterprise, and Datacenter Editions 32 bit and 64 bit

AIX

  • AIX V5.3 (64 bit only)

HP-UX

  • HP-UX for 64-bit HP Integrity servers (Itanium-based systems)

Solaris

  • Solaris 9 for UltraSPARC servers (64 bit only)
  • Solaris 10 for UltraSPARC servers (64 bit only)

Supported Web browsers:

  • Web browsers supported by DB2 Warehouse Administration Console: The DB2 Warehouse Administration Console was certified with Internet Explorer 6.0 with SP 1 and Internet Explorer V7.0 (Windows), and Firefox V1.5 and V2.0.
  • Web browsers supported by WebSphere Application Server: The administrative console for WebSphere Application Server supports Internet Explorer 6.0 with SP 1 (Windows), Mozilla V1.7.8, and Firefox V1.5.

Disk space

Temporary space for installable images of the DB2 Warehouse components:

  • If you download images from the IBM Web site, 8 GB of free disk space is required to store and unpackage the product components.
  • Approximately 2.7 GB of disk space is recommended for the installation images of the Application Server components alone. If you install all of the documentation, you need another 3.2 GB.
  • On AIX, you must have enough disk space for all the installable images for the entire DB2 Warehouse product, even if you are not installing all the components. This is approximately 7.5 GB.

Temporary space for running the installation program: Approximately 550 MB of disk space is recommended.

Permanent space for the installed components: Approximately 2 GB of disk space is recommended for WebSphere, the DB2 Warehouse Administration Console, and the DB2 Alphablox administration tool. If you are installing WebSphere into a 64-bit instance, you will need an additional 500 MB.

Memory

Memory for installing the product: Approximately 1 GB of memory is recommended to install the Application Server.

Memory for running the product:

  • A minimum of 1 GB of memory is recommended to run the Application Server alone. If you run the DB2 Warehouse Server components on the same computer, another 2 GB of memory is recommended.
  • If you add more DB2 Warehouse components to the same computer, you must have more memory to run them in addition to the memory reserved for the Application Server.

Requirements for the DB2 Warehouse client computer

You can install client components if you purchased the DB2 Warehouse Starter Edition, Intermediate Edition, Advanced Edition, Base Edition, Enterprise Edition, or Developer Edition.

The following documents the required hardware and software for the client computer for DB2 Warehouse V9.5.

Linux

  • Red Hat Enterprise Linux (RHEL) 4 on 32-bit AMD and Intel x86 systems
  • SUSE Linux Enterprise Server (SLES) 9 on 32-bit AMD and Intel x86 systems

Windows

  • Windows XP Professional Edition 32 bit
  • Windows Vista Business, Enterprise, and Ultimate Editions 32 bit

Disk space

Temporary space for installable images of the DB2 Warehouse components:

  • If you download images from the IBM Web site, 8 GB of free disk space is required to store and unpackage the product components.
  • Approximately 1.5 GB of temporary disk space is recommended to store the installation images. If you install all of the documentation, you need another 3.2 GB.

Temporary space for running the installation program: Approximately 500 MB of disk space is recommended to run the installation program.

Permanent space for the installed components: Approximately 2 GB of disk space is recommended for the installed product.

Memory

Memory for installing the product: Approximately 1 GB of memory is recommended to install the client applications.

Memory for running the product: Approximately 1 GB of memory is recommended to run the client applications.

Planning information

Software Maintenance is included with licenses purchased through Passport Advantage and Passport Advantage Express. Product upgrades and technical support are provided by the Software Maintenance offering as described in the Agreements. Product upgrades provide the latest versions and releases to entitled software, and technical support provides voice and electronic access to IBM support organizations, worldwide.

IBM includes one year of Software Maintenance with each program license acquired. The initial period of Software Maintenance can be extended by the purchase of a renewal option, if available.

Packaging

Notes:

  • The Warehouse Server DVDs include DB2 Enterprise Server Edition, applicable DB2 Feature entitlements, Warehouse components, and WebSphere Application Server.
  • The Warehouse Client DVDs include IBM Data Server Client, Warehouse components, Information Center, Samples, and Tutorial.

DB2 Warehouse Starter Edition V9.5 — Authorized user and CPU options

  • IBM DB2 Warehouse Quick Start CD
  • IBM DB2 Warehouse Starter Edition — Activation CD
  • IBM DB2 Warehouse Server for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
  • IBM DB2 Warehouse Server for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM DB2 Warehouse Server for Windows on AMD64 and Intel EM64T systems (x64) DVD
  • IBM DB2 Warehouse Client for Linux on 32-bit AMD and Intel systems (x86) DVD
  • IBM DB2 Warehouse Client for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM WebSphere Application Server Toolkit for Linux on 32-bit AMD and Intel systems (x86) CD
  • IBM WebSphere Application Server Toolkit for Windows on 32-bit AMD and Intel systems (x86) CD
  • IBM Tivoli® System Automation Multiplatforms for Windows on 32-bit AMD and Intel systems (x86) CD

DB2 Warehouse Intermediate Edition V9.5 — Authorized user and CPU options

  • IBM DB2 Warehouse Quick Start CD
  • IBM DB2 Warehouse Intermediate Edition — Activation CD
  • IBM DB2 Warehouse Server for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
  • IBM DB2 Warehouse Server for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM DB2 Warehouse Server for Windows on AMD64 and Intel EM64T systems (x64) DVD
  • IBM DB2 Warehouse Client for Linux on 32-bit AMD and Intel systems (x86) DVD
  • IBM DB2 Warehouse Client for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM WebSphere Application Server Toolkit for Linux on 32-bit AMD and Intel systems (x86) CD
  • IBM WebSphere Application Server Toolkit for Windows on 32-bit AMD and Intel systems (x86) CD
  • IBM Tivoli System Automation Multiplatforms for Windows on 32-bit AMD and Intel systems (x86) CD

DB2 Warehouse Advanced Edition V9.5

  • IBM DB2 Warehouse Quick Start CD
  • IBM DB2 Warehouse Advanced Edition — Activation CD
  • IBM DB2 Warehouse Server for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
  • IBM DB2 Warehouse Client for Linux on 32-bit AMD and Intel systems (x86) DVD
  • IBM WebSphere Application Server Toolkit for Linux on 32-bit AMD and Intel systems (x86) CD
  • IBM DB2 Performance Expert for Multiplatforms Quick Start CD
  • IBM DB2 Performance Expert for Multiplatforms (Windows on 32-bit AMD and Intel systems (x86), Linux on 32-bit AMD and Intel systems (x86), Linux on AMD64 and Intel EM64T systems (x64)) CD
  • IBM DB2 Performance Expert for Multiplatforms (Linux on System z™, Linux on POWER™ (System i™ and System p™) systems, AIX, HP-UX on HP Integrity Itanium-based systems, Solaris on UltraSPARC systems) CD

DB2 Warehouse Base Edition V9.5

  • IBM DB2 Warehouse Quick Start CD
  • IBM DB2 Warehouse Base Edition — Activation CD
  • IBM DB2 Warehouse Server for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
  • IBM DB2 Warehouse Server for AIX DVD
  • IBM DB2 Warehouse Server for HP-UX on HP Integrity Itanium-based systems DVD
  • IBM DB2 Warehouse Server for Solaris on UltraSPARC systems DVD
  • IBM DB2 Warehouse Server for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM DB2 Warehouse Server for Windows on AMD64 and Intel EM64T systems (x64) DVD
  • IBM DB2 Warehouse Client for Linux on 32-bit AMD and Intel systems (x86) DVD
  • IBM DB2 Warehouse Client for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM WebSphere Application Server Toolkit for Linux on 32-bit AMD and Intel systems (x86) CD
  • IBM WebSphere Application Server Toolkit for Windows on 32-bit AMD and Intel systems (x86) CD
  • IBM Tivoli System Automation Multiplatforms for Windows on 32-bit AMD and Intel systems (x86) CD
  • IBM DB2 Enterprise Server Edition for Linux on POWER (System i and System p) systems DVD
  • IBM DB2 Enterprise Server Edition for Linux on System z DVD

DB2 Warehouse Enterprise Edition V9.5

  • IBM DB2 Warehouse Quick Start CD
  • IBM DB2 Warehouse Enterprise Edition — Activation CD
  • IBM DB2 Warehouse Server for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
  • IBM DB2 Warehouse Server for AIX DVD
  • IBM DB2 Warehouse Server for HP-UX on HP Integrity Itanium-based systems DVD
  • IBM DB2 Warehouse Server for Solaris on UltraSPARC systems DVD
  • IBM DB2 Warehouse Server for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM DB2 Warehouse Server for Windows on AMD64 and Intel EM64T systems (x64) DVD
  • IBM DB2 Warehouse Client for Linux on 32-bit AMD and Intel systems (x86) DVD
  • IBM DB2 Warehouse Client for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM WebSphere Application Server Toolkit for Linux on 32-bit AMD and Intel systems (x86) CD
  • IBM WebSphere Application Server Toolkit for Windows on 32-bit AMD and Intel systems (x86) CD
  • IBM Tivoli System Automation Multiplatforms for Windows on 32-bit AMD and Intel systems (x86) CD
  • IBM DB2 Performance Expert for Multiplatforms Quick Start CD
  • IBM DB2 Performance Expert for Multiplatforms (Windows on 32-bit AMD and Intel systems (x86), Linux on 32-bit AMD and Intel systems (x86), Linux on AMD64 and Intel EM64T systems (x64)) CD
  • IBM DB2 Performance Expert for Multiplatforms (Linux on System z, Linux on POWER (System i and System p) systems, AIX, HP-UX on HP Integrity Itanium-based systems, Solaris on UltraSPARC systems) CD

DB2 Warehouse Developer Edition V9.5

  • IBM DB2 Warehouse Quick Start CD
  • IBM DB2 Warehouse Developer Edition — Activation CD
  • IBM DB2 Warehouse Server for Linux on AMD64 and Intel EM64T systems (x86-64) DVD
  • IBM DB2 Warehouse Server for AIX DVD
  • IBM DB2 Warehouse Server for HP-UX on HP Integrity Itanium-based systems DVD
  • IBM DB2 Warehouse Server for Solaris on UltraSPARC systems DVD
  • IBM DB2 Warehouse Server for Windows on 32-bit AMD and Intel systems (x86) DVD
  • IBM DB2 Warehouse Server for Windows on AMD64 and Intel EM64T systems (x64) DVD
  • IBM DB2 Warehouse Client for Linux on 32-bit AMD and Intel systems (x86) DVD
  • IBM DB2 Warehouse Client for Windows on 32-bit AMD and Intel Systems (x86) DVD
  • IBM WebSphere Application Server Toolkit for Linux on 32-bit AMD and Intel systems (x86) CD
  • IBM WebSphere Application Server Toolkit for Windows on 32-bit AMD and Intel systems (x86) CD
  • IBM Tivoli System Automation Multiplatforms for Windows on 32-bit AMD and Intel systems (x86) CD
  • IBM DB2 Performance Expert for Multiplatforms Quick Start CD
  • IBM DB2 Performance Expert for Multiplatforms (Windows on 32-bit AMD and Intel systems (x86), Linux on 32-bit AMD and Intel systems (x86), Linux on AMD64 and Intel EM64T systems (x64)) CD
  • IBM DB2 Performance Expert for Multiplatforms (Linux on System z, Linux on POWER (System i and System p) systems, AIX, HP-UX on HP Integrity Itanium-based systems, Solaris on UltraSPARC systems) CD

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

Software Services

IBM Software Services has the breadth, depth, and reach to manage your services needs. You can leverage the deep technical skills of our lab-based, software services team and the business consulting, project management, and infrastructure expertise of our IBM Global Services team. Also, we extend our IBM Software Services reach through IBM Business Partners to provide an unmatched portfolio of capabilities. Together, we provide the global reach, intellectual capital, industry insight, and technology leadership to support any critical business need.

To learn more about IBM Software Services or to contact a Software Services sales specialist, visit

To locate an IBM Business Partner, visit:


 
Back topBack to top
 
Ordering information

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

Product information

                                                    Product
Licensed function title             Product group   category
 
IBM Alphablox Add-in                IBM Database    DB2
                                     Management
IBM DB2 Warehouse Advanced Edition  IBM Database    DB2
                                     Management
IBM DB2 Warehouse Developer         IBM Database    DB2
 Edition                             Management
IBM DB2 Warehouse Base Edition      IBM Database    DB2
                                     Management
IBM DB2 Warehouse Enterprise        IBM Database    DB2
 Edition                             Management
IBM DB2 Warehouse Intermediate      IBM Database    DB2
 Edition Value Unit                  Management
IBM DB2 Warehouse Starter Edition   IBM Database    DB2
 Value Unit                          Management
IBM Non-DWE (Data Warehouse         IBM Database    DB2
 Edition) Connector                  Management

Program name                          PID        Charge unit
                                      number     description
 
IBM Alphablox Add-in                  5724-E34   Value Unit
IBM DB2 Warehouse Advanced Edition    5724-E34   Value Unit
IBM DB2 Warehouse Base Edition        5724-E34   Value Unit
IBM DB2 Warehouse Developer Edition   5724-E34   Authorized
                                                  Users
IBM DB2 Warehouse Enterprise Edition  5724-E34   SubCapacity
                                                  Value Unit
IBM DB2 Warehouse Enterprise Edition  5724-E34   Value Unit
IBM DB2 Warehouse Enterprise Edition  5724-E34   Processor
                                                  Day
IBM DB2 Warehouse Intermediate        5724-E34   Authorized
 Edition Authorized Users                         Users
IBM DB2 Warehouse Intermediate        5724-E34   Value Unit
 Edition Value Unit
IBM DB2 Warehouse Starter Edition     5724-E34   Value Unit
 Value Unit
IBM DB2 Warehouse Starter Edition     5724-E34   Authorized
 Authorized Users                                 Users
IBM Non-DWE (Data Warehouse Edition)  5724-E34   Processor
 Connector                                        Day
IBM Non-DWE (Data Warehouse Edition)  5724-E34   Value Unit
 Connector

Charge metrics definitions

Value Unit

A Value Unit is a pricing charge metric for program license entitlements which is based upon the quantity of a specific designated measurement used for a given program. Each program has a designated measurement. The most commonly used designated measurement is a processor core. However, for select programs, there are other designated measurements such as users, client devices, and messages. The number of Value Unit entitlements required for a program depends on how the program is deployed in your environment and must be obtained from a Value Unit table. You must obtain a PoE for the calculated number of Value Unit entitlements for your implementation. The Value Unit entitlements are specific to a program and may not be exchanged, interchanged, or aggregated with Value Unit entitlements of another program.

Processor (Value Unit)

A processor core is a functional unit within a computing device that interprets and executes instructions. A processor core consists of at least an instruction control unit and one or more arithmetic or logic unit. With multicore technology, each core is considered a processor. Not all processor cores require the same number of Value Unit entitlements. To calculate the number of Value Unit entitlements required, refer to the Value Unit table on the following Web site

With full capacity licensing, a PoE must be acquired for the appropriate number of Value Units based on all activated processor cores available for use on the server.

Sub-capacity processor (Value Unit)

For programs eligible for sub-capacity licensing, a PoE must be acquired for the appropriate number of value units based on all activated processor cores available for use in each partition (utilizing eligible partitioning technologies) where the program runs. Refer to the International Passport Advantage Agreement Attachment for sub-capacity terms or the program's license information to determine applicable sub-capacity terms.

Authorized user

An authorized user is one and only one individual (named or unnamed) within or outside your enterprise. A PoE must be obtained for each individual user accessing the program in any manner. A program licensed under an authorized user PoE may be installed on a single computer or server, and accessed by multiple users, provided that a PoE has been obtained for each individual user accessing the program either directly or indirectly (via a multiplexing program, device, or application server) through any means on behalf of the user.

Passport Advantage program licenses

IBM DB2 Warehouse

                                                     Part
Part description                                     number
 
IBM DB2 Warehouse Enterprise  Edition
DB2 Warehouse Enterprise Edition                     D57UBLL
 Value Unit Lic and SW Maint 12 Mo
DB2 Warehouse Enterprise Edition                     E02GVLL
 Value Unit Annual SW Maint Rnwl
DB2 Warehouse Enterprise Edition Value               D57UCLL
 Unit SW Maint Reinstate 12 Mo
DB2 Warehouse Enterprise Ed VU fr DB2 Warehouse      D57UDLL
 Adv VU Trdup Lic and SW Maint 12 Mo
DB2 Warehouse Enterprise Edition Value Unit          D57UELL
 fr DB2 ESE VU Trdup Lic and SW Maint 12 Mo

IBM DB2 Warehouse

                                                     Part
Part description                                     number
 
IBM Non-DWE (Data Warehouse Edition) Connector
Non DWE Connector Value Unit Lic and SW Maint 12 Mo  D55T2LL
Non DWE Connector Value Unit Annual SW Maint Rnwl    E024ELL
Non DWE Connector Value Unit                         D55T3LL
 SW Maint Reinstate 12 Mo

IBM DB2 Warehouse

                                                     Part
Part description                                     number
 
IBM DB2 Warehouse Base Edition
DB2 Warehouse Base Edition Value                     D57U9LL
 Unit Lic and SW Maint 12 Mo
DB2 Warehouse Base Edition Value                     E02GULL
 Unit Annual SW Maint Rnwl
DB2 Warehouse Base Edition Value                     D57UALL
 Unit SW Maint Reinstate 12 Mo
DB2 Warehouse Base Ed VU fr DB2                      D60JULL
 ESE VU Trdup Lic and SW Maint 12 Mo
DB2 Warehouse Base Ed Value Unit fr DB2              D60JVLL
 Int VU Trdup Lic and SW Maint 12 Mo

IBM DB2 Warehouse

                                                     Part
Part description                                     number
 
IBM DB2 Warehouse Developer Edition
DB2 Warehouse Developer Edition Authorized           D59QFLL
 
 Users Lic and SW Maint 12 Mo
DB2 Warehouse Developer Edition Authorized           E033KLL
 Users Annual SW Maint Rnwl
DB2 Warehouse Developer Edition Authorized           D59QILL
 Users SW Maint Reinstate 12 Mo

IBM DB2 Warehouse

                                                     Part
Part description                                     number
 
IBM DB2 Warehouse Starter Edition
DB2 Warehouse Starter Edition Authorized             D601YLL
 Users Lic and SW Maint 12 Mo
DB2 Warehouse Starter Edition Authorized             E037KLL
 Users Annual SW Maint Rnwl
DB2 Warehouse Starter Edition Authorized             D601ZLL
 Users SW Maint Reinstate 12 Mo
DB2 Warehouse Starter Edition                        D601WLL
 Value Unit Lic and SW Maint 12 Mo
DB2 Warehouse Starter Edition                        E037JLL
 Value Unit Annual SW Maint Rnwl
DB2 Warehouse Starter Edition Value                  D601XLL
 Unit SW Maint Reinstate 12 Mo

IBM DB2 Warehouse

                                                     Part
Part description                                     number
 
IBM DB2 Warehouse Intermediate Edition
DB2 Warehouse Intermediate Edition Authorized        D601QLL
 Users Lic and SW Maint 12 Mo
DB2 Warehouse Intermediate Edition Authorized        E037ELL
 Users Annual SW Maint Rnwl
DB2 Warehouse Intermediate Edition Authorized        D601RLL
 Users SW Maint Reinstate 12 Mo
DB2 Warehouse Intermediate Edition                   D601NLL
 Value Unit Lic and SW Maint 12 Mo
DB2 Warehouse Intermediate Edition                   E037DLL
 Value Unit Annual SW Maint Rnwl
DB2 Warehouse Intermediate Edition                   D601PLL
 Value Unit SW Maint Reinstate 12 Mo
DB2 Warehouse Intermediate Ed VU fr DB2 Warehouse    D60HALL
 Starter Ed VU Trdup Lic and SW Maint 12 Mo
DB2 Warehouse Intermediate Ed VU fr DB2              D60H9LL
 Workgroup VU Trdup Lic and SW Maint 12 Mo

IBM DB2 Warehouse

                                                     Part
Part description                                     number
 
 
IBM DB2 Warehouse Advanced Edition
DB2 Warehouse Advanced Edition                       D6023LL
 Value Unit Lic and SW Maint 12 Mo
DB2 Warehouse Advanced Edition                       E037NLL
 Value Unit Annual SW Maint Rnwl
DB2 Warehouse Advanced Edition Value                 D6024LL
 Unit SW Maint Reinstate 12 Mo
DB2 Warehouse Advanced Edition VUfr DB2 Warehouse    D60JGLL
 Intermediate VU Trdup LIC and SW Maint 12 Mo

IBM DB2 Warehouse

                                                     Part
Part description                                     number
 
IBM Alphablox Add-in
Alphablox Add-in Value Unit Lic and SW Maint 12 Mo   D6020LL
Alphablox Add-in Value Unit Annual SW Maint Rnwl     E037LLL
Alphablox Add-in Value Unit SW Main Reinstate 12 Mo  D6021LL

Passport Advantage supply

                                                     Part
Program name/description                             number
 
DB2 DW Advanced Edition V9.5.0
DB2 Warehouse Advanced Edition                       BB006ML
DB2 DW Base Edition V9.5.0
DB2 Warehouse Base Edition Windows,                  BB0W1ML
 AIX, Linus, Solaris, HP-UX
DB2 DW Developer Edition V9.5.0
DB2 Warehouse Developer Edition                      BB0W2ML
DB2 DW Enterprise Edition V9.5.0
DB2 Warehouse Enterprise Edition                     BB0W0ML
 Windows, AIX, Linux, Solaris, HP-UX
DB2 DW Intermediate Edition V9.5.0
DB2 Warehouse Intermediate Edition                   BB005ML
DB2 DW Starter Edition V9.5.0
DB2 Warehouse Starter Edition                        BB004ML

Passport Advantage customer: Media pack entitlement details

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

IBM DB2 Warehouse Enterprise Edition V9.5.0

Entitled maintenance   Media packs                   Part
offerings description  description                   number
 
IBM DB2 Warehouse      IBM DB2 Warehouse             BB0W0ML
 Enterprise Edition     Enterprise Edition,
 Value Unit             (Multilingual English,
                        French, Korean, Chinese --
                        Simplified, Spanish,
                        Portuguese-Brazilian,
                        German, Japanese, Chinese
                        -- Traditional, Italian)
                        Windows, AIX, Linux,
                        Solaris, HP-UX DVD -- ISO
                        9660 Standard
 
IBM DB2 Warehouse      IBM DB2 Warehouse             BB0W0ML
 Enterprise Edition     Enterprise Edition,
 Value Unit             (Multilingual English,
 SubCapacity            French, Korean, Chinese --
                        Simplified, Spanish,
                        Portuguese-Brazilian,
                        German, Japanese, Chinese
                        -- Traditional, Italian)
                        Windows, AIX, Linux,
                        Solaris, HP-UX, DVD -- ISO
                        9660 Standard
 
Non-DWE Connector      IBM DB2 Warehouse             BB0W0ML
 Value Unit             Enterprise Edition,
                        (Multilingual English,
                        French, Korean, Chinese --
                        Simplified, Spanish,
                        Portuguese-Brazilian,
                        German, Japanese, Chinese
                        -- Traditional, Italian)
                        Windows, AIX, Linux,
                        Solaris, HP-UX, DVD -- ISO
                        9660 Standard

IBM DB2 Warehouse Intermediate Edition V9.5.0

Entitled maintenance   Media packs                   Part
offerings description  description                   number
 
IBM DB2 Warehouse      IBM DB2 Warehouse             BB005ML
 Intermediate Edition   Intermediate Edition
 Authorized User        (Multilingual English,
                        French, Korean, Chinese --
                        Simplified, Spanish,
                        Portuguese-Brazilian,
                        German, Japanese, Chinese
                        -- Traditional, Italian)
                        Windows, AIX, Linux,
                        Solaris, HP-UX, DVD -- ISO
                        9660 Standard
 
IBM DB2 Warehouse      IBM DB2 Warehouse             BB005ML
 Intermediate Edition   Intermediate Edition
 Value Unit             (Multilingual English,
                        French, Korean, Chinese --
                        Simplified, Spanish,
                        Portuguese-Brazilian,
                        German, Japanese, Chinese
                        -- Traditional, Italian)
                        Windows, AIX, Linux,
                        Solaris, HP-UX, DVD -- ISO
                        9660 Standard

IBM DB2 Starter Edition V9.5.0

Entitled maintenance   Media packs                   Part
offerings description  description                   number
 
IBM DB2 Starter        IBM DB2 Starter Edition       BB004ML
 Edition Authorized     (Multilingual English,
 User                   French, Korean, Chinese --
                        Simplified, Spanish,
                        Portuguese-Brazilian,
                        German, Japanese, Chinese
                        -- Traditional, Italian)
                        Windows, AIX, Linux,
                        Solaris, HP-UX, DVD -- ISO
                        9660 Standard
 
IBM DB2 Starter        IBM DB2 Starter Edition       BB004ML
 Edition Value Unit     (Multilingual English,
                        French, Korean, Chinese --
                        Simplified, Spanish,
                        Portuguese-Brazilian,
                        German, Japanese, Chinese
                        -- Traditional, Italian)
                        Windows, AIX, Linux,
                        Solaris, HP-UX, DVD -- ISO
                        9660 Standard

IBM DB2 Developer Edition V9.5.0

Entitled maintenance   Media packs                   Part
offerings description  description                   number
 
IBM DB2 Warehouse      IBM DB2 Developer Edition     BB0W2ML
Developer Edition      (Multilingual English,
Authorized User        French, Korean, Chinese --
                       Simplified, Spanish,
                       Portuguese-Brazilian,
                       German, Japanese, Chinese
                       -- Traditional, Italian)
                       Windows, AIX, Linux,
                       Solaris, HP-UX, DVD -- ISO
                       9660 Standard

IBM DB2 Advanced Edition V9.5.0

Entitled maintenance   Media packs                   Part
offerings description  description                   number
 
IBM DB2 Advanced       IBM DB2 Advanced Edition      BB006ML
Edition Value Unit     (Multilingual English,
                       French, Korean, Chinese --
                       Simplified, Spanish,
                       Portuguese-Brazilian,
                       German, Japanese, Chinese
                       -- Traditional, Italian)
                       Windows, AIX, Linux,
                       Solaris, HP-UX, DVD -- ISO
                       9660 Standard

IBM DB2 Warehouse Base Edition V9.5.0

Entitled maintenance   Media packs                   Part
offerings description  description                   number
 
IBM DB2 Warehouse      IBM DB2 Warehouse Base        BB0W1ML
 Base Edition Value     Edition (Multilingual
 Unit                   English, French, Korean,
                        Chinese -- Simplified,
                        Spanish,
                        Portuguese-Brazilian,
                        German, Japanese, Chinese
                        -- Traditional, Italian)
                        Windows, AIX, Linux,
                        Solaris, HP-UX, DVD -- ISO
                        9660 Standard
 
Non-DWE Connector      IBM DB2 Warehouse Base        BB0W1ML
 Value Unit             Edition (Multilingual
                        English, French, Korean,
                        Chinese -- Simplified,
                        Spanish,
                        Portuguese-Brazilian,
                        German, Japanese, Chinese
                        -- Traditional, Italian)
                        Windows, AIX, Linux,
                        Solaris, HP-UX, DVD -- ISO
                        9660 Standard

Sub-capacity

IBM DB2 Warehouse Enterprise Edition

Part
number              Part description
 
E02GWLL             DB2 Data Warehouse Enterprise Ed SubCap
                     Value Unit Annual SW Maint Rnwl
D57UFLL             DB2 Data Warehouse Enterprise Ed SubCap
                     Value Unit Lic and SW Maint 12 Mo
D57UGLL             DB2 Data Warehouse Enterprise Ed SubCap
                     Value Unit SW Maint Reinstate 12 Mo

Sub-capacity for selected middleware products

Sub-capacity licensing on a per processor or per Value Unit basis is available for selected middleware products. To offer sub-capacity licensing, IBM software products implement IBM Tivoli License Compliance Manager within their offerings so that you can monitor and report quarterly to IBM on the use of the programs on a continuous basis.

More information can be found on the Passport Advantage Web site

Eligibility requirements for sub-capacity licensing

To be eligible for sub-capacity licensing terms on this product, you must agree to install and configure IBM Tivoli License Manager for IBM Software, in accordance with the IBM Tivoli License Manager publications, and to enable the collection of program use data on all eligible machines subject to sub capacity terms.

For those machines running programs with sub-capacity licensing terms, you must use IBM Tivoli License Manager for IBM Software to monitor program use and submit to IBM an IBM Use Report each calendar quarter. Multiple copies of IBM Tivoli License Manager for IBM Software or IBM Tivoli License Manager are not required. You can use more copies if you need them to support your operational environment, but only one copy is required to monitor all your sub capacity licensed products.

Additionally, if this is the first product you have licensed under sub-capacity terms, you must agree to the terms of an attachment to your Passport Advantage or Passport Advantage Express contract and submit a new Passport Advantage enrollment form. First-time sub-capacity clients also have an opportunity to ensure a primary business contact is established for their contracts.

For more information on required and entitled license capacity, license requirements, and reporting, refer to Software Announcement 205-093 , dated April 19, 2005.

If you order (this product) under sub-capacity terms, IBM Tivoli License Manager for IBM Software will be made available to you if you do not already have one. You must install and configure this tool for your sub-capacity products. Alternately, you can use Tivoli License Manager. Once the license manager software is installed, you will be required to register online. (IBM may need to contact you in order to finalize the registration process.) You must monitor program use on a continuous basis with an IBM Tivoli License Manager for IBM Software and submit IBM Use Reports to IBM on a calendar quarterly basis.

IBM Tivoli License Manager for IBM Software is documented in the following customer publications, which are available from IBM Publications Center at

Publication                                        Form
 
Planning, Installation, and Configuration          SC32-1431
Administration                                     SC32-1430
Problem Determination                              SC32-9102
Data Dictionary                                    SC32-1432
Release Notes                                      SC32-1429

For IBM Tivoli License Manager configuration guidance and instructions for specific products (including this product) acquired with sub capacity terms, refer to

The Web site will give you information about how to set up the product for detection by IBM Tivoli License Manager, any required maintenance, and any required steps that are unique to this product.

On/Off Capacity on Demand (CoD)

IBM DB2 Warehouse Enterprise Edition

                                                     Part
Part description                                     number
 
IBM DB2 Warehouse Enterprise Edition Proc            D53ZLLL
 day Per Use-Day, OOCoD Temp Use Charge

IBM Non-DWE (Data Warehouse Edition) Connector

                                                     Part
Part description                                     number
 
Non-DWE Connector Proc day Per                       D54XCLLL
 Use-Day, OOCoD Temp Use Charge

 
Back topBack to top
 
Terms and conditions

The information provided in this announcement letter is for reference and convenience purposes only. The terms and conditions that govern any transaction with IBM are contained in the applicable contract documents such as the IBM International Program License Agreement, IBM International Passport Advantage Agreement, and the IBM Agreement for Acquisition of Software Maintenance.

Licensing: IBM International Program License Agreement including the License Information document and PoE govern your use of the program. 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.

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 Warehouse Starter Edition       5724-E34   L-SVAY-74DSHH
DB2 Warehouse Intermediate Edition  5724-E34   L-SVAY-74DSHK
DB2 Warehouse Advanced Edition      5724-E34   L-SVAY-74DSHL
DB2 Warehouse Base Edition          5724-E34   L-SVAY-74DSHM
DB2 Warehouse Enterprise Edition    5724-E34   L-SVAY-74DSHP
DB2 Warehouse Developer Edition     5724-E34   L-SVAY-74DSHQ

On or near the planned availability date, the License Information will be available for review on the IBM Software License Agreement Web site

Limited warranty applies: Yes

Warranty: IBM warrants that when the program is used in the specified operating environment, it will conform to its specifications. The warranty applies only to the unmodified portion of the program. IBM does not warrant uninterrupted or error-free operation of the program or that IBM will correct all program defects. You are responsible for the results obtained from the use of the Program.

IBM provides you with access to IBM databases containing information on known program defects, defect corrections, restrictions, and bypasses at no additional charge. Consult the IBM Software Support Guide for further information at

IBM will maintain this information for at least one year after the original licensee acquires the program (warranty period).

Money-back guarantee: If for any reason you are dissatisfied with the program and you are the original licensee, you may obtain a refund of the amount you paid for it, if within 30 days of your invoice date you return the program and its PoE to the party from whom you obtained it. If you downloaded the program, you may contact the party from whom you acquired it for instructions on how to obtain the refund.

For programs acquired under the IBM International Passport Advantage Agreement, this term applies only to your first acquisition of the program. For programs acquired under any of IBM's On/Off CoD software offerings, this term does not apply since these offerings apply to programs already acquired and in use by you.

Authorization for use on home/portable computer: The program may be stored on the primary machine and another machine, provided that the program is not in active use on both machines at the same time. You may not copy and use this program on another computer without paying additional license fees.

Product name
 
DB2 Warehouse Enterprise Edition             No

Usage restriction: Yes

For a complete copy of the enclosed license with all of the detail information regarding usage restrictions of the DB2 Warehouse products refer to the License Information Document that is available on the IBM Software License Agreement Web site

International Passport Agreement

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

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

Agreement for Acquisition of Software Maintenance

The following agreement applies for maintenance and does not require customer signatures:


    IBM Agreement for Acquisition of Software Maintenance (Z125-6011)

Software Maintenance applies: Yes. Software Maintenance is included with licenses purchased through Passport Advantage and Passport Advantage Express. Product upgrades and technical support are provided by the Software Maintenance offering as described in the Agreements. Product upgrades provide the latest versions and releases to entitled software and Technical Support provides voice and electronic access to IBM support organizations, worldwide.

IBM includes one year of Software Maintenance with each program license acquired. The initial period of Software Maintenance can be extended by the purchase of a renewal option, if 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, 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, 7 days a week. 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 the applicable agreements.

For additional information about the International Passport Advantage Agreement and the IBM International Passport Advantage Express Agreement, visit the Passport Advantage Web site at

Other terms

Volume orders (IVO): No

System i Software Maintenance applies: No

Educational allowance available: Not applicable.

On/Off CoD

To be eligible for On/Off CoD 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 has transformed its delivery of hardware and software support services to help you achieve higher system availability. Electronic Services is a Web-enabled solution that offers an exclusive, no-additional-charge enhancement to the service and support available for IBM servers. These services are designed to provide the opportunity for greater system availability with faster problem resolution and preemptive monitoring. Electronic Services comprises two separate, but complementary, elements: Electronic Services news page and Electronic Services Agent.

The Electronic Services news page is a single Internet entry point that replaces the multiple entry points traditionally used to access IBM Internet services and support. The news page enables you to gain easier access to IBM resources for assistance in resolving technical problems.

The Electronic Service Agent™ is no-additional-charge software that resides on your server. It monitors events and transmits system inventory information to IBM on a periodic, client-defined timetable. The Electronic Service Agent automatically reports hardware problems to IBM. Early knowledge about potential problems enables IBM to deliver proactive service that may result in higher system availability and performance. In addition, information collected through the Service Agent is made available to IBM service support representatives when they help answer your questions or diagnose problems. Installation and use of IBM Electronic Service Agent for problem reporting enables IBM to provide better support and service for your IBM server.
 
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

Business Partner information

If you are an IBM Business Partner — Distributor for Workstation Software acquiring products from IBM, you may link to Passport Advantage Online for resellers where you can obtain Business Partner pricing information. An IBM ID and password are required.

IBM Global Financing

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

IBM Global Financing offerings are provided through IBM Credit LLC in the United States, and other IBM subsidiaries and divisions worldwide to qualified commercial and government customers. Rates are based on a customer's credit rating, financing terms, offering type, equipment type, and options, and may vary by country. Other restrictions may apply. Rates and offerings are subject to change, extension, or withdrawal without notice.
 
Back 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:   callserv@ca.ibm.com
 Mail:       IBM Teleweb Customer Support
             ibm.com Sales Execution Center, Americas North
             3500 Steeles Ave. East, Tower 3/4
             Markham, Ontario
             Canada
             L3R 2Z1
 
 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, System z, POWER, System p, System i, IBMLink, iSeries, and Electronic Service Agent are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, Cube Views, Passport Advantage, WebSphere, AIX, Tivoli, Lotus, Notes, pSeries, and PartnerWorld are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Intel is a registered trademark of Intel Corporation.
 
Windows is a trademark of Microsoft Corporation.
 
UNIX is a registered trademark of the Open Company in the United States and other countries.
 
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