Feedback
IBM United States
Software Announcement 202-048
March 5, 2002

New and Enhanced IBM Data Management Tools for DB2 and IMS Add Function for Managing Your Database Environment

 ENUS202-048.PDF (91KB)

(Corrected on July 9, 2002)

Added an additional requirement to Software Requirements section.

(Corrected on April 12, 2002)

Corrected to add additional information on DB2 Query Tools, added a publication to publication list, and changed Support Line to Yes.

At a Glance

New database tools, versions, and releases for your DB2 and IMS installations can help you:

  • Maximize the availability of your systems
  • Keep your operating environment running at peak performance
  • Meet requirements for additional recovery/replication capabilities
  • Effectively create and operate your application subsystem

New capabilities are announced for each category:

  • IBM Tools for Database Administration
  • IBM Tools for Database Recovery and Replication
  • IBM Tools for Database Performance Management
  • IBM Tools for Database Application Management

For ordering, contact:

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

Overview

Building on a strengthened focus on data management tools, IBM now has new tools and functions that further complement IBM's premier DB2 Universal Database® (UDB) for z/OS™ and IMS™ database engines.

IBM wants to be your preferred supplier of tools, so check out our affordable, high-performance, and functionally rich products.

New in this Announcement

  • Program Services for DB2® Performance Monitor for z/OS, V7 have been extended 12 months to November 30, 2004.
  • One service enhancement.
  • Two new licensed programs — one DB2 and one IMS.
  • Five new program versions — four DB2 and one IMS.
  • Six new program releases — four DB2 and two IMS.

For details about these products, refer to the Description section.

Clarification

All the data management tools for DB2 and IMS:

  • Have a 30-day money back guarantee.
  • Have only hardcopy publications of the License Agreement and Program Directory shipped with the products. Other publications, for example, the User's Guide, are available only in softcopy.

Effective March 8, 2002, user publications, other than license agreements and program directories, will be available in softcopy only for previously announced Data Management Tools. Specifically, refer to the Publications section for a list of products for which hardcopy publications will no longer be available.

Planned Availability Dates

  • March 8, 2002: IMS Queue Control Facility for z/OS, V1.2
  • March 15, 2002: IMS High Performance Prefix Resolution for z/OS, V2
  • May 10, 2002: IMS High Availability Large Database Conversion Aid for z/OS, V1
  • June 21, 2002:
    • DB2 Change Accumulation Tool for z/OS, V1.2
    • DB2 Query Monitor for z/OS, V1.2
    • DB2 SQL Performance Analyzer for z/OS, V2
  • June 28, 2002: IMS Index Builder for z/OS, V2.2
  • July 26, 2002:
    • DB2 Administration Tool for z/OS, V4
    • DB2 Object Comparison Tool for z/OS, V2
    • DB2 High Performance Unload for z/OS, V2
    • DB2 Performance Expert for z/OS, V1
    • DB2 Table Editor for z/OS, V4.3
    • DB2 Web Query Tool for z/OS, V1.3

For DB2 Utilities Suite for z/OS, V7.1 Program Temporary Fixes (PTFs), refer to APARs PQ56293, PQ56295, and PQ56296 for availability.

Key Prerequisites

Any hardware and software configuration that supports the required version of DB2 or IMS. Details are listed in the Hardware Requirements and Software Requirements sections.

Description

IBM Tools for Database Administration

DB2 Administration Tool for z/OS, V4 gives you a comprehensive set of functions that help DB2 systems personnel efficiently and effectively manage their DB2 environments. It is an interactive, intuitive, and easy-to-use tool that gives you a cost-effective solution for a full range of database administration functions for DB2 for z/OS. DB2 Administration Tool also provides centralized access to any tool with an ISPF interface through the DB2 tools Launchpad.

Enhancements are:

  • Cloning of work statement lists
  • More support for generating work statement lists
  • Restartable execution of utilities, DSN, and DB2 commands in addition to the support of SQL statements currently provided
  • ALTER of primary key will also change foreign keys
  • DB2 subsystem selection on DB2 Tools Launchpad
  • DROP and REVOKE impact analysis

DB2 High Performance Unload for z/OS, V2 offers sequential reading and the capability to access your DB2 data at top speed. It can unload data from image copies as well as active tables and create multiple output files during a single unload with minimal cost. DB2 High Performance Unload can store the output in multiple formats including those that are user tailored.

New capabilities:

  • DB2 Admin Line command support
  • Multiple unload statement in one SYSIN
  • Tablespace name becomes an optional parameter
  • Support of FastUnload from Computer Associates and Unload Plus from BMC Software, Inc.
  • Expressions supported in the SELECT clause of the select statement
  • SQL-Case statements supported in the SELECT clause and in the WHERE clause

Refer to the DB2 High Performance Unload for z/OS section for more information on the new capabilities of this product.

DB2 Object Comparison Tool for z/OS, V2 helps you keep your test and development system as a mirror image of the production system. New applications, application modifications, or mistakes can cause DB2 objects in one of these systems to have different attributes than on other systems. The DB2 Object Comparison Tool allows you to compare objects (and dependent objects) from one source to another. Once a difference file is generated, the product can be used to generate the DB2 commands needed to bring the catalogs back into synchronization.

Enhancements include:

  • Target changes can be generated into a work statement list
  • Improved reports

For DB2 Utilities Suite for z/OS, V7.1 (5697-E98), DB2 Diagnostic and Recovery Utilities (5655-E62), and DB2 Operational Utilities (5655-E63) PTFs, refer to the following APAR Numbers:

  • PQ56296 for DB2 Diagnostic and Recovery Utilities (5655-E62)
  • PQ56295 for DB2 Operational Utilities (5655-E63)
  • PQ56293 for DB2 Universal Database Server for z/OS and OS/390® (5675-DB2)

These PTFs enhance V7 of the DB2 Utilities by removing a restriction in the COPY/RECOVERY parallelism support when backup copies are on tape. This support improves backup and recovery elapsed time performance by parallel processing of backup copies going to or from different tape devices and usability by automatic stacking of backup copies on tape for the COPY and RECOVER utilities in these products.

IMS High Availability Large Database (HALDB) Conversion Aid for z/OS, V1 can help you take advantage of the capacity and availability features of IMS at a stepped up pace by giving you utilities and aids to analyze, model, and convert existing IMS database structures to a HALDB format. IMS HALDB Conversion Aid gives you:

  • An easy-to-use ISPF front-end
  • Automatic DBD conversion
  • Conversion of TEST databases
  • Index pointer healing
  • Partition modeling tool

Refer to the IMS HALDB Conversion Aid for z/OS section for more information on the capabilities of the product.

IMS High Performance Prefix Resolution, V2 performs the same functions as the IMS Prefix Resolution utility (DFSURG10) but with considerably reduced elapsed times.

Prefix resolution is a required step for resolving pointers for databases containing logical relationships and for creating or recreating secondary indices. Unlike V1, this version of the product does not require the BatchPipes®/MVS™ subsystem. A data transfer service called HPPRPIPE is used to eliminate the intermediate Work File 2 (WF2) data set, which avoids much of the I/O, tape handling, and DASD requirements often associated with prefix resolution.

IMS Index Builder, V2.2 can help you simplify index recovery and maintenance, reduce index maintenance time, and eliminate the need to image copy index databases. IMS Index Builder gives you an easy-to-use, one-step procedure for the maintenance of primary and secondary indices. This release of the product provides a complete service rollup. No new function is included with this release.

IBM Database Tools for Replication and Recovery

DB2 Change Accumulation Tool for z/OS, V1.2 helps DB2 administrators minimize data recovery time by efficiently keeping current and consistent data images more readily available.

New and enhanced capabilities are:

  • New ISPF user interface integrated with the DB2 Admin Launchpad
  • Mini-logs
  • SYSLGRNX log ranges supported just like the DB2 Recover Utility
  • Full image copy produced when no incremental or log data found
  • Improved support for LP/RP/LB/RB
  • Up to 5000 separate tablespaces can be specified per job
  • Improved Support for Data Sharing
  • Usability improvements
  • SHRLEVEL now propagated from the last image copy read
  • TO_QUIESCE control card
  • User defined BUFNO and NCP parameters
  • SMS management classes for temp datasets now user definable

Refer to the DB2 Change Accumulation Tool for z/OS section for more information on the new capabilities of this product.

IBM Database Tools for Performance Management

DB2 Performance Expert for z/OS, V1 integrates and provides common user interfaces, ISPF, and workstation GUI for the functions of:

  • DB2 Performance Monitor for z/OS
  • DB2 Buffer Pool Analyzer for z/OS
  • New application performance expert facilities

While DB2 Performance Expert for z/OS includes all the functions and features of DB2 Performance Monitor for z/OS and DB2 Buffer Pool Analyzer for z/OS, the stand-alone products continue to be available and supported. Program Services for DB2 Performance Monitor for z/OS, V7 have been extended 12 months to November 30, 2004.

DB2 Performance Expert may be optionally integrated with the DB2 Tools Launchpad on ISPF and DB2 Control Center for the workstation GUI.

Trade-up Prices to DB2 Performance Expert are available for customers who currently have DB2 Performance Monitor, V7 (5655-E61), and/or DB2 Buffer Pool Analyzer V1 (5655-E54). Refer to the Ordering Information section for a description of the trade-up opportunities.

Refer to the DB2 Performance Expert for z/OS section for more information on the new capabilities of this product.

DB2 Query Monitor for z/OS, V1.2 helps you maximize DB2 availability by clearly identifying resource-intensive queries and providing drill-down analysis of the resources used in their execution. Administrators can more easily develop problem prevention measures for all types of queries issued from any type of connection (including static SQL, dynamic SQL, JDBC, ODBC, DB2 Connect®) in multiple types of operational environments, including transactional, data warehouse, and Web-based.

New and enhanced capabilities are:

  • Enhanced monitoring profiles
  • VSAM file support
  • Easy drill-through from summary to detail data
  • Section oriented tracking and visibility
  • Usability enhancements
  • Quiet-time detection

Refer to the DB2 Query Monitor for z/OS section for more information on the new capabilities of this product.

DB2 SQL Performance Analyzer for z/OS, V2 delivers performance analysis for all phases of database application design and development. Installations spend a great deal of their budget managing the performance of their applications. DB2 SQL Performance Analyzer is an outstanding aid to prevent 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

New capabilities include:

  • Improved SQL Cost Estimates
  • Enhanced SQL Advisor
  • COBOL Stored Procedure Sample Program
  • Multiple DBRM Member Support under ISPF
  • Supplemental Information on Indices

Refer to the DB2 SQL Performance Analyzer for z/OS section for more information on the new capabilities of this product.

IBM Database Tools for Application Management

DB2 Table Editor for z/OS, V4.3 is IBM's multipurpose table editing environment that offers database administrators, developers, and the entire enterprise, direct update and data creation operations on DB2 UDB for OS/390 and z/OS databases from within Java™, ISPF or Windows®-based interfaces.

The following new features have been added to the ISPF component of DB2 Table Editor:

  • Row-at-a-time editor/form mode

    Now Table Editor gives you increased flexibility in viewing and editing data by allowing you to view data vertically, one row at a time. Once in "form mode", you can move from one row to another (go to the next row or the previous row). You can also zoom into large columns. At any time, you can go back to tabular mode.

  • Edit remote data via alias

    With proper licensing, DB2 for z/OS and OS/390 tables residing at remote locations can be edited by specifying the defined alias name.

  • INSERT into Empty Table

    If you specify a table that contains no data, Table Editor will display an empty table and allow you to insert one or more rows of data. Once data is inserted, you can edit normally.

  • VARCHAR updates when in zoom mode

    When making changes to VARCHAR columns on the Zoom Panel, Table Editor will calculate automatically the length of the column based on the input value and trailing "pad" characters.

  • Flexible null indicator

    If you edit a value that is NULL, Table Editor will turn the NULL indicator off automatically, preventing the loss of changes made.

  • Abbreviated or full data type names

    You can choose to see abbreviated or full data type names on the column selection panel.

  • Undo for change

    You can now specify the Undo line command on rows that are changed. The row changes will be undone and reset to their original values.

  • Improved Scrolling

    Numerous scrolling enhancements are provided, including persistent cursor positioning and column justified scrolling.

  • Display current row position

    Two row counters are displayed. The first counter indicates the number of the rows currently displayed at the top of the tabular section of the ISPF panel. The second counter indicates the total number of rows available for display, for example, "Row 5 of 3000."

  • Improved handling of decimals

    Decimal columns will not contain spaces on either side of the decimal character.

  • Thousands separator in numeric columns

    Table Editor now shows you the thousands separator (comma, period) in a numeric column.

DB2 Web Query Tool for z/OS, V1.3 allows end users and administrators to access enterprise data with speed, reliability, and simplicity. It enables pervasive connectivity over the Internet to every desktop. DB2 Web Query sets a new standard for business responsiveness because now anyone in your organization can take robust data access for granted, virtually anywhere, and at anytime. Less latency, less waiting, and less waste means more opportunity for you and your organization.

DB2 Web Query Tools are capable of accessing DB2 data on z/OS, iSeries, AIX, Linux, Windows, HP-UX, and Sun platforms. The products run on Web servers, which need not be on the same platforms as the database servers. For example, to access DB2 database data on iSeries, you need the DB2 Web Query Tool for iSeries. To access DB2 database data on z/OS, you need DB2 Web Query Tool for z/OS. To access DB2 database data on AIX, Linux, Windows, HP-UX and Sun platforms, you need DB2 Web Query Tool for Multiplatforms.

DB2 Web Query V1.3 gives you increased versatility with the introduction of the following features:

  • J2EE Support

    Web Query is now a J2EE-compliant Web application. As such, it can now be deployed on WebSphere® V4.

  • Server-side XSLching

    Server side XSL transformations are now applied to the generated XML/XSL data, which removes all requirements for client side XML translation software components.

  • Stored Procedure Support

    A DB2 stored procedure can be run by selecting it from the Web Query object tree. You can also run a stored procedure by specifying a CALL statement in your query.

  • Web Services (SOAP)

    A saved query can be published as a SOAP service that any SOAP requestor can access.

  • Scalable Vector Graphing

    Result sets can be transformed to graphs/charts using the Scalable Vector Graphics (SVG) model.

  • Large Object (LOB) Support

    You can retrieve LOB data in Web Query. Web Query can also launch the appropriate viewing application to render the LOB data (picture, video, and audio).

IMS Queue Control Facility for z/OS, V1.2 delivers all the functions of IMS Message Requeuer and a lot more. QCF gives you an interactive ISPF front end, allowing you to Browse, Query, Unload, and Dequeue messages, set controls for the Queue Overflow Protection feature, and more. Message selection capabilities and other features quickly locate checkpoints. QCF supports IMS Standard Queues and Shared Queues. This release of IMS Queue Control Facility contains no new function but provides a rollup of all service.

Accessibility by People with Disabilities

The following features support use by people with disabilities:

  • Operation by keyboard alone
  • Optional font enlargement and high-contrast display settings

Euro Currency

These programs are not impacted by euro currency.

Reference Information

Previous DB Tools Announcements

There were four major DB tools announcements last year. Refer to:

  • Software Announcement 201-250 , dated September 11, 2001
  • Software Announcement 201-251 , dated September 11, 2001
  • Software Announcement 201-162 , dated May 29, 2001
  • Software Announcement 201-056 , dated March 6, 2001

These announcements offered 12 new products, seven new versions, and 13 new releases.

Trademarks

 
IMS, z/OS, and MVS are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
WebSphere, DB2 Universal Database, DB2, OS/390, BatchPipes, and DB2 Connect are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows is a registered trademark of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
Other company, product, and service names may be trademarks or service marks of others.

DB2® Change Accumulation Tool for z/OS™, V1.2

V1.2 of this program helps DB2 administrators minimize data recovery time by efficiently keeping current and consistent data images more readily available. This release offers the following new and enhanced capabilities:

  • New ISPF user interface

    A new method is provided for building the Change Accumulation batch job by using a series of ISPF panels that group objects to recover along with options "profiles." These components are then used by the ISPF online component to build the JCL via ISPF file tailoring services. The resulting jobs can then be stored off and run at a later time.

  • Mini-logs

    Change Accumulation Tool now has a new component called mini-logs that extracts portions of the DB2 log that pertain to the object being processed. Creating an alternate mini-log dataset that is stored in a Change Accumulation Tool maintained database saves you valuable resources. If mini-logs are present, they will be used instead the entire DB2 log. Mini-logs shift the I/O time spent in reading vast portions of the log (even when SYSLGRNX is factored in), which contain no relevant data, to non-critical times.

  • SYSLGRNX log ranges supported just like the DB2 Recover Utility

    Change Accumulation Tool now adds support for SYSLGRNX that greatly reduces the amount of log records, archive log files, and archive log file mounts needed for processing.

  • Full image copy produced when no incremental or log data found

    In the case where a tablespace was processed and it is determined to have no updates to apply, the Change Accumulation Tool notices this condition and makes no copy and writes no record to SYSCOPY.

  • Improved support for LP/RP/LB/RB

    The RECOVERY_SITE control card is used when writing a new SYSCOPY record.

  • Up to 5000 separate tablespaces can be specified per job

    Now you can specify up to 5000 separate tablespaces for DB2 Change Accumulation Tool processing.

  • Improved Support for Data Sharing

    All the members in a data sharing group can be easily found. The Change Accumulation Tool can read all of the appropriate BSDSs, find all of the log ranges, and read all of the necessary log records.

  • Usability improvements

    For easier analysis and diagnosis of errors, all error messages are now written to SYSOUT and all follow the same message format.

  • SHRLEVEL now propagated from the last image copy read

    The Change Accumulation Tool will always write into the new SYSCOPY row the share level of the most recent image copy (either full or incremental) used in processing.

  • TO_QUIESCE control card

    The Change Accumulation Tool now has a TO_QUIESCE control card that allows you to process the data up to a log point established by a stand-alone quiesce utility run. This will prevent the Change Accumulation Tool from going beyond the most recent quiesce point in the log.

  • User defined BUFNO and NCP parameters

    Instead of using the default values for BUFNO (number of QSAM buffers) and NCP (number of QSAM channel programs), the Change Accumulation Tool now gives you the ability to specify these values. These values are then used during dynamic allocation of its work and input/output files.

  • SMS management classes for temp datasets now user definable

    Instead of using the default values for all SMS fields, the Change Accumulation tool now gives you the ability to specify these values. These values are then used during dynamic allocation of work files.

DB2 High Performance Unload for z/OS, V2

DB2 High Performance Unload for z/OS, V2 offers sequential reading and the capability to access your DB2 data at top speed. It can unload data from image copies as well as active tables and create multiple output files during a single unload with minimal cost. DB2 High Performance Unload can store the output in multiple formats including those that are user tailored.

New capabilities:

  • New and integrated DB2 Admin Line command support

    This support enables you to launch High Performance Unload from the DB2 Admin Tool. This support also includes a new ISPF interface that allows High Performance Unload to be invoked from either batch or ISPF. As with all of our DB2 tools products that have an ISPF interface, High Performance Unload can also be launched from the DB2 Admin Launchpad.

  • Multiple unload statement in one SYSIN

    You may now code multiple Unload statements in a single SYSIN. Each Unload statement will be processed one at a time.

  • The tablespace name becomes an optional parameter

    Prior to High Performance Unload V2.1, you were required to specify the tablespace name in the Unload statement. Now the tablespace name will be derived from the tablename specified in the SELECT statements. If multiple Select statements are present and can be processed natively but refer to different table spaces, distinct unload processing will be created automatically.

  • Support of FastUnload from Computer Associates and Unload Plus from BMC Software, Inc.

    High Performance Unload V2.1 is JCL tolerant of FastUnload 3.1 and Unload Plus 2.1.01. Some features of the these two products may be ignored or have slightly different interpretations when executed by High Performance Unload. In most cases, this function significantly reduces the amount of work required to convert from FastUnload or UnloadPlus to High Performance Unload.

  • Native support of expressions in the SELECT clause

    Expressions are supported in the SELECT clause of the select statement. For example, Select C1, SUBSTR(C1 || C2, 5, 10), C3 FROM..., is supported natively. The expressions supported are the same ones that are supported in the WHERE clause.

  • Native support of SQL-Case statements

    SQL-Case statements are supported in the SELECT clause and in the WHERE clause.

DB2 Performance Expert for z/OS, V1

DB2 Performance Expert is the tool for ultimate performance. It helps you get optimum performance from your database management system and provides support for resolving critical performance issues. It may be optionally integrated with the DB2 Tools Launchpad on ISPF and DB2 Control Center for the workstation GUI.

Monitoring functions keep you informed about the health of your system and what is currently running in it.

The Reporting Facility presents performance information about details of DB2 events. The system-wide performance data provides information about CPU times, buffer pool usage, locking, I/O activity, and more.

The Performance Warehouse function supports you in managing and handling your DB2 Performance Expert performance database. You can:

  • Save DB2 trace and report data in the performance database for further investigation and trend analysis
  • Configure and schedule the report and load process from the workstation GUI functions
  • Use analysis functions (rules of thumb) that are shipped with the product along with analysis functions you define

Buffer Pool Analysis helps database administrators (DBAs) manage buffer pools more efficiently by providing information about current buffer pool behavior and using simulation to anticipate future behavior. It helps you tune DB2 buffer pools and get the most out of your system resources. It lets you optimize memory usage by specifically recommending which buffer pool to change and by how much.

Explain functions complete the monitoring, reporting, and analysis functions with the capability to explain the determined access path of SQL statements. You can explain a single SQL statement, which is currently executed or saved in the dynamic statement cache, and you can also explain an SQL statement out of your editor during coding of your application program. The Batch Explain report allows you to explain all or selected SQL statements of your plan or package. The workstation GUI invokes the Visual Explain function shipped with DB2.

The key benefits of DB2 Performance Expert are:

  • Specificity

    Detailed monitoring and in-depth analysis of DB2 Universal Database® for z/OS and DB2 applications is provided.

  • Reliability

    You can trust DB2 Performance Expert. It is the tool IBM relies on to develop and test DB2.

  • Flexibility

    DB2 Performance Expert presents its analysis results in a wide range of specialized reports that can be tailored to suit individual needs.

  • Comprehensiveness

    DB2 Performance Expert helps you prevent and solve performance problems covering the full range of DB2 Universal Database for z/OS installations.

  • Investment protection

    The close relation between DB2 and Performance Expert ensures that your investment in DB2 is protected. DB2 Performance Expert provides complete coverage of the latest DB2 Universal Database for z/OS enhancements and also supports all previous DB2 versions starting with DB2 Universal Database for OS/390®, V6.

DB2 Query Monitor for z/OS, V1.2

V1.2 of this program helps you maximize DB2 availability by clearly identifying resource-intensive queries and providing drill-down analysis of the resources used in their execution. Administrators can more easily develop problem prevention measures for all types of queries issued from any type of connection (including static SQL, dynamic SQL, JDBC, ODBC, DB2 Connect®) in multiple types of operational environments, including transactional, data warehouse, and Web-based.

DB2 Query Monitor gives you extensive control over what data is gathered during activity monitoring, when it is gathered, about whom and what database resources, and then what alerts 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. DB2 Query Monitor provides powerful views into the query processing events occurring in your enterprise z/OS environment.

New and enhanced capabilities are:

  • Enhanced monitoring profiles

    Monitoring Profiles determine when and for what Query Monitor should start collecting detail statistics. Query Monitor collects only summary data when there is no active Monitoring Profile. When a Monitoring Profile is active, then detail is collected for the specified resources (plan, DBRM, job, or user) when exception conditions are triggered (excessive GETPAGE requests, or negative SQL CODEs).

  • VSAM file support

    Detail data being collected by Query Monitor is written to VSAM at each interval boundary or when the dataspace usage exceeds a certain threshold. You can load the data from VSAM to DB2 via batch jobs that are provided.

  • Easy drill-through from summary to detail data

    Panel navigation now flows from summary data directly to detail data. Users can see detail/exceptions related to summary data items.

  • Section oriented tracking and visibility

    Query Monitor now separates SQL performance statistics at the section level. SQL calls are combined at the section level along with associated host variable and SQLCA data.

  • Usability enhancements

    These enhancements include columnar scrolling improvements, automatic cursor positioning when drilling through data, and enhanced help for detail statistics.

  • Quiet-time detection

    Query Monitor can detect when there is quiet time (no activity) in DB2. When quiet time is detected, a user exit is called.

DB2 SQL Performance Analyzer for z/OS, V2

V2 of this program delivers performance analysis for all phases of database application design and development. Developing applications under DB2 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. DB2 SQL Performance Analyzer is an aid to prevent 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

New capabilities include:

  • Improved SQL cost estimates through:
    • Revamped cost estimates, algorithms, and formulas
    • Better recognition and handling of multistep and multiquery block estimates
    • Accuracy enhancements for filter factors and query cardinality estimates

  • Enhanced SQL Advisor

    New and updated information and recommendations, fine tuning of advice given under certain special circumstances, elimination of some non-essential advice; upgraded Warnings, Alerts, Guidelines, Recommendations, Good News, and Performance Notes™ covering DB2 V5 through V7.

  • White Paper on Calibration and Validation

    Documentation on how to calibrate SQL Performance Analyzer, validate the installation configuration parameters, and compare SQL Performance Analyzer cost estimates against measured results.

  • COBOL Stored Procedure Sample Program

    In addition to the sample PL/1 program provided in V1, a new COBOL sample program calling the SQL Performance Analyzer stored procedure (ANLPROC) is provided, including source code, to allow your users familiar with COBOL to more easily incorporate SQL Performance Analyzer stored procedure calls into their application programs.

  • Multiple DBRM Member Support under ISPF

    Under the TSO/ISPF interface to SQL Performance Analyzer, users will now be able to analyze the content of an entire DBRM library, or selected members (screened with the DBRMKEY parameter) interactively under a TSO session. Previously, this feature was only available to SQL Performance Analyzer Batch users.

  • Supplemental Information on Indices

    For all indices chosen by the DB2 Optimizer for access path selection, SQL Performance Analyzer will now display additional index "key column" information, similar to the data available on alternative indices via the optional SHOWALT parameter.

IMS High Availability Large Database (HALDB) Conversion Aid for z/OS, V1

IMS HALDB Conversion Aid for z/OS, V1 can help you take advantage of the capacity and availability features of IMS at a stepped-up pace by providing utilities and aids to analyze, model, and convert existing IMS database structures to an HALDB format. IMS HALDB Conversion Aid provides:

  • An easy-to-use ISPF front-end

    HALDB conversion requires a skilled DBA. As these skills are not freely available, this tool supports migration without a skilled DBA. The conversion process is guided by an ISPF application. It allows you to model the partitions (via ISPF dialog or by standard setup rules). The DBD and DBRC definitions are created. The HALDB partition datasets are allocated. The conversion JCL is created. The conversion process can be monitored.

  • Automatic DBD conversion

    The HALDB database definition is "cloned" from the original DBD. There are setup parameters for changing the dataset group definition (the old DBD may have multiple datasets because of its size) or access method (VSAM, OSAM). The "old" DBD is saved as source code during the conversion process. It can be made available as necessary. This process can be interactive or automatic.

  • Conversion of TEST databases

    Many installations require the test environment to be a mirror of the production environment, so the test databases need to be converted. There may be many test environments. The ISPF application has setup definitions for different environments, for example, production or test. This allows the conversion of test databases to be made by application programmers, since no DBA skills are required. The standard modeling rule for partition sizes and boundaries should be used.

  • Index pointer healing

    The migration process and a "normal" reorganization puts all EPS pointers into "healing needed" status. This tool allows you to heal the index pointer. It is part of the conversion process. It may be used after reorganization. If the primary database has multiple indices, it will run them in parallel.

  • Partition modeling tool

    The modeling tool reads the database to be converted and saves data in a repository. The data is used to create partition boundaries and sizes. You can now interactively determine the size and the number of partitions. There is no need to rerun the data collection portion several times.

Offering Information

Product information is available through Offering Information (OITOOL) at:

Publications

Effective March 8, 2002, user publications, other than license agreement and program directories, will be available in softcopy only for previously announced Data Management Tools. Specifically, hardcopy publications will no longer be available for the following products:

                                                       Product ID
Product                                                Number
 
DB2 DataPropagator(TM) V7                              5655-E60
DB2 Performance Monitor V7                             5655-E61
DB2 Row Archive Manager V1                             5655-E65
IMS Advanced ACB Generator V1                          5655-E05
IMS DEDB Fast Recover V2                               5655-E32
IMS High Performance Load V1                           5655-E07
IMS High Performance Prefix Resolution V1              5655-E08
IMS High Performance Unload V1                         5655-E06
IMS Library Management Utilities V1                    5655-E04
IMS Performance Analyzer V3                            5655-E15
IMS Program Restart Facility V2                        5655-E14
IMS Randomizer Generator V1                            5655-E11

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

                                                       Order
Title                                                  Number
 
DB2 Administration Tool for z/OS, V4                   GC27-1596
 (5655-I23) License Information
DB2 Change Accumulation Tool for z/OS,                 GC27-1196
 V1.2 (5655-F55) License Information
DB2 High Performance Unload for z/OS,                  GC27-1597
 V2 (5655-I19) License Information
DB2 Object Comparison Tool for z/OS,                   GC27-1598
 V2 (5655-I20) License Information
DB2 Performance Expert for z/OS                        GC27-1599
 (5655-I21) License Information
DB2 Query Monitor for z/OS, V1.2                       GC27-0969
 (5655-E67) License Information
DB2 SQL Performance Analyzer                           GC27-1600
 for z/OS, V2 (5655-I22)
 License Information
DB2 Table Editor for z/OS, V4.3                        GC27-1200
 (5697-G65) License Information
DB2 Web Query Tool for z/OS, V1.3                      GC27-0970
 (5655-E71) License Information
IMS High Availability Large Database                   GC27-1578
 Conversion Aid for z/OS (5655-I01)
 License Information
IMS High Performance Prefix                            GC27-1589
 Resolution for z/OS, V2.1
 (5655-I15) License Information
IMS Index Builder for z/OS, V2.2                       GC27-0931
 (5655-E24) License Information
IMS Queue Control Facility for z/OS,                   GC26-9686
 V1.2 (5697-E99) License Information

The following publications cannot be ordered in hardcopy. The publications are made available on the Web at:

Publications on CD-ROM for the products in this announcement will be available on the next release of the following collections of software product libraries:

  • z/OS Software Products Collection (SK3T-4270), BookManager® and PDF formats
  • OS/390 Software Products Collection (SK2T-6700), BookManager format

                                                       Order
Title                                                  Number
 
DB2 Administration Tool for z/OS, V4
 (5655-I23)
  User's Guide                                         SC27-1601
  Reference Card                                       SX26-3850
DB2 Change Accumulation Tool for z/OS,                 SC27-1191
 V1.2 (5655-F55) User's Guide
DB2 High Performance Unload for z/OS,                  SC27-1602
 V2 (5655-I19) User's Guide
DB2 Object Comparison Tool for z/OS,                   SC27-1603
 V2 (5655-I20) User's Guide
DB2 Performance Expert for z/OS (5655-I21)
 Monitoring User's Guide -- Workstation                SC27-1645
 Installation and Customization                        SC27-1646
 Report Reference                                      SC27-1647
 Report Command Reference                              SC27-1649
 Messages                                              SC27-1650
 Reporting User's Guide                                SC27-1651
 Monitoring User's Guide -- ISPF                       SC27-1652
 Buffer Pool Analyzer User's Guide                     SC27-1653
DB2 Query Monitor for z/OS, V1.2                       SC27-0968
 (5655-E67) User's Guide
DB2 SQL Performance Analyzer for z/OS,
 V2 (5655-I22)
  User's Guide                                         SC27-1605
 
  Installation Guide                                   SC27-1625
DB2 Table Editor for z/OS, V4.3                        SC27-1616
 (5697-G65) User's Guide
DB2 Web Query Tool for z/OS, V1.3                      SC27-0971
 (5655-E71) User's Guide
IMS High Availability Large                            SC27-1579
 Database Conversion Aid
 for z/OS (5655-I01) User's Guide
IMS High Performance Prefix                            SC27-1590
 Resolution for z/OS, V2.1
 (5655-I15) User's Guide
IMS Index Builder for z/OS, V2.2                       SC27-0930
 (5655-E24) User's Guide
IMS Queue Control Facility for z/OS,                   SC26-9685
 V1.2 (5697-E99) User's Guide

The following material is available on the Internet at:

Overview brochure

  • IBM Tools for DB2 and IMS for z/OS and OS/390 (GC27-1070)

Specification Sheets

  • DB2 Administration Tool (GC27-1045)
  • DB2 Change Accumulation Tool (GC27-1052)
  • DB2 High Performance Unload (GC27-1047)
  • DB2 Object Comparison Tool (GC27-1051)
  • DB2 Performance Expert (GC27-1633)
  • DB2 Query Monitor (GC27-1042)
  • DB2 SQL Performance Analyzer (GC27-1038)
  • DB2 Table Editor (GC27-1053)
  • DB2 Web Query Tool (GC27-1044)
  • IBM IMS High Availability Large Database (HALDB) Conversion Aid (GC27-1632)
  • IBM IMS High Performance Prefix Resolution (GC27-1065)
  • IBM IMS Index Builder (GC27-1065)
  • IBM IMS Queue Control Facility (GC27-1069)

Technical Information

Hardware Requirements

The products in this announcement will operate on any hardware configuration that supports the required versions of DB2 and/or IMS. Additional hardware requirements are:

  • A display station supported by Interactive System Productivity Facility (ISPF).
  • An IBM color graphics display station, or equivalent, supported by Graphical Data Display Manager (GDDM®) is needed by the host-based graphics facility of DB2 Performance Expert.
  • A workstation with a high-resolution monitor that supports Windows NT® V4, Windows® 2000, or Windows XP with approximately 120 MB of available hard disk space is required by the DB2 Performance Expert workstation-based Online Monitor.

Software Requirements

DB2 Object Comparison Tool for z/OS, V2 (5655-I20) requires DB2 Administration Tool for z/OS, V4 (5655-I23). DB2 Performance Expert requires DB2 V6, or later. The other DB2 products in this announcement require DB2 V5, or later.

  • DB2 V5 (5655-DB2)
  • DB2 V6 (5645-DB2)
  • DB2 V7 (5675-DB2)

DB2 Performance Expert has additional software requirements:

  • ISPF, Windows NT or Windows XP is needed depending on which Online Monitor you use. The host-based graphics facility (ISPF) requires:
    • Graphical Data Display Manager (GDDM) V2.3 (5665-356)
    • GDDM Presentation Graphics Feature (GDDM/PGF) V2.1.1 (5668-812)
  • DB2 Connect Personal Edition V7 (5648-D40) is needed if you use the Performance Warehouse.

DB2 Web Query for z/OS is supported for hosting on WebSphere® for z/OS, V3.5 (5655-A98) and V4 (5655-F31).

  • Host servers require support for:
    • JDK V1.3, or later
    • JDBC V1, or later
    • JSDK V2, or later
    • JSP V1.1, or later
    • Servlet 2.2, or later
  • Client interfaces and devices must support:
    • HTTP (Web browser) interface, Level 4 browser capable of Java™
    • WAP device interface, V3, or later
    • POP/SMTP interface, standard POP/SMTP e-mail protocols

IMS HALDB Conversion Aid requires IMS V7, or later. The other IMS products in this announcement operate on all supported versions of IMS.

  • IMS V6 (5655-158)
  • IMS V7 (5655-B01)
  • IMS V8 (5655-C56)

Planning Information

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

  • Basic machine-readable material on a 3480 tape cartridge except for DB2 Web Query Tool and DB2 Table Editor:
    • DB2 Web Query Tool machine-readable material, which is all workstation code, is on CD-ROM. No z/OS code is required. During installation on the workstation, DB2 Web Query binds to the appropriate databases on z/OS.
    • DB2 Table Editor is shipped with workstation code on CD-ROM and z/OS code on 3480 tape cartridge.
  • Program Directory
  • Proof of Entitlement (PoE)
  • IBM International Program License Agreement (IPLA)
  • License Information

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

The products in this announcement have one charge unit: Value Unit.

Value Unit based pricing will help to align the prices of these Products to the principle of the PSLC pricing curve, which provides for a lower price per MSU (millions of service units per hour) for larger capacities.

There is also be a price benefit when customers grow their capacity. Additional capacity will be based on the number of Value Units (MSUs) the customer has already installed, for example, additional capacity will not be priced starting at the base with a higher price per unit but on the capacity that is already installed.

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

Translation from MSUs to Value Units

                MSUs        Value Units/MSU
 
Base            1-3             1.00
Tier A          4-45             .45
Tier B         46-175            .36
Tier C        176-315            .27
Tier D        316+               .20

The total number of Value Units is calculated according to the following example:

If the customer has installed 1,000 MSUs, the applicable Value Units would be:

3 x 1.00 + 42 x 0.45 + 130 x 0.36 + 140 x 0.27 + 685 x 0.20 = 244 Value Units

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

Value Units for IBM 9672 Processors will be based upon the full capacity of these systems. This is applicable to all S/390®-based systems that are measured on MSU capacity. Information on MSU capacities can be found in the IBM System/370™, System/390®, and IBM eServer zSeries Machine Exhibit (Z125-3901).

Value Units for zSeries will be based upon full MSU capacity as defined in the Machine Exhibits, unless a customer qualifies for sub-capacity pricing on the z/900 server.

Value Units for non-MSU-based S/390 Processors

MP3000 Models 

              H30       =   6.00 Value Units
              H50       =   8.00 Value Units
              H70       =  12.00 Value Units
 
P/390, R/390, IBM 3006  =   2.00 Value Units

A tool is available that supports transforming the MSU-based capacities of S/390 Systems to new Value Units by calculating the applicable number of Value Units for a given number of MSUs. The person preparing an order is required to use this tool to calculate the number of Value Units, based upon the number of MSUs (processor capacity). CFSW expects Value Units as configuration input.

Value Unit Exhibit VUE007

                                    Value               Value
                                    Units/              Units/
Usage Level    Minimum   Maximum    MSU     Hardware    Machine
 
Base                1         3     1       MP3000 H30     6
PSLC / Level A      4        45     0.45    MP3000 H50     8
PSLC / Level B     46       175     0.36    MP3000 H70    12
PSLC / Level C    176       315     0.27    ESL Models     2
PSLC / Level D    316         +     0.2

The products in this announcement have one charge unit: Value Units.

Value Units for IBM 9672 Processors will be based upon the full capacity of these Systems. This is applicable to all S/390-based systems that are measured on MSU capacity. Information on MSU capacities can be found in the IBM System/370, System/390, and zSeries Machine Exhibit (Z125-3901).

Value Units for zSeries will be based upon full MSU capacity as defined in the Machine Exhibits.

There is a tool available that provides support for transforming the MSU-based capacities of S/390 systems to new Value Units by calculating the applicable number of Value Units for a given number of MSUs.

Translation from MSUs to Value Units Example

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

Note: For the actual translation from MSUs to Value Units for this product, see below.

Ordering Example: The total number of Value units is calculated according to the following example:

If the customer has installed 1,000 MSUs, the applicable Value Units would be:

Translation from MSUs to Value Units

            MSUs    x  Value Units/MSU  = Value Units
 
Base          3     x      1.00         =      3.00
Tier A       42     x       .45         =     18.90
Tier B      130     x       .36         =     46.80
Tier C      140     x       .27         =     37.80
Tier D      685     x       .20         =    137.00
 
Total      1000                              244

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

                           Feature
 
  1 Value Unit             0001
250 Value Units            0002

Example: For a product running on machines with 1,000 MSUs requiring 244 Value Units, you would order feature number 0001, quantity 244.

Note: For actual feature numbers, see below.

Value Units for Non-MSU-Based S/390 Processors

MP3000 Models 

              H30       =   6.00 Value Units
              H50       =   8.00 Value Units
              H70       =  12.00 Value Units
 
P/390, R/390, IBM 3006  =   2.00 Value Units

Basic License: To order, specify the program number, feature number 9001 for asset registration, and the one-time charge (OTC) feature number. Also specify the feature number of the desired distribution medium. To suppress shipment of media, select the License-only option in CFSW.

Translation from MSUs to Value Units

               MSUs         Value Units/MSU
 
Base            1-3             1.00
Tier A          4-45             .45
Tier B         46-175            .36
Tier C        176-315            .27
Tier D        316+               .20

The ordering information is not changed for:

  1. New product releases in this announcement from prior releases
  2. Subscription and Support licenses for new product releases and product versions in this announcement from prior releases and versions

                                                            Program
Program Name                                                Number
 
DB2 Change Accumulation Tool                                5655-F55
 for z/OS, V1.2
Subscription and Support DB2 Change                         5655-E48
 Accumulation Tool for z/OS
DB2 Query Monitor for z/OS, V1.2                            5655-E67
Subscription and Support                                    5655-E87
 DB2 Query Monitor for z/OS
DB2 Table Editor for z/OS, V4.3                             5697-G65
Subscription and Support                                    5655-E84
 DB2 Table Editor for z/OS
DB2 Web Query Tool for z/OS, V1.3                           5655-E71
Subscription and Support                                    5655-E91
 DB2 Web Query Tool for z/OS
IMS Index Builder for z/OS, V2.2                            5655-E24
Subscription and Support                                    5655-E23
 IMS Index Builder for z/OS
IMS Queue Control Facility for z/OS, V1.2                   5697-E99
Subscription and Support                                    5655-E99
 IMS Queue Control Facility for z/OS
Subscription and Support                                    5655-E90
 DB2 Administration Tool for z/OS
Subscription and Support                                    5655-E89
 DB2 High Performance Unload for z/OS
Subscription and Support                                    5655-E40
 DB2 Object Comparison Tool for z/OS
Subscription and Support                                    5655-E97
 DB2 SQL Performance Analyzer for z/OS
Subscription and Support                                    5655-E28
 IMS High Performance Prefix
 Resolution for z/OS

Trade-up Prices to DB2 Performance Expert, V1 (5655-I21) are available for customers who currently have DB2 Performance Monitor V7 (5655-E61), and/or DB2 Buffer Pool Analyzer V1 (5655-E54). The trade-up prices are supported with unique trade-up price feature numbers and will be available until March 31, 2003. The price metric is per Value Unit, and the terms and conditions of the IPLA license apply.

The ordering information for the new products and versions in this announcement follows.

                                      OTC         Medium
                                      Feature     Feature
Description                           Number      Number       Medium
 
Program Number 5655-I23
 
DB2 Administration Tool for                       5802         3480
  z/OS, V4                                                     Tape
    One Value Unit                    0001
    250 Value Units                   0002
 
Program Number 5655-I19
 
DB2 High Performance                              5802         3480
  Unload for z/OS, V2                                          Tape
    One Value Unit                    0001
    250 Value Units                   0002
 
Program Number 5655-I20
 
DB2 Object Comparison                             5802         3480
  Tool for z/OS, V2                                            Tape
    One Value Unit                    0001
    250 Value Units                   0002
 
                                      OTC         Medium
                                      Feature     Feature
Description                           Number      Number       Medium
 
Program Number 5655-I21
 
DB2 Performance Expert                            5802         3480
  for z/OS, V1                                                 Tape
    One Value Unit                    0001
    250 Value Units                   0002
    Trade-Up from DB2
     Performance Monitor
     (5655-E61)
       One Value Unit                 0003
       250 Value Units                0004
    Trade-Up from DB2
     Buffer Pool Analyzer
     (5655-E54)
       One Value Unit                 0005
       250 Value Units                0006
    Trade-Up from DB2
     Performance
     Monitor (5655-E61) and
     DB2 Buffer Pool
     Analyzer (5655-E54)
       One Value Unit                 0007
       250 Value Units                0008
 
Program Number 5655-I22
 
DB2 SQL Performance                               5802         3480
  Analyzer for z/OS, V2                                        Tape
    One Value Unit                    0001
    250 Value Units                   0002
 
Program Number 5655-I01
 
IMS High Availability Large                       5802         3480
  Database Conversion Aid                                      Tape
  for z/OS, V1
    One Value Unit                    0001
    250 Value Units                   0002
 
Program Number 5655-I15
 
IMS High Performance Prefix                       5802         3480
  Resolution for z/OS, V2                                      Tape
    One Value Unit                    0001
    250 Value Units                   0002

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.

Subscription and Support will be available in the country in which the agreement is made.

To order, specify the support program number. 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 customer is not entitled for new products.

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

                                                  OTC
                                                  Reseller
                                      ACS(1)      One Year    Medium
                                      Feature     Feature     Feature
Description                           Number      Number      Number
 
Subscription and Support for:
 
Program Number 5655-I31
 
DB2 Performance Expert                                        6621
  for z/OS                                                    Paper
    One Value Unit                    0002        0005
    250 Value Units                   0003        0006
    Decline (No charge)               0004
 
Program Number 5655-I02
 
IMS High Availability                                         6610
  Large Database                                              Paper
  Conversion Aid
  for z/OS
    One Value Unit                    0001        0004
    250 Value Units                   0002        0005
    Decline (No charge)               0003
1
Annual support charge

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 (that is, CBPDO, ServerPac, and Systempac®). Non-customized items (CDs, diskettes, source media, media kits) will continue to be shipped via the stand-alone product.

Terms and Conditions

Sub-Capacity Charges Terms and Conditions

zSeries software charges at less than full machine capacity for eligible Data Management and Application Development Tools apply when z/OS is running in z/Architecture (64 bit) mode on an IBM eServer zSeries 900, no other MVS™-based operating system is licensed to that server and the required information is provided by the customer in accordance with the applicable terms.

Sub-capacity charges for an eligible AD or DM Tool is based on the z/OS product defined capacity. To obtain charges at less than full machine capacity for eligible AD and DM tools, the customer is required to:

  • Determine the MSUs needed for each machine on which the Tools will run. Only machines on which the customer has implemented sub-capacity WLC according to the above terms and conditions are eligible for charges at less than full machine capacity for the Tools.
  • Use the product defined capacity for z/OS (as specified on the Sub-Capacity Reports submitted to IBM for sub-capacity WLC) as the sub-capacity (MSUs)for each tool.
  • Submit any additional MSUs and/or Value Units required for each product along with the current entitlement in Value Units for each Product.

Sub-Capacity Charges for AD and DM Tools

To be eligible for sub-capacity charges for AD and DM Tools, the machine on which the AD and DM Tools are running must be eligible for WLC sub-capacity charges terms and conditions. The customer must have signed the Attachment for zSeries Workload License Charges-Pre-ILM (Z125-6516) and submitted at least one Sub-Capacity Report to IBM as defined in the attachment.

With sub-capacity charges, the charge for an eligible AD or DM Tool is based on the z/OS product defined capacity. To obtain charges at less than full machine capacity for each eligible AD and DM Tool for each machine, the customer should:

  • Determine the MSUs needed for the machine on which the Tools will run. In a data sharing environment, determine the aggregate MSUs needed on the machine where the tools run. Use the product defined capacity (MSUs) for z/OS (as specified on the Sub-Capacity Reports submitted to IBM for sub-capacity WLC) as the sub-capacity (MSUs) for each tool.
  • Submit any additional MSUs and/or Value Units required for each product along with the current entitlement in Value Units for each product.
  • If the use of sub-capacity pricing terms for AD and DM Tools results in a reduced requirement for Value Units, thus "freeing up" entitlements, customers can reallocate the entitlement difference by distributing the Value Units across a larger or different set of systems, or reserve them for future growth. There will be no refunds for these "freed up" Value Units. Subscription and Support volumes and entitlements for existing contracts will continue to be at the same levels as the acquired licenses.

Management of the Value Unit entitlements continues to be a customer responsibility. If one of the following occur on a machine to which AD or DM Tools are licensed, the customer must determine if additional Value Units and Subscription and Support need to be ordered for those Tools to cover the increase:

  • The z/OS defined capacity is increased.
  • The requirements for WLC sub-capacity charges are no longer met.

Licensing: IPLA. Proofs of Entitlement (PoE) are required for all authorized use. Part number products only, offered outside of Passport Advantage, where applicable, are license only and do not include Software Maintenance.

The following agreements apply for maintenance and do not require customer signatures:

  • IBM Agreement for Acquisition of Support (Z125-6011)

These products are licensed under the IPLA, and the associated Agreement for Acquisition of Support, and the Addendum for Support (Z125-6336), which provides for support with ongoing access to releases and versions of the program. These programs have a one-time license charge for use of the program and an ongoing recurring charge for the enhanced support that includes telephone assistance (voice support for defects during normal business hours) as well as access to updates, releases, and versions of the program as long as support is in effect. S/390 and zSeries IBM Operational Support Services — Support Line is an option for those customers who desire added services.

IPLA licenses can be transferred from one machine to another within, but not limited to an enterprise. The customer may aggregate the capacity for all the processors the product is operated on to achieve a more economic price. This will result in a single Proof of Entitlement. It is the customer's responsibility to manage the distribution of Value Units within the limits of the Entitlement of the Product License.

Limited Warranty: Yes

Program Services

  • Available until March 31, 2005, for all products in this announcement except DB2 Performance Monitor for z/OS, V7
  • Available until November 30, 2004, for the previously announced DB2 Performance Monitor for z/OS, V7 (a 12-month extension)

Money-Back Guarantee: A 30-day, money-back guarantee, applicable to the first instance per customer enterprise. The money-back guarantee will commence on the invoice date.

Copy and Use on Home/Portable Computer: No

Volume Orders (IVO): No

Passport Advantage Applies: No

Software Maintenance Applies: For Operating System software, the revised IBM Operational Support Services — Support Line offering will provide support for those operating systems and associated products that are not available with the newly announced Software Maintenance offering. This will ensure total support coverage for your enterprise needs, including IBM and selected non-IBM products. For complete lists of products supported under both the current and revised Support Line offering, refer to our Web site at:

For additional information on the revised IBM Operational Support Services, refer to Services Announcement 601-023 , dated July 10, 2001.

IBM Operational Support Services — Support Line: Yes

AIX®/UNIX® Upgrade Protection Applies: No

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

IBM e(logo)Server iSeries Software Subscription Applies: No

Variable Charges Apply: No

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

Replaced Programs                       Replacement Programs
 
DB2 Administration Tool                 DB2 Administration
  feature of DB2 V6                       Tool V4 (5655-I23)
  (5645-DB2)
 
DB2 Administration Tool
  for OS/390, V2 (5655-D52)
 
DB2 Administration Tool
  for MVS/ESA(TM), V1 (5688-515)
 
DB2 High Performance                    DB2 High Performance
  Unload V1 (5697-F44)                    Unload V2 (5655-I19)
 
DBT V2 (Fast Prefix                     IMS High Performance
  Resolution Feature)                     Prefix Resolution V2
  (5685-093)                              (5655-I15)

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@vnet.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

 
iSeries and zSeries are trademarks of International Business Machines Corporation.
 
The e-business logo, z/OS, IMS, DataPropagator, System/370, MVS, and MVS/ESA are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
WebSphere, DB2, DB2 Universal Database, OS/390, DB2 Connect, BookManager, GDDM, S/390, System/390, Systempac, and AIX are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows and Windows NT are registered trademarks of Microsoft Corporation.
 
Java is a trademark of Sun Microsystems, Inc.
 
UNIX is a registered trademark is a registered trademark of the Open Company in the United States and other countries.
 
Notes is a trademark of Lotus Development Corporation and/or IBM Corporation.
 
Other company, product, and service names may be trademarks or service marks of others.