IBM United States
Software Announcement 202-216
September 17, 2002
IBM DB2 Warehouse Manager for z/OS and DB2 Warehouse Manager Sourcing Agent for z/OS are Upgraded to V8.1
(Corrected on October 24, 2002)
Corrected Software Requirements section for DB2 Warehouse Manager
Sourcing Agent. Added z/OS.e after OS/390 V2R10, z/OS. Basic License
section -- deleted "OTC Feature Number 5802" and "Tape" from chart for
Program Number 5655-I62 and changed Medium Feature Number to "6499" in
chart for Program Number 5655-F33.
At a Glance
Enhancements in V8.1 of DB2 Warehouse Manager for z/OS and DB2 Warehouse Manager Sourcing Agent for z/OS:
For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: YE001).
DB2® Warehouse Manager V8.1 Enhancements
DB2 Warehouse Manager for z/OS delivers a complete warehouse solution to use with your DB2 for z/OS. This new offering brings together the tools to build, manage, and access DB2 data warehouses. It is based on proven technologies enhanced to offer additional function and to provide tighter integration among the components. Included in the DB2 Warehouse Manager for z/OS, V8.1 are:
Use DB2 Warehouse Manager for z/OS 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 Enterprise Server Edition V8.1: The data warehouse management infrastructure is delivered as elements of DB2 UDB Enterprise Server Edition V8.1. This copy of DB2 is included, with a restricted-use license, to permit delivery and utilization of the Workstation-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:
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.
z/OS Agent and Transformers: The warehouse agent for z/OS executes z/OS-based processes on behalf of the Data Warehouse Center. It permits data to be processed in your z/OS 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 z/OS.
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 Warehouse Manager Sourcing Agent for z/OS
The DB2 Warehouse Manager Sourcing Agent for z/OS is designed for
customers who already have a non-z/OS Warehouse Manager package, and want
to use the z/OS agent against z/OS sources. The z/OS warehouse agent
will source data from z/OS and move it to a DB2 Intel®/UNIX® platform
warehouse. This eliminates the need to move data off the S/390® before
Section 508 of the U.S. Rehabilitation Act
DB2 Warehouse Manager for z/OS, V8.1 and DB2 Warehouse Manager Sourcing
Agent for z/OS, V8.1 are capable as of December 27, 2002, when
used in accordance with associated IBM documentation, of satisfying the
applicable requirements of Section 508 of the Rehabilitation Act,
provided that any assistive technology used with the product properly
interoperates with it.
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 millions of service units per hour (MSU) for larger capacities.
There is also be a price benefit when customers grow their capacity. Additional capacity will based on the number of Value Units (MSUs) the customer has already 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.
International Program License Agreement (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.
For information on the types and availability of training, visit:
The appropriate curriculum will include the enhancements described in this announcement.
Refer to the IBM Learning Services Home Page for available courses in your country:
Call IBM Education and Training at 800-IBM-TEACH (426-8322) for catalogs, schedules, and enrollments.
Product information will be available on day of announcement through Offering Information (OITOOL) at:
No publications are shipped with these programs.
The following are some of the publications that can be ordered from IBM.
Order Title Number IBM DB2(R) Data Warehouse GC27-1122 Manager Installation Guide English IBM DB2 Universal SC27-1123 Database(R) Data Warehouse Center Administration Guide English IBM DB2 Warehouse Manager SC27-1125 Information Catalog Centre Administration Guide English IBM DB2 Universal Database SC27-1124 Data Warehouse Center Application Integration Guide English
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 or customer number. A large number of publications are available online in various file formats, and they can all be downloaded free of charge.
The IBM Publications Notification System (PNS)
PNS enables subscribers to set up profiles of interest by order number/product number. PNS subscribers automatically receive notifications by e-mail of all new publications defined in their profiles. These may then be ordered/downloaded via the Publications Center.
The following can be accessed from the Internet:
The DB2 Warehouse Manager for z/OS requires system capable of running DB2 UDB for OS/390® or z/OS, V6, or later.
It requires 30 MB of storage.
DB2 Warehouse Manager Sourcing Agent for z/OS requires system that will run OS/390 V2R10 or z/OS.
HFS disk space on the z/OS machine of 30 MB.
DB2 Warehouse Manager for z/OS, V8.1
The DB2 Warehouse Manager for z/OS uses the Data Warehouse Center as its User Interface. The Data Warehouse Center is a part of DB2 Administrative Client, which is included in the DB2 UDB Enterprise Server Edition. A restricted-use copy of the DB2 UDB Enterprise Server Edition V8.1 is included in the DB2 Warehouse Manager for z/OS, V8.1 package.
The Administrative Client supports Windows NT® 4.0, Windows 2000®, or XP (32-bit), AIX® 188.8.131.52 32-bit or 5.1d, and Sun Solaris operating environments. For details, refer to Software Announcement 202-214 , dated September 17, 2002.
DB2 Warehouse Manager provides agents for z/OS and OS/390. These agents require:
To use the transformers, DB2 Java Stored procedures must be enabled.
For workstation component requirements in general you need either AIX or Windows and a machine to run the operating system. These are the supported releases of Windows and AIX:
DB2 Warehouse Manager Sourcing Agent for z/OS, V8.1
DB2 Warehouse Manager Sourcing Agent for z/OS requires:
The DB2 Warehouse Manager Sourcing Agent for z/OS, V8.1 is distributed with the following content:
Security, Auditability, and Control
DB2 Warehouse Manager for z/OS, V8.1 and DB2 Warehouse Manager Sourcing Agent for z/OS, V8.1 use 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, V8.1 has a single charge unit of "Value Units."
Subscription and Support for DB2 Warehouse Manager for z/OS also has a single charge unit of "Value Units."
DB2 Warehouse Manager Sourcing Agent for z/OS, V8.1 has a single charge unit of "Value Units."
Subscription and Support for DB2 Warehouse Manager Sourcing Agent for z/OS also has a single charge unit of "Value Units."
Value Unit Exhibit VUE007
Value Usage Level Minimum Maximum Units/MSU Base 1 3 1 PSLC/Level A 4 45 0.45 PSLC/Level B 46 175 0.36 PSLC/Level C 176 315 0.27 PSLC/Level D 316 + 0.2
Value HW Units/Machine MP3000 H30 6 MP3000 H50 8 MP3000 H70 12 ESL Models 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 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 Example
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, refer below.
If the customer has installed 1,500 MSUs, the applicable Value Units would be:
Translation from MSUs to Value Units Value MSUs * 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, the sum is to be rounded up to the next integer.
Feature Number 1 Value Unit 0001 250 Value Units 0002
Example: For a product running on machines with 1,500 MSUs requiring 344 Value Units, order feature number 0001, quantity 94 and feature number 0002, quantity 1.
Note: For actual feature numbers, refer below.
Value Units for non MSU-based S/390 Processors:
H30 = 6 Value Units H50 = 8 Value Units H70 = 12 Value Units P/390, R/390, IBM 3006 = 2 Value Units
Basic License: To order, specify the program number, feature number 9001 for asset registration, 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 5655-I61 Warehouse Manager for z/OS, V8.1 1 Value Unit 0001 250 Value Units 0002 English 5802 Tape and CD-RWs
OTC Program Feature Description Number Number DB2 5655-I62 Warehouse Manager Sourcing Agent for z/OS, V8.1 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 and feature number 9001 for asset registration. 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 (IAAS). This offering:
Once subscription and support is ordered, the charges will renew automatically annually unless cancelled by the customer.
ASC(2) Medium Program Feature Feature Description Number Number Number Medium Subscription 5655-I33 6635 Paper and Support for DB2 Warehouse Manager for z/OS, V8.1 1 Value Unit 0001 250 Value Units 0002 Decline 0003 (no charge)
ASC(2) Medium Program Feature Feature Description Number Number Number Medium Subscription 5655-F33 6499 Paper and Support for DB2 Warehouse Manager Sourcing Agent for z/OS, V8.1 1 Value Unit 0001 250 Value Units 0002 Decline 1001 (no charge)
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.
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 a 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, the customer is 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. The customer 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, the customer 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:
The IBM Agreement for Acquisition of Support (Z125-6011) applies for maintenance and do not require customer signatures.
These products are licensed under the IPLA, and 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 customers who want added services.
Money-Back Guarantee: If for any reason you are dissatisfied with the program, return it within 30 days from the invoice date, to the party (either IBM or its reseller) from whom you acquired it, for a refund. This applies only to your first acquisition of the program.
Authorization to use this copy of DB2 UDB Enterprise Server 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 Server Edition, other than the uses specifically described above, you must obtain a separate license for DB2 UDB Enterprise Server Edition from IBM.
DB2 Warehouse Manager Sourcing Agent for z/OS: Requires customers to have already purchased DB2 Warehouse Manager and that the agent only be used to source data from the DB2 servers running on the system to which it is licensed.
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, refer to our Web site at:
For additional information on the revised IBM Operational Support Services, refer to Services Announcement 601-023 , dated July 10, 2001.
Replaced Program Replacement Program Program Program Program Program Number Name Number Name 5675-DB2 DB2 UDB for 5655-I61 DB2 Warehouse OS/390 and Manager for z/OS, V7 (DB2 z/OS, V8.1 Warehouse Manager Feature)
Use Priority/Reference Code: YE001 Phone: 800-IBM-CALL Fax: 800-2IBM-FAX Internet: email@example.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.