DB2 Warehouse Manager for z/OS, V8.2 upgrade supports new languages

IBM United States Software Announcement 204-280
November 30, 2004

 

 ENUS204-280.PDF (38KB)

Table of contents   Document options  
TOC link At a glance TOC link Publications
TOC link Overview TOC link Technical information
TOC link Key prerequisites TOC link Ordering information
TOC link Planned availability date TOC link Terms and conditions
TOC link Description TOC link IBM Electronic Services
TOC link Education support TOC link Prices
TOC link Offering information TOC link Order now
 
Printable version Printable version

 
At a glance

Warehouse Manager for z/OS supports three new languages in V8.2:

  • Russian
  • Czech
  • Simplified Chinese

The product now supports the GB18030 code page.

For ordering, contact:

Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: LE001).
 
Back topBack to top
 

Overview

DB2® Warehouse Manager V8.2 enhancements

Warehouse Manager for z/OS® supports three new languages in V8.2: Russian, Czech, and Simplified Chinese.

In addition, the product now supports the GB18030 code page.

Note that DB2 Warehouse Manager for z/OS, V8.2 replaces DB2 Warehouse Manager for z/OS, V8.1.
 
Back topBack to top
 

Key prerequisites
  • DB2 for z/OS, V7 or V8
  • Workstation running Windows NT™, Windows™ 2000, Windows XP, or AIX®


 
Back topBack to top
 

Planned availability date

December 3, 2004
 
Back topBack to top
 

Description

Warehouse integration

DB2 Warehouse Manager for z/OS, V8.2 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 and enhanced to offer additional function and to provide tighter integration among the components. Included in the DB2 Warehouse Manager for z/OS, V8.2 are:

  • DB2 Data Warehouse Center, which is a GUI that integrates with the DB2 Control Center
  • Warehouse agent for z/OS, 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® V8.2 Enterprise Server Edition (restricted use license)

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.2: The data warehouse management infrastructure is delivered as elements of DB2 UDB Enterprise Server Edition V8.2. 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 z/OS, V8.2.

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.

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:

  • 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

Section 508 of the U.S. Rehabilitation Act

DB2 Warehouse Manager for z/OS, V8.2 is capable as of December 3, 2004, when used in accordance with IBM's associated 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.

Trademarks

 
DB2, z/OS, AIX, and DB2 Universal Database are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows and Windows NT are trademarks of Microsoft Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.

 
Back topBack to top
 
Education support

For information on the types and availability of training, visit

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

Offering information

Product information is available via the Offering Information Web site


 
Back topBack to top
 
Publications

No publications are shipped with this program.

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

Publication Notification System

The IBM Publication Notification System (PNS) enables subscribers to set up profiles of interest by order number or product number. PNS subscribers automatically receive e-mail notifications of all new publications defined in their profiles. These may then be ordered or downloaded from the Publications Center.

The site is available in English and Canadian French.

The following can be accessed from the Internet:


 
Back topBack to top
 
Technical information

Specified operating environment

Hardware requirements

DB2 Warehouse Manager for z/OS®, V8.2 requires a system capable of running DB2 UDB for z/OS, V7 or later. It requires 30 MB of storage.

The workstation component requires an Intel™-based system.

Software requirements

DB2 Warehouse Manager for z/OS, V8.2: 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's Administrative Client, which is included in DB2 UDB Enterprise Server Edition. A restricted-use copy of DB2 UDB Enterprise Server Edition V8.2 is included in the DB2 Warehouse Manager for z/OS, V8.2 package.

The Administrative Client supports Windows NT™ 4.0, 2000, or XP (32-bit), AIX® 4.3.3.0 32-bit or 5.x, and Sun Solaris operating environments.

DB2 Warehouse Manager provides an agent for z/OS. This agent requires z/OS or z/OS.e.

Warehouse Manager requires DB2 UDB for z/OS, V7 (5675-DB2) or DB2 UDB for z/OS, V8.

To use the transformers, DB2 Java™ stored procedures must be enabled.

For workstation component requirements, you need AIX 5.1 or later.

Windows™

  • Windows NT 4.0 with SP 6a, or later, and Internet Explorer 4.01 with SP 2, or later
  • Windows 2000 Professional, Standard Server, Advanced Server, and Datacenter Servers
  • Windows XP (32-bit) Home Edition and Professional Edition
  • Windows Server 2003
  • Windows XP (64-bit) Professional Edition

AIX

  • AIX (32-bit) 4.3.3 with maintenance level 9 or later, and APARs IY22308, Y32690, and IY33024 (32-bit only)
  • AIX (32-bit) 5.1.0 with maintenance level 2 or later, and APARs IY31254, IY32217, IY32905, and IY33023
  • AIX 5.2 or higher

Planning information

Installability: DB2 Warehouse Manager for z/OS, V8.2 is upward compatible from DB2 Warehouse Manager for z/OS, V8.1 and replaces it.

Packaging: DB2 Warehouse Manager for z/OS, V8.2 is distributed with the following content:

  • Basic machine-readable material on a 3480 tape cartridge
  • Program Directory (GI10-8672-00)
  • Proof of Entitlement
  • IBM International Program License Agreement (IPLA)
  • License Information (GC18-9418-00)
  • DB2 Warehouse Manager Kit/CD V8.2

Security, auditability, and control

DB2 Warehouse Manager for z/OS, V8.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.
 
Back topBack to top
 

Ordering information

DB2 Warehouse Manager for z/OS, V8.2 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.

Value Unit Exhibit VUE007

                                                          Value
                  MSUs                MSUs                Units/
                  minimum             maximum             MSU
 
Base                1                   3                 1
Tier A              4                  45                 0.45
Tier B             46                 175                 0.36
Tier C            176                 315                 0.27
Tier D            316                   +                 0.2

Value Units for non-MSU-based S/390® processors:

                                      Value
                                      Units/
Hardware                              machine
 
MP3000 H30                             6
MP3000 H50                             8
MP3000 H70                            12
ESL Models                             2

Ordering example: The total number of Value Units is calculated according to the following example.

If the customer has installed 1,500 MSUs, the applicable Value Units would be:

Translation from MSUs to Value Units

                                   Value
                                   Units/                 Value
             MSUs         *        MSU           =        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       1,185        *         .20          =        237.00
 
Total        1,500                                        343.50

When calculating the total number of Value Units, the sum is to be rounded up to the next integer.

Example: In the above ordering example, for the product running on a machine with 1,500 MSUs requiring 344 Value Units, order Value Units, quantity 94, and 250 Value Units, quantity 1.

Ordering z/OS through the Internet

ShopzSeries provides an easy way to plan and order your z/OS ServerPac or CBPDO. It will analyze your current installation, determine the correct product migration, and present your new configuration based on z/OS. Additional products can also be added to your order (including determination of whether all product requisites are satisfied). ShopzSeries is available in the U.S. and several countries in Europe. In countries where ShopzSeries is not available yet, contact your IBM representative (or IBM Business Partner) to handle your order via the traditional IBM ordering process. For more details and availability, visit the ShopzSeries Web site at

Program
number                      Program name
 
5655-I61                    DB2 Warehouse Manager for z/OS, V8.2

Basic License One-Time Charge
Upgrade path

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.

Note that Order Control Codes have not changed since DB2 Warehouse Manager for z/OS, V8.1.

DB2 Warehouse Manager for z/OS, V8.2: 5655-I61

Entitlement                                      License option/
identifier             Description               pricing metric
 
S00XCF4                DB2 Warehouse             Value Units
                        Manager for
                        z/OS, V8.2

Subscription and Support: 5655-I33

Entitlement                                      License option/
identifier             Description               pricing metric
 
SOOWLJN                Subscription and          Value Units
                        Support for DB2
                        Warehouse
                        Manager for
                        z/OS, V8.2

Translation from MSUs to Value Units

                                                          Value
                                                          Units/
                            MSUs                          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

Ordering example

The total number of Value Units is calculated according to the following example:

If the customer has installed 1,500 MSUs, the applicable Value Units would be:

Translation from MSUs to Value Units

                                   Value
                                   Units/                 Value
             MSUs         *        MSU           =        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       1,185        *         .20          =        237.00
 
Total        1,500                                        343.50

When calculating the total number of Value Units, the sum is to be rounded up to the next integer.

Example: In the above ordering example, for the product running on a machine with 1,500 MSUs requiring 344 Value Units, order Value Units, quantity 94, and 250 Value Units, quantity 1.

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 this product via a separately purchased offering under the terms of the IBM International Agreement for Acquisition of Support (IAAS). 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 the customer is not entitled to new products.

When Subscription and Support is ordered, the charges will renew automatically annually unless cancelled by the customer.

Subscription and Support PID: 5655-I33

Entitlement                                      License option/
identifier             Description               pricing metric
 
S00WLJN                Subscription and          Value Unit
                        Support for
                        DB2 Warehouse
                        Manager for
                        z/OS, V8.2
 
1 Value Unit
250 Value Units
Decline Software
 Subscription
 and Support

On/Off Capacity on Demand

Program
number                      Description
 
5655-I61                    Per Value Unit
5655-I61                    Per 250 Value Units

Customized offerings

Product media is shipped only via Customized Offerings (for example, CBPDO, ServerPac, SystemPac®). Noncustomized items (CDs, diskettes, source media, media kits) will continue to be shipped via the stand-alone product.
 
Back topBack to top
 

Terms and conditions

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

This product is licensed under the IBM Program License Agreement (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. This program has a one-time license charge for use of the program and an annual renewable 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. zSeries® IBM Operational Support Services — SoftwareXcel is an option for those customers who desire added services.

Limited warranty applies: Yes

Warranty: This program has warranty for a minimum of one year from acquisition from IBM or authorized IBM Business Partner. The warranty provided to the customer, for at least one year from acquisition, is access to databases (read Web sites) for program information and FAQs, including any known fixes to defects, which the customer can download or obtain otherwise and install at leisure.

Program support: Enhanced Support, called Subscription and Support, 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. The customer will be notified of discontinuance of support with 12 months' notice.

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.

Copy and use on home/portable computer: No

Volume orders (IVO): No

Passport Advantage® applies: No

Usage restriction: Yes

Software Maintenance applies: No

For operating system software, the revised IBM Operational Support Services — SoftwareXcel 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 SoftwareXcel 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 — SoftwareXcel: Yes

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, a 15% education allowance applies to qualified education institution customers.

On/Off Capacity on Demand

To be eligible for On/Off Capacity on Demand pricing, customers must be enabled for temporary capacity on the corresponding hardware, and the required contract — Z125-6611, Attachment for Customer Initiated Upgrade and IBM eServer On/Off Capacity on Demand — Software — must be signed prior to use.
 
Back topBack to top
 

IBM Electronic Services

IBM Global Services has transformed its delivery of hardware and software support services to put you on the road to higher systems availability. IBM Electronic Services is a Web-enabled solution that provides you with an exclusive, no-additional-charge enhancement to the service and support on the IBM eServer. You should benefit from greater system availability due to faster problem resolution and preemptive monitoring. IBM Electronic Services is comprised of two separate, but complementary, elements: IBM Electronic Services news page and IBM Electronic Service Agent™.

IBM Electronic Services news page provides you with a single Internet entry point that replaces the multiple entry points traditionally used by customers 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 IBM Electronic Service Agent is no-additional-charge software that resides on your IBM eServer system. It is designed to proactively monitor events and transmit system inventory information to IBM on a periodic, customer-defined timetable. The IBM Electronic Service Agent tracks system inventory, hardware error logs, and performance information. If the server is under a current IBM maintenance service agreement or within the IBM warranty period, the Service Agent automatically reports hardware problems to IBM. Early knowledge about potential problems enables IBM to provide proactive service that maintains higher system availability and performance. In addition, information collected through the Service Agent will be made available to IBM service support representatives when they are helping answer your questions or diagnosing problems.

To learn how IBM Electronic Services can work for you, visit


 
Back topBack to top
 
Prices

Charges for this product are unchanged from DB2 Warehouse Manager for z/OS, V8.1. Refer to Software Announcement 202-216 , dated September 17, 2002.

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, from both 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. For more financing information, visit


 
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:  ibm_direct@vnet.ibm.com
 Mail:      IBM Americas Call Centers
            Dept:  IBM CALL, 11th Floor
            105 Moatfield Drive
            North York, Ontario
            Canada M3B 3R1
 
 Reference: LE001

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

 
iSeries and Electronic Service Agent are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, z/OS, AIX, S/390, SystemPac, zSeries, and Passport Advantage are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Intel is a trademark of Intel Corporation.
 
Windows NT and Windows 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.
 
Other company, product, and service names may be trademarks or service marks of others.

Back to topBack to top
 

 
Printable version Printable version