IBM United States
Software Announcement 201-162
May 29, 2001

IBM Data Management Tools Enhanced for DB2 and IMS

 ENUS201-162.PDF (39KB)


At a Glance

New, improved, and repositioned 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
  • Effectively create and operate your application subsystem

New capabilities are being announced in each of these categories:

  • IBM Tools for Database Administration
  • IBM Tools for Database Application Management

For ordering, contact:

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

Overview

Building on a strengthened focus on data management tools, IBM announces new tools and functions that further complement IBM's premier DB2 Universal Database® (UDB) for OS/390® and IMS™ engines. With committed focus, IBM seeks to be your preferred supplier of tools by providing affordable, high-performance, and functionally rich products.

This announcement includes:

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

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 Dates

  • May 29, 2001, for IMS Connect service enhancements
  • June 22, 2001, for DB2 Bind Manager, Version 2 and DB2 Path Checker
  • August 3, 2001, for IMS HD Compression Extended for z/OS, Version 2.2

Description

DB2 Bind Manager for z/OS, Version 2

DB2 Bind Manager for z/OS, Version 2 and DB2 Path Checker for z/OS consist of a rich set of functions to assist you during DB2 application management and test. To provide greater granularity in your tools selections, the Path Checker functions have been removed from Bind Manager and enhanced to create the new DB2 Path Checker product. In addition, major DBRM management function is added to DB2 Bind Manager.

Customers of DB2 Bind Manager for OS/390, Version 1.1 on the date of this announcement who are licensed for Subscription and Support for DB2 Bind Manager for OS/390, Version 1.1 are entitled to receive DB2 Bind Manager for z/OS, Version 2 and DB2 Path Checker for z/OS.

Use of DB2 Bind Manager can pay major dividends in change management, since it will detect automatically production application changes requiring a bind. This frees DBAs from analyzing bind impacts and allows them to concentrate only on the changes that affect the SQL structure.

Consistency checking may be done between an existing DBRMLIB and a DB2 subsystem using the DBRM Checker function of DB2 Bind Manager. DBRM Checker will identify DBRMs by plan that have consistency tokens inconsistent with those in the DB2 catalog tables. You can determine which of the DBRMs you need to bind. An application may have hundreds of packages (that is, DBRMs) making up one plan. If you only changed one, then you only need to bind that one package.

This release of Bind Manger contains the following enhancements:

  • Match time stamps in a DBRM to time stamps in a load module
  • Scan a load library and produce a report of modules and CSECTS that contain static SQL

DB2 Path Checker for z/OS

Using the DB2 Path Checker, you can quickly determine whether a bind of a DBRM will result in a changed access path. This is usually done when a new release (or version) of DB2 is installed, service is applied, and/or you are migrating a large application from one system to another. You've spent many hours fine tuning the SQL for performance only to have the optimizer select a path you didn't expect. By using Path Checker, you can see the effects of doing a bind (or having done a bind). Path Checker does an EXPLAIN into your plan table of the "new" DBRM and gives you a report on those that changed. You can then use any EXPLAIN tool to look at the result and determine whether you need to take action or not.

DB2 Checker contains all the Path Checker function formerly found in DB2 Bind manager plus the following major enhancements:

  • Statement table cost estimates displayed when available
  • On path change, add selected DB2 Catalog statistics
  • Show new SQL statement 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

IMS HD Compression Extended for z/OS, Version 2.2

This release of IMS HD Compression Extended is offered to correct packaging problems that were discovered in Release 1 that cannot be corrected by the normal service process. No new function has been added.

IMS Connect for OS/390

IMS Connect, Version 1 Release 1 (5655-E51) provides the following APARs:

  • APAR number PQ45057 adds local support for communication using Program Calls without requiring TCP/IP from a Web serving application to IMS in a z/OS or OS/390 environment, easing the management in this environment. This support is used by the VisualAge® for Java™ IMS Connector for Java for creating Java applications that can access IMS transactions from WebSphere™ Application Servers for z/OS and OS/390.
  • APAR number PQ47906 adds Unicode support for sending Unicode application data to an IMS host application capable of dealing with Unicode, such as a Java application running in IMS.
  • APAR number PQ46195 adds ACK/NAK required notification support. It provides client notification that an ACK or NAK response is required by the client without additional testing of data received. This notification will be sent to the Client in the CSM and RSM.
  • APAR number PQ48182 changes the output message structure to include the full message length preceding the output message to the client, reducing the design and coding effort of a client application.

IMS Connect, Version 1 Release 2 — IBM plans to provide WebSphere Adapter support, through the addition to IMS Connect in Version 1 Release 2 of the IMS Connector for Java J2EE Runtime support. This IMS Connector for Java J2EE support provides the run-time environment for Java applications developed using the VisualAge for Java IMS Connector for Java J2EE Development support. VisualAge for Java could be used to customize connectors and generate Java Beans that are deployed into the WebSphere Application Server or any other application server that conforms to the J2EE Connector Architecture. This IMS Connector support is designed to be used with the Java 2 Platform, Enterprise Edition, Connector Architecture Specification V1.0. IBM plans to make this IMS Connector for Java J2EE support, along with the other WebSphere Adapters, available in the second half of 2001. Availability depends on completion of the J2EE Connector Architecture Final Specification and the J2EE Platform V2.3 Specification by JavaSoft. This specification is similar to IBM's proprietary Common Connector Framework (CCF), which was delivered in VisualAge for Java, Version 2.0 along with the IMS Connector for Java for deployment in WebSphere Application Servers. The specification of the Connector Architecture is currently in Public Draft Status. To download the draft specification, visit:

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.

Reference Information

The prices for IMS HD Compression Extended Version 2.1 were previously announced and do not change with Version 2.2. Refer to Software Announcement 201-057 dated March 6, 2001.

Trademarks

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

Offering Information

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

Publications

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

DB2® Bind Manager for z/OS, Version 2 (5655-E43)

                                                  Order
Title                                             Number
 
License Information                               GC27-1271
  DB2 Path Checker for z/OS (5655-E39)
License Information                               GC27-1272
  IMS(TM) HD Compression Extended for z/OS,
  Version 2.2 (5655-E02)
License Information                               GC27-1006

The following publications cannot be ordered in hardcopy . They are available only on the Internet at:

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)

DB2 Bind Manager for z/OS, Version 2 (5655-E43)

                                                  Order
Title                                             Number
 
User's Guide                                      SC27-1218
  DB2 Path Checker for z/OS (5655-E39)
User's Guide                                      SC27-1273
  IMS HD Compression Extended for z/OS
  Version 2.2 (5655-E02)
User's Guide                                      SC27-1005

The following material is available on the Internet at:

Overview brochure

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

Specification Sheets

  • IBM DB2 Bind Management and Path Analysis Solutions (GC27-1037)
  • IBM Connect (GC27-1071)

Technical Information

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), DB2 Version 6 (5645-DB2), or DB2 Version 7 (5675-DB2).

IMS HD Compression Extended for z/0S, Version 2.2 will operate on any OS/390 or z/OS software configuration that supports IMS Version 5 (5695-176), IMS Version 6 (5695-158) or IMS Version 7 (5655-B01).

Planning Information

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

  • Basic machine-readable material on a 3480 tape cartridge
  • Program Directory
  • Proof of Entitlement (PoE)
  • IBM International Program License Agreement (IPLA)
  • License Information

Security, Auditability, and Control

The announced programs use the security and auditability features of the host operating system software.

The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.

Ordering Information

New Licensees

The CFSW configurator stand-alone path for all products in this announcement will be updated to support price proposals on May 29, 2001.

For all products, media is only shipped via Customized Offerings (ServerPac, Systempac® and CBPDO). CFSW configuration and order entry capability will commence with CBPDO on the following dates:

  • Bind Manager Version 2, DB2 Path Checker: June 19, 2001
  • IMS HD Compression Extended Version 2.2: July 31, 2001

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

Value Units

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

Translation from MSUs to Value Units

                                       Value Units/
                    MSUs                   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 x 1.00 + 42 x 0.45 + 130 x 0.36 + 140 x 0.27 + 685 x 0.20 = 244 Value Units

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

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

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

Value Units for non MSU-based S/390 processors: MP3000 Models 

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

A tool is available that provides support for transforming the MSU-based capacities of S/390 systems to new Value Units by calculating the applicable number of Value Units for a given number of MSUs. 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). The configurator 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 feature numbers with the desired quantity represented by the sum of Value Units of all the machines on which the program is running.

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

Customers of DB2 Bind Manager for OS/390, Version 1.1 on the date of this announcement who are licensed for Subscription and Support for DB2 Bind Manager for OS/390, Version 1.1 are entitled to receive both:

  • DB2 Bind Manager for z/OS, Version 2
  • DB2 Path Checker for z/OS

                                                  OTC(1)
                              Program             Feature
Description                   Number              Number
 
DB2 Bind Manager for          5655-E43
  z/OS, Version 2
    One Value Unit                                0001
    250 Value Units                               0002
DB2 Path Checker for          5655-E39
  z/OS
    One Value Unit                                0001
    250 Value Units                               0002
IMS HD Compression for        5655-E02
  z/OS, Version 2.2
    One Value Unit                                0030
    250 Value Units                               0031
1
One-time charge

Example 1: For IMS HD Compression, machines with 200 MSUs require 76 Value Units and would order feature number 0030, quantity 76.

Translation from MSUs to Value Units

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

Example 2: For IMS HD Compression, machines with 1100 MSUs require 264 Value Units and would order feature number 0030, quantity 14 and feature number 0031, quantity 1.

Translation from MSUs to Value Units

                         Value
                        Units/               Value
        MSUs       x       MSU     =         Units
 
Base       3       x      1.00     =          3.00
Tier A    42       x       .45     =         18.90
Tier B   130       x       .36     =         46.80
Tier C   140       x       .27     =         37.80
Tier D   785       x       .20     =        157.00
 
Total   1100                                   264

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

Example 3: For IMS HD Compression, adding 200 MSUs to a prior order would require 40 Value Units and would order feature number 0030, quantity 40.

Translation from MSUs to Value Units

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

This additional capacity of 200 MSUs costs 40 Value Units as opposed to example 1 where the initial 200 MSUs would cost 103 Value Units.

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

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

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

                                                       ASC(2)
                                        Program        Feature
Description                             Number         Number
 
Subscription and Support for            5655-E98
  DB2 Bind Manager for OS/390
  This product provides
  subscription and support for
  all releases and versions of
  DB2 Bind Manager.
    One Value Unit                                     0007
    250 Value Units                                    0008
Subscription and Support for
DB2 Path Checker for z/OS               5655-E49
  One Value Unit                                       0001
  250 Value Units                                      0002
Subscription and Support                5655-E01
  for IMS HD Compression
  Extended for OS/390
  provides subscription and
  support for all releases
  and versions of IMS HD
  Compression Extended.
    One Value Unit                                     0007
    250 Value Units                                    0008
1
Annual Support Charge

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       Distribution
Product                            Number        Medium
 
DB2 Bind Manager for               5802          3480 tape
  z/OS Version 2 (5655-E43)                      cartridge
Subscription and Support           6173          Hardcopy
  for DB2 Bind Manager for                       publication
  OS/390 (5655-E98)
  This product provides
  subscription and support
  for all releases and
  versions of DB2 Bind
  Manager.
DB2 Path Checker for z/OS          5802          3480 tape
  (5655-E39)                                     cartridge
Subscription and Support           6478          Hardcopy
  for DB2 Path Checker for                       publication
  z/OS (5655-E49)
IMS HD Compression                 5802          3480 tape
  Extended Version 2.2                           cartridge
  (5655-E02)
Subscription and Support           6210          Hardcopy
  for IMS HD Compression                         publication
  Extended for OS/390
  (5655-E01) (Provides
  subscription and
  support for all releases
  and versions of IMS HD
  Compression Extended.)

Basic License: To order, specify the program number, feature number 9001 for asset registration, and the one-time charge (OTC) feature number. Also specify the feature number of the desired distribution medium.

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

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

                                                    Feature
Description                                         Number
 
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). Non-customized items (CDs, diskettes, source media, media kits) will continue to be shipped via the stand-alone product.

Terms and Conditions

Licensing: IPLA. Proofs of Entitlement are required for all authorized use.

These products are licensed under the IPLA, and the associated Agreement for Acquisition of Support, and the Addendum for Support, 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

Product                                 Available Until
 
DB2 Bind Manager for z/OS,              November 30, 2004
  Version 2
DB2 Path Checker for z/OS               November 30, 2004
IMS Connect for OS/390                  November 30, 2003
IMS HD Compression Extend for           November 30, 2004
  for z/OS Version 2.2

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, a 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: YE001
 
 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@us.ibm.com
 Mail:      IBM Atlanta Sales Center
            Dept. YE001
            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

 
IMS, z/OS, zSeries, and System/370 are trademarks of International Business Machines Corporation in the United States or other countries or both.
 
DB2, BookManager, OS/390, S/390, Systempac, System/390, 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.