IBM United States
Software Announcement 200-298
September 12, 2000

IBM Tools for Database Performance Management

 ENUS200-298.PDF (52KB)

(Corrected on Ocotober 30, 2000)

Text regarding product support clarified.

At a Glance

IBM Tools for Database Performance Management:

  • Provide you the ability to monitor both system and application performance
  • Provide you with guidance on how to improve performance — be it SQL tuning or Utility tuning

For ordering, contact:

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

Overview

Today, IBM announces products to help manage database performance:

  • IBM DB2® Performance Monitor for OS/390® Version 7
  • IBM DB2 SQL Performance Analyzer for OS/390 Version 1
  • IBM DB2 Query Monitor for OS/390 Version 1
  • IBM IMS™ Performance Analyzer for OS/390 Version 3
  • IBM IMS Queue Control Facility for OS/390 Version 1

Performance management tools help you to keep your database environment operating at peak performance.

All of these products can be a tremendous aid to performance management of your database environment. Try these new and repositioned tools today and see the benefits.

Key Prerequisites

The database tools products in this announcement will operate on any S/390® hardware configuration that supports the required version of the supported database (IMS for OS/390 or DB2 for OS/390). For a list of the required versions of DB2 and IMS, refer to the Hardware Requirements section.

Planned Availability Dates

  • September 22, 2000, for IMS Performance Analyzer for OS/390 Version 3
  • November 17, 2000, for IMS Queue Control Facility for OS/390 Version 1
  • December 1, 2000, for DB2 Performance Monitor for OS/390 Version 7
  • December 1, 2000, for DB2 SQL Performance Analyzer for OS/390 Version 1
  • December 1, 2000, for DB2 Query Monitor for OS/390 Version 1

Description

Today, IBM introduces products to help manage database performance:

  • IBM DB2 Performance Monitor
  • IBM DB2 SQL Performance Analyzer
  • IBM DB2 Query Monitor
  • IBM IMS Performance Analyzer
  • IBM IMS Queue Control Facility

Performance management tools help you to keep your database environment operating at peak performance.

IBM DB2 Performance Monitor for OS/390 Version 7 is IBM's strategic tool for analyzing, controlling, and tuning the performance of a DB2 for OS/390 system as well as DB2 applications. DB2 PM can be used in the following ways:

  • Online monitoring allows you to obtain a "snap-shot" view of DB2 activities, while the history facility allows you view events both recently and in a more distant past. With the workstation-based Monitor you can monitor all your DB2 subsystems in parallel. It has interfaces to other IBM DB2 tools, such as Visual Explain, for explaining SQL statements, and it can be launched by other tools, such as the DB2 Control Center.
  • Use the wide variety of reports provided or customize them for even more in-depth performance analysis.
  • DB2 Trace data can be stored in the DB2 Performance Monitor performance database for further investigation and trend analysis.
  • Threshold-based and event-based exception event processing allows you to be notified of exceptional system situations immediately via online alerts, via user exits to system monitors such as NetView®, or during report processing.

Now with Version 7, you can take advantage of new functions:

  • Data Sharing (Sysplex) Monitoring Online with group scope view
  • Dynamic SQL statement cache monitoring
  • Buffer pool dataset statistics
  • New Event exceptions:
    • Activity Log Dataset full
    • Dataset extent activity
    • Units of recovery inflight/indoubt
  • An application programming interface (API) that you can use to easily retrieve performance data and pass it to an application program

DB2 Performance Monitor continues to provide you with a powerful set of functions to do your daily work in analyzing, controlling, and tuning your DB2 environment.

DB2 Performance Monitor supports all instrumentation, catalog, and PLAN_Table changes, including those introduced in DB2 UDB for OS/390, Version 7. With DB2 PM, you can rely upon timely and comprehensive support of performance evaluation and analysis.

IBM DB2 SQL Performance Analyzer for OS/390 Version 1 delivers performance analysis for all phases of database application design and development. Developing applications under DB2 today requires the cooperative skills of the system architect, the database administrator, the programming staff, and members of the systems support team. In the daily quest to produce applications on time and within budget, too often corners are cut such that performance is not adequately considered. Once put into production, these applications fail to perform adequately, particularly at high transaction volumes. In addition, even applications that originally performed well may deteriorate over time due to changes in data distribution and data volume, system changes, and even changes to the DB2 product itself. Therefore, installations spend a great deal of their budget managing the performance of their applications.

All DB2 problem queries have one thing in common. They run too long. These queries cause the batch production window to shrink. Too often the online queries take what seems like forever to execute, causing customers and users to become frustrated. The most cost-effective solution to the problem is prevention. IBM is introducing DB2 SQL Performance Analyzer to aid in preventing queries from running too long. With this tool you can find out how long queries will take:

  • Before you run them
  • Before resources are consumed
  • Before the query exceeds your installation's governor settings

Query cost can be determined regardless of which DB2 attach is used and regardless of whether static or dynamic SQL is used. Estimates are given in familiar units like CPU time, I/O count, and elapsed time and in even simpler terms, such as a single number representing overall cost. In addition, a monetary cost for each query is computed and delivered with the above.

IBM DB2 Query Monitor for OS/390 Version 1 helps you to maximize DB2 availability. Query monitoring facilities can generate mountains of data, most of which might be insignificant for your specific purposes. The key to generating information useful to you, then, is to customize what is gathered during the query monitoring process, and to make sure that activity of interest grabs your attention.

IBM DB2 Query Monitor provides extensive choice in determining what data is gathered during activity monitoring, when it is gathered, about whom and what database resources, and then what alerts and corrective action should be executed. Monitoring agents, which can be started and stopped dynamically, use menu-driven criteria to watch up to 64 DB2 subsystems. As defined by administrators, data gathered is offloaded at intervals from memory to storage. IBM DB2 Query Monitor provides powerful, real-time views into the query processing events occurring in your enterprise OS/390 environment.

IBM IMS Performance Analyzer for OS/390 Version 3 is fast becoming the standard for IMS resource and performance management. Providing a wide variety of reports, IMS/ESA® Performance analyzer can help:

  • Shorten transaction response times
  • Enhance message region and queue use
  • Improve buffer pool usage
  • Increase resource availability
  • Boost system and application programmer productivity
  • Reduce the need to run IMS utilities
  • Provide ongoing system management and measurement reports

IMS Performance Analyzer Version 3 provides enhancements to existing functions and adds support for the IMS Fast Path environment. Version 2 includes:

  • An easy-to-use ISPF user interface
  • Improved reporting capabilities
  • New support for Fast Path
  • New support for IMS Monitor Reports (DFSUTR20 and DFSUTR30)
  • Support for IMS Versions 5, 6, and 7, from a single load library

IMS Performance Analyzer Version 3 helps provide more of the information you need to better manage IMS performance and resources.

IBM IMS Queue Control Facility for OS/390 Version 1 opens the door to a new era of managing IMS transaction queues. Building on the capabilities of the IBM IMS Message Requeuer product, the IMS Queue Control Facility (QCF) moves beyond IMS transaction requeuing to become a robust IMS queue management solution.

QCF provides all the functions of IMS Message Requeuer and a lot more. QCF introduces an interactive ISPF front end, allowing the user to Browse, Query, Unload, and Dequeue messages, set controls for the new Queue Overflow Protection feature, and more. Message selection capabilities have been enhanced and features added to locate checkpoints faster. QCF supports both IMS Standard Queues and Shared Queues.

Subscription and Support

Base support for these products is included as part of the one-time charge for the product and is provided by the IBM Support Center. This support is subject to the terms of the IBM International Program License Agreement (IPLA) contained in the program package. This base support includes resolution of defects in the IBM program. This support is provided via mail or fax and is available until the end of service date listed in this announcement.

IBM is also providing enhanced 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 (voice support for defects during normal business hours)
  • Entitles customers to future versions and releases at no additional charge

New License Agreement for Selected S/390 Software

IBM is announcing selected S/390 software products with revised provisions. These products are licensed under the IBM Program License Agreement (IPLA), and support is provided under the Agreement for Acquisition of Support and its Addendum (Z125-6336). 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. SupportLine is an option for those customers who desire added services.

Year 2000

These products are Year 2000 ready. When used in accordance with their associated documentation, they are capable of correctly processing, providing, and/or receiving date data within and between the twentieth and twenty-first centuries, provided that all products (for example, hardware, software, and firmware) used with the products properly exchange accurate date data with them.

The service end date for these Year 2000 ready products is November 30, 2003.

Euro Currency

These programs are not impacted by euro currency.

Trademarks

 
IMS is a trademark of International Business Machines Corporation in the United States or other countries or both.
 
DB2, OS/390, S/390, NetView, and IMS/ESA 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.

Offering Information

Product information will be available on day of announcement through Offering Information (OITOOL) at:

Publications

The following publications will be available at product availability. To order, contact your IBM representative.

                                                  Order
Title                                             Number
 
DB2(R) Performance Monitor
 License Information                              GC27-1089
 General Information                              GC27-0852
 Report Reference, Volume 1                       SC27-0853
 Report Reference, Volume 2                       SC27-0854
 Command Reference                                SC27-0855
 Messages                                         SC27-0856
 Batch User's Guide                               SC27-0857
 Online Monitor User's Guide                      SC27-0858
 Using the Workstation Online Monitor             SC27-0859
 Installation and Customization                   SC27-0860
 Data Collector Application Programming           SC27-0861
  Interface Guide
 
DB2 SQL Performance Analyzer
 License Information                              GC27-1001
 User's Guide                                     SC27-1002
 Install Guide                                    SC27-1003
 
DB2 Query Monitor
 License Information                              GC27-0969
 User's Guide                                     SC27-0968
 
IMS(TM) Performance Analyzer
 License Information                              GC27-0914
 User's Guide                                     SC27-0912
 Reporting Analysis Guide                         SC27-0913
 
IMS Queue Control Facility
 License Information                              GC26-9686
 User's Guide                                     SC26-9685

Displayable Softcopy Publications

Publications for the programs are offered in displayable softcopy form. All unlicensed manuals are included. The displayable manuals are part of the basic machine-readable material. The files are shipped on CD-ROM.

These displayable manuals can be used with the BookManager® READ licensed programs in any of the supported environments. Terms and conditions for use of the machine-readable files are shipped with the files.

Technical Information

Specified Operating Environment

Hardware Requirements

Processors: The database tools products in this announcement will operate on any S/390® hardware configuration that supports the required version of the supported database (IMS for OS/390® or DB2 for OS/390).

Database Tools Product                  Supported Database
 
IBM DB2 Performance                     5655-DB2, DB2 Version 5,
 Monitor                                 or later
 
IBM DB2 SQL                             5655-DB2, DB2 Version 5,
 Performance Analyzer                    or later
 
IBM DB2 Query Monitor                   5655-DB2, DB2 Version 5,
                                         or later
 
IBM IMS Performance                     5695-176, IMS Version 5,
 Analyzer                                or later
 
IBM IMS Queue Control                   5695-176, IMS Version 5,
 Facility                                or later

DB2 Performance Monitor Requirements: DB2 Performance Monitor has the following dependencies.

  • For the host-based Online Monitor, a display station supported by Interactive System Productivity Facility (ISPF)
  • For the host-based graphics facility, an IBM color graphics display station, or equivalent, supported by Graphical Data Display Manager (GDDM®)

The DB2 PM Workstation-Based Online Monitor has the following dependencies:

  • A high-resolution monitor
  • A workstation that supports OS/2® Version 3 or Windows NT™ Version 4.0
  • Approximately 40 MB of hard disk space

Software Requirements

The database tools products in this announcement will operate on any software configuration that supports the required version of the supported database (IMS for OS/390 or DB2 for OS/390).

Database Tools Product                  Supported Database
 
IBM DB2 Performance                     5655-DB2, DB2 Version 5,
 Monitor                                 or later
 
IBM DB2 SQL                             5655-DB2, DB2 Version 5,
 Performance Analyzer                    or later
 
IBM DB2 Query Monitor                   5655-DB2, DB2 Version 5,
                                         or later
 
IBM IMS Performance                     5695-176, IMS Version 5,
 Analyzer                                or later
 
IBM IMS Queue Control                   5695-176, IMS Version 5,
 Facility                                or later

DB2 Performance Monitor Requirements: DB2 Performance Monitor supports an environment of multiple DB2 releases, namely instrumentation, catalog, and PLAN_TABLE data from:

  • DB2 UDB for OS/390, Version 7 (5675-DB2)
  • DB2 UDB for OS/390, Version 6 (5645-DB2)
  • DB2 for OS/390, Version 5 (5655-DB2)

Function-Dependent Program Requirements

  • DB2 PM runs in the same OS/390 and MVS™ environments as described for the DB2 for OS/390 versions listed above.

For the host-based graphics facility:

  • Graphical Data Display Manager (GDDM) Version 2 Release 3 (5665-356)
  • GDDM Presentation Graphics Feature (GDDM/PGF) Version 2 Release 1.1 (5668-812)

For the workstation-based Online Monitor, either of:

  • OS/2, which requires both:
    • OS/2 Version 3 or above
    • Personal Communications AS/400® and 3270 Version 4.1 (5622-972)
  • Windows NT Version 4.0

    Windows NT uses TCP/IP to communicate with the programs that run on OS/390, and so requires TCP/IP for MVS, Version 3 Release 2 (5655-HAL).

The new workstation PRINT option requires:

  • For OS/2, Netscape 4.0 or above
  • For Windows NT, any Web browser that can handle HTML documents

Online Data Sharing Monitoring and Display of bufferpool dataset statistics require:

  • DB2 UDB for OS/390, Version 6 (5645-DB2) with service to PUT 0003, or later

Optional Programs: You can use the following optional features of DB2 UDB for OS/390 with DB2 PM for OS/390, Version 7. Unless otherwise specified, the release shown and any subsequent release are acceptable. In some cases, earlier versions or releases may also work with DB2 PM for OS/390, but IBM may not have tested them at the time this document was published. If you have questions, check with your IBM representative.

  • Database administration and systems management support

    DB2 Performance Monitor for OS/390 may be launched by:

    • DB2 Control Center, an element of the DB2 Management Tools Package, a feature of DB2 for OS/390, Version 5, or later

    To explain an executing SQL statement, the DB2 PM Workstation Monitor launches:

    • DB2 Visual Explain, an element of the DB2 Management Tools Package, a feature of DB2 for OS/390, Version 5, or later
  • Query support

    The following query product may be used to query the DB2 PM performance database:

    • Query Management Facility (QMF™), a feature of DB2 for OS/390, Version 6, or later
  • Utility support

    DB2 Performance Monitor for OS/390 gives you the capability to trace and report utility processing provided by:

    • DB2 Utilities, a function of DB2 for OS/390, Version 5, or later

The DB2 PM Workstation-Based Online Monitor API is supported on the following platforms:

  • IBM AIX® Version 4.3
  • Microsoft™ Windows NT 4.0
  • Sun Solaris 5.6 (32 bit) and Sun Solaris 5.7 (64 bit)
  • LINUX® Version 2.2 on Intel® (X86)
  • OS/390 Version 2.7

Compatibility: The database tools products in this announcement are compatible with the following database environments:

Database Tools Product                  Database Environment
 
IBM DB2 Performance                     5655-DB2, DB2 Version 5,
 Monitor                                 or later
 
IBM DB2 SQL                             5655-DB2, DB2 Version 5,
 Performance Analyzer                    or later
 
IBM DB2 Query Monitor                   5655-DB2, DB2 Version 5,
                                         or later
 
IBM IMS Performance                     5695-176, IMS Version 5,
 Analyzer                                or later
 
IBM IMS Queue Control                   5695-176, IMS Version 5,
 Facility                                or later

Planning Information

Packaging: The IBM DB2 Performance Monitor for OS/390 (5655-E61) package is distributed with the following contents:

  • Basic machine-readable material on the customer-selected distribution medium (either 9/6250 tape, 3480 tape cartridge, or 4-mm DAT cartridge)
  • Memo to Users
  • Program Directory
  • Proof of Entitlement
  • IBM International Program License Agreement (IPLA)
  • License Information (GC27-1089)
  • Messages (SC27-0856)
  • Batch User's Guide (SC27-0857)
  • Using the Workstation Online Monitor (SC27-0859)
  • Installation and Customization (SC27-0860)

The IBM DB2 SQL Performance Analyzer for OS/390 (5697-F57) package is distributed with the following contents:

  • Basic machine-readable material on the customer-selected distribution medium (either 9/6250 tape, 3480 tape cartridge, or 4-mm DAT cartridge)
  • Memo to Users
  • Program Directory
  • Proof of Entitlement
  • IBM International Program License Agreement (IPLA)
  • License Information (GC27-1001)
  • User's Guide (SC27-1002)
  • Install Guide (SC27-1003)

The IBM DB2 Query Monitor for OS/390 (5655-E67) package is distributed with the following contents:

  • Basic machine-readable material on the customer-selected distribution medium (either 9/6250 tape, 3480 tape cartridge, or 4-mm DAT cartridge)
  • Memo to Users
  • Program Directory
  • Proof of Entitlement
  • IBM International Program License Agreement (IPLA)
  • License Information (GC27-0969)
  • User's Guide (SC27-0968)

The IBM IMS Performance Analyzer for OS/390 (5655-E15) package is distributed with the following contents:

  • Basic machine-readable material on the customer-selected distribution medium (either 9/6250 tape, 3480 tape cartridge, or 4-mm DAT cartridge)
  • Memo to Users
  • Program Directory
  • Proof of Entitlement
  • IBM International Program License Agreement (IPLA)
  • License Information (GC27-0914)
  • User's Guide (SC27-0912)
  • Reporting Analysis Guide (SC27-0913)

The IBM IMS Queue Control Facility for OS/390 (5697-E99) package is distributed with the following contents:

  • Basic machine-readable material on the customer-selected distribution medium (either 9/6250 tape, 3480 tape cartridge, or 4-mm DAT cartridge)
  • Memo to Users
  • Program Directory
  • Proof of Entitlement
  • IBM International Program License Agreement (IPLA)
  • License Information (GC26-9686)
  • User's Guide (SC26-9685)

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.

Ordering Information

Each of the following is a product that has one charge unit (MSUs):

  • IBM DB2 Performance Monitor for OS/390 V7
  • Subscription and Support for IBM DB2 Performance Monitor for OS/390 V7
  • IBM DB2 SQL Performance Analyzer for OS/390 V1
  • Subscription and Support for IBM DB2 SQL Performance Analyzer for OS/390 V1
  • IBM DB2 Query Monitor for OS/390 V1
  • Subscription and Support for IBM DB2 Query Monitor for OS/390 V1
  • IBM IMS Performance Analyzer for OS/390 V3
  • Subscription and Support for IBM IMS Performance Analyzer for OS/390 V3
  • IBM IMS Queue Control Facility for OS/390 V1
  • Subscription and Support for IBM IMS Queue Control Facility for OS/390 V1

Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration, the appropriate charge feature numbers and quantities, and the feature number of the desired distribution medium.

New Customers: Specify the appropriate one-time charge (OTC) feature numbers with the desired quantity represented by the sum of Service Units in Millions (MSUs) ratings of the designated machines.

                                                         One-
                                                         Time
                                                         Charge
                                        Program          Feature
Description                             Number           Number
 
IBM DB2 Performance Monitor             5655-E61
 for OS/390 V7
 
 1 -- 45 MSUs                                            0001
 46 -- 175 MSUs                                          0002
 176 -- 315 MSUs                                         0003
 316+ MSUs                                               0004
 176 -- 315 MSUs (quantity 250)                          0005
 316+ MSUs (quantity 250)                                0006
 
                                                         One-
                                                         Time
                                                         Charge
                                        Program          Feature
Description                             Number           Number
 
IBM DB2 SQL Performance                 5697-F57
 Analyzer for OS/390 V1
 
 1 -- 45 MSUs                                            0001
 46 -- 175 MSUs                                          0002
 176 -- 315 MSUs                                         0003
 316+ MSUs                                               0004
 176 -- 315 MSUs (quantity 250)                          0005
 316+ MSUs (quantity 250)                                0006
 
IBM DB2 Query Monitor                   5655-E67
 for OS/390 V1
 
 1 -- 45 MSUs                                            0018
 46 -- 175 MSUs                                          0019
 176 -- 315 MSUs                                         0020
 316+ MSUs                                               0021
 176 -- 315 MSUs (quantity 250)                          0022
 316+ MSUs (quantity 250)                                0023
 
IBM IMS Performance Analyzer            5655-E15
 for OS/390 V3
 
 1 --  45 MSUs                                           0018
 46 -- 175 MSUs                                          0019
 176 -- 315 MSUs                                         0020
 316+ MSUs                                               0021
 176 -- 315 MSUs (quantity 250)                          0022
 316+ MSUs (quantity 250)                                0023
 
IBM IMS Queue Control Facility          5697-E99
 for OS/390 V1
 
 1 -- 45 MSUs                                            0019
 46 -- 175 MSUs                                          0020
 176 -- 315 MSUs                                         0021
 316+ MSUs                                               0022
 176 -- 315 MSUs (quantity 250)                          0005
 316+ MSUs (quantity 250)                                0006

Example 1: For DB2 Performance Monitor, machines with 200 MSUs would order feature number 0003, quantity 200.

Example 2: For DB2 Performance Monitor, machines with 300 MSUs would order feature number 0003, quantity 50, and feature number 0005, quantity 1.

Subsequent orders for additional MSUs are considered independent transactions. MSU quantities previously ordered are not accumulated to determine an ordering tier.

Example 3: For DB2 Performance Monitor, to add 50 additional MSUs, a new order would be placed for feature number 0002, quantity 50.

Trade-In Customers: These products are available at a one-time upgrade price for those customers currently licensed for competitive database performance management products. Customers must provide an original proof of purchase (front of user manual, front of cartridge insert, or copy of purchase invoice/bill of sale). Specify the appropriate OTC trade-in feature numbers with the desired quantity represented by the sum of MSUs of the designated machines.

                                                         One-
                                                         Time
                                                         Charge
                                                         Trade-In
                                        Program          Feature
Description                             Number           Number
 
IBM DB2 Performance Monitor             5655-E61
 for OS/390 V7 -- Trade-In
 
 1 --  45 MSUs                                           0007
 46 -- 175 MSUs                                          0008
 176 -- 315 MSUs                                         0009
 316+ MSUs                                               0010
 176 -- 315 MSUs (quantity 250)                          0011
 316+ MSUs (quantity 250)                                0012
 
IBM DB2 SQL Performance                 5697-F57
 Analyzer for OS/390 V1
 -- Trade-In
 
 1 --  45 MSUs                                           0009
 46 -- 175 MSUs                                          0010
 176 -- 315 MSUs                                         0011
 316+ MSUs                                               0012
 176 -- 315 MSUs (quantity 250)                          0013
 316+ MSUs (quantity 250)                                0014
 
IBM DB2 Query Monitor for               5655-E67
 OS/390 V1 -- Trade-In
 
 1 -- 45 MSUs                                            0027
 46 -- 175 MSUs                                          0028
 176 -- 315 MSUs                                         0029
 316+ MSUs                                               0030
 176 -- 315 MSUs (quantity 250)                          0031
 316+ MSUs (quantity 250)                                0032
 
IBM IMS Performance Analyzer            5655-E15
 for OS/390 V3 -- Trade-In
 
 1 -- 45 MSUs                                            0025
 46 -- 175 MSUs                                          0026
 176 -- 315 MSUs                                         0027
 316+ MSUs                                               0028
 176 -- 315 MSUs (quantity 250)                          0029
 316+ MSUs (quantity 250)                                0030
 
IBM IMS Queue Control Facility          5697-E99
 for OS/390 V1 -- Trade-In
 
 1 -- 45 MSUs                                            0008
 46 -- 175 MSUs                                          0009
 176 -- 315 MSUs                                         0010
 316+ MSUs                                               0011
 176 -- 315 MSUs (quantity 250)                          0012
 316+ MSUs (quantity 250)                                0013

Subscription and Support: To receive voice technical support via telephone (voice support for defects during normal business hours) and future versions and releases at no additional charge, subscription and support must be ordered.

To order, specify the support program number and feature number 9001 for asset registration. Specify the annual support charge feature number with the desired quantity represented by the sum of MSUs of the designated machines.

Once subscription and support is ordered, the charges will automatically renew annually unless cancelled by the customer.

                                                         Annual
                                                         Support
                                                         Charge
                                        Program          Feature
Description                             Number           Number
 
Subscription and Support                5655-E81
 for IBM DB2 Performance
 Monitor for OS/390 V7
 
 1 -- 45 MSUs                                            0001
 46 -- 175 MSUs                                          0002
 176 -- 315 MSUs                                         0003
 316+ MSUs                                               0004
 176 -- 315 MSUs (quantity 250)                          0005
 316+ MSUs (quantity 250)                                0006
 
Subscription and Support for            5655-E97
 IBM DB2 SQL Performance
 Analyzer for OS/390 V1
 
 1 -- 45 MSUs                                            0006
 46 -- 175 MSUs                                          0005
 176 -- 315 MSUs                                         0003
 316+ MSUs                                               0001
 176 -- 315 MSUs (quantity 250)                          0004
 316+ MSUs (quantity 250)                                0002
 
Subscription and Support                5655-E87
 for IBM DB2 Query Monitor
 for OS/390 V1
 
 1 -- 45 MSUs                                            0001
 46 -- 175 MSUs                                          0004
 176 -- 315 MSUs                                         0005
 316+ MSUs                                               0002
 176 -- 315 MSUs (quantity 250)                          0006
 316+ MSUs (quantity 250)                                0003
 
Subscription and Support                5655-E18
 for IBM IMS Performance
 Analyzer for OS/390 V3
 
 1 -- 45 MSUs                                            0003
 46 -- 175 MSUs                                          0006
 176 -- 315 MSUs                                         0001
 316+ MSUs                                               0004
 176 -- 315 MSUs (quantity 250)                          0002
 316+ MSUs (quantity 250)                                0005
 
Subscription and Support                5655-E99
 for IBM IMS Queue Control
 Facility for OS/390 V1
 
 1 -- 45 MSUs                                            0004
 46 -- 175 MSUs                                          0001
 176 -- 315 MSUs                                         0005
 316+ MSUs                                               0002
 176 -- 315 MSUs (quantity 250)                          0006
 316+ MSUs (quantity 250)                                0003

Basic Machine-Readable Material

                        Feature
Environment             Number               Distribution Medium
 
IBM DB2 Performance Monitor for OS/390 (5655-E61)
 
OS/390                  5801                 9/6250 tape
OS/390                  5802                 3480 tape cartridge
OS/390                  6098                 4-mm DAT cartridge
 
                        Feature
Environment             Number               Distribution Medium
 
IBM DB2 SQL Performance Analyzer for OS/390
 (5697-F57)
 
OS/390                  5801                 9/6250 tape
OS/390                  5802                 3480 tape cartridge
OS/390                  6227                 4-mm DAT cartridge
 
IBM DB2 Query Monitor for OS/390 (5655-E67)
 
OS/390                  5801                 9/6250 tape
OS/390                  5802                 3480 tape cartridge
OS/390                  6137                 4-mm DAT cartridge
 
IBM IMS Performance Analyzer for OS/390 (5655-E15)
 
OS/390                  5801                 9/6250 tape
OS/390                  5802                 3480 tape cartridge
OS/390                  6125                 4-mm DAT cartridge
 
IBM IMS Queue Control Facility for OS/390 (5697-E99)
 
OS/390                  5801                 9/6250 tape
OS/390                  5802                 3480 tape cartridge
OS/390                  5042                 4-mm DAT cartridge

Customization Options: Select the appropriate feature numbers to customize your order with delivery options desired. These features can be specified on the initial or MES orders.

Example: If publications are not desired for the initial order, specify feature number 3470 to ship media only. For future updates, specify feature number 3480 to ship media updates only. If, in the future, publication updates are required, order an MES to remove feature number 3480; then, the publications will ship with the next release of the program.

                                                    Feature
Description                                         Number
 
Initial Shipments
 
Serial Number Only (suppresses shipment             3444
 of media and documentation)
 
Ship Media Only (suppresses initial                 3470
 shipment of documentation)
 
Ship Documentation Only (suppresses                 3471
 initial shipment of media)
 
Update Shipments
 
Ship Media Updates Only (suppresses                 3480
 update shipment of documentation)
 
Ship Documentation Only (suppresses                 3481
 update shipment of media)
 
Suppress Updates (suppresses update                 3482
 shipment of media and documentation)
 
Expedite Shipments
 
Local IBM Office Expedite                           3445
 (for IBM use only)
 
Customer Expedite Process Charge                    3446
 ($30 charge for each product)

Expedite shipments will be processed to receive 72-hour delivery from the time IBM Software Delivery and Fulfillment (SDF) receives the order. SDF will then ship the order via overnight air transportation.

Terms and Conditions

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

For the subscription and support offering — IBM Agreement for Acquisition of Programs and Support (Z125-5790), or IBM International Agreement for Acquisition of Support (Z125-6011), or IBM International Agreement for Acquisition of Programs and Support (Z125-5599) with the Attachment for Support and its Addendum for Support for Database Tools (Z125-6336).

Limited Warranty Applies: Yes

Program Services: Available until November 30, 2003

Money-Back Guarantee: Two-month, money-back guarantee

Copy and Use on Home/Portable Computer: No

Volume Orders (IVO): No

Passport Advantage Applies: No

Passport Advantage Subscription Applies: No

Support Line: Yes

AIX/UNIX® Upgrade Protection Applies: No

Entitled Upgrade for Current AIX/UNIX Upgrade Protection Licensees: No

AS/400 Software Subscription Applies: No

Variable Charges Apply: No

Educational Allowance Available: Yes, 15% education allowance applies to qualified education institution customers.

Prices

Contact your IBM representative for charges information for this announcement.

Order Now

 Use Priority/Reference Code: LE001
 
 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@us.ibm.com
 Mail:      IBM Atlanta Sales Center
            Dept. LE001
            P.O. Box 2690
            Atlanta, GA  30301-2690

You can also contact your local IBM Business Partner or IBM representative. To identify them, call 800-IBM-4YOU.

Note: Shipments will begin after the planned availability date.

Trademarks

 
IMS, MVS, and QMF are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, BookManager, S/390, OS/390, GDDM, OS/2, AS/400, and AIX are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Intel is a registered trademark of Intel Corporation.
 
Windows NT and Microsoft are trademarks of Microsoft Corporation.
 
UNIX is a registered trademark in the United States and other countries exclusively through X/Open Company Limited.
 
LINUX is a registered trademark of Linus Torvalds.
 
Other company, product, and service names may be trademarks or service marks of others.