DB2 Warehouse Manager for z/OS, V8.2 upgrade supports new languages
IBM United States Software Announcement 204-280November 30, 2004
 ENUS204-280.PDF (38KB)
|
At a glance
 |
| 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 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 to top
|
|
| Key prerequisites |
|
- DB2 for z/OS, V7 or V8
- Workstation running Windows NT™, Windows™ 2000, Windows XP, or AIX®
|
|
| Planned availability date |
|
December 3, 2004
Back 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
Back 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 to top
|
|
| Offering information |
|
Product information is available via the Offering Information Web site
Back 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:
- Warehouse (and DB2®) books on the Web
Back 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 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 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 
On/Off Capacity on Demand — Software — must be signed prior to use.
Back 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 . 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 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 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 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
Back to top
Printable version