|
IBM United States
Software Announcement 202-331 December 3, 2002 Enhanced IBM Data Management Tools for DB2 Add Function for Managing Your DB2 Database Environment
At a GlanceThe IBM Data Management Tools business is a unique model in the industry. IBM continues to increase its investment in tools to deliver comprehensive solutions that meet requirements faster than ever before. Increased focus is on common interfaces, cross-tool integration, testing with the same criteria used for the databases, and expansion into multiplatforms. Five newly enhanced DB2 for z/OS tools offer capabilities in major key functional areas. Administration tools and utilities — The enhanced DB2 Automation Tool for z/OS, V1.3 streamlines database management tasks and improves productivity. Performance management tools — DB2 Buffer Pool Analyzer for z/OS, V1.2 and DB2 Performance Monitor for z/OS, V7.2 facilitate peak operation levels. Recovery and replication tools — DB2 Log Analysis Tool for z/OS, V1.3 and DB2 Object Restore for z/OS, V1.3 add additional backup and recovery functions. For ordering, contact: Your IBM representative, an IBM Business Partner, or the Americas Call Centers at 800-IBM-CALL (Reference: LE001). OverviewBuilding on a strengthened focus on data management tools, IBM now has enhanced tools and functions that further complement the premier DB2® Universal Database (UDB) for z/OS™ database engine. New in this Announcement IBM continues to meet customer requirements in performance and recovery management by offering enhancements to five key tools for DB2 for z/OS. The enhanced program releases include:
For details about these products, refer to the Description section. IBM first announced its entry into the data management tools business in September 2000, delivering a set of 34 tools for IMS™ and DB2 covering key system management functions, and committing to expand this portfolio in response to customer requirements. This announcement is further proof of our ability to offer a broad range of tools that support the DB2 and IMS databases and to provide that support with day one availability for each new version or release of the databases. View the complete list of IBM Data Management Tools announcements on our Web site at: IBM now offers more than 60 tools that increasingly feature common interfaces and cross-tool integration and that are tested under the same configurations and workloads as the databases they support. To view the complete list of IBM Data Management Tools, visit our Web site at: Key PrerequisitesAny hardware and software configuration that supports the required version of DB2. Details are listed in the Hardware Requirements and Software Requirements sections. Planned Availability Dates
DescriptionIBM Tools for Database AdministrationDB2 Automation Tool for z/OS, V1.3 allows database administrators (DBAs) to greatly reduce manual work associated with database maintenance. Database objects, exceptions, and utilities are specified in profiles, then combined into a job profile. When jobs are built, DB2 Automation Tool evaluates database conditions against the thresholds specified by the administrator and generates the appropriate utility jobs. Jobs may execute multiple DB2 utilities against multiple objects, with appropriate parameters for each, in a specified order of steps. In addition to utility automation, DB2 Automation Tool V1.3 provides robust data set management and data page browser/editor tools to simplify the precise and timely execution of key database management tasks. Significant new functionality in DB2 Automation Tool V1.3 advances the goal of enterprise autonomic computing, including:
Support for DB2 V7 JCL, including:
If you have Enterprise Resource Planning (ERP) environments, such as SAP and PeopleSoft, you can take advantage of the following enhancements:
Profile creation and management improvements include:
The Dataset Manager feature of DB2 Automation Tool is a powerful and flexible facility that allows administrators to easily view, evaluate, and relocate DB2 data sets. At move time, characteristics of the target data set also may be changed, and Dataset Manager takes care of related required tasks, such as stopping and starting the associated database and updating the DB2 catalog. Usability enhancements to Dataset Manager include:
IBM Database Tools for Replication and RecoveryDB2 Log Analysis Tool for z/OS, V1.3 makes it easy to quickly audit and identify changes to data. Once identified, changes may be selectively reversed, reapplied (at the original database or at other databases), or reported upon. Highly customized summary or detailed views of data changes, and automatically generated SQL for reversing or reapplying changes, easily provide tighter control over data integrity. Enhanced Reporting Capabilities
Increased Control Over Report Generation
More Options When Applying Results of Analysis
Performance and Integration Enhancements
DB2 Object Restore for z/OS, V1.3 provides rapid, targeted restore of objects dropped from DB2 environments including databases, tablespaces, tables, indexes, data, table authorizations, and related object dependencies even if they no longer exist in the DB2 catalog. Now database administrators can reduce downtime, accelerate restore processes, and have more confidence in maintenance and test procedures that involve dropping DB2 objects. By adding DB2 Object Restore's comprehensive recovery capabilities to their portfolio of tools, DBAs can avoid the overhead and effort associated with full disaster recovery procedures in the event of unintended object loss or corruption. New Recovery Capabilities DB2 Object Restore V1.3 now offers a significantly expanded scope of recoverable database objects and attributes, including:
Repository Management Enhancements Administration of the DB2 Object Restore V1.3 versioning repository has been greatly enhanced through new automated loading, cleanup, update, and other capabilities.
Administrators now have easier access to image copying function and the ability to inspect image copy results through:
Interface and Usability Enhancements
Installation and Administration Enhancements
z/OS Tool Integration In addition to existing integration with DB2 Administration Launchpad and DB2 Log Analysis Tool, the following integration enhancements have been implemented in DB2 Object Restore V1.3.
IBM Database Tools for Performance ManagementDB2 Buffer Pool Analyzer for z/OS, V1.2 contains:
Enhancements
DB2 Performance Monitor for z/OS, V7.2 contains:
Enhancements
Workstation Client Improvements
Section 508 of the U.S. Rehabilitation Act
The products in this announcement are capable as of their general
availability, 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.
Value Unit Based PricingValue 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 be a price benefit when customers grow their capacity. Additional capacity will be 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.
Note that Value Units of a given product cannot be
exchanged/interchanged/aggregated with Value Units of another product.
IBM International Program License Agreement (IPLA) and Subscription and Support ConsiderationsIPLA 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.
Trademarks
PublicationsThe 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: The Publications Notification System (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. One copy of the following publications is supplied automatically with the basic machine-readable material.
Order
Title Number
DB2(R) Automation Tool for z/OS(TM), V1.3 GC27-1190
(5697-G63) License Information
DB2 Buffer Pool Analyzer for z/OS, V1.2 GC27-1463
(5655-E54) License Information
DB2 Log Analysis Tool for z/OS, V1.3 GC27-0966
(5655-E66) License Information
DB2 Object Restore for z/OS, V1.3 GC27-0972
(5655-E72) License Information
DB2 Performance Monitor for z/OS, V7.2 GC27-1089
(5655-E61) License Information
The following publications cannot be ordered in hardcopy . The publications are made available on the Web at: Publications on CD-ROM for the products in this announcement will be available on the next release of the following collections of software product libraries:
Order
Title Number
DB2 Automation Tool for z/OS, V1.3 SC27-1189
(5697-G63) User's Guide
DB2 Buffer Pool Analyzer for z/OS, V1.2
(5655-E54)
User's Guide SC27-1653
Installation and Customization SC27-1646
Messages SC27-1650
DB2 Log Analysis Tool for z/OS, V1.3 SC27-0967
(5655-E66) User's Guide
DB2 Object Restore for z/OS, V1.3 SC27-0973
(5655-E72) User's Guide
DB2 Performance Monitor for z/OS, V7.2
(5655-E61)
Installation and Customization SC27-1646
Messages SC27-1650
Monitoring Performance from ISPF SC27-1652
Monitoring Performance from the SC27-1645
Workstation
Report Command Reference SC27-1649
Report Reference SC27-1647
Reporting User's Guide SC27-1651
The IBM Publications Center Portal: 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. A large number of publications are available online in various file formats, which can currently be downloaded free of charge. The following material is available on the Internet at: Overview brochure
Specification Sheets
Specification Sheets, User's Guides, and White Papers are also available on CD-ROM (GK3T-7099). Technical InformationSpecified Operating EnvironmentHardware Requirements
The products in this announcement will operate on any hardware
configuration that supports the required versions of DB2.
Software RequirementsThe products in this announcement require DB2 V6, or later.
DB2 Log Analysis Tool for z/OS, V1.3 requires support for Unicode for
OS/390 (5647-A01) or z/OS (5694-A01). Unicode support is available for
Web download for OS/390 V2.10 and z/OS V1.1. It is integrated into z/OS
starting with V1.2.
Planning InformationPackaging: The programs in this announcement are distributed with the following content:
Security, Auditability, and ControlThe announced programs use the security and auditability features of the host operating system 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 InformationThe products in this announcement have one charge unit: Value Unit. 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 customers grow their capacity. Additional capacity will be 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. Note that Value Units of a given product cannot be exchanged, interchanged, or aggregated with Value Units of another product.
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
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, see below. Ordering Example: The total number of Value units is calculated according to the following example. If the customer has installed 1,200 MSUs, the applicable Value Units would be:
Translation from MSUs to Value Units
MSUs * Value Units/MSU = Value Units
Base 3 * 1. = 3.00
Tier A 42 * .45 = 18.90
Tier B 130 * .36 = 46.80
Tier C 140 * .27 = 37.80
Tier D 685 * .20 = 137.00
-----------------------------------------------------
Total 1,000 284
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,200 MSUs requiring 284 Value Units, order feature number 0001, quantity 34 and feature number 0002, quantity 1.
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, 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
The ordering information is not changed for the products and their Subscription and Support licenses in this announcement from prior releases. 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.
Single Version Charging:
To elect single version charging, the customer must notify and
identify to IBM the prior program and replacement program and the machine
the programs are operating on.
Customized OfferingsProduct 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 ConditionsSub-Capacity Charges Terms and Conditions
IBM 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 ToolsTo 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:
Licensing: IBM International Program License Agreement (IPLA). Proofs of Entitlement (PoE) are required for all authorized use. The following agreements apply 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 those customers who desire added services. Program Services: This program has program services for a minimum of one year from acquisition from IBM or authorized business partner. 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. These programs have program services for a minimum of one year from acquisition from IBM or authorized Business Partner. Customers will be notified of discontinuance of support with 12 months' notice. 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. 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 Passport Advantage Applies: No Software Maintenance Applies: No 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. IBM Operational Support Services — Support Line: Yes AIX®/UNIX® Upgrade Protection Applies: No Entitled Upgrade for Current AIX/UNIX Upgrade Protection Licensees: No iSeries™ Software Subscription Applies: No Educational Allowance Available: Yes, 15% education allowance applies to qualified education institution customers. PricesThe prices provided in this announcement are suggested retail prices for the U.S. only and are provided for your information only. Dealer prices may vary, and prices may also vary by country. Prices are subject to change without notice. For additional information and current prices, contact your local IBM representative.
The ordering information and prices for the products and their
subscription and support licenses in this announcement are not changed
from the prior releases.
Global FinancingIBM Global Financing offers competitive financing to credit-qualified customers to assist them in acquiring IT solutions. Our offerings include financing for IT acquisition, including hardware, software, and services, both from 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 the Web at: Order NowTo 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: The Americas Call Centers
Dept. LE001
P.O. Box 2690
Atlanta, GA 30301-2690
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
|
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.