IBM United States
Software Announcement 201-157
May 15, 2001

IBM DB2 Warehouse Manager for iSeries — Business Intelligence Infrastructure — Upgraded to Version 7 Release 2

 ENUS201-157.PDF (51KB)

(Corrected on June 12, 2001)

Changes were made to the following sections: Software Requirements, changed second bullet; Technical Limitations, added a third bullet on warehouse function; Ordering Information, deleted one part number and added others; and changed IBM Operational Support Services — Support Line to "Yes".

At a Glance

DB2 Warehouse Manager for iSeries Version 7 Release 2 introduces the following key enhancements:

  • Data Warehouse Center
  • Star Schema Builder
  • Process Modeler
  • Enhanced support for creating and changing warehouse target tables
  • Mandatory fields
  • New warehouse sources
  • Microsoft OLE DB and Data Transaction Services support

For ordering, contact:

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

Overview

DB2® Warehouse Manager for iSeries Version 7 Release 2 gives you flexible, easy-to-use tools and techniques for building, maintaining, managing, and accessing your data warehouse. It provides an infrastructure upon which packaged business intelligence applications and tools can be built. DB2 Warehouse Manager for iSeries simplifies and speeds warehouse prototyping, development, and deployment.

Data warehousing is the foundation for business intelligence and customer relationship management. To leverage your data effectively, DB2 Warehouse Manager can help you:

  • Translate your business users' needs into workable data models
  • Build an easily accessible data warehouse that continually draws on diverse application and data sources including DB2, Oracle, Sybase, Informix, Microsoft™ SQL Server, flat file, ODBC, and OLE DB
  • Maintain warehouse responsiveness to changing user needs in an ad hoc query environment

DB2 Warehouse Manager for iSeries will provide you with better:

  • Data scalability of the Data Warehouse Center with point-to-point data movement options for distributed systems
  • User scalability by providing governing functions to manage query workloads
  • Management of the warehouse via resource and usage tracking
  • End-user access through an information catalog
  • Faster deployment via common, pre-built warehouse and statistical transformations
  • Enterprise reporting to develop and deliver reports to unlimited clients
  • Pre-built programs to build, load, and calculate OLAP cubes for DB2 OLAP Server™ for AS/400®

The DB2 Warehouse Manager for iSeries also gives you pre-built transformers for statistical functions and warehouse transformations that will relieve your staff from programming these powerful functions, saving valuable time, resource, and development testing.

DB2 Warehouse Manager for iSeries includes:

  • Data Warehouse Center (creates, schedules, and manages data warehouses)
  • AS/400 Agent (manages the flow of data between the data sources and the target warehouses)
  • Information Catalog Manager (helps end users find, understand, and access available information)
  • QMF™ for Windows® (a multipurpose query, reporting, and table editing tool)
  • DB2 Universal Database® (UDB) Enterprise Edition Version 7.2 (limited-use license)

Key Prerequisites

iSeries V4R4, or later

For details, refer to the Hardware Requirements and Software Requirements sections.

Planned Availability Date

June 8, 2001

Description

You Can Start Data Warehousing Today

Data warehousing is the foundation for business intelligence and customer relationship management — so it's important to do it correctly. That means:

  • Accurately translating your business users' needs into workable data models
  • Building an easily accessible data warehouse that continually draws on diverse application and data sources
  • Maintaining a warehouse that is responsive to changing user needs in an ad hoc query environment

If you're thinking you don't have the time or resources to handle that, DB2 Warehouse Manager for iSeries Version 7 Release 2 can help. It provides a rich graphical environment for creating and managing high-performance, scalable DB2 data warehouses — right from within your DB2 Control Center. Once you have your data warehouse in place, DB2 Warehouse Manager provides flexible, easy-to-use tools to access the data warehouse and to govern and track its usage.

DB2 Warehouse Manager for iSeries includes:

  • Data Warehouse Center
  • Information Catalog Manager
  • QMF for Windows
  • AS/400 Agent
  • DB2 UDB Enterprise Edition Version 7.2 (limited-use license)

Build and Manage from a Central Point-of-Control

Within the DB2 Control Center of DB2 UDB, you will find the Data Warehouse Center — the command console for warehouse management. This integration gives you a common environment to manage your database, your data warehouse, and the processes for building and maintaining your environment. From this common environment, your database administrators (DBAs) can:

  • Access multiple sources of data
  • Build warehouse extraction and transformation processes
  • Test processes
  • Analyze and monitor processes
  • Authorize users
  • Put data warehouses into production

A unique graphical environment in the Data Warehouse Center makes it easy for warehouse designers to specify over 150 built-in transformations and visualize the flow of the build process. This "flowchart" also gives designers a clear way to present the data warehouse to end users so they can verify it meets their business needs.

Transformers for Statistical Functions and Warehouse Management

The DB2 Warehouse Manager for iSeries provides transformers for statistics for functions such as ANOVA, Calculate statistics, Calculate Chi-square, Correlation, Moving average, and Regression. In addition, DB2 Warehouse Manager for iSeries provides transformers for warehouse transformations such as clean data, generate key table, generate period table, invert data, and pivot data. These standard transformations relieve your programming staff from programming these powerful functions, saving valuable time, resource, and development testing.

Integrate Data in Diverse Distributed Environments

As users realize the advantages of your data warehouse, they will inevitably use it more and expect it to offer increasingly sophisticated levels of information. With DB2 Warehouse Manager, you can build data warehouses that grow and change with your business and leverage more of your available information resources.

DB2 Warehouse Manager enhances the scalability of your data warehouse with a distributed warehouse agent for the iSeries operating environment. This agent executes the transformation and data movement requests, allowing the administrator to select the correct platform for transformation processes and enabling point-to-point, distributed, and parallel data movement.

The AS/400 Agent is a powerful tool, running natively on iSeries, which manages the flow of data between the data sources and target warehouses. It uses the DB2 CLI to communicate with different databases.

The Data Warehouse Center provides access to DB2, Oracle, Sybase, Informix, Microsoft SQL Server, flat file, ODBC, and OLE DB sources. It uses simple movement techniques to help you get started quickly and more advanced functions for incremental data movement.

As your data warehousing needs diversify, DB2 Warehouse Manager makes it easy to gain access to disparate data sources and populate dependent datamarts across distributed platforms from a centralized control point.

Simplify User Access

The DB2 Warehouse Manager and QMF for Windows for iSeries enable easy and reliable access to your data warehouse. QMF for Windows provides:

  • Easy yet powerful query, reporting, and updating functionality that supports novice to expert users
  • Easy distributed application enabling
  • Ability to share queries, report forms, and procedures across the enterprise

To extend business reporting capabilities to Windows clients or Web browsers, QMF for Windows:

  • Enables you to integrate query results with any OLE2 desktop tool including spreadsheets, report writers, and desktop databases
  • Launches Java™ SQL queries and publishes reports to the Web
  • Integrates with other products using command line parameters or its own powerful API

QMF for Windows supplies metadata that populates the Information Catalog with QMF for Windows queries and procedures, enabling these objects to be located and launched from within the Information Catalog.

DB2 Warehouse Manager also includes the Information Catalog that helps users find, understand, and access the data available to them so they can quickly make informed decisions using accurate data.

  • Administrators and users can register information directly in the catalog — such as spreadsheets, reports, queries, Web pages, or other relevant information they want to share.
  • The catalog can be populated via metadata interchange with popular OLAP, query, and desktop tools.
  • To access shared information, users can use a familiar search tool from a Windows or Web browser interface.

The Information Catalog also integrates with the IBM Enterprise Information Portal (EIP) providing access to structured and unstructured data through Web browsers.

Enable Controlled Warehouse Growth and Use

In addition to built-in governing in DB2 UDB, DB2 Warehouse Manager gives you complementary tools to govern and track warehouse access. You can take advantage of QMF for Windows governing for DB2 for iSeries databases.

With the growing number of users and varying query requirements, the database administrator has a tough job protecting resources from runaway queries and tuning the database for optimum performance. These tools help data centers:

  • Govern users and queries to support a growing user base with diverse skills and needs
  • Manage resources by controlling workloads and setting access limits by user or group
  • Support charge-back accounting based on usage
  • Target performance tuning for the most-used tables and queries
  • Identify archival candidates to manage storage expenses

Leverage Metadata Standards to Deliver Integrated Solutions

A major challenge in data warehouse implementations is the integration of independent products to create a complete solution. One of the obstacles to integration has been the multiplicity of metadata formats. Used in data warehouses and numerous business intelligence tools, metadata informs users and DBAs about the characteristics and applicability of the data they are accessing.

To deliver this information efficiently in an integrated solution, the component tools must use standard metadata formats to communicate common information. Such standards help to:

  • Reduce systems integrator workload and expedite deployment
  • Provide more choice to customers in selecting products for their solution

Data Warehouse Center creates and manages data warehouses by easing the tasks of:

  • Registering and accessing data sources
  • Defining data extraction and transformation steps
  • Populating data warehouses
  • Automating and monitoring warehouse management processes
  • Managing and interchanging metadata

The new graphical user interface is integrated with the DB2 Control Center and offers full replacement, incremental, and replication style data movement options for flexibility in maintaining the data warehouse.

The Information Catalog Manager, previously provided with Visual Warehouse®, is now an integral component of DB2 Warehouse Manager. It helps end users find, understand, and access available information by:

  • Populating the catalog through metadata interchange with the Data Warehouse Center and other analytical and reporting tools
  • Allowing users to directly register shared information objects
  • Providing navigation or searching across the objects to find relevant information
  • Displaying the metadata about the object
  • Launching the tools used to render the information for the end user

QMF for Windows is included with the DB2 Warehouse Manager for iSeries to provide a multipurpose query tool for business reporting, data sharing, server resource protection, powerful application development, and native connectivity to DB2 for iSeries databases. It allows users to:

  • Build queries and reports easily via its quick start interface
  • Use the new Java-based query capability to launch queries from their favorite browser
  • Easily integrate query results with desktop tools such as spreadsheets and personal databases
  • Rapidly build data access and update applications
  • Fully exploit DB2 performance, SQL syntax, and advanced database performance techniques such as static SQL

Also, the Administrator component controls resource consumption by user group through detailed permissions by group, schedule, or both.

The AS/400 Agent is a powerful tool, running natively on the iSeries, which manages the flow of data between the data sources and the target warehouses. It uses the DB2 CLI to communicate with different databases.

New DB2 Warehouse Manager with Version 7 Release 2

Data Warehouse Center: The power of Visual Warehouse and the simplicity of the DB2 Control Center have been merged to provide a single, new user interface for business intelligence customers. You can use the Data Warehouse Center to:

  • Register and access data sources
  • Define data extraction and transformation steps
  • Populate data warehouses
  • Automate and monitor warehouse management processes
  • Manage and interchange metadata

The Warehouse launchpad simplifies the job of populating a warehouse by leading you through the related tasks.

The Data Warehouse Center supports full refresh and incremental update data movement options including leveraging the power of IBM's integrated data replication functions. Integrated SQL Assist capabilities help customers define over 100 transformations using the rich SQL available with DB2.

Star Schema Builder: Within the Data Warehouse Center, the warehouse schema modeler is a specialized tool for generating and storing schema associated with a data warehouse. Any schema resulting from this process can be passed easily as metadata to the OLAP Integration Server, which is part of the OLAP Starter Kit and the DB2 OLAP Server.

Process Modeler: The Process Modeler allows users to graphically link the steps needed to build and maintain data warehouses and dependent datamarts. Dependency relationships, conditional processing, and notifications can all be included in the model. Processes can be scheduled for one-time or repeated execution, or can be triggered by internal or external processes.

Enhanced Support for Creating and Changing Warehouse Target Tables: With DB2 Version 7 Release 2, the Data Warehouse Center provides additional flexibility for creating and changing warehouse target tables. When a change to a warehouse step creates additional columns, you can have the Data Warehouse Center create automatically the new columns in the target table and map the results of the step to these new columns. You can also now choose the name and table space for the target table.

Mandatory Fields: The Data Warehouse Center now displays red borders on required fields. The red borders alert you to information such as database names, user IDs, or passwords necessary to define the Data Warehouse Center objects. When you enter the required information, the borders disappear.

New Warehouse Sources: With DB2 Version 7 Release 2, you can access many new and diverse warehouse sources. New warehouse data sources include Microsoft OLE DB objects and Microsoft Data Transaction Services packages.

Microsoft OLE DB and Data Transaction Services Support: The Data Warehouse Center now enables you to access data from an OLE DB provider as a DB2 database view. A wizard is provided to create a DB2 OLE DB table function and the DB2 view through which you can access the data. Because Data Transaction Services (DTS) packages can be accessed as OLE DB sources, the wizard also allows you to create the view for a DTS package. When you access the view at run time, the DTS package executes and populates the target table of the DTS.

Trademarks

 
iSeries, DB2 OLAP Server, and QMF are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, AS/400, DB2 Universal Database, and Visual Warehouse are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Microsoft is a trademark of Microsoft Corporation.
 
Windows is a registered trademark of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
Other company, product, and service names may be trademarks or service marks of others.

Education Support

For information on the types and availability of training, visit the Web at:

The appropriate curriculum will include the enhancements described in this announcement.

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

Offering Information

Product information is available through Offering Information (OITOOL) at:

Publications

The following publications can be ordered from IBM after June 8, 2001. To order, contact your IBM representative.

                                                       Order
Title                                                  Number
 
DB2(R) UDB Data Warehouse Center                       SC26-9993
  Administration Guide V7
DB2 UDB Data Warehouse Center                          SC26-9994
  Application Integration Guide V7
DB2 UDB Warehouse Manager Information                  SC26-9995
  Catalog Manager Administration
  Guide V7
DB2 UDB Warehouse Manager Information                  SC26-9996
  Catalog Manager User's Guide V7
DB2 UDB Warehouse Manager Information                  SC26-9997
  Catalog Manager Programming Guide
  and Reference V7
DB2 UDB Warehouse Manager Installation                 SC26-9998
  Guide V7

You can also order the above from the Publications Web page at:

The Publication Notification System (PNS) is available by order number/product number. Customers currently subscribing to PNS will automatically receive notifications by e-mail. Customers who want to subscribe, can visit the PNS Web site location at:

The IBM Publications Center Portal:

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, as well as payment options via credit card. Furthermore, a large number of publications are available online in various file formats, which can currently be downloaded free of charge.

Note that PNS subscribers most often order their publications via the Publication Center.

Note: QMF™ for Windows® publications provide multiplatform support, including QMF for iSeries. In addition, a booklet specific to QMF for iSeries is available from the QMF Web site at:

It is recommended that customers download this booklet.

Publications for DB2 UDB are included in softcopy form on the CD-ROM as part of the install image. To assist with the initial installation, a DB2 for Windows Quick Beginnings book is also provided in hardcopy within the product box.

The displayable manuals can be viewed using an HTML browser installed on your system, or by using the Netscape Navigator browser provided.

There is also a separate publications CD-ROM where PDF versions of the library can be viewed or printed.

Technical Information

Hardware Requirements

Server hardware requirements are those required to run DB2 for iSeries (V4R4, or later).

Workstation hardware requirements are those needed to run the Windows software as described in the Software Requirements section.

The following table shows applicable, recommended minimum disk space for a typical installation in megabytes (MB). The actual space required may vary depending on the customers' file system and the components installed. The numbers are for reference only.

                                      Windows NT(R)/
                                       Windows 2000
 
DB2 Warehouse Manager                   175 MB(1)
DB2 UDB Enterprise Edition              245 MB(2)
DB2 Clients
  Administrative Client                   125 MB
  Run-time Clients                        25 MB
  Application Development               325 MB(3)
Transformers                              12 MB
1
Includes ICM tools, Administration, User, and Agents
2
Includes documentation, administration tools, and JRE
3
Includes JDK

For more information, refer to the Hardware Requirements section in Software Announcement 201-128 , dated April 24, 2001.

Software Requirements

The DB2 Warehouse Manager for iSeries (5724-B08) uses the warehouse server component of DB2 UDB Enterprise Edition Version 7.2, which runs on 32-bit platforms as follows:

  • Windows NT (requires Version 4 with SP5, or later)
  • Windows 2000 (no prerequisite requirement)

The DB2 Warehouse Manager for iSeries (5724-B08) uses the warehouse administrative client component of DB2 UDB Enterprise Edition Version 7.2, which runs on 32-bit platforms as follows:

  • Windows NT (requires Version 4 with SP5, or later)
  • Windows 95 (requires Version 4.00.950, or later)
  • Windows 98 (no prerequisite requirement)
  • Windows 2000 (no prerequisite requirement)
  • Windows Me (no prerequisite requirement)
  • AIX® (Version 4.2.1, or later)
  • Sun Solaris (Version 2.6, or later)

Notes

  • The AS/400® Agent contained in the DB2 Warehouse Manager requires iSeries V4R5 for full function (JAVA stored procedures).
  • Visual Warehouse® Versions 3.1 and 5.2 cannot be used with the Data Warehouse Center or the Warehouse Manager. Visual Warehouse products will be uninstalled when DB2 UDB Version 7 products are installed.

For more information, refer to the Software Requirements section in Software Announcement 201-128 , dated April 24, 2001.

Limitations

License Limitations: The following license limitations exist within the DB2 UDB Version 7 Release 2 product:

  • A copy of DB2 UDB Enterprise Edition is provided with the DB2 Warehouse Manager for iSeries under restricted use terms. This database is supplied for the internal use of DB2 Warehouse Manager administrative functions.
  • The intent is not to provide a general-use database for customer storage of enterprise data nor for the building of applications to store/retrieve/query data. Customers who require a general-use database for the storage and access of their enterprise data are required to upgrade to a full licensed DB2 UDB product.
  • When the Warehouse Server component of the DB2 UDB Server is installed, a DB2 UDB for NT server of the same edition as the purchased license is also installed with a restricted use license. You are entitled to use this DB2 server on NT to manage one or more of the following types of data:
    • Warehouse Control database
    • Information Catalog database
    • Sample databases created by DB2 UDB Version 7 products or components

Technical Limitations

  • Connectivity restrictions: DRDA® support requires iSeries V4R3, or later, for TCP/IP support to DB2/iSeries.
  • The Data Warehouse Center requires a Warehouse Server component, which is available only on Windows NT and Windows 2000.
  • The warehouse function in DB2 UDB Version 7.2 (including DB2 Warehouse Manager Version 7.2) can be distributed across many platforms, including Windows NT/2000, AIX, Sun Solaris, OS/2, AS/400, and OS/390. All warehouse components must be at the same service level as the Data Warehouse Center and the warehouse server. For example, the AS/400 agent component of DB2 Warehouse Manager Version 7.2 will not operate with the warehouse server component of DB2 Version 7.1 FixPack 2a.

Planning Information

DB2 UDB Enterprise Edition does not restrict access to local DB2 server data through user counting, although customers are required to obtain user entitlements for host connectivity with these two products.

DB2 Warehouse Manager for AS/400, Version 7 Release 1 customers with AS/400 subscription are entitled to free upgrade to DB2 Warehouse Manager for iSeries, Version 7 Release 2, and will receive their upgrades automatically after product availability.

Customer Responsibilities: Installation and support for these products on all supported platforms is provided for a fee by IBM Global Services under the Personal System Support Family organization at 800-237-5511. For information or prices related to a SupportLine Technical Support contact, call 800-426-4343. To speak to an IBM representative about personal systems software, call 800-426-4968.

Informal support can be found on the Web at:

All support or advice provided through the Web is provided on an as-is basis.

Direct Customer Support: Direct customer support is provided by IBM Operational Support Services — Support Line. This fee service enhances customers' productivity by providing voice and electronic access into the IBM support organization. IBM Operational Support Services — Support Line will help answer questions pertaining to usage, and suspected software defects for eligible products.

Installation and technical support is provided by Global Services. For more information call, 800-IBM-4YOU (426-4968).

Packaging: DB2 Warehouse Manager for iSeries Version 7 Release 2 is shipped with all required information for its operation.

  • Publications
    • IBM DB2 UDB Data Warehouse Center Administration Guide
    • IBM DB2 Warehouse Manager Installation Guide
    • IBM DB2 Warehouse Manager Information Catalog Manager Administration Guide
    • Installing and Managing QMF for Windows
    • Getting Started With QMF for Windows
  • Media
    • Warehouse Manager for AS/400 Agent & Transformers CD-ROM
    • DB2 UDB Enterprise Edition Version 7.2 CD-ROM
    • QMF for Windows for AS/400, Version 7.1 CD-ROM
    • PDF Pubs CD-ROM
  • Mechanicals
    • IPLA booklet
    • IPLA pointer sheet
    • Proof of Entitlement
    • Warehouse Manager License Information booklet
    • Service flyer
    • QMF for Windows Version 7 Release 2 package
    • DB2 UDB Enterprise Edition Version 7 Release 2 package

This program when downloaded from a Web site, contains the applicable IBM license agreement, and License Information (LI), if appropriate and will be presented for acceptance at the time of installation of the program. The license and LI will be stored in a directory such as LICENSE.TXT for future reference.

Security, Auditability, and Control

DB2 Warehouse Manager uses the security and auditability features of the iSeries operating system.

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

Ordering Information

DB2 Warehouse Manager is a client server product that has a single charge unit: processor.

                                                  Part
Description                                       Number
 
DB2 Warehouse Manager for iSeries, Version 7.2    20P4323
  Program Package with 1 Processor English
DB2 Warehouse Manager for iSeries, Version 7.2    20P4327
  1 Processor PoE
DB2 Warehouse Manager for iSeries, Version 7.2    20P5835
  Net Delivery
 
Upgrades
 
DB2 Warehouse Manager for iSeries, Version 7.2    20P4325
  with 1 Processor Program Package
  Upgrade English
DB2 Warehouse Manager for iSeries, Version 7.2    20P4328
  Upgrade from Version 7.1 Processor PoE

Passport Advantage

 
                                                  Part
Description                                       Number
 
DB2 Warehouse Manager for iSeries,                BB7R9NA
  V7.2 Multi (non-AP) Media Pack
DB2 Warehouse Manager for iSeries,                BB7UVNA
  V7.2 Doc Pack English
 
Volume Purchase Options
 
VPO Instl DB2 WarehsMgr for                       D57WULL
  iSeries Process
VPO Instl/SW Sub DB2 WarehsMgr for                D57X7LL
  iSeries Process 1 Anniv
VPO Instl/SW Sub DB2 WarehsMgr for                D57X8LL
  iSeries Process 2 Anniv
VPO SW Sub Rnwl DB2 WarehsMgr for                 E17YRLL
  iSeries Process
VPO SW Sub DB2 WarehsMgr for                      D57YTLL
  iSeries Process 1 Anniv
 
                                                  Part
Description                                       Number
 
VPO SW Sub DB2 WarehsMgr for                      D57YVLL
  iSeries Process 2 Anniv
VPO Upgrade DB2 WarehsMgr for                     No SKU
  iSeries Process                                  Needed
 
Contract Options
 
CO Instl DB2 WarehsMgr for                        No SKU
  iSeries Process                                  Needed
CO Instl/SW Sub DB2 WarehsMgr for                 D57YWLL
  iSeries Process 1 Anniv
 
CO Instl/SW Sub DB2 WarehsMgr for                 D57YZLL
  iSeries Process 2 Anniv
CO SW Sub Rnwl DB2 WarehsMgr for                  E17Z0LL
  iSeries Process
CO Upgrade DB2 WarehsMgr for                      No SKU
  iSeries Process                                   Needed
CO SW Sub DB2 WarehsMgr for                       D57Z9LL
  iSeries Process 1 Anniv
CO SW Sub DB2 WarehsMgr for                       D57ZFLL
  iSeries Process 2 Anniv
 
CO Support Options
 
CO Supt DB2 WarehsMgr for iSeries                 No SKU
  Process 2 Anniv                                   Needed
CO Supt DB2 WarehsMgr for iSeries                 AT603LL
  Process 1 Anniv
CO Instl/SW Sub/Supt DB2 WarehsMgr for            D56LFLL
  iSeries Process 1 Anniv
CO Instl/SW Sub/Supt DB2 WarehsMgr for            D56LGLL
  iSeries Process 2 Anniv
CO SW Sub/Supt DB2 WarehsMgr for                  D56LHLL
  iSeries Process 1 Anniv
CO SW Sub/Supt Rnwl DB2 WarehsMgr for             E16LNLL
  iSeries Process
CO Instl/Supt DB2 WarehsMgr for                   No SKU
  iSeries Process 1 Anniv                           Needed

Terms and Conditions

Licensing: IBM International Program License Agreement. Proofs of Entitlement are required for all authorized use.

License Information Form Number: CT7B7ML

Limited Warranty: Yes

Program Services: Available until June 8, 2003

Money-Back Guarantee: Two-month, money-back guarantee

Copy and Use on Home/Portable Computer: No

Volume Orders (IVO): No

Passport Advantage Applies: Yes

Passport Advantage Subscription Applies: Yes

Upgrades: Customers can acquire upgrades up to the currently authorized level of use of the qualifying programs.

Usage Restriction: Yes

The following license limitations exist within the DB2 UDB Version 7 Release 2 product:

  • A copy of DB2 UDB Enterprise Edition is provided with the DB2 Warehouse Manager for iSeries under restricted use terms. This database is supplied for the internal use of DB2 Warehouse Manager administrative functions.
  • The intent is not to provide a general-use database for customer storage of enterprise data nor for the building of applications to store/retrieve/query data. Customers who require a general-use database for the storage and access of their enterprise data are required to upgrade to a full licensed DB2 UDB product.
  • When the Warehouse Server component of the DB2 UDB Server is installed, a DB2 UDB for NT server of the same edition as the purchased license is also installed with a restricted use license. You are entitled to use this DB2 server on NT to manage one or more of the following types of data:
    • Warehouse Control database
    • Information Catalog database
    • Sample databases created by DB2 UDB Version 7 products or components

The following technical limitations exist within the DB2 UDB Version 7 Release 2 product:

  • Connectivity restrictions: DRDA support requires iSeries Version 4 Release 3, or later, for TCP/IP support to DB2/iSeries.
  • The Data Warehouse Center requires a Warehouse Server component, which is available only on Windows NT and Windows 2000.

IBM Operational Support Services — Support Line: Yes

Other Support: Passport Advantage

AIX/UNIX® Upgrade Protection Applies: No

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

AS/400 Software Subscription Applies: No

Variable Charges Apply: No

Educational Allowance Available: Not applicable

Prices

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

                                    Part
Description                         Number             OTC(4)
 
DB2 Warehouse Manager               20P4323            $10,600
  for iSeries, Version 7.2
  Program Package
  with 1 Processor English
DB2 Warehouse Manager               20P4327             10,500
  for iSeries, Version 7.2
  1 Processor PoE
DB2 Warehouse Manager               20P5835             10,573
  for iSeries, Version 7.2
  Net Delivery
                                    Part
Description                         Number             OTC(4)
 
Upgrades
 
DB2 Warehouse Manager               20P4325             $5,300
  for iSeries, Version 7.2
  with 1 Processor
  Program Package
  Upgrade English
DB2 Warehouse Manager               20P4328              5,250
  for iSeries, Version 7.2
  Upgrade from Version 7.1
  1 Processor PoE
4
One-time charge

Contact your sales channel for IBM Operational Support Services — Support Line pricing information.

Customer Financing: IBM Global Financing offers attractive financing to credit-qualified commercial and government customers and Business Partners in more than 40 countries. IBM Global Financing is provided by the IBM Credit Corporation in the United States. Offerings, rates, terms, and availability may vary by country. Contact your local IBM Global Financing organization. Country organizations are listed on the Web at:

Order Now

 Use Priority/Reference Code: AE001
 
 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@us.ibm.com
 Mail:      IBM Atlanta Sales Center
            Dept. AE001
            P.O. Box 2690
            Atlanta, GA  30301-2690

You can also contact your local IBM Business Partner or IBM representative. To identify them, call 800-IBM-4YOU.

Note: Shipments will begin after the planned availability date.

Trademarks

 
iSeries and QMF are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, AIX, AS/400, Visual Warehouse, and DRDA are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows and Windows NT are registered trademarks of Microsoft Corporation.
 
UNIX is a registered trademark is a registered trademark of the Open Company in the United States and other countries.
 
Other company, product, and service names may be trademarks or service marks of others.