IBM United States
Software Announcement 202-043
February 26, 2002

IBM DB2 Warehouse Manager for z/OS and OS/390: Revised Pricing Structure

 ENUS202-043.PDF (39KB)


Overview

The DB2® Warehouse Manager feature of the DB2 Universal Database® Server for OS/390® and z/OS™, V7 is now a separate program with one-time charges.

Key Prerequisites

  • DB2 for OS/390 V5, 6, or 7
  • Workstation with Windows NT® or Windows® 2000

Planned Availability Date

March 15, 2002

For ordering, contact:

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

Description

Warehouse Integration

DB2 Warehouse Manager for z/OS and OS/390 delivers a complete warehouse solution to use with your DB2 for OS/390. This new offering brings together the tools to build, manage, and access DB2 data warehouses. It is based on proven technologies enhanced to provide additional function and to provide tighter integration among the components. Provided in the DB2 Warehouse Manager for z/OS and OS/390, V7.2 are:

  • DB2 Warehouse Center, which is a GUI that integrates with the DB2 Control Center
  • Warehouse agent for the 390, which executes on behalf of the Data Warehouse Center and enables point-to-point data movement
  • Warehouse transformers, which are stored procedures or user-defined functions that provide commonly used transformations for building data warehouses
  • The Information Catalog, which helps end users find, understand, and access relevant information
  • DB2 Universal Database V7.2 Enterprise Edition (restricted use license)
  • OLAP Starter Kit, which provides integrated OLAP capability combined with the power of DB2

Use DB2 Warehouse Manager for z/OS and OS/390 to simplify and speed your warehouse prototyping, development, and deployment to production. Integration with the Information Catalog enables you to satisfy user requirements for finding, understanding, and accessing the right data.

DB2 Universal Database V7.2 Enterprise Edition: The data warehouse management infrastructure and OLAP Starter Kit are delivered as elements of DB2 UDB V7.2 Enterprise Edition. This copy of DB2 is included, with a restricted-use license, to permit delivery and utilization of the Windows-based components of the DB2 Warehouse Manager for OS/390.

Data Warehouse Center: The Data Warehouse Center gives you a graphical control facility, fully integrated with DB2 Control Center. Now you can more easily accomplish the diverse tasks of warehouse creation and management:

  • Registering and accessing data sources for your warehouse
  • Defining data extraction and data transformation steps
  • Directing the population of your data warehouses
  • Automating and monitoring the warehouse management processes
  • Managing your metadata utilizing standards-based metadata interchange

The Information Catalog: The Information Catalog helps end users to find, understand, and access information they need for making decisions. It:

  • Populates the catalog through metadata interchange with the DB2 Warehouse Center
  • Includes DB2 Warehouse Manager Agents for Windows NT, Windows 2000, Solaris, and AIX®

OS/390 Agents and Transformers: The warehouse agent for OS/390 executes OS/390-based processes on behalf of the Data Warehouse Center. It permits data to be processed in your OS/390 environment without the need to export it to an intermediate platform environment, allowing you to take full advantage of the power, security, reliability, and availability of DB2 and OS/390.

Warehouse transformers are stored procedures or user-defined functions that provide commonly used transformations for building data warehouses. These transformers provide complex transformations commonly used in warehouse development including:

  • Date manipulation
  • Data cleaning
  • Key generation
  • Statistical calculations

These transformers augment the rich transformations available with SQL built-in functions including:

  • String manipulation
  • Boolean operations
  • Mathematical calculations
  • Datatype conversions
  • Utility invocations

DB2 OLAP Starter Kit: The DB2 OLAP Starter Kit is a limited user license of DB2 OLAP Server™ and the OLAP Integration Server. Use it to quickly build and deploy OLAP applications in a Windows-based environment. The DB2 OLAP server for OS/390 is separately available. You can order and use it for OLAP applications to be run natively on OS/390.

Accessibility by People with Disabilities

The following features support use by people with disabilities:

  • Operation by keyboard alone
  • Optional font enlargement and high-contrast display settings
  • Screen readers and screen magnifiers tested for use by people with visual impairment
  • Speech recognition products tested for use by people with mobility impairment
  • Optional display of audio alerts for people with hearing impairment

Euro Currency

This program is not impacted by euro currency.

Value Unit Based Pricing

Value Unit based pricing will help to align the prices of these products to the principle of the PSLC pricing curve, which provides for a lower price per MSU (millions of service units per hour) for larger capacities.

There is also a price benefit when you grow your capacity. Additional capacity is based on the number of Value Units (MSUs) you have installed; for example, additional capacity will not be priced starting at the base with a higher price per unit but on the capacity that is already installed.

Note that Value Units of a given product cannot be exchanged, interchanged, or aggregated with Value Units of another product.

IPLA and Subscription and Support Considerations

IPLA licenses can be transferred from one machine to another within, but not limited to, an enterprise. The customer 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. It is the customer's 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.

Reference Information

Refer to the product DB2 Universal Database Server for OS/390 and z/OS, V7 — Software Announcement 201-054 , dated March 6, 2001.

Also refer to Software Withdrawal 902-038 , dated February 26, 2002, DB2 Warehouse Manager feature of DB2 Universal Database Server for OS/390 and z/OS, V7.

Trademarks

 
z/OS and DB2 OLAP Server are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, DB2 Universal Database, OS/390, and AIX 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.
 
Other company, product, and service names may be trademarks or service marks of others.

Education Support

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

No publications are shipped with this program.

Displayable Softcopy Documentation

The following can be accessed from the Internet:

Technical Information

Hardware Requirements

Intel®-based system configured to run Windows NT® or Windows® 2000.

Software Requirements

The DB2 Warehouse Manager for z/OS™ and OS/390® uses the warehouse server component of DB2 UDB Enterprise Edition V7 for Windows, which supports Microsoft™ Windows 2000 and Windows NT.

A restricted-use copy of DB2 UDB Enterprise Edition is provided in the DB2 Warehouse Manager for z/OS and OS/390 package to satisfy this functional dependency.

The DB2 Warehouse Manager for z/OS and OS/390 uses the warehouse administrative client component of DB2 UDB Enterprise Edition V7. The administrative client supports Windows, AIX®, and Sun Solaris operating environments. (For details, refer to Software Announcement 200-089 , dated April 18, 2000.)

Data Warehouse Center provides agents for OS/390. These agents require:

  • UNIX® Systems Services element of OS/390
  • DB2 Java™ stored procedure enablement

Data Warehouse Center can support target data warehouses that are built on any of the following DB2 for OS/390 versions:

  • DB2 UDB for OS/390 and z/OS, V7 (5675-DB2)
  • DB2 UDB for OS/390, Version 6 (5645-DB2)
  • DB2 for OS/390, Version 5 (5655-DB2)

Planning Information

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: The programs in this announcement are distributed with the following content:

  • Basic machine-readable material is on a 3480 tape cartridge
  • Program Directory (GI10846300)
  • Proof of Entitlement
  • IBM International Program License Agreement (IPLA)
  • License Information (GC27-1669-00)
  • DB2 Warehouse Manager Kit/CD V7R2 (L20P425500)
  • DB2 UDB EE Kit V7R2 (L20P526500)

Security, Auditability, and Control

DB2 Warehouse Manager for z/OS and OS/390, V7.2 uses the security and auditability features of the host system hardware and software.

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

Ordering Information

DB2 Warehouse Manager for z/OS and OS/390, V7.2 has a single charge unit of Value Units.

Subscription and Support for DB2 Warehouse Manager for z/OS and OS/390, V7.2 also has a single charge unit of Value Units.

Value Unit Exhibit VUE007

                                     Value               Value
 
                                     Units/              Units/
Usage Level       Minimum   Maximum   MSU     HW         Machine
 
Base                 1         3     1      MP3000 H30     6
PSLC / Level A       4        45     0.45   MP3000 H50     8
PSLC / Level B      46       175     0.36   MP3000 H70    12
PSLC / Level C     176       315     0.27   ESL Models     2
PSLC / Level D     316         +     0.2

The products in this announcement have one charge unit — Value Units.

Value Units for IBM 9672 processors will be based upon the full capacity of these systems. This is applicable to all S/390® based systems that are measured on MSU capacity. Information on MSU capacities can be found in the IBM System/370™, System/390®, and zSeries Machine Exhibit (Z125-3901).

Value Units for IBM e(logo)server zSeries will be based upon full MSU capacity as defined in the machine exhibits.

There will be a tool available that provides support for transforming the MSU based capacities of S/390 systems to new Value Units by calculating the applicable number of Value Units for a given number of MSUs.

Translation from MSUs to Value Units

            MSUs       Value Units/MSU
 
Base         1-3            1.00
Tier A       4-45            .45
Tier B      46-175           .36
Tier C     176-315           .27
Tier D     316+              .20

Note: For the actual translation from MSUs to Value Units for this product, see below.

Ordering Example: The total number of Value units is calculated according to the following example:

If you installed 1500 MSUs, the applicable Value Units would be:

            MSUs    *  Value Units/MSU  =  Value Units
 
Base          3     *      1.00         =      3.00
Tier A       42     *       .45         =     18.90
Tier B      130     *       .36         =     46.80
Tier C      140     *       .27         =     37.80
Tier D     1185     *       .20         =    237.00
 
Total      1500                              344

When calculating the total number of Value Units, round the sum up to the next integer.

                                       Feature
                                       Number
 
  1 Value Unit                         0001
250 Value Units                        0002

Example: For a product running on machines with 1500 MSUs requiring 344 Value Units, you would order feature number 0001, quantity 94, and feature number 0002, quantity 1.

Note: For actual feature numbers, see below.

Value Units for Non-MSU-Based S/390 Processors

MP3000 Models

H30                     =   6.00 Value Units
H50                     =   8.00 Value Units
H70                     =  12.00 Value Units
 
P/390, R/390, IBM 3006  =   2.00 Value Units

Basic License: To order, specify the program number and the one-time charge (OTC) feature number. Also specify the feature number of the desired distribution medium. To suppress shipment of media, select the license-only option in CFSW.

Translation from MSUs to Value Units

             MSUs        Value Units/MSU
 
Base          1-3            1.00
Tier A        4-45            .45
Tier B       46-175           .36
Tier C      176-315           .27
Tier D      316+              .20

                                     OTC      Medium
                          Program    Feature  Feature
Description               Number     Number   Number   Medium
 
DB2 Warehouse Manager     5655-H34            5802     3480
 for z/OS & OS/390, V7.2                               Tape
 
   1 Value Unit                      0001
 250 Value Units                     0002

Subscription and Support: To receive voice technical support via telephone during normal business hours, and future releases and versions at no additional charge, subscription and support must be ordered. The capacity of Subscription and Support (Value Units) must be the same as the capacity ordered for the product licenses.

To order, specify the support program number. IBM is also providing subscription and support for these products via a separately purchased offering under the terms of the IBM International Agreement for Acquisition of Support. This offering:

  • Includes and extends the support services provided in the base support to include technical support via telephone during normal business hours.
  • Entitles customers to future releases and versions at no additional charge. Note that customer is not entitled for new products.

Once subscription and support is ordered, the charges will renew automatically annually unless cancelled by the customer.

                                    Annual   OTC
                                    Support  Reseller
                                    Charge   One Year  Medium
                          Program   Feature  Feature   Feature
Description               Number    Number   Number    Number
 
Subscription and Support  5655-I33                     6635
 for DB2 Warehouse                                     Paper
 Manager for z/OS &
 OS/390, V7.2
 
   1 Value Unit                     0001     0004
 250 Value Units                    0002     0005
 Decline (No charge)                0003

Single Version Charging: To elect single version charging, you must notify and identify to IBM the prior program and replacement program and the machine the programs are operating on.

Customized Offerings

Product media is shipped only via Customized Offerings (for example, CBPDO, ServerPac, Systempac®). Non-customized items (CDs, diskettes, source media, media kits) will continue to be shipped via the stand-alone product.

Terms and Conditions

Sub-Capacity Charges Terms and Conditions

zSeries software charges at less than full machine capacity for eligible data management (DM) and application development (AD) tools apply when z/OS is running in z/Architecture (64-bit) mode on an IBM e(logo)server zSeries 900, no other MVS™-based operating system is licensed to that server and the required information is provided by the customer in accordance with the applicable terms.

Sub-capacity charges for an eligible AD or DM tool is based on the z/OS product defined capacity. To obtain charges at less than full machine capacity for eligible AD and DM tools, you are required to:

  • Determine the MSUs needed for each machine on which the tools will run. Only machines on which the customer has implemented sub-capacity WLC according to the above terms and conditions are eligible for charges at less than full machine capacity for the tools.
  • Use the product defined capacity for z/OS (as specified on the Sub-Capacity Reports submitted to IBM for sub-capacity WLC) as the sub-capacity (MSUs) for each tool.
  • Submit any additional MSUs and/or Value Units required for each product along with the current entitlement in Value Units for each product.

Sub-Capacity Charges for AD and DM Tools

To be eligible for sub-capacity charges for AD and DM tools, the machine on which the AD and DM tools are running must be eligible for WLC sub-capacity charges terms and conditions. You must have signed the Attachment for zSeries Workload License Charges-Pre-ILM, Z125-6516, and submitted at least one Sub-Capacity Report to IBM as defined in the attachment.

With sub-capacity charges, the charge for an eligible AD or DM tool is based on the z/OS product defined capacity. To obtain charges at less than full machine capacity for each eligible AD and DM tool for each machine, you should:

  • Determine the MSUs needed for the machine on which the tools will run. In a data sharing environment, determine the aggregate MSUs needed on the machine where the tools run. Use the product defined capacity (MSUs) for z/OS (as specified on the Sub-Capacity Reports submitted to IBM for sub-capacity WLC) as the sub-capacity (MSUs) for each tool.
  • Submit any additional MSUs and/or Value Units required for each product along with the current entitlement in Value Units for each product.
  • If the use of sub-capacity pricing terms for AD and DM tools results in a reduced requirement for Value Units, thus "freeing up" entitlements, customers can reallocate the entitlement difference by distributing the Value Units across a larger or different set of systems, or reserve them for future growth. There will be no refunds for these "freed up" Value Units. Subscription and Support volumes and entitlements for existing contracts will continue to be at the same levels as the acquired licenses.

Management of the Value Unit entitlements continues to be a customer responsibility. If one of the following occur on a machine to which AD or DM tools are licensed, the customer must determine if additional Value Units and Subscription and Support need to be ordered for those tools to cover the increase:

  • The z/OS defined capacity is increased.
  • The requirements for WLC sub-capacity charges are no longer met.

Licensing: IPLA. Proofs of Entitlement are required for all authorized use. Part number products only, offered outside of Passport Advantage, where applicable, are license only and do not include software maintenance.

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

    IBM Agreement for Acquisition of Support (Z125-6011)

These products are licensed under the IPLA, the associated Agreement for Acquisition of Support, and the Addendum for Support (Z125-6336), which provides for support with ongoing access to releases and versions of the program. These programs have a one-time license charge for use of the program and an ongoing recurring charge for the enhanced support that includes telephone assistance (voice support for defects during normal business hours) as well as access to updates, releases, and versions of the program as long as support is in effect. S/390 and zSeries IBM Operational Support Services — Support Line is an option for those customers who desire added services.

Limited Warranty: Yes

Program Services: Available until June 30, 2003

Money-Back Guarantee: 30-day, money-back guarantee, applicable to the first instance per customer enterprise. The money-back guarantee will commence on the invoice date.

Copy and Use on Home/Portable Computer: No

Volume Orders (IVO): No

Passport Advantage Applies: No

Usage Restriction: Yes

Limited-Use License for DB2 UDB Enterprise Edition: The DB2 Warehouse Manager provides a restricted-use copy of DB2 UDB Enterprise Edition V7.

Authorization to use this copy of DB2 UDB Enterprise Edition is to enable database management of DB2 for OS/390 data warehouse control databases by the following workstation tools only:

  • Data Warehouse Center
  • Information Catalog
  • DB2 OLAP Starter Kit

For use of DB2 UDB Enterprise Edition other than the uses specifically described above, you must obtain a separate license for DB2 UDB Enterprise Edition from IBM.

Software Maintenance Applies: For operating system software, the revised IBM Operational Support Services — Support Line offering will provide support for those operating systems and associated products that are not available with the newly announced software maintenance offering. This will ensure total support coverage for your enterprise needs, including IBM and selected non-IBM products. For complete lists of products supported under both the current and revised Support Line offering, visit:

For additional information on the revised IBM Operational Support Services, refer to Services Announcement 601-023 , dated July 10, 2001.

IBM Operational Support Services — Support Line: No

AIX/UNIX Upgrade Protection Applies: No

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

iSeries Software Subscription Applies: No

Variable Charges Apply: No

Educational Allowance Available: Yes, 15% education allowance applies to qualified education institution customers.

Withdrawn Program            Replacement Program
 
DB2 Warehouse Manager        DB2 Warehouse Manager
 feature of the IBM           for z/OS and
 DB2 Universal                OS/390, V7.2
 Database Server for          (5655-H34)
 OS/390 and z/OS, V7
 (5675-DB2)

Prices

Contact your IBM representative for charges information for this announcement.

Order Now

 Use Priority/Reference Code: YE001
 
 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@vnet.ibm.com
 Mail:      IBM Atlanta Sales Center
            Dept. YE001
            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

 
zSeries and iSeries are trademarks of International Business Machines Corporation.
 
The e-business logo, z/OS, System/370, and MVS are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, OS/390, AIX, S/390, System/390, and Systempac 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.
 
Microsoft is a trademark of Microsoft Corporation.
 
Windows and Windows NT are registered trademarks of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
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.