IBM United States
Software Announcement 201-056
March 6, 2001

IBM Database Tools: Your Best Choice for Continuous Improvement with More Power and More Function

 ENUS201-056.PDF (69KB)

(Corrected on March 16, 2001)

In the Planning Information and Ordering Information sections, the media for machine-readable material was amended.

(Corrected on March 7, 2001)

In the Overview, the announcement number 201-050 was corrected.

At a Glance

New, improved, and repositioned IBM database tools 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 being announced in each of the following IBM database tool categories:

  • Administration
  • Recovery and Replication
  • Performance Management
  • 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 and functions which further complement IBM's premier DB2® Universal Database (UDB) for OS/390® and IMS™ database engines. With committed focus, IBM seeks to be your preferred supplier of tools by providing affordable, high-performance, and functionally rich products.

New, repositioned, and improved products

Following the direction established by the announcements made in September 2000, IBM is offering new and repositioned competitive products, function-rich new versions, significant new function available via the service stream for existing tools, and improved integration for tools presentation and data exchange between the tools.

This announcement includes:

  • Five new products, four DB2 and one IMS
  • Three new versions of products, one DB2 and two IMS
  • Service stream enhancements to seven products, four DB2 and three IMS

For a complete list of these products, refer to the Description section.

In a separate announcement, IBM DB2 Universal Database® Server for z/OS, Version 7 Utilities is being introduced. Refer to Software Announcement 201-050 , dated March 6, 2001, for details on the three subsets available:

  • DB2 Operational Utilities
  • DB2 Diagnostic Recovery Utilities
  • DB2 Utilities Suite

In September 2000, 34 new or enhanced products were announced in the following functional areas:

  • Database administration tools to help you maximize the availability of your systems, refer to Software Announcement 200-302 , dated September 12, 2000.
  • Performance management tools to help you keep your operating environment running at peak performance, refer to Software Announcement 200-298 , dated September 12, 2000.
  • Recovery and replication management tools to help with additional requirements, such as archiving data, point in time recovery, online recovery, and added image copy capabilities, refer to Software Announcement 200-299 , dated September 12, 2000.
  • Application management tools to help you effectively create and operate your application subsystem, refer to Software Announcement 200-300 , dated September 12, 2000.

In December 2000, the following IMS tools were added to the database administration area. For details refer to Software Announcement 200-451 , dated December 19, 2000.

  • IMS High Performance Sysgen Tools for z/OS
  • IMS Command Control Facility for z/OS
  • IMS Message Format Services Reversal Utilities for z/OS

Key Prerequisites

The products in this announcement will operate on any hardware and software configuration that supports the required version of DB2 or IMS.

Planned Availability Date

Refer to the Description section for planned availability dates for each new product, version, or PTF.

Description

Summary

To further enhance the productivity of your DB2 and IMS database systems, new products, versions and PTFs are being made available in the following categories.

  • IBM Tools for Database Administration

    For more information on products recently made available in this category refer to Software Announcement 200-307 , dated September 12, 2000, and Software Announcement 200-451 , dated December 19, 2000. The current announcement adds the following:

    • DB2 Administration Tool for OS/390, Version 2.1 5655-E70 PTFs
      • Refer to APAR numbers PQ44056, PQ42882, and PQ41660
        Availability Date: March 6, 2001
      • Refer to APAR number PQ45029
        Availability Date: June 29, 2001
    • DB2 Archive Log Compression Tool for z/OS 5655-F54
      Subscription and Support 5655-E73
      Availability Date: May 18, 2001
    • DB2 Automation Tool for z/OS 5697-G63
      Subscription and Support 5655-E38
      Availability Date: March 30, 2001
    • DB2 Log Analysis Tool for OS/390 5655-E66 PTFs
      Refer to APAR numbers PQ44222 and PQ44831
      Availability Date: March 6, 2001
    • DB2 Object Comparison Tool for z/OS 5697-G64
      Subscription and Support 5655-E40
      Availability Date: April 27, 2001
    • DB2 Table Editor for z/OS, Version 4.1 5697-G65
      Subscription and Support 5655-E84
      Availability Date: May 18, 2001
    • IMS Database Control Suite for z/OS, Version 2.1 5655-F76
      Subscription and Support 5655-F75
      Availability Date: June 29, 2001
    • IMS Database Repair Facility for OS/390 5655-E03 PTF
      Refer to APAR number PQ44923
      Availability Date: May 11, 2001
    • IMS Fast Path Online Tools for z/OS, Version 2.1 5655-F78
      Subscription and Support 5655-E25
      Availability Date: July 27, 2001
    • IMS High Performance Pointer Checker for OS/390 5655-E09 PTF
      Refer to APAR number PQ44834
      Availability Date: June 29, 2001
  • IBM Tools for Database Recovery and Replication Management

    For more information on products recently made available in this category refer to Software Announcement 200-299 , dated September 12, 2000. The current announcement adds the following:

    • DB2 Change Accumulation Tool for z/OS 5655-F55
      Subscription and Support 5655-E48
      Availability Date: May 18, 2001
    • IMS Image Copy Extensions for OS/390 5655-E10 PTF
      Refer to APAR number PQ44862
      Availability Date: June 29, 2001
    • IMS Online Recovery Service for z/OS 5655-E50
      Subscription and Support 5655-E33
      Availability Date: April 27, 2001
  • IBM Database Tools for Performance Management

    For more information on products recently made available in this category refer to Software Announcement 200-298 , dated September 12, 2000. The current announcement adds the following:

    • DB2 SQL Performance Analyzer for OS/390 5697-F57 PTFs
      • Refer to APAR number PQ44835
        Availability Date: March 30, 2001
      • Refer to APAR number PQ44838
        Availability Date: May 18, 2001
  • IBM Database Tools for Application Management

    For more information on products recently made available in this category refer to Software Announcement 200-300 , dated September 12, 2000. The current announcement adds the following:

    • DB2 Bind Manager for OS/390 5655-D38 PTF
      Refer to APAR number PQ44863
      Availability Date: May 18, 2001

IBM Tools for Database Administration

DB2 Administration Tool for OS/390, Version 2.1 PTFs provide the following enhancements to the product.

  • PQ44056 enhances the restart capabilities of Alter and Migrate by combining jobs into step restartable jobs. Partitioned tables can now be altered.
  • PQ42882 provides a new space manager function in DB2 Administration Tool which merges VSAM dataset information with DB2 catalog information. This allows you to move page sets to other storage groups or VSAM catalogs. A resize function enables resizing of pagesets that are in many extents or over-allocated. The space manager function also provides a table space and index space estimator that calculates the space required for the object based on the number of rows and the length.
  • PQ41660 gives you the ability to save DB2 Administration Tool parameters. These saved parameters then can be restored the next time DB2 Administration Tool is invoked. This also includes the last value of CURRENT SQLID.
  • PQ45029 provides the foundation to integrate IBM DB2 tools and DB2 Administration Tool in the z/OS environment. This support provides you with the option to customize DB2 Administration Tool to launch installed IBM DB2 tools that have an ISPF interface.

DB2 Log Archive Compression Tool for z/OS makes highly compressed off-site copies of DB2 logs allowing administrators to reduce the volume of archived logs resulting in:

  • Shorter I/O and recovery times
  • Lower storage costs
  • Making storage of DB2 logs on DASD affordable in many cases instead of tape

Archive Log Compression uses high performance compression technology designed especially for DB2 logs to maximize the:

  • Reduction of your offload/retrieval time
  • Value of your storage media

Administrators may elect to keep SQL UNDO entries in the log to be compressed and achieve very high compression rates. Or they may choose to have DB2 Archive Log Compression remove SQL UNDO (which is not needed for disaster recovery) in order to obtain even higher rates of compression.

DB2 Automation Tool for z/OS helps you realize the full potential of your DB2 system by continuously and automatically coordinating the execution of specific DB2 utilities on an around-the-clock basis. The primary capabilities provided are:

  • Automatic execution of the following DB2 utilities against specified objects
    • Image Copy
    • REORG
    • RUNSTATS
  • Manual, periodic, or rules-based execution with a combination of parameters and options
  • Development of job and profiles through intuitive ISPF panels and special syntax without needing JCL skills.
  • Support that allows multiple database administrators to securely maintain their own sets of profiles

Now, without relying on repeated manual interventions, every DB2 administrator is able to add maximum value to the enterprise by extracting full performance constantly from even the most heavily-used database environment.

DB2 Log Analysis Tool for OS/390 PTFs add the following ease-of-use and reporting enhancements to this tool's existing capabilities for tracking and selectively reversing changes to DB2 data:

  • Support for data sharing by automatically and transparently reading through multiple member logs to obtain log information. By specifying a group name as the SSID, all members' logs will be read when DB2 Log Analysis Tool is run.
  • Easier access to summarized analysis, through generation of a separate Summary Report when you select Option #1, "Generate Database Activity Report (General)," from the DB2 Log Analysis Tool main menu. (Previously, this summary information was appended to the General Report.) The Summary Report summarizes and totals the number of updates, inserts, and deletes for a table and its associated tablespace and database.
  • Additional activity reporting in the ACTION field. Now, the ACTION field on the DB2 Log Analysis General Report identifies activity resulting from the execution of the LOAD or REORG DB2 utilities. The ACTION field can contain the following values:
    • U = Update
    • D = Delete
    • I = Insert
    • X = Load or Reorg Found
  • An option to include/exclude DB2 catalog data in reports, through a CATALOG DATA filter that has been added to the Generate Database Activity Report (General) selection screen.
  • Display of the log record timestamp in the Detail Report, as a hexadecimal value in the new LRSN column. This field represents the actual time of the log record creation, and is used mostly in data sharing environments to synchronize log records across members of a data sharing group.
  • Additional filtering options allowing for generated reports and SQL to be further refined by column data values.

DB2 Object Comparison Tool for z/OS 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. 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.

Masking and ignore files are supported to account for intentional differences and/or naming conventions that exist between the two sets of objects to be compared. For example, primary/secondary quantities usually are different between a test and production system. Likewise, the same object might have an owner name of TESTxxx on the test system and an owner name of PRODxxx on the production system. Use of the mask and or ignore files allow you to compare only on real differences that might exist.

"Version files" are used for comparison. A version file is created from either a file of DDL or from objects in a DB2 catalog. The "known-to-be-correct" source version file is compared to a target version file that may be back level. Using version files as a base you may compare DDL, catalog object definitions, and/or other version files in any pair-wise combination desired.

The ability to do comparisons with previously generated version files gives you the opportunity to:

  • Restore application objects to a previous version (backout)
  • Compare a new version with several production versions (clones) of the objects

DB2 Object Comparison runs as an extension to DB2 Administration Tool for OS/390, Version 2.1 and consists of:

  • An ISPF frontend for specification of the objects to be compared
  • A DB2 catalog extract function that pulls definitions from the catalog into a version file to support the compare process
  • A DDL extract function that reads DDL statements and converts them into a version file
  • A batch compare function that compares two version files, produces a report that describes the differences found and generates the information needed to apply changes to the target
  • A batch job generator that provides everything necessary to apply the changes to the target

DB2 Table Editor for z/OS, Version 4.1 provides the widest choice and most robust features available in the industry for the entire range of enterprise table editing needs. DB2 Forms has been renamed DB2 Table Editor to better describe the major functions that it provides. As a result, this new version is DB2 Table Editor for z/OS, Version 4.1 rather than DB2 Forms for z/OS, Version 4.1. The major facilities provided are:

  • Robust table editing across multiple end-user environments, including ISPF, JAVA (including from within a web browser), and 32-bit Windows™
  • Table editing in full-screen (multi-row)
  • Filter records easily and build custom views of data
  • "Save at End" feature, which allows you to perform multiple edit actions (inserts, updates, deletes) before sending results to DB2
  • Edit Tables in ISPF directly from DB2 Administration Tool

DB2 Table Editor for z/OS now allows you to edit tables directly from the DB2 Control Center using:

  • Edit Full Screen
  • Edit Row at a Time
  • Edit Wizard

Windows and Java™ Users also have the following facilities:

  • Row-at-a-time (single row), or wizard mode
  • Ability to update primary keys
  • "Edit Related" feature allows you to automatically jump to related tables based on current parent or child column value
  • Save views instantly for repeat editing; share centrally with others
  • Create advanced table editing forms that contain data validation rules, synchronized referential scrolling, colors, fonts, and more, which can be distributed to Windows and web users alike

IMS Database Control Suite for z/OS, Version 2.1 is a day-to-day IMS database environment management tool for Database Administrators, System Programmers, and Application Support Specialists. It allows these users to collect and build the data required to generate JCL for database backup/recovery/reorganization management using standard IMS utilities and IBM high performance IMS tools products.

IMS Database Control Suite has been remodeled to:

  • Simplify the user interface
  • Improve operations by reducing and consolidating the:
    • Number of datasets
    • ISPF Panels
    • Process steps
  • Exclusively support IMS Base Utilities and IBM High Performance Tools
  • Provide more flexibility for local standards

The product supports:

  • Database backup, recovery, reorganization, and monitoring for the following databases:
    • Full Function (including indexes)
    • Fast Path
    • High Availability (HALDB) only in IMS V7
  • The following IMS Base Utilities:
    • HD Unload
    • HD Load
    • Prefix Resolution
    • Change Accumulation
    • Image Copy
    • Image Copy 2
    • Online Image Copy
    • Image Copy Recovery
    • Full Recovery
  • The following High Performance Tools and Utilities:
    • HP Unload
    • HP Load
    • HP Pointer Checker (Space Management Utilities)
    • HP Prefix Resolution
    • Index Builder V2
    • DB Repair Facility
    • Library Management Utilities
  • Consolidated product datasets for improved:
    • Installation
    • Storage utilization
    • Management of resources
  • Consolidated product panels and additional automatic accumulation of data to improve and simplify operations
  • Accommodation of "shop specific" JCL standards and naming conventions
  • Monitoring function with more thresholds
  • Backup of Control Suite datasets
  • Improved help panels
  • Shared Recons
  • Better recovery processing to handle Change Accum
  • Revised VSAM Zapper panels to attach and use the IMS Database Repair Facility 5655-E03. VSAM Zapper code is obsolete. It is no longer included in the product.
  • A revised Library Management Utilities function to attach and use IMS Library Management Utilities 5655-E04. Library Management Utilities code is no longer included in this product.

IMS Database Repair Facility for OS/390 PTF extends support to IMS Fast Path Databases.

IMS Database Repair Facility is a powerful tool that interactively repairs VSAM- and OSAM-organized IMS databases containing pointer or data errors. The product's interactive capabilities let you make the repair quickly, which means that the affected database needs to be taken off-line only for a brief period. IMS Database Repair Facility features both VSAM and OSAM pointer repair, pointer navigation, and a backout safety feature. Driven by an ISPF front-end, this tool is a powerful addition to any System Programmer or DBA workbench.

IMS Fast Path Online Tools for z/OS, Version 2.1 are the perfect extension to the IMS Fast Path Basic Tools. This product includes:

  • DEDB Online Pointer Checker
  • DEDB Online Data Extract

The DEDB Online Pointer Checker functions as an online interface to the IMS Fast Path Tools DEDB Pointer Checker and DEDB Tuning Aid. It accesses the DEDB area dataset online using Fast Path utility services. The output of this utility is a set of sequential files which are input into DEDB Pointer Checker/Tuning Aid. Online Pointer Checker provides the following:

  • Summary report of pointer errors found
  • Option to produce a snap listing of CIs found to be in error
  • Option to take an Image Copy during execution, which will be similar to the IMS Concurrent Image copy
  • DBRC notification of the image copy
  • Dual Image Copy output datasets

DEDB Online Data Extract provides IMS DEDB users with an easy-to-use, flexible tool to extract data from a DEDB area while the area is online. The product functions in read-only mode, and uses locking protocols to ensure a consistent view of the data.

The specification of which segments to extract allows comparisons of data offset into a segment against supplied values. More than one comparison per segment type is supported and the ability to write a subset of the matching segment's data to the output file is supported.

DEDB Online Data Extract uses standard IMS data access techniques ensuring it will function correctly with all DEDB facilities, including data sharing, MADS, VSO, Shared VSO, EQE, and IMS V7 EEQE support. DEDB Online Data Extract also can write output data in a format compatible with the IMS Fast Path Basic Tools Reload utility.

This powerful utility can be used:

  • To satisfy data reporting requirements
  • To extract data to populate test databases
  • As an alternative to writing a customized BMP application program

IMS Fast Path Online Tools Version 2 provides a new utility called Fast Path Online Area Extender. This new utility allows you to dynamically expand the size of a DEDB area online via expanding the SDEP portion OR the IOVF portion (if sdeps are NOT defined) of the DEDB area. This allows 24x7 availability of an IMS Fast Path DEDB area.

IMS High Performance Pointer Checker for OS/390 PTF gives you the ability to set the following new thresholds:

  • Available extents
  • Control area (CA) splits
  • Control interval (CI) splits
  • Dataset last extent
  • Used space as a percentage of allocated space
  • The number of days since last reorganization run
  • Database last extent

The space monitor utility indicates over-threshold values on the Pointer Checker reports. This is very useful information to database administrators. Messages are issued when any thresholds values are exceeded.

IBM Tools for Database Recovery and Replication Management

DB2 Change Accumulation Tool for z/OS provides DB2 administrators with a powerful tool for backing up database objects in the most precise and least disruptive manner possible by:

  • Making precise "point-in-time" recovery of database objects simple and reliable
  • Allowing recovery routines to focus on single objects and previous states
  • Producing SHRLEVEL REFERENCE image copies without the associated overhead and data locking
  • Controlling the scope and specificity of image copy creation precisely via control cards
  • Maintaining data integrity without recovery to RBA
  • Reducing recovery session times significantly in many cases
  • Providing low overhead and minimizing downtimes for high-volume, complex databases with large numbers of tables and dependencies

IMS Image Copy Extensions for OS/390 PTF supports a One Step full function database HASH Check function. Only an ICE image copy step with the HASH check option is needed for the full-function database HASH Check. This means that the DBD analysis program step, Hash Evaluation program step, PSBLIB, DBDEFCTL data set, or PROCCTL data set are no longer required.

One Step full function HASH Check can be invoked from the FABJMAIN program. It cannot be invoked from the IMS compatible JCL. However, full function HASH check JCL can still be used.

In order to submit the One Step full function database HASH Check the following actions are required and restrictions apply.

  • Pointer Checker DD statements are must be added to the FABJMAIN JCL
  • HDPC=Y must be specified in the ICEIN data set
  • The FABJMAIN JCL must provide for image copies of all logically related databases and indexes that are included in the PSB generation

IMS Online Recovery Service for z/OS , in a single pass of the input data, manages the accumulation and merging of recovery related database data for the recovery of:

  • One or more IMS full function databases or
  • Fast path areas

Data sets, including image copy, change accumulation and logs are processed in parallel while multiple database data sets are updated simultaneously.

IMS Online Recovery Service allows you to recover shared IMS databases directly from image copies and log data sets if change accumulation data sets are not available. In fact, IMS Online Recovery Service even uses incomplete change accumulation data sets for recovery if they are the latest copy available.

In addition, a new timestamp recovery function provides recovery to any prior point in time, regardless of database allocation ranges.

IMS commands control IMS Online Recovery Service, and recovery can be initiated through the IMS Automated Operator Interface.

IBM Database Tools for Performance Management

DB2 SQL Performance Analyzer for OS/390 PTFs

  • PQ44835 provides:
    • A new parameter-driven option to show the alternative indexes that are available as possible access path choices, but which are not presently chosen by the Optimizer. This option provides you with all access path possibilities.
    • Easier integration with existing change management systems by supporting:
      • Specialized condition code settings for SQL Performance Analyzer Batch and TSO runs to indicate various levels of warnings and alerts
      • Codes for specific thresholds being exceeded
    • Improved SQL Performance Analyzer report formatting and statement separation for easier following of complex multi-step plans, joins, unions, subqueries and multi-index access steps
    • Improved ISPF panel flow control and ease-of-use enhancements to the SQL Performance Analyzer TSO interface since:
      • Specification of all files is done on the ANLMAIN panel
      • Cancel and exit controls and are improved
  • PQ44838 provides:
    • An interface to the PathCheck function of DB2 Bind Manager for OS/390, allowing selected SQL Statements, identified by PathCheck as exceptions, to be passed to SQL Performance Analyzer for further analysis and advisor recommendations.
    • Multiple DBRM processing, including support for concatenated DBRM library members, allows a significant set of application plans to be evaluated with a single execution of SQL Performance Analyzer in Batch.

IBM Database Tools for Application Management

DB2 Bind Manager for OS/390 PTF provides the following enhancements to the Path Checker function.

  • Statement table cost estimates displayed when available
  • On path change add selected DB2 catalog statistics
  • Show new SQL statement that is explained
  • Easy to understand description of EXPLAIN statements
  • On path change, allow statement level EXPLAIN to be passed to DB2 SQL Performance Analyzer
  • Wild card processing of DBRM library entries

Subscription and Support (S&S)

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

IBM is also providing S&S 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 customers are not entitled for new products.

To take full advantage of S&S, it must be ordered at the aggregated quantity of the product license.

License Agreement

These products are licensed under the IBM Program License Agreement (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) as well as 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.

Value Unit Charges for Data Management Tools

Value Unit Pricing is a new pricing model for Data Management Tools. For a complete description of this new model refer to Software Announcement 201-057 , dated March 6, 2001.

Accessibility by People with Disabilities

For Software Offerings

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

 
z/OS, and IMS are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, OS/390, DB2 Universal Database, and S/390 are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Windows is a 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 will be available on day of announcement 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) Archive Log Compression (5655-F54)              GC27-1188
 License Information
 
DB2 Automation Tool (5697-G63)                         GC27-1190
 License Information
 
DB2 Change Accumulation Tool (5655-F55)                GC27-1196
 License Information
 
DB2 Object Comparison Tool (5697-G64)                  GC27-1198
 License Information
 
DB2 Table Editor 4.1 (5697-G65)                        GC27-1200
 License Information
 
IMS(TM) Database Control Suite 2.1 (5655-F76)          GC27-1182
 License Information
 
IMS Fast Path Online Tools 2.1 (5655-F78)              GC27-1183
 License Information
 
IMS Online Recovery Service (5655-E50)                 GC27-0945
 License Information

The following publications are not orderable in hardcopy . They are available only on the internet.

Publications on CD-ROM for the products in this announcement will be available on the next release of the following collections of BookManager® and PDF formats.

  • z/OS Software Products Collection, SK3T-4270
  • OS/390® Software Products Collection, SK2T-6700

                                                    Order
Title                                               Number
 
DB2 Archive Log Compression (5655-F54)
 User's Guide                                       SC27-1187
 
DB2 Automation Tool (5697-G63)
 User's Guide                                       SC27-1189
 
DB2 Bind Manager (5655-D38)
 User's Guide                                       SC27-0899-01
 
DB2 Change Accumulation Tool (5655-F55)
 User's Guide                                       SC27-1191
 
DB2 Log Analysis (5655-E66)
 User's Guide                                       SC27-0967-01
 
DB2 Object Comparison Tool (5697-G64)
 User's Guide                                       SC27-1197
 
DB2 SQL Performance Analyzer (5697-F57)
 User's Guide                                       SC27-1002-01
 Installation Guide                                 SC27-1003-01
 
DB2 Table Editor 4.1 (5697-G65)
 User's Guide                                       SC27-1199
 
IMS Database Control Suite 2.1 (5655-F76)
 User's Guide                                       SC27-1181
 
IMS Database Repair Facility (5655-E03)
 User's Guide                                       SC27-0942-01
 
IMS Fast Path Online Tools 2.1 (5655-F78)
 User's Guide                                       SC27-1184
 
IMS High Performance Checker (5655-E09)
 User's Guide                                       SC27-0921-01
 
IMS Image Copy Extensions (5655-E10)
 User's Guide                                       SC27-0924-01
 
IMS Online Recovery Service (5655-E50)
 User's Guide                                       SC27-0944

The following material is available on the internet at:

Overview Brochure

  • GC27-1070-01 IBM Tools for DB2 and IMS for z/OS and OS/390,

Specification Sheets

  • GC27-1054 IBM DB2 Utilities Suite for OS/390 and z/OS Utilities, Version 7
  • GC27-1048 IBM DB2 Automation Tool for z/OS
  • GC27-1050 IBM DB2 Archive Log Compression Tool for z/OS
  • GC27-1052 IBM DB2 Change Accumulation Tool for z/OS
  • GC27-1051 IBM DB2 Object Comparison Tool for z/OS
  • GC27-1041 IBM DB2 Object Restore Tool for z/OS
  • GC27-1053 IBM DB2 Table Editor for z/OS, V4
  • GC27-1077 IBM IMS Database Control Suite for z/OS, V2
  • GC27-1074 IBM IMS Online Recovery Service for z/OS
  • GC27-1076 IMS Image Copy Solutions from IBM

Technical Information

Specified Operating Environment

Hardware Requirements

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

Software Requirements

The DB2 products in this announcement will operate on any OS/390 or z/OS software configuration that supports DB2 Version 5 (5655-DB2) or later.

The IMS products in this announcement will operate on any OS/390 or z/OS software configuration that supports IMS Version 5 (5695-176) or later, except as noted below.

Product                                 Required Software
 
IMS Fast Path Online                    IMS Version 6 (5655-158)
 Tools for z/OS                          or
                                        IMS Version 7 (5655-B01)
 
IMS Online Recovery                     IMS Version 7 (5655-B01)
 Service for z/OS

Planning Information

Packaging

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

  • Basic machine-readable material on 3480 tape cartridge
  • Program Directory
  • Proof of Entitlement (PoE)
  • IBM International Program License Agreement (IPLA)
  • License Information
  • In addition to the above items DB2 Table Editor includes one CD-ROM

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

Translation from MSUs to Value Units
 
                                        Value
                    MSUs                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 that are measured on MSU capacity. Information on MSU capacities can be found in the IBM System/370, System/390 and IBM e(logo)server 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

There will be 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. The person preparing for an order is required to 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.

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

New Customers: Specify the appropriate one-time charge (OTC) feature number(s) with the desired quantity represented by the sum of Value Units of all the machines the program is running on.

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 Archive Log Compression Tool         5655-F54
 One Value Unit                                          0017
 250 Value Units                                         0018
 
DB2 Automation Tool                      5697-G63
 One Value Unit                                          0013
 250 Value Units                                         0014
 
DB2 Change Accumulation Tool             5655-F55
 One Value Unit                                          0013
 250 Value Units                                         0014
 
DB2 Object Comparison Tool               5697-G64
 One Value Unit                                          0013
 250 Value Units                                         0014
 
DB2 Table Editor 4.1                     5697-G65
 One Value Unit                                          0013
 250 Value Units                                         0014
 
IMS Database Control Suite 2.1           5655-F76
 One Value Unit                                          0013
 250 Value Units                                         0014
 
IMS Fast Path Online Tools 2.1           5655-F78
 One Value Unit                                          0013
 250 Value Units                                         0014
 
IMS Online Recovery Service              5655-E50
 One Value Unit                                          0031
 250 Value Units                                         0032

Note that customers who purchased Subscription and Support for DB2 Forms for OS/390, Version 3 (5655-E84) are entitled to receive DB2 Table Editor 4.1, since the name of DB2 Forms was changed to DB2 Table Editor with this announcement. Also, note that the Subscription and Support PID for both DB2 Table Editor for z/OS, Version 4.1 and DB2 Forms for OS/390, Version 3.1 is 5655-E84.

Example 1: For IMS Online Recovery Service, machines with 200 MSUs require 76 Value Units and would order feature number 0031, quantity 76. Refer to below.

Translation from MSUs to Value Units

                                     Value
                                     Units/                Value
              MSUs          *        MSU          =        Units
 
Base            3           *        1.00         =         3.00
Tier A         42           *         .45         =        18.90
Tier B        130           *         .36         =        46.80
Tier C         25           *         .27         =         6.75
Tier D          0           *         .20         =          .00
 
Total         200                                          76

Example 2: For IMS Online Recovery Service, machines with 1100 MSUs require 264 Value Units and would order feature number 0031, quantity 14 and feature number 0032, quantity 1.

Translation from MSUs to Value Units

                                     Value
                                     Units/                Value
              MSUs          *        MSU          =        Units
 
Base             3          *        1.00         =          3.00
Tier A          42          *         .45         =         18.90
Tier B         130          *         .36         =         46.80
Tier C         140          *         .27         =         37.80
Tier D         785          *         .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 Online Recovery Service, adding 200 MSUs to a prior order would require 40 Value Units and would order feature number 0031, quantity 40. Refer to below.

Translation from MSUs to Value Units

                                     Value
                                     Units/                Value
              MSUs          *        MSU          =        Units
 
Base            0           *        1.00         =          .00
Tier A          0           *         .45         =          .00
Tier B          0           *         .36         =          .00
Tier C          0           *         .27         =          .00
Tier D        200           *         .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 76 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.

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

                                                         Annual
                                                         Support
                                                         Charge
                                        Program          Feature
Description                             Number           Number
 
Subscription and Support for            5655-E73
 DB2 Archive Compression Tool
 
  One Value Unit                                         0007
  250 Value Units                                        0008
 
Subscription and Support for            5655-E38
 DB2 Automation Tool
 
  One Value Unit                                         0007
  250 Value Units                                        0008
 
                                                         Annual
                                                         Support
                                                         Charge
                                        Program          Feature
Description                             Number           Number
 
Subscription and Support for            5655-E48
 DB2 Change Accumulation Tool
 
  One Value Unit                                         0007
  250 Value Units                                        0008
 
Subscription and Support for            5655-E40
 DB2 Object Comparison Tool
 
  One Value Unit                                         0007
  250 Value Units                                        0008
 
Subscription and Support for            5655-E84
 DB2 Table Editor 4.1
 
  One Value Unit                                         0007
  250 Value Units                                        0008
 
                                                         Annual
                                                         Support
                                                         Charge
                                        Program          Feature
Description                             Number           Number
 
Subscription and Support for            5655-F75
 IMS Database Control Suite 2.1
 
  One Value Unit                                         0007
  250 Value Units                                        0008
 
Subscription and Support for            5655-E25
 IMS Fast Path Online Tools 2.1
 
  One Value Unit                                         0007
  250 Value Units                                        0008
 
Subscription and Support for            5655-E33
 IMS Online Recovery Service
 
  One Value Unit                                         0007
  250 Value Units                                        0008

Basic Machine-Readable Material: The Environments for all the products in this announcement are OS/390 and z/OS. The Distribution Feature Numbers are listed in the following table.

                                         Feature
Product                                  Number  Distribution Medium
 
DB2 Archive Log Compression     5655-F54 5802    3480 tape cartridge
Tool
Subscription and Support for    5655-E73 6481    Hardcopy publication
 DB2 Archive Log Compression
 Tool
 
DB2 Automation Tool             5697-G63 5802    3480 tape cartridge
 
Subscription and Support for    5655-E38 6478    Hardcopy publication
 DB2 Automation Tool
 
DB2 Change Accumulation Tool    5655-F55 5802    3480 tape cartridge
 
Subscription and Support for    5655-E48 6468    Hardcopy publication
 DB2 Change Accumulation Tool
 
DB2 Object Comparison Tool      5697-G64 5802    3480 tape cartridge
 
Subscription and Support for    5655-E40 6479    Hardcopy publication
 DB2 Object Comparison Tool
 
DB2 Table Editor 4.1            5697-G65 5802    3480 tape cartridge
 
Subscription and Support for    5655-E84 6156    Hardcopy publication
 DB2 Table Editor 4.1
 
IMS Database Control Suite 2.1  5655-F76 5802    3480 tape cartridge
 
Subscription and Support for    5655-F75 6471    Hardcopy publication
 IMS Database Control Suite 2.1
 
IMS Fast Path Online Tools      5655-F78 5802    3480 tape cartridge
 
Subscription and Support for    5655-E25 6209    Hardcopy publication
 IMS Fast Path Online Tools
 
IMS Online Recovery Service     5655-E50 5802    3480 tape cartridge
 
Subscription and Support for    5655-E33 6475    Hardcopy publication
 IMS Online Recovery Service

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 publications are not desired for the initial order, specify feature number 3470 to ship media only. For future updates, specify feature number 3480 to ship media updates only. If, in the future, publication updates are required, order an MES to remove feature number 3480; then, the publications will ship with the next release of the program.

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

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

Customized Offerings

Most product media is shipped only via Customized Offerings (that is, CBPDO, ServerPac, Systempac®).

Terms and Conditions

Licensing: IBM International Program License Agreement. PoEs are required for all authorized use.

These products are licensed under the IBM Program License Agreement (IPLA), and the associated Agreement for Acquisition of Support, and the Addendum for Support for Database Tools (Z125-6336) can be found at:

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 IBM Operational Support Services — Support Line is an option for those customers who desire added services.

Limited Warranty Applies: Yes

Program Services: Available until March 31, 2004

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

Copy and Use on Home/Portable Computer: No

Volume Orders (IVO): No

Passport Advantage Applies: No

Passport Advantage Subscription Applies: No

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: No

Variable Charges Apply: No

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

Prices

Contact your IBM representative for charges information for this announcement.

Order Now

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

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

Note: Shipments will begin after the planned availability date.

Trademarks

 
z/OS and IMS are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, BookManager, OS/390, DB2 Universal Database, S/390, Multiprise, Systempac, AIX, and AS/400 are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
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.