IBM United States
Software Announcement 201-250
September 11, 2001

New and Enhanced IBM Data Management Tools for DB2 and IMS

 ENUS201-250.PDF (106KB)

(Corrected on October 31, 2001)

Under Terms and Conditions Replace Z125-XXXX with Z125-6336.

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 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 announces new tools, functions, and tool integration which 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. Check out our affordable, high-performance, and functionally rich products.

New and Improved

Following the direction announced in 2000, competitive products, function-rich new versions, significant new functions and tool integration are being made available.

Previous DB Tools Announcements

Refer to Software Announcements 201-056 , dated March 6, 2001, and 201-162 , dated May 29, 2001. The latter features:

  • One new product — DB2® Path Checker for z/OS
  • One new version — DB2 Bind Manager for z/OS, Version 2
  • One new release — IMS HD Compression Extended for z/OS, Version 2.2
  • Service stream enhancements for IMS Connect for OS/390®

Tools for Distributed DB2 Environments

  • Tools for z/OS and IBM e(logo)server iSeries
  • Concurrent with this announcement, tools for additional DB2 environments are announced. Refer to Software Announcement 201-251 , dated September 11, 2001.

New in this Announcement:

  • Six new licensed programs — four DB2 and two IMS
  • Three new program versions — one DB2 and two IMS
  • Ten new program releases — seven DB2 and three IMS

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.

Planned Availability Dates

  • September 14, 2001
    • DB2 Table Editor for iSeries 4.2
    • DB2 Web Query Tool for iSeries 1.2
  • September 21, 2001: IMS Network Compression Facility for z/OS
  • October 5, 2001: IMS DataPropagator™ for z/OS 3.1
  • November 2, 2001
    • DB2 High Performance Unload for z/OS 1.2
    • DB2 Table Editor for z/OS 4.2
    • IMS Connect for z/OS 1.2
    • IMS Fast Path Basic Tools for z/OS 1.2
    • IMS Parallel Reorganization for z/OS 2.1
  • December 7, 2001
    • DB2 Administration Tool for z/OS 3.1
    • DB2 Automation Tool for z/OS 1.2
    • DB2 Buffer Pool Analyzer for z/OS
    • DB2 Data Export Facility for z/OS
    • DB2 Log Analysis Tool for z/OS 1.2
    • DB2 Object Restore for z/OS 1.2
    • DB2 SQL Performance Analyzer for z/OS 1.2
    • DB2 Web Query Tool for z/OS 1.2
    • IMS Extended Terminal Option Support for z/OS 2.2
    • IMS High Performance Change Accumulation Utility for z/OS

Description

  • IBM Tools for Database Administration
    • DB2 Administration Tool for z/OS, Version 3.1 5655-E64
      • Subscription and Support 5655-E90
      • Availability Date: December 7, 2001
    • DB2 Automation Tool for z/OS, Version 1.2 5697-G63
      • Subscription and Support 5655-E38
      • Availability Date: December 7, 2001
    • DB2 High Performance Unload for z/OS, Version 1.2 5655-E69
      • Subscription and Support 5655-E89
      • Availability Date: November 2, 2001
    • DB2 Log Analysis Tool for z/OS, Version 1.2 5655-E66
      • Subscription and Support 5655-E86
      • Availability Date: December 7, 2001
    • DB2 Object Restore for z/OS, Version 1.2 5655-E72
      • Subscription and Support 5655-E92
      • Availability Date: December 7, 2001
    • DB2 Table Editor for iSeries, Version 4.2 5697-G84
      • Availability Date: September 14, 2001
    • DB2 Table Editor for z/OS, Version 4.2 5697-G65
      • Subscription and Support 5655-E84
      • Availability Date: November 2, 2001
    • IMS Extended Terminal Option Support for z/OS, Version 2.2 5655-E12
      • Subscription and Support 5655-E13
      • Availability Date: December 7, 2001
    • IMS Fast Path Basic Tools for z/OS, Version 1.2 5655-E30
      • Subscription and Support 5655-E36
      • Availability Date: November 2, 2001
    • IMS High Performance Change Accumulation Utility for z/OS 5655-F59
      • Subscription and Support 5655-F58
      • Availability Date: December 7, 2001
    • IMS Parallel Reorganization for z/OS, Version 2.1 5655-F74
      • Subscription and Support 5655-F73
      • Availability Date: November 2, 2001
  • IBM Tools for Database Recovery and Replication Management
    • IBM DataPropagator for z/OS, Version 3.1 5655-E52
      • Subscription and Support 5655-E53
      • Availability Date: October 5, 2001

IBM Database Tools for Performance Management

  • DB2 Buffer Pool Analyzer for z/OS 5655-E54
    • Subscription and Support 5655-E55
    • Availability Date: December 7, 2001
  • DB2 SQL Performance Analyzer for z/OS, Version 1.2 5697-F57
    • Subscription and Support 5655-E97
    • Availability Date: December 7, 2001
  • IMS Network Compression Facility for z/OS 5655-E41
    • Subscription and Support 5655-E42
    • Availability Date: September 21, 2001

IBM Database Tools for Application Management

  • DB2 Data Export Facility for z/OS 5655-E46
    • Subscription and Support 5655-E47
    • Availability Date: December 7, 2001
  • DB2 Web Query Tool for iSeries, Version 1.2 5697-G85
    • Availability Date: September 14, 2001
  • DB2 Web Query Tool for z/OS, Version 1.2 5655-E71
    • Subscription and Support 5655-E91
    • Availability Date: December 7, 2001
  • IMS Connect for z/OS, Version 1.2 5655-E51
    • Subscription and Support 5655-E34
    • Availability Date: November 2, 2001

IBM Tools for Database Administration

DB2 Administration Tool for z/OS, Version 3.1 provides 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 provides a cost-effective solution for a full range of database administration functions for DB2 for z/OS.

DB2 Administration Tool provides in-depth catalog navigation by displaying and interpreting objects in the DB2 catalog and executing dynamic SQL statements. DB2 Admin provides the ability to make changes and updates quickly and easily to the data presented and integrates with other DB2 utilities. Alter and migrate functions, reverse engineering of the DB2 catalog, and many other catalog administrative tasks are supported.

Enhancements:

  • DB2 Version 7 exploitation
  • Generation of REBIND commands in reverse engineering
  • Quick reverse engineering function for single objects
  • Online display and change of DB2 system parameters
  • Prompt/Batch option for DDL, DCL, and DML update statements
  • Generation of change operations that can be reused
  • Support for running on multiple copies of the DB2 catalog

DB2 Automation Tool for z/OS, Version 1.2 allows database administrators to automate database maintenance by specifying sets of database objects, conditions to monitor, and then launch one or a series of utilities as jobs that execute according to specified parameters. By combining object profiles and utility option profiles into job profiles, DBAs can keep tight control over database conditions and the utilities needed to correct them with minimal personal intervention.

This release is significantly more flexible and robust than Release 1 with the addition of the following new capabilities:

  • Integration with DB2 Administration Tool DB2 Automation Tool may now be launched from the DB2 Administration Launchpad.

  • Additional Utility Support in addition to IMAGE COPY, RUNSTATS, and REORG, DB2 Automation Tool V1.2 now supports the QUIESCE utility, the MODIFY utility, automatic reallocation of STOGROUP defined objects, and the Data Page Verification Reporting utility

  • Exception Profiles Support is added for thresholds and exceptions, allowing job profiles to be executed automatically without DBA intervention when specified conditions appear for any given object or set of objects. In addition, to the basic RUNSTATS information captured in the DB2 Automation Tool Repository, DBAs may also define exception conditions using any combination of:
    • A group of popular product-defined calculations based on RUNSTATs information
    • Access to dataset statistics from the MVS™ catalog
    • Access to information from SYSCOPY

    For example, REORG if dataset is in x extents, or COPY if most recent copy is more than one week old.

  • Multiple Jobs

    Multiple jobs can be generated from a single profile. Options for multiple job generation include number of objects per job, number of jobs per profile, DASD usage, and elapsed time.

  • Profile Sharing

    You can now use a secondary ID as the creator of a profile, allowing full access to the profile by other workgroup members.

  • Profile Moving

    Profiles can now be copied among multiple DB2 subsystems, allowing faster and easier setup of and user access to frequently used DB2 Automation Tool profiles on those subsystems.

  • Dataset Manager

    A new Dataset Manager Facility now enables DB2 datasets to be viewed, evaluated, and moved. This new facility provides online displays allowing you to select the desired datasets to be moved. Datasets can be moved interactively from within TSO/ISPF or by using the batch facility provided. The Dataset Manager Facility supports all types of dataset allocation including STOGROUP, user defined, SMS, and non SMS.

  • User Interface Enhancements

    These enhancements include a streamlined main menu, the ability to work with all profiles from a Job Profile, and a common look and feel across all profile panels.

  • Base GDG Support

    Automatic creation of base GDGs (Generation Data Groups) is now provided. If GDGs are in use with image copy utilities in a DB2 environment, then DB2 Automation Tool will trigger the generation of a base GDG as needed at the time of image copy execution.

  • Improved Support for ERP Environments

    Support for multiple jobs (described above) and new support for searching and selecting objects using the Tablespace Creator improves DB2 Automation Tool support for complex database environments, such as SAP.

DB2 High Performance Unload for z/OS, Version 1.2 offers sequential reading and the capability to access your DB2 data at top speed. It can unload data from image copies and 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:

  • Data sharing support
  • Inline FIC support
  • CCSID conversion at the column level
  • SYSKEYS keyword support in the generated load statement
  • Option DB2 FORCE to force the usage of DB2 to extract data when DSNTIAUL is faster than HPU
  • Improved flexibility in default user format setting
  • Return code 4 issued if an unload returns 0 lines

DB2 Log Analysis Tool for z/OS, Version 1.2 makes it easy to quickly audit and identify changes to data. Once identified, changes may be selectively reversed, reapplied (at the original database or at other databases), or reported upon. Highly customized summary or detailed views of data changes, and automatically generated SQL for reversing or reapplying changes, easily provide tighter control over data integrity.

New capabilities:

  • Integration with DB2 Administration and DB2 Object Restore
    • DB2 Log Analysis Tool may now be launched from the DB2 Administration Launchpad.

    • Output files generated by DB2 Object Restore may be accessed from within DB2 Log Analysis Tool allowing reporting on dropped objects and restoring their data to a desired point in time.

  • Bypass of the SYSLGRNX table

    Reports may now be run on time frames prior to the last cleanup of the SYSLGRNX table by bypassing the table.

  • "Auto-continue" Mode

    Report parameters now may be set once and then run any number of times, with each subsequent run beginning in the log where the previous run left off. The same report can be run a periodic (that is, nightly) basis, providing continuous, non-redundant coverage of all log entries. Inflight units-of-work will be automatically saved between runs in this operating mode, so reporting capabilities on such activities are always retained.

  • New General Report Format

    The general report is much smaller. Identical records (within a URID) are summarized into one record with a count value. This count value represents the number of identical records (that is, the number of records displayed in earlier releases).

  • Log Forward Process

    When analyzing data in the log for a specific period of time, it is common for Log Analysis Tool to encounter a REORG related to the specified table. Log Analysis Tool can now read the log in the forward direction starting from the START TIME and properly handle activity that spans REORGs. Similarly, the log forward process can also report on LOADs and Mass Deletes (that is, DELETE FROM TABLEX, where TABLEX is part of a segmented tablespace) found in the DB2 logs.

  • Static SQL Support

    The SQL generated by DB2 Log Analysis Tool can be automatically bound into static SQL. This allows for significant performance improvements when running a large number of SQL statements.

  • Querying Report Results

    The DB2 Log Analysis Tool Detail Report data is also written to a file in DB2 Load format. You can load this file into a new DB2 table, allowing the data behind the detail report to be available for further analysis via DB2 Web Query Tool.

  • New Filter Criteria

    New criteria for filtering on OBID, PSID, and DBID are available. Reporting on dropped objects is also available, simplifying the use of Log Analysis Tool in conjunction with DB2 Object Restore V1.2 to restore objects and their data to a desired point in time.

DB2 Object Restore for z/OS, Version 1.2 makes it possible to quickly restore dropped objects. The following enhancements are provided in this release:

  • Integration with DB2 Administration Tool and DB2 Log Analysis Tool

    • DB2 Object Restore may now be launched from the DB2 Administration Launchpad.

    • In addition to its existing support for DSN1COPY, DB2 Object

      Restore V1.2 produces output files that can be accessed from within DB2 Log Analysis Tool to quickly roll forward the data associated with a restored object to a desired point in time.

  • Objects

    Recreation of storage groups, databases, tablespaces, tables, indexes, aliases, synonyms, views, plans, and packages is now supported.

  • Privileges

    Privileges supported now include user privileges, system privileges, database privileges, table privileges, view privileges, collection privileges, plan privileges, package privileges, and column privileges.

  • Global Object Dependencies View

    From within the main panel or from any object list, users can quickly switch to a view displaying all object dependencies. From this view, the dependencies desired for inclusion in a restore process may be selected.

  • Administrative Options

    Administrative options are expanded allowing the DBA to specify what types of objects and privileges will be maintained within the DB2 Object Restore Versioning Repository. For example, you may specify that only tables be maintained, but not the privileges for tables.

DB2 Table Editor for z/OS, Version 4.2 extends the capabilities of this powerful tool even further with:

  • Tool Integration
    • The DB2 Table Editor Java™ interface may be launched from the DB2 Control Center, and the ISPF interface may be launched from the DB2 Administration Launchpad, or via a line command from within DB2 Export Facility or DB2 Administration Tool.

  • Linked Forms

    DB2 Table Editor V4.2 forms developers building Windows® or Java based forms may now define linkages between forms. This allows for sets of forms to be built and linked with parent/child relationships, whether or not the data in the forms is related in the underlying DB2 table structure.

  • SQL Command Buttons

    A form builder can now place a command button on any Windows or Java based form that will launch any SQL, including stored procedures.

  • Large Object Support

    The Windows and Java based DB2 Table Editor V4.2 interfaces now provide large object support, including support for large objects through forms rendered in those environments.

  • ISPF Interface enhancements

    The ISPF interface of DB2 Table Editor V4.2 provides:

    • Launch from the DB2 Administration Launchpad, or via a line command from within DB2 Export Facility or DB2 Administration Tool
    • Toggle easily between "browse" and "edit" modes
    • Execute INSERT, DELETE, COPY, REPEAT, and UNDO upon blocks of data with ISPF editor command syntax
    • Select column order when displaying data
    • Choose which columns to show or hide when displaying data
    • Choose which column to "freeze" in the leftmost position
    • Include all/Exclude all to quickly change which columns are displayed
    • Use uppercase command (forces data in a selected column to be entered in uppercase)
    • Use PF key and command to zoom into a specific column (column may be viewed in hex mode when zoomed)
    • Preview number of rows that will be in an editing session before beginning
    • Use PF key to display column name, column number, datatype, and length from within an edit session
    • Use Commands Change, Repeat Change, Change All, Find, Repeat Find all work upon and entire result set or single columns
    • Use undo command to undo inserts and deletes

DB2 Table Editor for iSeries, Version 4.2 provides the same robust table editing for DB2 on the iSeries as DB2 Table Editor does on the other DB2 family platforms. On all platforms this function is delivered from multiple GUI end user environments: Java-enabled Web browsers and workstations, and Windows workstations.

IMS Extended Terminal Option Support for z/OS, Version 2.2 provides the following enhancements.

  • SLUTYPEP support allows you to specify the Logon Descriptor, change the signon completed message (DFS3650), override ASOT/ALOT, or other IMS options on an LU by LU basis. It can also perform automatic RACF® signon for these devices.
  • SLU1 Console support enables you to specify the Logon Descriptor, change the signon completed message (DFS3650), override ASOT/ALOT, or other IMS options on an LU-by-LU basis. It can also perform automatic RACF signon for this device type.
  • SLU2/3270 support has been enhanced to allow execution of an IMS transaction in place of the DFS3650 message.
  • With customer tailored DFS3649I error messages you can specify the error text used to replace the default Return Code numeric value.
  • Support is provided for multiple versions of IMS.
  • Alternate ALOT=0 processing is now supported to allow you to take advantage of either form of ALOT=0. There are two forms of ALOT=0 processing:
    • The first ALOT=0 causes Auto Logoff to take effect immediately.
    • The second ALOT=0 causes Auto Logoff to take effect immediately after ASOT is reached.
  • LTERM names may now start with a numeric value.
  • Tailoring of signon processing is now supported. Specifically, reserved MFS MOD names are provided that may be used to give you more flexibility in tailoring your signon screens.

IMS Fast Path Basic Tools for z/OS, Version 1.2 provides the capability to verify the integrity and utilization of DEDBs, evaluate the potential benefit or impact of changes to existing DEDBs, and efficiently unload and reload or reorganize DEDBs. The product includes:

  • DEDB Pointer Checker
  • DEDB Tuning Aid
  • DEDB Unload/Reload Utilities

Enhancements include:

  • Control statement parameter ACCESS=FAST in the DEDB Unload Utility supports high performance read access to the DEDB area data set by using the DFSMS Media Manager interfaces.
  • DEDB Reload Utility allows you to produce image copies for reloaded DEDB areas and provide automatic notification of them to DBRC. This function requires IMS Image Copy Extensions for OS/390.
  • Improved Database Definition Record Create Utility for detailed, easy-to-understand reports of DEDB definitions in the DURDBDFN record and/or DMB member in ACBLIB.

IMS High Performance Change Accumulation Utility for z/OS replaces the IMS Parallel Change Accumulation product and provides the following new features and functional improvements.

  • Improved operations
    • Parallel Change Accumulation runs the standard Change Accumulation utility in parallel. Multiple jobs (address spaces) are triggered via multiple JOB statements in a single JCL stream, which has to be submitted by the user.
    • IMS High Performance Change Accumulation will trigger a single job through the internal reader, without the need to submit the JCL manually. The job will function as a multitask address space, ensuring parallel streaming of both input and output data.
  • Easier installation
    • Eliminates the need for the XCM address space and subsystem.
  • Improved flexibility and performance
    • Parallel Input/Output ensures an elapsed execution time as short as possible. Input data (from RLDSs) and output data (new CAs) are processed in parallel. The user can control the number of parallel processes. If the number of parallel processes are user throttled, the excess processes will be processed in series after the first maximum number of tasks have completed. This results in elongated execution time, but the option is provided and up to the user to exploit.
    • Single pass of input/output.
  • Improved interface
    • ISPF and Batch interface for operations.
    • ISPF interfaces allow for customization, setup, and execution.
  • Provides full support for DBRC

IMS Parallel Reorganization for z/OS, Version 2 replaces IMS Parallel Reorganization Version 1 and provides the following new features and functional improvements.

  • Execution of Unload, Reload, and Index Builder tasks as sub-tasks in one address space
  • Elimination of the need for the XCM address space and subsystem
  • Dynamic allocation of input and output database data sets
  • Full DBRC support, including DBRC notification processing
  • Automated name swapping for input and output database data sets
  • Automated IMS command processing

IMS Parallel Reorganization Version 2 provides the infrastructure to operate IMS High Performance Unload, IMS High Performance Load, and IMS Index Builder Version 2 products in parallel as a single Job step. The advantage of such operation is a significantly reduced batch window for full-function databases. Since the reorganization components are operated in parallel rather than sequentially, the reorganization operation takes only slightly longer than the longest component operation.

IMS Parallel Reorganization Version 2 provides both manual and automated post processing capabilities to rename the input and output database data sets and notify DBRC.

IBM Database Tools for Replications and Recovery

IMS DataPropagator for z/OS, Version 3.1 supports an additional method of propagation of IMS DB changes: an MQSeries®-based, asynchronous near real time propagation. With this method:

  • A new IMS-DPROP Capture Component captures the IMS database changes (the Source DBs) performed by IMS Batch, IMS BMP, and IMS TM application programs.
  • A new IMS-DPROP Apply Component transforms the IMS DB changes into relational format and applies the changes to DB2 tables (the target tables). The transformation of the IMS data into relational format is based, as in previous IMS DPROP releases, on mapping definitions provided by the database administrators. The DB2 target tables can be on the same or on different systems from the IMS DBs.
  • The transmission of the DB changes from the Capture to the Target Component is via the recoverable, buffered and queued asynchronous messaging services of MQSeries.

When the teleprocessing connections between source and target systems and the system software are not overloaded, the elapsed time between the IMS DB updates and the DB2 table updates can often be as short as a couple of seconds. With IMS DataPropagator 3.1, an up-to-date copy of IMS data in DB2 tables for new DB2-based applications is possible.

In addition to a near real-time propagation, the new MQSeries-based asynchronous propagation also supports a point-in-time propagation. With point-in-time propagation, the content of the DB2 target tables reflect some clearly identified logical point-in-times of the IMS source databases, for example, the logical end of a business day, the logical end of a business month, or the end of a specific IMS batch/BMP jobstream. Point-in-time propagation is typically used to propagate to data warehouses or decision support systems that subset of data that does not need to be propagated within seconds.

The new IMS DataPropagator exploits the well established, first-class, high-performance, extremely reliable, queued messaging services of the MQSeries Software. Use of the familiar MQSeries Software allows enterprises to leverage their MQSeries Administration and Operations skills.

Performance is an important design criteria for DataPropagator. Examples of performance features are:

  • Multiple IMS database changes are transmitted within the same MQSeries message.
  • The MQSeries message data is compressed.
  • The efficient caching services of the Virtual Lookaside Facility (VLF) of z/OS is exploited.

By using both IMS DataPropagator and DB2 DataPropagator you can propagate your IMS database changes to all the relational database management systems on all the platforms supported by the apply programs of DB2 DataPropagator. This is achieved by using:

  • IMS DataPropagator to propagate the IMS database changes to DB2 staging tables
  • DB2 DataPropagator apply programs to propagate the staging tables to the relational database management systems and platforms supported by DB2 DataPropagator which include:
    • DB2 UDB for AS/400®
    • DB2 UDB for AIX®
    • DB2 UDB for HP-UX
    • DB2 UDB for Linux
    • DB2 UDB for Sun Solaris
    • DB2 UDB for Windows
    • DB2 UDB for z/OS
    • Oracle, SQL Server, Informix, and Sybase on a wide variety of platforms

IMS DataPropagator 3.1 continues to support:

  • Asynchronous propagation of changed IMS data to DB2 on z/OS based on the reading of the IMS archive logs. With this method, the elapsed time between the IMS database update and the DB2 table update is typically at least 30 minutes.
  • Synchronous propagation of changed:
    • IMS data to DB2 on z/OS
    • DB2 data on z/OS to IMS

    With this method the IMS databases and the DB2 tables must be on the same System. Because the propagation is synchronous, the elapsed time of the database update operations of the application programs increases by the time required to propagate the changes to the target database management system. Whether of not this elapsed time increase is acceptable depends on the rate of propagated database updates.

IBM Database Tools for Performance Management: DB2 Buffer Pool Analyzer for z/OS is a new product that provides:

  • Data collection of virtual buffer pool activity via the DB2 IFI interface
  • Comprehensive reporting of the buffer pool activity, including:
    • Ordering by various identifiers (for example, buffer pool, plan, object, primary authorization id)
    • Sorting by, for example, getpage, sequential prefetch, and synchronous read
    • Filtering capability
    • Loading into tables
  • Simulation of buffer pool usage for
    • Varying buffer pool size
    • Different object placement
  • Display of report and simulation results on workstation in form of spreadsheets, graphs and diagrams

DB2 SQL Performance Analyzer for z/OS, Version 1.2 focuses on the integration of SQL Performance Analyzer with other database tools.

  • Tool integration enables you to
    • Launch DB2 SQL Performance Analyzer from the DB2 Administration Tool for z/OS
    • Select SQL statements and invoke DB2 SQL Performance Analyzer from DB2 Query Monitor for z/OS
    • Evaluate SQL statement costs on the workstation with DB2 Web Query for z/OS

In addition, a catalog statistics extraction and migration facility gives you with the ability to:

  • Import production catalog statistics from other DB2 subsystems into the local DB2 SQL Performance Analyzer test DB2 system
  • Route remote executions of DB2 SQL Performance Analyzer to other DB2 systems using DRDA® Connect

IMS Network Compression Facility for z/OS reduces the size of data streams sent to 3270 terminals logged on to IMS, without any changes to IMS application programs or MFS. IMS Network Compression Facility also includes an ISPF facility to display statistics and options, update options currently in use, and trace data streams.

The data stream compression engine examines each outbound 3270 data stream, and uses standard 3270 data stream commands to reduce the size of outbound data streams. There are a number of separately controlled options used in the data stream compression process. These options are initially defined in an IMS PROCLIB member, and can be dynamically updated through the ISPF interface. Compression options can be excluded by node name, LTERM name, userid, IMS user name, transaction code, or MFS format name.

The trace facility included in the ISPF interface allows the user to display both before and after compression images of the data streams sent to a given node name. The trace feature can be used to help diagnose problems not only with IMS Network Compression Facility, but with remote screen scraper applications and IMS application programs.

IBM Database Tools for Application Management

DB2 Data Export Facility for z/OS exports and copies data for application development and testing. The ISPF interface easily extracts referentially intact sets of data, or individual tables and/or rows, into a DB2LOAD-ready file format for copying to other DB2 subsystems.

  • Copy selected source data quickly to test environments for faster application development and testing
  • Find relationships between tables
  • Navigate through table relationships with an intuitive forward/back, browser-like interface
  • Identify referential integrity properties instantly as you navigate, including parent/child relationships, indexes, and columns

Today's enterprise applications (such as ERP, CRM, and e-commerce) rely upon highly structured database environments with complex data relationships. These offer optimal performance, but can also present significant challenges to the developer or DBA supporting, modifying, or designing these or entirely new applications. DB2 Export Facility's robust support for highly selective data copying helps cut through the complexity normally associated with surgical problem resolution, populating test environments, or migrating applications to new or additional environments.

DB2 Data Export Facility provides a simple step-through interface for accessing DB2 for z/OS subsystems and precisely extracting desired subsets of data. Starting anywhere in a referential set and navigating anywhere throughout the set, users can see the attributes of tables (such as columns, indexes, and parent/child relationships) as they move about. From any point (including on key values), DB2 Data Export Facility finds all table relationships and allows easy selection and export of precisely the desired scope of data among the referential set, such as exporting a table, or a table and all its dependencies, or only certain dependencies.

DB2 Export Facility also provides exporting without referential integrity from a single table. Data exported in this manner can be narrowed down to the precise columns and rows desired. Columns may be omitted or remapped to new positions, partial sets of data may be retrieved, and transformations can be performed upon data values. For example, only data from every "n" rows may be copied (n SELECT statement), or sensitive data that would be inappropriate for a test environment (such as credit card numbers) may be masked.

DB2 Web Query Tool for z/OS, Version 1.2 gives Web-based users robust data access and data migration operations for DB2 data on the OS/390 and z/OS platforms.

  • Tool Integration

    The capabilities of DB2 Table Editor and DB2 SQL Performance Analyzer (if already licensed and installed) are now available from within the DB2 Web Query Tool browser interface. You may, for example, view SQL in DB2 Web Query Tool and quickly analyze the SQL for optimal performance. Or, when navigating through database objects in DB2 Web Query V1.2, a table may be opened up in the browser in table editing mode.

DB2 Web Query Tool 1.2 expands user interfaces and available data operations in this release.

  • WAP and e-mail

    Additional interfaces for WAP and e-mail users extend access to DB2 Web Query Tool functionality to virtually any location. With a WAP device or any e-mail client, users may now send commands to and receive responses from DB2 Web Query Tool, including running critical summary reports.

  • Compare Data

    Comparing one set of data with another to highlight differences in structure (fields, types, indexes), permissions, and data

  • Copy Data

    Copying data to another location, including as formatted text, CSV (and other delimiters), and HTML tables

  • XSL

    In addition to existing data formatting in HTML and support for exporting data as XML, DB2 Web Query V1.2 now supports data display using XSL. Stylesheets may be generated to provide richer cross-platform data display options.

DB2 Web Query Tool for iSeries, Version 1.2 brings the power of DB2 Web Query Tool to the iSeries. It provides the same Web-based data access, manipulation, and data migration operations for DB2 on the iSeries as DB2 Web Query Tool on the all other DB2 family platforms. The Web server and servlet can run on a different computer than the DB2 database data server. DB2 Web Query Tool V1.2 supports WAP and e-mail interfaces, new data operations, and has XML/XSL support.

IMS Connect for z/OS, Version 1.2 is extended to provide WebSphere™ Adapter support with the addition of the IMS Connector for Java J2C (J2EE Connector Architecture) Runtime support. J2C is the industry-wide standard version of the IBM Common Connector Framework. The IMS Connect for Java J2C Runtime support provides the runtime environment for Java applications developed using the VisualAge® for Java IMS Connector for Java J2C Development support. VisualAge for Java can be used to customize connectors and generate Java Beans that are deployed into the WebSphere Application Server or any other application server that conforms to the J2C Connector Architecture. The IMS Connector support conforms to the Java 2 Platform, Enterprise Edition, Connector Architecture Specification V1.0. This specification is similar to IBM's proprietary Common Connector Framework (CCF), which was delivered in VisualAge for Java, Version 2.0 along with the IMS Connector for Java for deployment in WebSphere Application Servers. The IMS Connector for Java J2C Runtime support, is available in this release of IMS Connect. To download the J2EE Connector Architecture Final Specification and the J2EE Platform V1.3 Specification by JavaSoft, visit:

Subscription and Support for z/OS Products

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

Subscription and support for these products is available separately 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. Customers are not entitled for new products.

To take full advantage of Subscription and Support, it must be ordered at the aggregated quantity of the product license.

License Agreement for z/OS Products

These products are licensed under the IPLA, and the associated Agreement for Acquisition of Support, and the Addendum for Support 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) and access to updates, releases, and versions of the program as long as support is in effect. S/390® SupportLine is an option for those customers who desire added services.

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.

Trademarks

 
iSeries is a trademark of International Business Machines Corporation.
 
IMS, z/OS, DataPropagator, MVS, and WebSphere are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2 Universal Database, DB2, OS/390, RACF, MQSeries, AS/400, AIX, DRDA, VisualAge, and S/390 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.

Offering Information

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

Publications

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

                                                  Order
Title                                             Number
 
DB2(R) Administration Tool for z/OS(TM),          GC27-1467
 Version 3.1 (5655-E64) License
 Information
DB2 Automation Tool for z/OS,                     GC27-1190
 Version 1.2 (5697-G63) License
 Information
DB2 Buffer Pool Analyzer for z/OS                 GC27-1463
 (5655-E54) License Information
DB2 Data Export Facility for z/OS                 GC27-1465
 (5655-E46) License Information
DB2 High Performance Unload for z/OS,             GC27-0964
 Version 1.2 (5655-E69)  License
 Information
DB2 Log Analysis Tool for z/OS,                   GC27-0966
 Version 1.2 (5655-E66) License
 Information
DB2 Object Restore for z/OS, Version 1.2          GC27-0972
 (5655-E72) License Information
DB2 SQL Performance Analyzer for z/OS,            GC27-1001
 Version 1.2 (5697-F57) License
 Information
DB2 Table Editor for iSeries,                     GC27-1469
 Version 4.2 (5697-G84) License
 Information
DB2 Table Editor for z/OS, Version 4.2            GC27-1200
 (5697-G65) License Information
DB2 Web Query Tool for iSeries,                   GC27-1470
 Version 1.2 (5697-G85) License
 Information
DB2 Web Query Tool for z/OS, Version 1.2          GC27-0970
 (5655-E71) License Information
IMS(TM) Connect for z/OS, Version 1.2             GC27-0947
 (5655-E51) License Information
IMS DataPropagator(TM) for z/OS, Version 3.1      GC27-1201
 (5655-E52) License Information
IMS Extended Terminal Option Support for          GC27-0909
 z/OS, Version 2.2 (5655-E12) License
 Information
IMS Fast Path Basic Tools for z/OS,               GC27-0933
 Version 1.2 (5655-E30) License
 Information
IMS High Performance Change Accumulation          GC27-1175
 Utility for z/OS (5655-F59) License
 Information
 
                                                  Order
Title                                             Number
 
MS Network Compression Facility for z/OS          GC27-1280
 (5655-E41) License Information
IMS Parallel Reorganization for z/OS,             GC27-1179
 Version 2.1 (5655-F74) 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,                 SC27-1468
 Version 3.1 (5655-E64) User's Guide
DB2 Automation Tool for z/OS,                     SC27-1189
 Version 1.2 (5697-G63) User's Guide
DB2 Buffer Pool Analyzer for z/OS                 SC27-1464
 (5655-E54) User's Guide
DB2 Data Export Facility for z/OS                 SC27-1466
 (5655-E46) User's Guide
DB2 High Performance Unload for z/OS,             SC27-0965
 Version 1.2 (5655-E69) User's Guide
DB2 Log Analysis Tool for z/OS,                   SC27-0967
Version 1.2 (5655-E66) User's Guide
DB2 Object Restore for z/OS,                      SC27-0973
 Version 1.2 (5655-E72) User's Guide
DB2 SQL Performance Analyzer for z/OS,            SC27-1002
 Version 1.2 (5697/F57) User's Guide
Install Guide                                     SC27-1003
DB2 Table Editor for iSeries,                     SC27-1471
 Version 4.2 (5697-G84) User's Guide
DB2 Table Editor for z/OS, Version 4.2            SC27-1199
 (5697-G65) User's Guide
DB2 Web Query Tool for iSeries,                   SC27-0971
 Version 1.2 (5697-G85) User's Guide
DB2 Web Query Tool for z/OS, Version 1.2          SC27-0971
 (5655-E71) User's Guide
IMS Connect for z/OS, Version 1.2                 SC27-0946
 (5655-E51) User's Guide
IMS DataPropagator for z/OS, Version 3.1
 (5655-E52)
  Diagnosis                                       GC27-1209
  Reference                                       SC27-1210
  An Introduction                                 GC27-1211
  Installation Guide                              GC27-1212
  Messages and Codes                              GC27-1213
 
                                                  Order
Title                                             Number
 
  Customization Guide                             SC27-1214
  Administrators Guide for Synchronous            SC27-1215
   Propagation
  Administrators Guide for Asynchronous           SC27-1216
   Propagation
  Administrators Guide for Asynchronous           SC27-1217
   MQSeries(R) Propagation
Concepts                                          SC27-1544
IMS Extended Terminal Option Support for          SC27-1004
 z/OS, Version 2.2 (5655-E12) User's
 Guide
IMS Fast Path Basic Tools for z/OS,               SC27-0932
 Version 1.2 (5655-E30) User's Guide
IMS High Performance Change Accumulation          SC27-1176
 Utility for z/OS (5655-F59)  User's
 Guide
IMS Network Compression Facility for              SC27-1281
 z/OS (5655-E41)  User's Guide
IMS Parallel Reorganization for z/OS,             SC27-1180
 Version 2.1 (5655-F74) 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

  • IBM DB2 Administration Tool (GC27-1045)
  • IBM DB2 Buffer Pool Analyzer (GC27-1082)
  • IBM DB2 Data Export Facility (GC27-1083)
  • IBM DB2 Table Editor (GC27-1053)
  • IBM DB2 Web Query (GC27-1044)
  • IBM IMS DataPropagator (GC27-1080)
  • IBM IMS High Performance Change Accumulation (GC27-1079)
  • IBM IMS Network Compression Facility (GC27-1078)
  • IBM IMS Parallel Reorganization (GC27-1360)

Technical Information

Hardware Requirements

The programs in this announcement operate on any hardware configuration that supports the required versions of DB2 and/or IMS.

Software Requirements

  • The DB2 programs in this announcement that operate on
    • z/OS require DB2 Version 5, or later
    • IBM e(logo)server iSeries require DB2 for iSeries Version 4, or later
  • The IMS products in this announcement require IMS Version 6, or later

DB2 Web Query

  • For z/OS is supported for hosting on WebSphere™ for z/OS, Version 1.2, or later
  • For iSeries is supported for hosting on WebSphere iSeries WAS Version 2.0, or later
  • Host servers require support for:
    • JDK Version 1, or later
    • JDBC Version 1, or later
    • JSDK Version 2, or later
  • Client interfaces and devices must support:
    • HTTP (Web browser) interface, Level 4 browser capable of Java™
    • WAP device interface, Version 3.0, or later
    • POP/SMTP interface, standard POP/SMTP e-mail protocols

IMS Connect for z/OS, Version 1.2 requires the IMS V6, or V7 Transaction Manager feature. Much of the function of IMS Connect can be used with terminals, applications and data running under IMS V6. However, Asynchronous Output, Local, Unicode, and Connector for Java J2EE Runtime support requires IMS V7 TM.

IMS Parallel Reorganization for z/OS, Version 2 requires three products. Each of the products requires enabling PTFs. Refer to the products' User's Guides and PSP Buckets for PTF numbers and current service.

  • IMS High Performance Unload for OS/390 Release 1 (5655-E06)
  • IMS High Performance Load for OS/390 Release 1 (5655-E07)
  • IMS Index Builder for OS/390 Version 2 Release 1 (5655-E24) is required only if INDEXBLD=YES is specified for IMS Parallel Reorganization driver

Planning Information

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

  • For z/OS
    • Basic machine-readable material is on a 3480 tape cartridge except for DB2 Web Query Tool:
      • DB2 Web Query Tool machine-readable material is on CD-ROM
      • In addition, IMS Connect and DB2 Table Editor are shipped with workstation code on CD-ROM
    • Program Directory
    • Proof of Entitlement (PoE)
    • IPLA
    • License Information
  • For iSeries
    • Workstation code on CD-ROM
    • PoE
    • 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. The charge unit is:

  • Processor group for the iSeries products. The charge unit is an OTC based on server processor group.
  • Value units for the z/OS products.

                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 1000 MSUs the applicable value units would be: 3 * 1.00 + 42 * 0.45 + 130 * 0.36 + 140 * 0.27 + 685 * 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 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

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 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. You must use this tool to calculate the number of value units, based upon the number of MSU (processor capacity). CFSW expects value units as configuration input.

Ordering Information for z/OS Products: When you use the HONE configurator aid, orders will be configured at the current release level. At availability, orders will be configured at the new release level.

Orders for new licenses can be placed now.

Shipment will not occur before availability date.

Unless a later date is specified, orders entered before the planned availability date will be assigned a schedule date of one week following availability.

Shipment will begin on the planned availability date.

  • Orders that ship before the planned availability will receive the then current release of the program if one is available.
  • Orders that ship after the planned availability date will receive the version and release of the program in this announcement.

The ordering information for the following programs is unaffected by this announcement.

                                                  Program
Description                                       Number
 
DB2 Automation Tool for z/OS 1.2                  5697-G63
 Subscription and Support                         5655-E38
DB2 High Performance Unload for z/OS 1.2          5655-E69
 Subscription and Support                         5655-E89
DB2 Log Analysis Tool for z/OS 1.2                5655-E66
 Subscription and Support                         5655-E86
DB2 Object Restore for z/OS 1.2                   5655-E72
 Subscription and Support                         5655-E92
DB2 SQL Performance Analyzer for z/OS 1.2         5697-F57
 Subscription and Support                         5655-E97
DB2 Table Editor  for z/OS 4.2                    5697-G65
 Subscription and Support                         5655-E84
DB2 Web Query Tool for z/OS 1.2                   5655-E71
 Subscription and Support                         5655-E91
IMS Connect for z/OS 1.2                          5655-E51
 Subscription and Support                         5655-E34
IMS Extended Terminal Option Support              5655-E12
 for z/OS 2.2
 Subscription and Support                         5655-E13
IMS Fast Path Basic Tools for z/OS 1.2            5655-E30
 Subscription and Support                         5655-E36
Subscription and Support for DB2                  5655-E90
 Administration Tool for z/OS 3.1

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

New Customers: Specify the appropriate OTC feature numbers with the desired quantity represented by the sum of value units of all the machines on which the program is running.

The CFSW configurator stand-alone path for all z/OS products in this announcement supports price proposals. Note that 5655-E71 is available only as a stand-alone offering. All other z/OS products will be available via CBPDO.

For all z/OS products in this announcement, except 5655-E71, media is shipped only via Customized Offerings (ServerPac, Systempac® and CBPDO).

CFSW configuration and order entry capability will commence with CBPDO on:

  • September 18, 2001, for 5655-E41
  • October 2, 2001, for 5655-E52
  • October 30, 2001, for:
    • 5655-E69
    • 5697-G65
    • 5655-E30
    • 5655-E51
    • 5655-F74
  • December 4, 2001, for:
    • 5655-E64
    • 5655-E54
    • 5655-E46
    • 5655-F59
    • 5697-G63
    • 5655-E66
    • 5655-E72
    • 5697-F57
    • 5655-E12

For CBPDO orders, shipments will begin one week after general availability.

Existing Customers: When adding additional capacity to a previous order, value units would be determined as an extension of the aggregate MSUs.

                                                  OTC
                              Program             Feature
Description                   Number              Number
 
DB2 Administration Tool       5655-E64
 for z/OS Version 3.1
  One value unit                                  0001
  250 value units                                 0002
DB2 Buffer Pool Analyzer      5655-E54
 for z/OS
  One value unit                                  0001
  250 value units                                 0002
DB2 Data Export Facility      5655-E46
 for z/OS
  One value unit                                  0001
  250 value units                                 0002
IMS DataPropagator for        5655-E52
 z/OS Version 3.1
  One value unit                                  0012
  250 value units                                 0013
IMS High Performance          5655-F59
 Change Accumulation
 Utility for z/OS
  One value unit                                  0013
  250 value units                                 0014
IMS Network Compression       5655-E41
 Facility for z/OS
  One value unit                                  0007
  250 value units                                 0008
IMS Parallel                  5655-F74
 Reorganization for
 z/OS 2.1
  One value unit                                  0001
  250 value units                                 0002

Example 1

For IMS Parallel Reorganization, machines with 200 MSUs require 76 value units and would order feature number 0001, quantity 76.

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| 25 |x|     .27       |=|     6.75  |
|Tier D|  0 |x|     .20       |=|      .00  |
|------+----+-+---------------+-+-----------|
|Total  200                          76     |
'-------------------------------------------'

Example 2

For IMS Parallel Reorganization, machines with 1100 MSUs require 264 value units and would order feature number 0001, quantity 14 and feature number 0002, quantity 1.

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| 785 |x|     .20       |=|   157.00  |
|------+-----+-+---------------+-+-----------|
|Total  1100                         264     |
'--------------------------------------------'

When adding additional capacity to a previous order, value units would be determined as an extension of the aggregate MSUs.

Example 3

For IMS Parallel Reorganization, adding 200 MSUs to a prior order would require 40 value units and would order feature number 0001, quantity 40.

Translation from MSUs to Value Units

.------+----+-+---------------+-+-----------.
|      |MSUs|x|Value Units/MSU|=|Value Units|
|Base  |  0 |x|    1.00       |=|      .00  |
|Tier A|  0 |x|     .45       |=|      .00  |
|Tier B|  0 |x|     .36       |=|      .00  |
|Tier C|  0 |x|     .27       |=|      .00  |
|Tier D|200 |x|     .20       |=|    40.00  |
|------+----+-+---------------+-+-----------|
|Total  200                          40     |
'-------------------------------------------'

This additional capacity of 200 MSUs costs 40 value units as opposed to Example 1 where the initial 200 MSUs would cost 103 value units.

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

To order, specify the support program number and feature number 9001 for asset registration. Specify the annual support charge feature numbers with the desired quantity represented by the sum of value units corresponding to the Service Units in Millions (MSUs) ratings of the designated machines. Subscription and Support must cover the same capacity as the product license entitlement.

Specify the medium feature number.

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

                                                  ASC(1)
                                   Program        Feature
Description                        Number         Number
 
Subscription and Support           5655-E55
 for DB2 Buffer Pool
 Analyzer for z/OS
  One Value Unit                                  0001
  250 Value Units                                 0002
  Line deleted
Subscription and Support           5655-E47
 for DB2 Data Export
 Facility for z/OS
  One Value Unit                                  0001
  250 Value Units                                 0002
Subscription and Support           5655-E53
 for IMS DataPropagator
 for z/OS
  One Value Unit                                  0007
  250 Value Units                                 0008
Subscription and Support           5655-F58
 for IMS High Performance
 Change Accumulation
 Utility for z/OS
  One Value Unit                                  0007
  250 Value Units                                 0008
Subscription and Support           5655-E42
 for IMS Network
 Compression Facility for
 z/OS
  One Value Unit                                  0001
  250 Value Units                                 0002
Subscription and Support           5655-F73
 for IMS Parallel
 Reorganization for z/OS
  One Value Unit                                  0001
  250 Value Units                                 0002
1
Annual Support Charge

Basic Machine-Readable Material for z/OS Products: The environments for the following products in this announcement are OS/390 and z/OS. The distribution feature numbers are listed in the following table.

                         Program        Feature      Distribution
Product                  Number         Number       Medium
 
DB2 Administration       5655-E64       5802         3480 tape
 Tool for z/OS,                                       cartridge
 Version 3.1
DB2 Buffer Pool          5655-E54       5802         3480 tape
 Analyzer for z/OS                                    cartridge
DB2 Data Export          5655-E46       5802         3480 tape
 Facility for z/OS                                    cartridge
Subscription and         5655-E55       6514         Hardcopy
 Support for DB2                                      publication
 Buffer Pool
 Analyzer for z/OS
Subscription and         5655-E47       6509         Hardcopy
 Support for DB2                                      publication
 Data Export
 Facility for z/OS
IMS DataPropagator       5655-E52       5802         3480 tape
 for z/OS                                             cartridge
 Version 3.1
Subscription and         5655-E53       6477         Hardcopy
 Support for IMS                                      publication
 DataPropagator for
 z/OS
 
                         Program        Feature      Distribution
Product                  Number         Number       Medium
 
IMS High                 5655-F59       5802         3480 tape
 Performance Change                                   cartridge
 Accumulation for
 z/OS
Subscription and         5655-F58       6431         Hardcopy
 Support for IMS                                      publication
 High Performance
 Change Accumulation
 for z/OS
IMS Network              5655-E41       5802         3480 tape
 Compression                                          cartridge
 Facility for z/OS
Subscription and         5655-E42       6498         Hardcopy
 Support for IMS                                      publication
 Network Compression
 Facility for z/OS
IMS Parallel             5655-F74       5802         3480 tape
 Reorganization for                                   cartridge
 z/OS, Version 2.1
Subscription and         5655-F73       6503         Hardcopy
 Support for IMS                                      publication
 Parallel
 Reorganization for
 z/OS

Ordering Information for iSeries Products

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

                                       Processor
                                       Based
                                       OTC
                           Program     Feature      Group
Description                Number      Number       Number
 
Medium Feature Number 5809 CD-ROM
 
DB2 Table Editor for       5697-G84
 iSeries Program                       0001         P05
 Package                               0002         P10
                                       0003         P20
                                       0004         P30
                                       0005         P40
                                       0006         P50
 
                                       Processor
                                       Based
                                       OTC
                           Program     Feature      Group
Description                Number      Number       Number
 
Processor Group
 Migration
 P5  to P10                            0007
 P5  to P20                            0008
 P5  to P30                            0009
 P5  to P40                            0010
 P5  to P50                            0011
 P10 to P20                            0012
 P10 to P30                            0013
 P10 to P40                            0014
 P10 to P50                            0015
 P20 to P30                            0016
 P20 to P40                            0017
 P20 to P50                            0018
 P30 to P40                            0019
 P30 to P50                            0020
 P40 to P50                            0021
 
DB2 Web Query for          5697-G85
 iSeries Program                       0001         P05
 Package                               0002         P10
                                       0003         P20
                                       0004         P30
                                       0005         P40
                                       0006         P50
Processor Group Migration
 P5  to P10                            0007
 P5  to P20                            0008
 P5  to P30                            0009
 P5  to P40                            0010
 P5  to P50                            0011
 P10 to P20                            0012
 P10 to P30                            0013
 P10 to P40                            0014
 P10 to P50                            0015
 P20 to P30                            0016
 P20 to P40                            0017
 P20 to P50                            0018
 P30 to P40                            0019
 P30 to P50                            0020
 P40 to P50                            0021

Basic Machine-Readable Material for iSeries Products: The environment for the following products in this announcement is OS/400®. The Distribution feature numbers are listed in the following table.

                                                  Part
Description                                       Number
 
Feature Number 5809 CD-ROM
 
DB2 Table Editor for iSeries Version 4.2          5697-G84
DB2 Web Query Tool for iSeries                    5697-G85
 Version 1.2

Basic License: To order, specify the program number, feature number 9001 for asset registration, and the OTC feature number. Also specify the feature number of the desired distribution medium.

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

Example: If the customer desires expedited shipment, then specify feature number 3446.

                                                    Feature
Description                                         Number
 
Initial Shipments
 
Ship media only (suppresses initial                 3470
 shipment of documentation)
 
Ship documentation only (suppresses                 3471
 initial shipment of media)
 
Expedite Shipments
 
Local IBM office expedite                           3445
 (for IBM use only)
 
Customer expedite process charge                    3446
 ($30 charge for each product)

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

Customized Offerings

Product media is shipped only via Customized Offerings (that is, CBPDO, ServerPac, SystemPac). Non-customized items (CDs, diskettes, source media, media kits) will continue to be shipped via the stand-alone product.

Terms and Conditions

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

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.

Limited Warranty Applies: Yes

Program Services: Available until November 30, 2004

Money-Back Guarantee: Thirty-day, money-back guarantee. The money-back guarantee commences on the Shipment Date stated on the invoice. In the event the Ship Date is not stated, 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

Passport Advantage Subscription Applies: No

IBM Operational Support Services — Support Line: Yes

AIX®/UNIX® Upgrade Protection Applies: No

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

AS/400® Software Subscription Applies: Yes

Variable Charges Apply: No

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

Prices

Contact your IBM representative for charges information for this announcement.

Order Now

 Use Priority/Reference Code: LE001
 
 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@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 is a trademark of International Business Machines Corporation.
 
z/OS, e-business logo, IMS, DataPropagator, WebSphere, and System/370 are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, BookManager, OS/390, MQSeries, S/390, System/390, Systempac, OS/400, AIX, and AS/400 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.
 
UNIX is a registered trademark 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.