IBM DB2 and IMS tools expanded and enhanced to help better manage database environments

IBM United States Software Announcement 206-043
March 7, 2006

 

 ENUS206-043.PDF (78KB)

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 dates TOC link Terms and conditions
TOC link Description TOC link Prices
TOC link Statement of direction TOC link Order now
TOC link Offering Information  
 
Printable version Printable version

 
At a glance

New and enhanced DB2 and IMS tools deliver:

  • Performance management: DB2 SQL Performance Analyzer for z/OS, V3.1 (5697-I04)
  • Recovery management
    • IMS Database Recovery Facility for z/OS, V3.1 (5655-N47)
    • IMS High Performance Change Accumulation Utility for z/OS, V1.3 (5655-F59)

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

Two new versions, one new release, and a service update of DB2® and IMS™ tools offer many innovative features to assist database administrators (DBAs) and system programmers in managing all aspects of DB2 and IMS database environments.

Versions

  • DB2 SQL Performance Analyzer for z/OS®, V3.1 (5697-I04): Trade-ups are available from DB2 DB/Explain V6.1 (5655-N83).
  • IMS Database Recovery Facility for z/OS, V3.1 (5655-N47).

Release: IMS High Performance Change Accumulation Utility for z/OS, V1.3 (5655-F59)

Service update: APAR PK19027 for Tivoli® OMEGAMON® XE for DB2 Performance Expert on z/OS, V3.1 (5655-P07) and Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V3.1 (5655-P08) provides integration with important functions of DB2 SQL Performance Analyzer for z/OS, V3.1 (5697-I04).

To view a complete list of the DB2 and IMS tools, visit


 
Back topBack to top
 
Key prerequisites

Any hardware configuration that supports the required versions of DB2 and IMS. Details are listed in the Hardware requirements and Software requirements sections.
 
Back topBack to top
 

Planned availability dates

March 10, 2006:

  • DB2 SQL Performance Analyzer for z/OS, V3.1 (5697-I04)
  • IMS Database Recovery Facility for z/OS, V3.1 (5655-N47)
  • IMS High Performance Change Accumulation Utility for z/OS, V1.3 (5655-F59)

 
Back topBack to top
 
Description

IBM offers more than 70 tools that feature common interfaces and cross-tool integration, tested under the same configurations and workloads as the databases they support. As we enter the era of autonomic computing, DB2 and IMS tools will become increasingly self-managed in terms of dynamically monitoring and managing data, and taking responsibility for decision making and initiating action.

Performance management

DB2 SQL Performance Analyzer for z/OS, V3.1 (5697-I04)

  • DB2 SQL Performance Analyzer for z/OS, V3.1 is the strategic replacement for DB2 DB/Explain. If you have DB2 DB/Explain installed, then the integration of Easy Explain into DB2 SQL Performance Analyzer gives you a comprehensive performance solution that also supports DB2 V8. Trade-ups are available from DB2 DB/Explain V6.1 to DB2 SQL Performance Analyzer V3.1.
  • Enhancements include:
    • Total Easy Explain function integration
    • New user-modifiable thresholds for the Advisor
    • ISPF interface improvements
    • Statistics migration improvements
    • Internal improvements to path lengths, algorithms, and report readability
    • Implementation of many outstanding marketing requirements

Total Easy Explain function integration: The integration of the Easy Explain function (EEE) is extended to include fully interactive TSO ISPF support, providing seamless movement between SQL Performance Analyzer and EEE under TSO. SQL Performance Analyzer V3 adds EEE's programming language source files and other input sources to SQL Performance Analyzer's input capabilities by the automatic creation and transfer of selected SQL statements (TOPA=ALL) from any input source, including "SQL= statement." Easy Explain can now store SQL in the user's EEEPATH table, along with source SQL statements in the accompanying ANLEEE.SQL file, for later comparison with the new plans, using SQL Performance Analyzer's Compare Old and New Plans function. All of these facilities are now available under TSO, as well as batch.

New user-modifiable thresholds for the Advisor: Many user-modifiable threshold parameters that set high water marks, triggers, and other controls for Advisor warning messages are introduced. You can now set warning flags for any table space scan, any non-matching index scan, or any partitioned scans that read all partitions. In addition, you can set the number of data pages to be read for table space scans, and index leaf pages to be read for both matching and non-matching index scans before triggering a warning message. The thresholds for the number of tables in a join, the number of elements in an IN (list), and the number of updated indexes are among the other user-specified thresholds available. Users may selectively turn off certain SQL Advisor messages or choose to have only the message IDs and not the text displayed.

ISPF interface improvements: DB2 SQL Performance Analyzer's TSO interface now allows the use of partitioned data set (PDS) members as both input and output report targets, including definition of new members and ISPF member list processing. The consistency guidelines for ISPF have been fully implemented with Version 3, adding such features as field-level help, dynamic trace enabling for diagnostics, and many other usability enhancements. The panels have been redesigned for better use and flow, and options on the main panel now include Retro Explain, Compare Old and New Plans, and links to Easy Explain and the Help Tutorial. Users can also display all of the parameter sets: User, System, and Threshold; modify any set; and define output reports from the main panel; as well as define and edit input data sets.

Statistics migration improvements: This version includes the ability to expand the collection of objects under a wide-ranging filter of database, table space, and table names, all with wildcarding capabilities, defined by the new FINDALL parameters. Now you may specify partial names at the database, table space, or table levels in a single run, and search broadly for catalog statistics collection. The limit on the number of objects to be collected has been raised substantially, and commit points are now inserted between each table's catalog updates in the output to facilitate restart. The "From" DB2 subsystem may be defined via parameters that allow the statistics migration program to choose the access SQL that will perform best (use indexes) against the catalog for that release.

Internal program changes: Enhancements and improvements are included for many internal cost algorithms and path lengths, designed to keep the estimates for overall costs within reasonable accuracy. By employing more lowercase text and including some reformatting of the input SQL, this version provides better readability in the output report.

Many marketing requirements implemented: Marketing requirements are addressed, including several ISPF enhancements, statistics collection at multiple levels, user-modifiable thresholds, message controls, exception reporting, Easy Explain integration under TSO, and others.

APAR PK19027 for Tivoli OMEGAMON XE for DB2 Performance Expert on z/OS, V3.1 (5655-P07) and Tivoli OMEGAMON XE for DB2 Performance Monitor on z/OS, V3.1 (5655-P08) provides important integration services with DB2 SQL Performance Analyzer. If DB2 SQL Performance Analyzer for z/OS, V3.1 (5697-I04) is installed, you:

  • Are now able to launch SQL Performance Analyzer using the OMEGAMON Classic end-user interface
  • Will find a function on the panel where the actual executed SQL statement text is displayed that allows you to launch and forward the SQL statement text to SQL Performance Analyzer for Explain
  • May review the SQL Performance Analyzer report after launching SQL Performance Analyzer

Recovery management

IMS Database Recovery Facility for z/OS, V3.1 (5655-N47)

Businesses need to be able to recover and process IMS data from an earlier point in time. IMS Database Recovery Facility for z/OS, V3.1 provides all functions of the previous version for recovery of an IMS database to a designated recovery point, and is extended to offer the following new features and functional improvements:

  • Creation of image copy data sets during the recovery process to eliminate the need to follow recovery with a separate image copy invocation
  • Creation of index data sets during the recovery process, including primary, secondary, and HALDB index list data sets, to eliminate the need to follow recovery with a separate index build invocation
  • Creation of off-line, cloned copies of the database that can be used for purposes such as application program testing, audit, and database recovery
  • Validation of data during the recovery process, which eliminates the need to follow a recovery with a separate validation procedure
  • Automatic deletion and creation of database data sets during the recovery process, which eliminates the need to precede recovery with a separate data set deletion and creation procedure
  • The ability to generate new image copy data sets by applying database updates from a log data set or change an accumulation data set to existing image copy data
  • Options for verifying data sets, including allocate and open, to verify availability and usability of recovery input data sets
  • Elimination of the need to issue the IMS /DBR DB and /DBR AREA commands before recovery and the IMS /STA DB and /STA AREA commands after recovery

IMS High Performance Change Accumulation Utility for z/OS, V1.3 (5655-F59) is a high-performance tool that merges most recent database changes quickly, safely, and accurately. The tool saves you time and protects your data, saving both DBA resources as well as supplementary software costs.

IMS High Performance Change Accumulation Utility for z/OS provides all of the functions of the previous release and is extended to offer the following new functions and enhancements:

  • A scan function analyzes setup and Job Control Language (JCL) conversion prior to running of IMS Change Accumulation update processing.
  • Additional formats are included for the Change Accumulation summary reports for transfer to external report interfaces and report viewers.
  • The ability to directly process secondary log data sets by using Database Recovery Control is included.
  • Type 29 log records are accumulated for Online Reorganization processing.
  • A standard procedure mode processes JCL by using dynamic allocation with no requirement for write access to a procedure library.
  • A Started Task Control (STC) interface merges the custom and standard procedure modes of JCL processing.
  • An updated ISPF user interface provides:
    • HPCSYSIN command file
    • Output reports DD selection panel
    • Panel changes
      • HPCPE01: Additional commands made available
      • HPCPSM0: Setup changes for option 9, Execution JCL DD
      • HPCPS03: STC and Standard PROC changes
      • HPCPS09: Execution JCL DD Control
  • New and changed IMS High Performance Change Accumulation commands:
    • New commands
      • STC NAME
      • RPT.COLUMNS
      • RPT.DATE
      • RPT.ORDER
      • RPT.SUMMARY
    • Changed commands
      • GEN.LIST
      • GEN.WARN
    • Deleted commands
      • REPORT CLASS

Section 508 of the U.S. Rehabilitation Act

The products in this announcement are capable as of their planned 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 pricing

Value Unit pricing for eligible zSeries® IPLA programs enables a lower cost of incremental growth and enterprise aggregation. Each zSeries IPLA product with Value Unit pricing has a single price per Value Unit and a conversion matrix, called Value Unit Exhibit, for converting from some designated measurement to Value Units. Most commonly Millions of Service Units (MSUs) is the measurement designated by IBM to be converted to Value Units. Some other measurements are engines or messages. Since MSUs are the most common measurement, that measurement will be used for the remainder of this description.

Value Unit pricing offers price benefits for customers. For each zSeries IPLA program with Value Unit pricing, the quantity of that program needed to satisfy applicable IBM terms and conditions is referred to as the required license capacity. Each of the various Value Unit Exhibits stipulate that the larger your required license capacity, the fewer Value Units per MSU you will need. Value Unit Exhibits are uniquely identified by a three-digit code and referred to using the nomenclature VUExxx, where xxx is the three-digit code.

Subsequent acquisitions of Value Unit priced programs offer additional price benefits for customers. The quantity of each zSeries IPLA program that you have acquired is referred to as entitled license capacity. If you want to grow your entitled license capacity for a zSeries IPLA program, the calculation to determine additional needed Value Units is based upon the number of Value Units already acquired.

For each zSeries IPLA program with Value Unit Pricing, you should:

  • Determine the required license capacity, in MSUs
  • Aggregate the MSUs across the enterprise
  • Convert the total MSUs to Value Units, using the applicable Value Unit Exhibit
  • Multiply the price per Value Unit by the total number of Value Units to determine the total cost

To simplify conversion from the designated measurement to VUs or vice-versa, use the Value Unit Converter Tool. For additional information or to obtain a copy of the Value Unit Converter Tool, visit the Value Unit Converter Tool Web site

Note that Value Units of a given product cannot be exchanged, interchanged, or aggregated with Value Units of another product.

To determine the required license capacity for the zSeries IPLA program you selected, refer to the Terms and conditions section.
 
Back topBack to top
 

Statement of direction

IBM plans to deliver a DB2 cloning tool in the future. This tool will be based on FlashCopy® technology and provide a fast, convenient method of creating a clone of a DB2 system. Included in this new tool will be:

  • The ability to rename and catalog data sets
  • Fix volume internals
  • Update any required DB2 internal information

A future announcement will provide more details and availability dates.

All statements regarding IBM's plans, directions, and intent are subject to change or withdrawal without notice.

Business Partner information

If you are a Direct Reseller - System Reseller acquiring products from IBM, you may link directly to Business Partner information for this announcement. A PartnerWorld ID and password are required (use IBM ID).

BP Attachment for Announcement Letter 206-043

Trademarks

 
IMS is a trademark of International Business Machines Corporation in the United States or other countries or both.
 
DB2, z/OS, Tivoli, OMEGAMON, zSeries, and FlashCopy are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Other company, product, and service names may be trademarks or service marks of others.

 
Back topBack to top
 
Offering Information

Product information is available via the Offering Information Web site


 
Back topBack to top
 
Publications

The IBM Publications Center portal is at

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. They can all be downloaded free of charge.

One copy of the following publications is supplied automatically with the basic machine-readable material.

                                                Order
Title                                           number
 
DB2® SQL Performance Analyzer for z/OS®, V3.1
 (5697-I04)
License Information                             GC18-9823
Program Directory                               GI10-8707
 
IMS™ Database Recovery Facility for z/OS, V3.1
 (5655-N47)
License Information                             GC18-9406
Program Directory                               GI10-8670
 
IMS High Performance Change Accumulation
 Utility for z/OS, V1.3 (5655-F59)
License Information                             GC27-1175
Program Directory                               GI10-8392

The publications for the products in this announcement cannot be ordered in hardcopy. All the publications in this announcement are available at

Publications are available in PDF and BookManager® formats on CD-ROM and on DVD on the next release of software product libraries:

  • z/OS Software Products Collection (SK3T-4270)
  • z/OS and Software Products DVD Collection (SK3T-4271) (requires a DVD drive in DVD-9 (single-sided, dual-layer) format)

                                                Order
Title                                           number
 
DB2 SQL Performance Analyzer for z/OS, V3.1
 (5697-I04)
User's Guide                                    SC18-9824
 
IMS Database Recovery Facility for z/OS, V3.1
 (5655-N47)
User's Guide                                    SC18-9407
 
IMS High Performance Change Accumulation
 Utility for z/OS, V1.3 (5655-F59)
User's Guide                                    SC27-1176

The following material is available at

  • Overview brochure: IBM DB2 and IMS Tools (GC27-1070)
  • Fact sheets:
    • DB2 SQL Performance Analyzer for z/OS, V3.1 (GC27-1038)
    • IMS Database Recovery Facility for z/OS, V3.1 (GC27-1074)
    • IMS High Performance Change Accumulation Utility for z/OS, V1.3 (GC27-1079)

Specification sheets, user's guides, and white papers are also available on CD-ROM (GK3T-7099). This CD-ROM can be ordered from the IBM Publications Center Portal at


 
Back topBack to top
 
Technical information

Hardware requirements

The products in this announcement will operate on any hardware S/390® configuration that supports the required versions of DB2 and IMS.

Software requirements

The products in this announcement require z/OS V1.4 (5694-A01), or later.

DB2 SQL Performance Analyzer for z/OS, V3.1 (5697-I04) is designed to operate with the following DB2 versions:

  • DB2 V7 (5675-DB2)
  • DB2 V8 (5625-DB2)

IMS Database Recovery Facility for z/OS, V3.1:

  • Requires:
    • z/OS V1.4 (5694-A01), or later. DFSORT™ or a functionally equivalent sort program is required.
    • One of:
      • IMS V8.1 (5655-C56) with PTF UQ90055, UK09835, UK09557, and UQ90209
      • IMS V9.1 (5655-J38) with PTF UK09922, UK04863, and UQ89994
  • Has the following functional requirements:
    • IMS HP Pointer Checker for z/OS, V2.1 (5655-K53) with APAR PK11662 for full-function database hash checking
    • IMS Index Builder for z/OS, V2.3 (5655-E24) with APAR PK11688 for primary and secondary index build
    • IMS HP Fast Path Utilities for z/OS V2.1 (5655-K94) with APAR PK11644, or later, for DEDB Hash Pointer Check
    • IMS HP Image Copy for z/OS, V4.1 (5655-N45) with APAR PK11605 for image copy

IMS High Performance Change Accumulation Utility for z/OS, V1.3 is designed to operate with the following IMS versions:

  • IMS V8 (5655-C56)
  • IMS V9 (5655-J38)

Customer requirements

Customer requirements are used extensively to determine how database tools evolve.

DB2 SQL Performance Analyzer for z/OS, V3.1 (5697-I04) satisfies the following requirements:

MR0414035214    MR0708033444    MR0816045414   MR0826045213
MR 0826045819   MR0826046221    MR0923032527   MR0923033729
MR1016056131    MR1119042549    MR112603627    MR0220037020
MR0618041925

IMS Database Recovery Facility for z/OS, V3.1 (5655-N47) satisfies the following requirements:

MR0120043552    MR0321024923    MR032504191    MR0401042240
MR0410015047    MR0413003650    MR050201296    MR0502015556
MR0502015556    MR0610021457    MR0611044028   MR0616041432
MR070401408     MR0711021839    MR0719011814   MR072704284
MR0918025330    MR0924021240    MR1009033122   MR11110398
MR1119025140    MR112304429     MR1219031444

IMS High Performance Change Accumulation Utility for z/OS, V1.3 (5655-F59) satisfies the following requirements:

MR0727041634    MR0826051015    MR1015034913

Planning information

Packaging: The programs in this announcement are distributed with the following content:

  • Basic machine-readable material on tape
  • Program Directory
  • Proof of Entitlement (PoE)
  • IBM International Program License Agreement (IPLA)

Security, auditability, and control

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

Ordering information

Charge Metric

                                 PID        Charge
Program name                     number     metric
 
DB2 SQL Performance Analyzer     5697-I04   Value Unit
 for z/OS, V3.1
IMS Database Recovery Facility   5655-N47   Value Unit
 for z/OS, V3.1
IMS High Performance Change      5655-F59   Value Unit
 Accumulation Utility for
 z/OS, V1.3

Sub-capacity Processor

The required authorized use level for eligible programs is based upon the highest utilization of the partitions where the program or a component of the program, executes. Customer agrees to periodically report program use to IBM using an IBM license management tool.

  1. The number of authorizations you must acquire is the smaller value of either of the following methods:
    1. The total number of activated (available for use) processors in the machine, or
    2. The sum of (i) and (ii) as follows (any remaining fraction of a processor must be rounded up to a full processor in the final aggregation)

      (i) When the program is run in partitions with dedicated processors, the sum of the Processing Units of those partitions, and

      (ii) When the program is run in partitions that are members of a Shared Processing Pool, the smaller of:

      1. The number of processors assigned to the pool, or
      2. The sum of the Virtual Processors of each Uncapped Partition plus the Processing Units in each Capped Partition running a program.
  2. z/VM® Guest Charging
    1. The total number of activated (available for use) processors in the machine, or
    2. The sum of (i) and (ii) as follows (any remaining fraction of a processor must be rounded up to a full processor in the final aggregation)

      (i) When the program is run in VM Guests with dedicated processors, the sum of the Integrated Facility for Linux™ (IFL) engines of those VM Guests, and

      (ii) When the program is run in VM Guests that are members of a Shared Processing Pool (z/VM), the smaller of:

      1. The number of processors assigned to the z/VM pool, or
      2. The sum of the IFL engines in each z/VM pool running a program.

The programs in this announcement all have Value Unit-based pricing.

                                          Value
Program                                   Unit
number    Program name                    Exhibit
 
5697-I04  DB2 SQL Performance Analyzer    VUE007
           for z/OS, V3.1
5655-N47  IMS Database Recovery Facility  VUE007
           for z/OS, V3.1
5655-F59  IMS High Performance Change     VUE007
           Accumulation Utility for
           z/OS, V1.3

For each IBM eServer zSeries® IPLA program with Value Unit pricing, the quantity of that program needed to satisfy applicable IBM terms and conditions is referred to as the "required license capacity." Your required license capacity is based upon the following factors:

  • The zSeries IPLA program you select
  • The applicable Value Unit Exhibit
  • The applicable terms
  • Whether your current mainframes are full-capacity or sub-capacity

Value Unit exhibit VUE007

              MSUs      MSUs
            minimum   maximum   Value Units/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 mainframes without MSU ratings:

Hardware        Value Units/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 your required license capacity is 1,500 MSUs for your selected zSeries IPLA product, the applicable Value Units would be:

             Translation from MSUs to Value Units
 
            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    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.

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

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

Basic license

On/Off Capacity on Demand

The products in this announcement are eligible for On/Off Capacity on Demand (On/Off CoD) with a Temporary Use Charge calculated based on MSUs-per day usage.

The On/Off CoD ordering information for the following product has not changed. Therefore, its On/Off CoD ordering information is not included in this announcement.

Product name                                 PID
 
IMS High Performance Change Accumulation     5655-F59
 Utility for z/OS, V1.3

The On/Off CoD ordering information for the remaining products in this announcement follows:

Program Name: DB2 SQL Performance Analyzer for z/OS, V3.1
Program PID: 5697-I04
 
Entitlement                    License Option /
Identifier   Description       Pricing Metric
 
S012CN2      DB2 SQL Perf      Basic OTC, Per MSU-day TUC
              Analyzer V3.1
 
Program Name: IMS Database Recovery Facility for z/OS, V3.1
Program PID: 5655-N47
 
Entitlement                    License Option /
Identifier   Description       Pricing Metric
 
S011L3B      IMS DB Recovery   Basic OTC, Per MSU-day TUC
              Facility V3
 

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

To order, specify the program product number and the appropriate license or charge option. Also, specify the desired distribution medium. To suppress shipment of media, select the license-only option in CFSW.

The ordering information for the following products has not changed. Therefore, ordering information is not included for these products in this announcement.

Product name                                 PID
 
Subscription and Support for DB2 SQL         5655-E97
 Performance Analyzer
Subscription and Support for IMS             5655-E33
 Database Recovery Facility
IMS High Performance Change Accumulation     5655-F59
 Utility for z/OS, V1.3
Subscription and Support for IMS High        5655-F58
 Performance Change Accumulation Utility

The ordering information for the other products in this announcement follows:

Program Name: DB2 SQL Performance Analyzer for z/OS, V3.1
Program PID: 5697-I04
 
Entitlement                    License Option /
Identifier   Description       Pricing Metric
 
S012CN2      DB2 SQL Perf      Basic OTC, Value Units
              Analyzer V3.1    Trade-up
 
Orderable
Supply ID    Language          Distribution Medium
 
S012CN3      U.S. English      3480 Tape Cartridge
 
Program Name: IMS Database Recovery Facility for z/OS, V3.1
Program PID: 5655-N47
 
Entitlement                    License Option /
Identifier   Description       Pricing Metric
 
S011L3B      IMS DB Recovery   Basic OTC, Value Units
              Facility V3
 
Orderable
Supply ID    Language          Distribution Medium
 
S011L3G      U.S. English      3480 Tape Cartridge

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 Subscription and Support program number (PID) referenced previously and the appropriate license or charge option.

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:

  • 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.

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 Offerings

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

Terms and conditions

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

These products are licensed under the IBM Program License Agreement (IPLA) and the associated Agreement for Acquisition of Software Maintenance, 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 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.

S/390 and zSeries IBM Operational Support Services — SoftwareXcel is an option for those customers who want added services.

Limited warranty: Yes

Warranty: This program includes a warranty for one year from acquisition from IBM or an authorized IBM Business Partner. For one year from acquisition of the program, this warranty provides the customer with access to databases containing program information and FAQs, including any known fixes to defects, which the customer can download or otherwise obtain and install.

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 and you are the original licensee, 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. For clarification, note that for programs acquired under any of IBM's On/Off Capacity on Demand (On/Off CoD) software offerings, this term does not apply since these offerings apply to programs already acquired and in use by the customer.

Copy and use on home/portable computer: No

Volume orders (IVO): No

Passport Advantage® applies: No

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

iSeries™ Software Maintenance applies: No

Variable charges apply: No

Educational allowance available

Yes, 15% education allowance applies to qualified education institution customers.

Replaced program             Replacement program
 
Program                      Program
number    Program name       number    Program name
 
5697-E32  Parallel Change    5655-F59  IMS High Performance
           Accumulation for             Change Accumulation
           IMS/ESA(R)                   Utility for z/OS, V1.3
 
5655-A68  IMS/ESA Recovery   5655-N47  IMS Database Recovery
           Saver                        Facility for z/OS, V3

Sub-capacity terms and conditions

For each zSeries IPLA program with Value Unit pricing, the quantity of that program needed to satisfy applicable IBM terms and conditions is referred to as the "required license capacity." Your required license capacity is based upon the following factors:

  • The zSeries IPLA program you select
  • The applicable Value Unit Exhibit
  • The applicable terms
  • Whether your current mainframes are full-capacity or sub-capacity

For more information on the Value Unit Exhibit for the zSeries IPLA program you selected, refer to the Ordering information section.

Program                                    Parents,
Number   Program Name          Terms       if applicable
 
5697-I04 DB2 SQL Performance   Reference-  DB2 V7 (5675-DB2) or
          Analyzer for          based       DB2 V8 (5625-DB2)
          z/OS, V3.1
 
5655-N47 IMS Database Recovery Reference-  IMS V8 (5655-C56) or
          Facility for          based       IMS V9 (5655-J38)
          z/OS, V3.1
 
5655-F59 IMS High Performance  Reference-  IMS V8 (5655-C56) or
          Change Accumulation   based       IMS V9 (5655-J38)
          Utility for
          z/OS, V1.3

Full-capacity mainframes: In cases where full-capacity is applicable, the following terms apply:

Execution-based, z/OS-based, full machine-based: The required capacity of a zSeries IPLA program with these terms equals the MSU rated capacity of the machines where the zSeries IPLA program executes.

For more information on mainframe MSU rated capacities, visit the Web site

Reference-based: The required license capacity of a zSeries IPLA program with these terms equals the license capacity of the applicable monthly license charge (MLC) program. This MLC program is called the "parent" program.

Sub-capacity mainframes: In cases where sub-capacity is applicable, the following terms apply:

Execution-based: The required capacity of a zSeries IPLA sub-capacity program with these terms equals the capacity of the LPARs where the zSeries IPLA program executes.

z/OS-based: The required license capacity of a zSeries IPLA program with these terms equals the license capacity of z/OS (and z/OS.e) on the machines where the zSeries IPLA program executes.

Reference-based: The required license capacity of a zSeries IPLA program with these terms equals the license capacity of the applicable monthly license charge (MLC) program. This MLC program is called the "parent" program.

Full machine-based: The required license capacity of a zSeries IPLA program with full machine-based terms equals the MSU rated capacity of the machines where the zSeries IPLA program executes.

For more information on mainframe MSU rated capacities, refer to The System/370™, System/390®, and zSeries Machine Exhibit (Z125-3901) or visit the "Mainframes" section of the zSeries Exhibits Web site

For more information on sub-capacity zSeries IPLA terms and conditions, refer to Software Announcement 204-184 , dated August 10, 2004.

Additional information for products with reference-based terms

zSeries IPLA sub-capacity programs with reference-based terms add value to the parent program across the environment, regardless of where in the environment the zSeries IPLA program executes.

An environment is defined as either a single/stand-alone machine or a qualified Parallel Sysplex®. Customers may have one or more different environments across their enterprise. To determine the required license capacity for each zSeries IPLA program with referenced-based terms, each environment should be assessed separately.

When a zSeries IPLA sub-capacity program with reference-based terms is used in a qualified Parallel Sysplex environment, the required license capacity of the zSeries IPLA program must equal with the license capacity of the parent program across the Parallel Sysplex. Qualified Parallel Sysplex refers to one:

  1. That meets the criteria defined in Hardware Announcement 198-001 , dated January 13, 1998
  2. Where MLC pricing is aggregated across the Sysplex

Sub-capacity eligibility: To be eligible for sub-capacity charging on select zSeries IPLA programs, you must first implement and comply with all terms of either sub-capacity Workload License Charges (WLC) or sub-capacity Entry Workload License Charges (EWLC). To implement sub-capacity WLC or EWLC, a machine must be zSeries (or equivalent). On that machine:

  • All instances of the OS/390® operating system must be migrated to the z/OS (or z/OS.e) operating systems
  • Any licenses for the OS/390 operating system must be discontinued
  • All instances of the z/OS operating (or z/OS.e) systems must be running in z/Architecture™ (64-bit) mode

For that machine, you must create and submit a Sub-Capacity Report to IBM each month. Sub-Capacity Reports must be generated using the Sub-Capacity Reporting Tool (SCRT). For additional information or to obtain a copy of SCRT, visit the zSeries Software Pricing Web site

You must comply with all of the terms of the WLC or EWLC offering, whichever is applicable:

  • The complete terms and conditions of sub-capacity WLC are defined in the IBM Customer Agreement — Attachment for zSeries Workload License Charges (Z125-6516).
  • The complete terms and conditions for sub-capacity EWLC are defined in the IBM Customer Agreement — Attachment for IBM eServer zSeries 890 and 800 License Charges (Z125-6587).

Additionally, you must sign and comply with the terms and conditions specified in the amendment to the IPLA contract — Amendment for IBM System z9™ and eServer® zSeries Programs Sub-Capacity Pricing (Z125-6929). Once the amendment is signed, the terms in the amendment replace any and all previous zSeries IPLA sub-capacity terms and conditions.

Sub-capacity utilization determination

Sub-capacity utilization is determined based on the utilization of a sub-capacity eligible reference product and machine.

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
 

Prices

Pricing information for the products has not changed. Therefore, it is not included in this announcement.

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, 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

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.
 
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:  callserv@ca.ibm.com
 Mail:      IBM Americas Call Centers
            Dept. Teleweb Customer Support, 9th 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

 
IMS, DFSORT, iSeries, System/370, z/Architecture, and System z9 are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
The e-business logo, z/OS, DB2, BookManager, S/390, z/VM, zSeries, SystemPac, Passport Advantage, IMS/ESA, eServer, System/390, Parallel Sysplex, and OS/390 are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Linux is a trademark of Linus Torvalds in the United States, other countries or both.
 
Other company, product, and service names may be trademarks or service marks of others.

Back to topBack to top
 

 
Printable version Printable version