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.

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.

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:

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.

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

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:

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.

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

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:

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.

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.

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:

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

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.

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.

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.

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.

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

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

Order Now

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.