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
(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:
New capabilities are being announced in each of the following IBM database tool categories:
For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: LE001).
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:
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:
In September 2000, 34 new or enhanced products were announced in the following functional areas:
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.
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.
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
DB2 Administration Tool for OS/390, Version 2.1 PTFs provide the following enhancements to the product.
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:
Archive Log Compression uses high performance compression technology designed especially for DB2 logs to maximize the:
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:
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:
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:
DB2 Object Comparison runs as an extension to DB2 Administration Tool for OS/390, Version 2.1 and consists of:
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:
DB2 Table Editor for z/OS now allows you to edit tables directly from the DB2 Control Center using:
Windows and Java Users also have the following facilities:
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:
The product supports:
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:
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:
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:
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:
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
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:
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.
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:
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.
IBM Database Tools for Performance Management
DB2 SQL Performance Analyzer for OS/390 PTFs
IBM Database Tools for Application Management
DB2 Bind Manager for OS/390 PTF provides the following enhancements to the Path Checker function.
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:
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
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
, dated March 6, 2001.
Accessibility by People with Disabilities
The following features support use by people with disabilities:
These programs are not impacted by euro currency.
Product information will be available on day of announcement through Offering Information (OITOOL) at:
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.
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:
Specified Operating Environment
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
The programs in this announcement are distributed with the following content:
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.
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.
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
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
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.
Most product media is shipped only via Customized Offerings (that is, CBPDO, ServerPac, Systempac®).
Terms and Conditions
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.
Use Priority/Reference Code: LE001 Phone: 800-IBM-CALL Fax: 800-2IBM-FAX Internet: firstname.lastname@example.org 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.