IBM United States
Software Announcement 202-043
February 26, 2002
IBM DB2 Warehouse Manager for z/OS and OS/390: Revised Pricing Structure
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.
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).
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:
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:
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:
These transformers augment the rich transformations available with SQL built-in functions including:
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:
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.
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.
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.
Call IBM Education and Training at 800-IBM-TEACH (426-8322) for catalogs, schedules, and enrollments.
Product information is available through Offering Information (OITOOL) at:
No publications are shipped with this program.
Displayable Softcopy Documentation
The following can be accessed from the Internet:
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:
Data Warehouse Center can support target data warehouses that are built on any of the following DB2 for OS/390 versions:
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).
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.
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 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
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:
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
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 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:
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:
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:
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:
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.
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:
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.
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)
Use Priority/Reference Code: YE001 Phone: 800-IBM-CALL Fax: 800-2IBM-FAX Internet: firstname.lastname@example.org 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.