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

IBM United States Software Announcement 208-044
March 4, 2008

 

 ENUS208044.PDF (55KB)

 

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

 
At a glance

DB2 Optimization Expert for z/OS, V1.2 and DB2 Query Monitor for z/OS, V2.3 help you monitor and manage the performance of your DB2 applications and database systems.

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 product releases offer enhancements to help manage DB2® database environments:

  • DB2 Optimization Expert for z/OS®, V1.2 (5655-S19) supports monitoring and tuning of SQL statements that run as part of a workload on your DB2 for z/OS subsystem.
  • DB2 Query Monitor for z/OS, V2.3 (5697-I03) gives you the ability to efficiently customize and tune your structured query language (SQL) workload and DB2 objects.

All DB2 for z/OS tools are now referenced-based to both the previously announced versions of DB2 for z/OS and DB2 for z/OS Value Unit Edition. Refer to 208-041 , dated February 26, 2008, for more information about the DB2 for z/OS Value Unit Edition product or talk to your IBM representative.

To view a complete list of the DB2 tools, visit


 
Back topBack to top
 
Key prerequisites

Prerequisites are listed in the Hardware requirements and Software requirements sections.
 
Back topBack to top
 

Planned availability date

March 14, 2008
 
Back topBack to top
 

Description

DB2 Optimization Expert for z/OS, V1.2 (5655-S19) introduces support for DB2 for z/OS, V8 and provides the ability to capture a workload across a data-sharing group. Many rules have been added to the advisors, and new user-specified "what-if" and table-based priority options have been added to the Index Advisor. Users can now extract queries directly from SQL Stored Procedures. Both experienced DBAs and application programmers will find DB2 Optimization Expert V1.2 easy to use and customize with powerful new filters, views, and search options. Enhancements include:

  • DB2 for z/OS, V8 support: DB2 for z/OS, V8 Compatibility Mode (CM) DB2 for z/OS, V8 New Function Mode (NFM)
  • Extended ability to capture queries:
    • Retrieve queries from SQL procedures
    • Retrieve queries from plans or packages based on tables, views, and indexes dependencies
    • New predefined view types for AVG_CPU_DESC and AVG_ELAP_DESC
    • New dynamic statement cache search options
    • A new stored procedure to extract queries from dynamic statement cache to support users without SYSADM authority
  • Extended ability to capture, export, and import workloads:
    • Users can capture workloads from the cache and create monitor profiles across an entire data-sharing group.
    • Users can export a workload from one DB2 subsystem and import to another DB2 subsystem.
    • Users can customize filters for object, access path, or cost-based searches.
  • Service Workload: A new component collects DDL statements, statistics, and EXPLAIN information for query workloads.
  • Powerful new Index Advisor capabilities and options:
    • Users can specify their own virtual indexes to perform a "what-if" analysis for single queries.
    • The workload-based index advisor evaluates all existing indexes and indicates whether each index is chosen by optimizer.
    • Users can specify table priorities to indicate the importance of different tables.
    • Users can configure benefit thresholds for query weight groups, suppress the index recommendations for less important queries, and see index recommendations for only the more important queries.
    • Users can disable the index recommendation on user-specified tables.
    • Show runtime information (Elapsed time, CPU time, and so on) for the related queries of each recommended index.
    • Users can drill down into the related queries for each recommended index by launching query-based advisors and tools.
    • The relative performance improvement in percentage is now shown for each recommended index and each related query.
  • New Statistics Advisor report, rules, and options:
    • New options are added in RUNSTATS recommendations, including SORTDEVT, SORTNUM, and REPORT.
    • A report similar to the query report can be generated for the statistics information for queries in a workload, including tables, indexes, columns, and column groups.
    • Users can search and set filters on the workload statistics explanations.
    • Conflicts in the conflict report are grouped by related tables.
    • A new conflict rule is added. When the maximum frequency of a column or a column group is less than the reciprocal of its cardinality, it is considered as a conflict and recommended to recollect statistics.
    • New parameters are provided for controlling the percentage of columns or column groups on which to collect statistics.
    • Users can check the updated statistics report of the workload after the RUNSTATS recommendations are executed for any remaining problematic statistics, such as missing and conflicting statistics.
  • New Query Advisor rules:
    • A new Cartesian join analysis rule provides warnings and rewrite recommendations when tables have no join predicates to other tables in the query.
    • A new Join key analysis rule provides warnings and query rewrite recommendations when an inner join has a data type mismatch or nullability mismatch on the joining columns.
    • A new Ambiguous cursor analysis rule provides warnings and query rewrite recommendations when an ambiguous cursor is opened on a read-only or update-only query.
    • A new outer-join to parent table analysis rule provides warnings and query rewrite recommendations when an outer join occurs with a child table as the outer table and the parent table as the inner table of join, which matches an inner join.
    • A new NOT IN predicate analysis rule provides warnings and recommendations when there is a NOT IN (noncorrelated sub query) in the SQL while sparse index cannot be applied.
    • Users can specify the severity levels for the rules.
    • Execution count, accumulated elapsed time, accumulated CPU time, average elapsed time, and average CPU time are included.
    • Show runtime information (Elapsed time, CPU time, and so on) for each query.
    • Users can drill down into each query by launching query-based advisors and tools.
  • New Access Path Advisor rules:
    • New Cartesian join rule: A form of nested loop join without join predicates between the two tables.
    • New relational scan rule: Whether the access method for a table is a relational scan. A relational scan is generally not the best access method if the number of qualified rows from the table is small while the table is large, or the relational scan is used to access the inner table in a nested loop join.
    • New non-matching index scan rule: No matching columns are in the index. Hence, all the index keys must be examined.
    • New RID pool usage rule: Used by multiple index scan and list prefetch.
    • New individual sort rule: Whether a sort operation is used. Sort can be used for join processing, group by, order by, duplicate removal, and subquery processing. You can design queries and indexes to avoid some sorts.

DB2 Query Monitor for z/OS, V2.3 (5697-I03) enables you to tune SQL workload and DB2 objects efficiently to ensure the effectiveness of your DB2 subsystems. DB2 Query Monitor's enterprise deployment capability enables you to leverage the additional functionality provided by the open systems architecture and provides the information necessary to accurately assess and manage SQL workload.

This release includes the following enhancements:

  • Recursion in ISPF summary reporting gives you the ability to drill down into prior selections while navigating within the summary displays. A new KEYMAP command shows the navigation path you have selected. An almost anywhere to anywhere selection path within summaries is provided. Many prior navigational restrictions have been removed; for example, you may drill down from SQL text to other selections like plan and program.
  • Interval Midnight allows you to align intervals so the first interval of each day starts at the midnight hour.
  • Summary Caching decreases DB2 Query Monitor's memory footprint by removing unreferenced summary totals and writing them to the summary backstore data sets prior to interval expiration.
  • Reliability, availability, and serviceability improvements have been made.
  • Co-existence for the Audit SQL Collector in DB2 Audit Management Expert for z/OS, V2.1 and DB2 Query Monitor for z/OS, V2.3 is supported on the same DB2 subsystem.
  • ISPF numbering options on ISPF panels have been changed from letters to numbers.
  • The Consolidation and Analysis Engine (CAE) Agent now uses significantly less memory and CPU time, because it no longer requires the use of Java™ or HFS on the mainframe. Instead, the CAE Agent is a non-Java address space running under z/OS, using no HFS facilities.
  • DB2 Query Monitor has discontinued use of its dataspace memory in lieu of shared memory objects. This results in an increase in performance of collection of the SQL metrics data.
  • Extended navigation from SQL text displays allows you to drill down from SQLText summaries to see how a particular SQL statement has been used.
  • In the CAE Client, you can view the TopN distinct SQL summaries for most metric fields, including those metric fields used only on detail panels; for example, RIDLIST failures.
  • SQL text handling in the CAE alert/action system is improved. The CAE now has the ability to include static SQL in an action and allows for integration of the CAE Client with z/OS batch applications such as SQLPA.

Accessibility by people with disabilities

You can request a U.S. Section 508 Voluntary Product Accessibility Template (VPAT) with details on accessibility compliance at

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 pricing

Value Unit pricing for eligible IBM System z™ IBM International Program License Agreement (IPLA) programs enables a lower cost of incremental growth and enterprise aggregation. Each System z 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 you. For each System z 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. The quantity of each System z IPLA program that you have acquired is referred to as entitled license capacity. If you wish to grow your entitled license capacity for a System z IPLA program, the calculation to determine additional needed Value Units is based upon the number of Value Units already acquired.

For each System z 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 Value Units 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 System z IPLA program you selected, refer to the Terms and conditions section.

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 208-044

Trademarks

 
System z is a trademark of International Business Machines Corporation in the United States or other countries or both.
 
DB2 and z/OS are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Java is a trademark of Sun Microsystems, Inc.
 
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.

Title                                                   Order number
 
DB2® Optimization Expert for z/OS®, V1.2 (5655-S19)
  License Information                                   GC19-1131
  Program Directory                                     GI10-8755
 
DB2 Query Monitor for z/OS, V2.3 (5697-I03)
  License Information                                   GC18-9201
  Program Directory                                     GI10-8587

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 the software product libraries:

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

Title                                                   Order number
 
DB2 Optimization Expert for z/OS, V1.2 (5655-S19)
  Getting Started                                       GC19-1144
 
DB2 Query Monitor for z/OS, V2.3 (5697-I03)
  User's Guide                                          SC18-9202

The following material is available at

  • Overview brochure: IBM DB2 and IMS™ Tools Overview (IMD11760-USEN)
  • Fact sheet:
    • DB2 Optimization Expert for z/OS (IMD11862-USEN)
    • DB2 Query Monitor for z/OS (GC27-1042)

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 S/390® hardware configuration that supports the required versions of DB2.

DB2 Optimization Expert for z/OS, V1.2 (5655-S19) requires a workstation with:

  • 500 MB of DASD
  • One GB of memory
  • Pentium® IV processor, or equivalent

DB2 Query Monitor for z/OS, V2.3 (5697-I03) workstation requirements:

  • Operating system: Windows® XP
  • Minimum processor speed: Pentium IV, 1 GHz, or equivalent
  • Network access speed: LAN, T1, DSL, or cable modem
  • Network protocols: TCP/IP
  • Display requirements: SVGA monitor; 256 colors or greater
  • Query Monitor Server host requires:
    • 768 MB of memory
    • 1 GB of DASD
  • Query Monitor Client host requires:
    • 256 MB of memory
    • 250 MB of DASD
  • Consolidation and Analysis Engine (CAE) Client requires:
    • 512 MB of memory
    • 400 MB of DASD
  • CAE Server requires:
    • 768 MB of memory
    • 1 GB of DASD
  • Additional capacity guidelines are provided in the Users' Guide.

Software requirements

The products in this announcement require z/OS V1.7 (5694-A01), or later, or z/OS.e V1.7 (5655-G52), or later.

DB2 Optimization Expert for z/OS, V1.1 (5655-S19) requires:

  • DB2 for z/OS, V8 (5625-DB2)/PDO level 0801, UK32046, PK46687, PK58941
  • DB2 for z/OS, V9 (5635-DB2)/PDO level 0801, UK32047, PK46687, PK58941
  • DB2 VUE V8 (5697-N29)
  • DB2 VUE V9 (5697-P12)
  • A workstation with:
    • One of the following operating systems:
      • Microsoft® Windows 2000
      • Microsoft Windows XP
      • Microsoft Windows Server 2003
      • Windows Vista® Business or Windows Vista Ultimate
    • Microsoft Internet Explorer 5.5, or later
    • DB2 Connect® — Application Server, Enterprise, Personal, or Unlimited Edition at Version 9.1 Fix Pack 4, Version 8.1 Fix Pack 15, Version 8.2 Fix Pack 8, or later, or equivalent software that can create an IP network connection to a DB2 for z/OS, V8.1 or V9.1 subsystem. A limited-use license for DB2 Connect Personal Edition V9 is included with DB2 for z/OS, 9.1 (DB2 Management Clients Package feature) that can be used for connections from Optimization Service Center to DB2 for z/OS. DB2 Optimization Expert requires a full DB2 Connect license.

DB2 Query Monitor for z/OS requires:

  • One of the following:
    • DB2 V8.1 (5625-DB2)
    • DB2 V9.1 (5635-DB2)
    • DB2 VUE V8.1 (5697-N29)
    • DB2 VUE V9.1 (5697-P12)
  • The most current maintenance of Java™ 1.5 (31 bit), including all prerequisites, must be installed on your S/390 system, if you wish to run the Consolidation and Analysis Engine (CAE) Server under UNIX® System Services (USS).
    • This requirement applies to running the CAE Server under USS and is not required if you only plan to run the CAE Agent on an LPAR.
    • If you are upgrading from DB2 Query Monitor for z/OS, V2.2, then the CAE Agent address space no longer uses a Java Virtual Machine. It runs under z/OS, not USS.
    • Java builds are available at
  • DB2 Query Monitor requires that the Hierarchical File System (HFS) into which the CAE Server components are installed be on DASD that is shared between primary and backup servers in order to support failover server capability in the CAE.
  • If you choose to run the CAE Server under USS, then the HFS containing the CAE Server requires 1 GB, 1200 cylinders.
  • DB2 Query Monitor's Visual Explain integration supports DB2 Universal Database® for z/OS Visual Explain, V8.1.4, or later. You must have Visual Explain installed and verify that your system environment property DB2TEMPDIR is pointing to DB2 Connect installation path, which by default is C:\Program Files\IBM\SQLLIB\). You must also verify that IVE_DIR points to the Visual Explain installation path, which by default is C:\Program Files\Visual Explain.
    • The Explain button in the Query Monitor CAE Client will only be visible when Visual Explain is installed and the system environment properties are properly set.
    • You are not required to configure Visual Explain to communicate with the database in question.
  • DB2 Query Monitor supports:
    • DB2 Performance Expert for z/OS, V2,1 (5655-J49) PTF UQ88096 (APAR PQ86611) with Performance Expert (PE) client of level L1036, or later versions. Only PE client level L1157 (PTF UK02213), or later, will support PE Thread Details. If you have a PE client at a lower level than L1157, then the PE Thread Details will not be shown as a menu choice.
    • DB2 SQL Performance Analyzer for z/OS, V2.1 (5655-I22), or later.
  • z/OS support for Unicode: The installation of z/OS support for Unicode with SMP/E is described in z/OS Planning for Installation (GA22-7504). Refer to this document to find a complete list of the necessary steps.

The program's specifications and specified operating environment information may be found in documentation accompanying the program, if available, such as a readme file, or other information published by IBM, such as an announcement letter. Documentation and other program content may be supplied only in the English language.

User Group requirements

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

DB2 Query Monitor for z/OS, V2.3 (5697-I03) satisfies requirements MR1001072732 and MR0104062111.

Planning information

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

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

In addition, DB2 Optimization Expert for z/OS, V1.2 is distributed with client code on CD-ROM LCD4-8229.

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.

Software Services

IBM Software Services has the breadth, depth, and reach to manage your services needs. You can leverage the deep technical skills of our lab-based, software services team and the business consulting, project management, and infrastructure expertise of our IBM Global Services team. Also, we extend our IBM Software Services reach through IBM Business Partners to provide an extensive portfolio of capabilities. Together, we provide the global reach, intellectual capital, industry insight, and technology leadership to support a wide range of critical business needs.

To learn more about IBM Software Services or to contact a Software Services sales specialist, visit


 
Back topBack to top
 
Ordering information

Charge metric

                                            PID          Charge
Program name                                number       metric
 
DB2 Optimization Expert for z/OS, V1.2      5655-S19     Value Unit
DB2 Query Monitor for z/OS, V2.3            5697-I03     Value Unit

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

                                                         Value
Program                                                  Unit
number      Program name                                 Exhibit
 
5655-S19    DB2 Optimization Expert for z/OS, V1.2       VUE007
5697-I03    DB2 Query Monitor for z/OS, V2.3             VUE007

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 System z™ 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

Basic license

On/Off CoD

The products in this announcement are eligible for On/Off CoD with a temporary use charge calculated based on MSUs per-day usage.

Program name: DB2 Optimization Expert for z/OS, V1.2
Program PID: 5655-S19
 
Entitlement                                License option/
identifier   Description                   Pricing metric
 
S013K1W      DB2 Optimization Expert       Basic OTC, Per MSU-day TUC
 
 
Program name: DB2 Query Monitor for z/OS, V2.3
Program PID: 5697-I03
 
Entitlement                                License option/
identifier   Description                   Pricing metric
 
S0103FS      DB2 Query Monitor z/OS        Basic OTC, Per MSU-day TUC

Translation from MSUs to Value Units
 
           MSUs       Value Units/MSU
 
Base         1-3      1.00
Tier A       4-45     0.45
Tier B      46-175    0.36
Tier C     176-315    0.27
Tier D     316+       0.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.

Program name: DB2 Optimization Expert for z/OS, V1.2
Program PID: 5655-S19
 
Entitlement                                  License option/
identifier   Description                     Pricing metric
 
S013K1W      DB2 Optimization Expert         Basic OTC, Value Units
 
 
Orderable supply ID    Language              Distribution medium
 
S013K7S                US English            3480 Tape Cartridge
 
Program name: DB2 Query Monitor for z/OS, V2.3
Program PID: 5697-I03
 
Entitlement                                  License option/
identifier   Description                     Pricing metric
 
S0103FS      DB2 Query Monitor z/OS          Basic OTC, Value Units
 
Orderable supply ID    Language              Distribution medium
 
S0103FT                US English            3480 Tape Cartridge

Subscription and Support PID: 5655-S20
 
Entitlement                          License option/
identifier   Description             Pricing metric
 
S013K21      DB2 Optimization        Basic ASC, per Value Unit SW S&S
             Expert S&S              No charge, decline SW S&S
                                     Per MSU SW S&S registration
 
Orderable supply ID    Language      Distribution medium
 
S013K22                English       Hardcopy publication
 
Subscription and Support PID: 5655-E87
 
Entitlement                          License option/
identifier   Description             Pricing metric
 
S00V785      DB2 Query Monitor S&S   Basic ASC, per Value Unit SW S&S
                                     No charge, decline SW S&S
                                     Per MSU SW S&S registration
 
Orderable supply ID    Language      Distribution medium
 
S00TH77                English       Hardcopy publication

Subscription and Support

To receive voice technical support via telephone 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 above 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 Software Maintenance (IAASM). This offering:

  • Includes and extends the support services provided in the base support to include technical support via telephone.
  • Entitles you to future releases and versions, at no additional charge. Note that you are not entitled to new products.

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

The combined effect of the IPLA license and the Agreement for Acquisition of Software Maintenance gives you rights and support services comparable to those under the traditional ICA S/390 and System z license or its equivalent. To ensure that you continue to enjoy the level of support you are used to in the ICA business model, you must order both the license for the program and the support for the selected programs at the same Value Unit quantities.

Single version charging: To elect single version charging, you must notify and identify to IBM the prior program and replacement program, and the machine the programs are operating on.

Customized Offerings

Product deliverables are shipped only via Customized Offerings (for example, CBPDO, ServerPac, SystemPac®).

CBPDO and ServerPac are offered for Internet delivery, where ShopzSeries product ordering is available. Internet delivery of ServerPac may help improve automation and software delivery time. For more details on Internet delivery, refer to the ShopzSeries help information at

Media type for this software product is chosen during the Customized Offerings ordering process. Based on your customer environment, it is recommended that the highest possible density tape media is selected. Currently offered media types are:

  • CBPDOs — 3480, 3480 Compressed, 3490E, 3590, 3592*
  • ServerPacs — 3480, 3480 Compressed, 3490E, 3590, 3592*
  • SystemPacs — 3480, 3480 Compressed, 3490E, 3590, 3592*
*
3592 is highest density media. Selecting 3592 will ship the fewest number of media.

Once a product becomes generally available, it will be included in the next ServerPac and SystemPac monthly update.

Production of software product orders will begin on the planned general availability date.

  • CBPDO shipments will begin one week after general availability.
  • ServerPac shipments will begin two weeks after inclusion in ServerPac.
  • SystemPac shipments will begin four weeks after inclusion in SystemPac due to additional customization and data input verification.

 
Back topBack to top
 
Terms and conditions

The information provided in this announcement letter is for reference and convenience purposes only. The terms and conditions that govern any transaction with IBM are contained in the applicable contract documents such as the IBM International Program License Agreement, IBM International Passport Advantage® Agreement, and the IBM Agreement for Acquisition of Software Maintenance.

Licensing: IBM International Program License Agreement including the License Information document and Proof of Entitlement (PoE) govern your use of the program. PoEs are required for all authorized use.

Agreement for Acquisition of Software Maintenance: The following agreement applies for maintenance and does not require customer signatures:

  • IBM Agreement for Acquisition of Software Maintenance (Z125-6011)

These programs are licensed under the IBM Program License Agreement (IPLA) and the associated Agreement for Acquisition of Software Maintenance, which provide for support with ongoing access to releases and versions of the program. IBM includes one year of Software Maintenance with the initial license acquisition of each program acquired. The initial period of Software Maintenance can be extended by the purchase of a renewal option, if available. 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 System z IBM Operational Support Services — SoftwareXcel is an option if you desire added services.

License information form number

                                            Program      License
Program name                                number       information
 
DB2 Optimization Expert for z/OS, V1.2      5655-S19     GC19-1131
DB2 Query Monitor for z/OS, V2.3            5697-I03     GC18-9201

The programs' License Information will be available for review on the IBM Software License Agreement Web site

Limited warranty: Yes

Limited warranty: IBM warrants that when the program is used in the specified operating environment, it will conform to its specifications. The warranty applies only to the unmodified portion of the program. IBM does not warrant uninterrupted or error-free operation of the program or that IBM will correct all program defects. You are responsible for the results obtained from the use of the program.

IBM provides you with access to IBM databases containing information on known program defects, defect corrections, restrictions, and bypasses at no additional charge. For further information, consult the IBM Software Support Handbook found at

IBM will maintain this information for at least one year after the original licensee acquires the program (warranty period).

Program support: Enhanced support, called Subscription and Support, includes telephone assistance, as well as access to updates, releases, and versions of the program as long as support is in effect. You 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, you may obtain a refund of the amount you paid for it, if within 30 days of your invoice date you return the program and its PoE to the party from whom you obtained it. If you downloaded the program, you may contact the party from whom you acquired it for instructions on how to obtain the 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 you.

Authorization for use on home/portable computer: You may not copy and use this program on another computer without paying additional license fees.

Other terms

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

IBM Operational Support Services — SoftwareXcel: Yes

System i™ Software Maintenance applies: No

Variable charges apply: No

Educational allowance available

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

Sub-capacity terms and conditions

For each System z 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 System z 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 System z IPLA program you selected, refer to the Ordering information section.

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 System z IPLA program with these terms equals the MSU-rated capacity of the machines where the System z IPLA program executes.

For more information on mainframe MSU-rated capacities, visit

Reference based: The required license capacity of a System z 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 System z IPLA sub-capacity program with these terms equals the capacity of the LPARs where the System z IPLA program executes.

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

Reference based: The required license capacity of a System z 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 System z IPLA program with full-machine based terms equals the MSU-rated capacity of the machines where the System z IPLA program executes.

For more information on mainframe MSU-rated capacities, refer to The IBM System z Machines Exhibit (Z125-3901), or visit the Mainframes section of the System z Exhibits Web site

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

For additional information for products with reference-based terms, System z IPLA sub-capacity programs with reference-based terms adds value to the parent program across the environment, regardless of where in the environment the System z IPLA program executes.

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

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

  • That meets the criteria defined in 198-001 , dated January 13, 1998
  • Where MLC pricing is aggregated across the sysplex

Sub-capacity eligibility: To be eligible for sub-capacity charging on select System z 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 System z (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 System z 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 System z 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 System z 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 System z 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 CoD

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

Prices

For all local charges, contact your IBM representative.

IBM Global Financing

IBM Global Financing offers competitive financing to credit-qualified customers to assist them in acquiring IT solutions. Offerings include financing for IT acquisition, including hardware, software, and services, from both IBM and other manufacturers or vendors. Offerings (for all customer segments: small, medium, and large enterprise), rates, terms, and availability can vary by country. Contact your local IBM Global Financing organization or visit

IBM Global Financing offerings are provided through IBM Credit LLC in the United States, and other IBM subsidiaries and divisions worldwide to qualified commercial and government customers. Rates are based on a customer's credit rating, financing terms, offering type, equipment type, and options, and may vary by country. Other restrictions may apply. Rates and offerings are subject to change, extension, or withdrawal without notice.
 
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 Teleweb Customer Support
             ibm.com Sales Execution Center, Americas North
             3500 Steeles Ave. East, Tower 3/4
             Markham, Ontario
             Canada
             L3R 2Z1
 
 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, System z, System i, z/Architecture, and System z9 are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
z/OS, DB2, BookManager, S/390, DB2 Connect, zSeries, eServer, DB2 Universal Database, SystemPac, Passport Advantage, Parallel Sysplex, and OS/390 are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Pentium is a registered trademark of Intel Corporation.
 
Windows, Microsoft, and Windows Vista are registered trademarks of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
UNIX is a registered trademark of the Open Company in the United States and other countries.
 
Other company, product, and service names may be trademarks or service marks of others.

Back to topBack to top
 

 
Printable version Printable version