IBM United States
Software Announcement 200-300
September 12, 2000

Maximize Your e-business Opportunities with IBM Tools for Database Application Environments

 ENUS200-300.PDF (39KB)

(Corrected on October 30, 2000)

Text regarding product support was clarified.

At a Glance

Maximize your e-business opportunities with database application management products that will provide the smooth and efficient support your business deserves.

  • Assist your administration staff in application development and testing
  • Provide connectivity for e-business access of IMS data
  • Examine data in a table (and change it if required!)
  • Quickly locate and correct data, or repair a bad page in a tablespace
  • Rapidly and accurately restart IMS applications

For ordering, contact:

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

Overview

Efficient database management is the key to success in today's rapidly evolving e-business world. IBM can guide you on your way to cost-effective utilization of your database management environments with these new and repositioned tools:

  • DB2® Bind Manager
  • DB2 Web Query Tool
  • IMS™ Program Restart Facility
  • IMS Connect

Let IBM give you the edge by providing you with the ability to:

  • Connect with the data you need, when you need it
  • Examine and change data
  • Control checkpoint activities

Simplify your business procedures and increase revenue with added business value.

To learn more about these offerings, refer to the Description section of this announcement.

Key Prerequisites

  • DB2 Bind Manager and DB2 Web Query Tool are designed to support DB2 Version 5 or later.
  • IMS Program Restart Facility Version 2 is designed to support the IMS Version 5, 6, and 7 operating environments.
  • IMS Connect requires the IMS V5, V6, or V7 TM feature. IMS Connect provides valuable benefits when using IMS Version 5 or Version 6. In order to utilize asynchronous, local support, and Unicode support, IMS Version 7 TM is required.

Planned Availability Dates

  • September 22, 2000, for IBM IMS Program Restart Facility Version 2
  • October 27, 2000, for IBM IMS Connect
  • December 1, 2000, for IBM DB2 Bind Manager
  • December 1, 2000, for IBM DB2 Web Query Tool

Description

IBM DB2 Bind Manager

Use of DB2 Bind Manager can pay major dividends in change management, since it will automatically detect 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.

Using the Path Checker function of DB2 Bind Manager, 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, 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.

IBM DB2 Web Query Tool

Prior to today's announcement of DB2 Web Query Tool, connecting to enterprise data most likely involved a huge amount of effort and, let's face it, grief. Complex configurations, obscure procedures, and in-depth user training were necessary preparation steps in order to access and finally be productive using enterprise data.

The resulting time, effort, expense, and, above all, waiting created a latency — a gap between opportunity and action that cost your organization every time it happened, perhaps thousands of times a day.

DB2 Web Query Tool changes this old paradigm and helps eliminate the pain previously associated with data access. With DB2 Web Query Tool, end users and administrators have a single, powerful tool for bringing data access into the e-business age with speed, reliability, and simplicity.

DB2 Web Query Tool sets a new standard for business responsiveness because now anyone in your organization can take robust data access for granted, virtually anywhere and at anytime. Less latency; less waiting; and less waste means more opportunity to you and your organization.

With the trusted architecture of DB2, DB2 Web Query Tool enables pervasive connectivity over the Internet to every desktop from the novice user to the expert.

IBM IMS Program Restart Facility

IBM's new IMS Program Restart Facility automatically assigns the most recent checkpoint ID to jobs that are being restarted because of an earlier abnormal termination.

Using this automatic restart tool will ensure that no amended job is started with a valid but incorrect checkpoint ID or worse, without any checkpoint ID being allocated. This program is designed to prevent the costly and time-consuming database recoveries that can arise from manual restart errors.

Extended restart support sets aside the checkpoint records in the IMS log required for a checkpoint restart and automatically makes them available to the job requiring a restart. No manual JCL changes are required to provide the correct log data set names.

A number of additional benefits can be utilized. However, JCL or application programming changes may be necessary.

IBM IMS Connect

IMS Connect provides enhanced IMS TCP/IP support including:

  • SMP installability
  • Dump and trace formatting
  • User exits, command improvement, and asynchronous output support
  • Persistent sockets and bottleneck relief

IMS Connect requires the IMS TM feature, but much of the above function in IMS Connect (other than asynchronous output support) can be used with terminals, applications, and data still running under IMS V5 or V6. Customers can thus successfully choose the IMS Connect ahead of a full migration to IMS V6 or IMS V7. Future enhancements to IMS TCP/IP support will only be provided through IMS Connect for IMS V7.

IBM also provides access to IMS from the S/390® LINUX® operating system through IMS Connect. IMS Connect can be used by an application running on Linux/390 or any other S/390 system in the enterprise.

Additionally, IMS Connect provides enhancements for IMS V7 through the service process. This includes Local Support, without TCP/IP, when communicating from a Web-serving application to IMS in a S/390 environment.

IMS Connect also provides Unicode support for IMS V7 through the service process. This provides the ability to send Unicode application data to an IMS host application capable of dealing with Unicode, such as a Java™ application running in IMS.

Subscription and Support

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 via mail or fax. It is subject to the terms of the IBM International Program License Agreement (IPLA) contained in the program package and includes resolution of defects in the IBM program. This support is available until the end-of-service date listed in this announcement.

IBM is also providing enhanced subscription and support 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 (voice support for defects during normal business hours)
  • Entitles customers to future versions and releases at no additional charge

New License Agreement for Selected S/390 Software

IBM is announcing selected S/390 software products with revised provisions. These products are licensed under the IPLA, and support is provided under the Agreement for Acquisition of Support and its Addendum (Z125-6336). These programs have a one-time license charge for use of the program and an ongoing recurring charge for 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. SupportLine is an option for those customers who desire added services.

Year 2000

These products are Year 2000 ready. When used in accordance with their associated documentation, they are capable of correctly processing, providing, and/or receiving date data within and between the twentieth and twenty-first centuries, provided that all products (for example, hardware, software, and firmware) used with the products properly exchange accurate date data with them.

Euro Currency

These programs are not impacted by euro currency.

Trademarks

 
IMS is a trademark of International Business Machines Corporation in the United States or other countries or both.
 
DB2 and S/390 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.
 
LINUX is a registered trademark of Linus Torvalds.
 
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
 
IBM DB2(R) Bind Manager (5655-D38)
 License Information                                   GC27-0898
 User's Guide                                          SC27-0899
 
IBM DB2 Web Query Tool (5655-E71)
 License Information                                   GC27-0970
 User's Guide                                          SC27-0971
 
IBM IMS(TM) Program Restart Facility
 V2 (5655-E14)
  License Information                                  GC27-0911
  User's Guide                                         SC27-0910
 
IBM IMS Connect (5655-E51)
 License Information                                   GC27-0947
 User's Guide                                          SC27-0946

Technical Information

Specified Operating Environment

Hardware Requirements

DB2 Bind Manager and DB2 Web Query Tool are designed to operate on any hardware supporting DB2 V5 or later.

IMS Program Restart Facility is designed to operate on any hardware supporting the IMS V5, 6, and 7 operating environments.

IMS Connect is designed to operate on any hardware supporting the IMS V5, V6, or V7 TM feature. IMS Connect provides valuable benefits when using IMS V5 or V 6. However, asynchronous, local support, and Unicode support require IMS V7.

Software Requirements

The products in this announcement will operate on any software configuration containing the prerequisite IMS or DB2 versions.

In addition, IMS Connect requires OS/390® V2.6, or later.

Planning Information

Packaging

IBM DB2 Bind Manager is distributed with the following content:

  • Basic machine-readable material on the customer-selected distribution medium (either 9/6250 tape, 3480 tape cartridge, or 4-mm DAT cartridge)
  • Program Directory
  • Proof of Entitlement (PoE)
  • IPLA
  • License Information
  • User's Guide

IBM DB2 Web Query Tool is distributed with the following content:

  • Basic machine-readable material on CD-ROM
  • PoE
  • IPLA
  • License Information
  • User's Guide

IBM IMS Program Restart Facility V2 is distributed with the following content:

  • Basic machine-readable material on the customer-selected distribution medium (either 9/6250 tape, 3480 tape cartridge, or 4-mm DAT cartridge)
  • Program Directory
  • PoE
  • IPLA
  • License Information
  • User's Guide

IBM IMS Connect is distributed with the following content:

  • Basic machine-readable material on the customer-selected distribution medium (either 9/6250 tape, 3480 tape cartridge, or 4-mm DAT cartridge)
  • Program Directory
  • PoE
  • IPLA
  • License Information
  • User's Guide

Note: IMS Connect User Guide is available on Web only as PDF file. Hardcopy User's Guide is not shipped as part of distribution package.

Security, Auditability, and Control

The announced program uses 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

IBM DB2 Bind Manager is a product which has one charge unit — MSUs.

Subscription and Support for IBM DB2 Bind Manager is a product which has one charge unit — MSUs.

IBM DB2 Web Query Tool is a product which has one charge unit — MSUs.

Subscription and Support for IBM DB2 Web Query Tool is a product which has one charge unit — MSUs.

IBM IMS Program Restart Facility V2 is a product which has one charge unit — MSUs.

Subscription and Support for IBM IMS Program Restart Facility V2 is a product which has one charge unit — MSUs.

IBM IMS Connect is a product which has one charge unit — MSUs.

Subscription and Support for IBM IMS Connect is a product which has one charge unit — MSUs.

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 numbers with the desired quantity represented by the sum of Service Units in Millions (MSUs) ratings of the designated machines.

                                                         One-
                                                         Time
                                                         Charge
                                        Program          Feature
Description                             Number           Number
 
DB2 Bind Manager                        5655-D38
 
 1 -- 45 MSUs                                            0007
 46 -- 175 MSUs                                          0008
 176 -- 315 MSUs                                         0009
 316+ MSUs                                               0010
 176 -- 315 MSUs (quantity 250)                          0011
 316+ MSUs (quantity 250)                                0012
 
DB2 Web Query Tool                      5655-E71
 
 1 -- 45 MSUs                                            0018
 46 -- 175 MSUs                                          0019
 176 -- 315 MSUs                                         0020
 316+ MSUs                                               0021
 176 -- 315 MSUs (quantity 250)                          0022
 316+ MSUs (quantity 250)                                0023
 
                                                         One-
                                                         Time
                                                         Charge
                                        Program          Feature
Description                             Number           Number
 
IMS Program Restart Facility            5655-E14
 
 1 -- 45 MSUs                                            0018
 46 -- 175 MSUs                                          0019
 176 -- 315 MSUs                                         0020
 316+ MSUs                                               0021
 176 -- 315 MSUs (quantity 250)                          0028
 316+ MSUs (quantity 250)                                0029
 
IMS Connect                             5655-E51
 
 1 -- 45 MSUs                                            0018
 46 -- 175 MSUs                                          0019
 176 -- 315 MSUs                                         0020
 316+ MSUs                                               0021
 176 -- 315 MSUs (quantity 250)                          0022
 316+ MSUs (quantity 250)                                0023

Example 1: For IMS Connect, machines with 200 MSUs would order feature 0020, quantity 200.

Example 2: For IMS Connect, machines with 300 MSUs would order feature 0020, quantity 50, and feature 0022 quantity 1.

Subsequent orders for additional MSUs are considered independent transactions. MSU quantities previously ordered are not accumulated to determine an ordering tier.

Example 3: For IMS Connect, to add 50 additional MSUs, a new order would be placed for feature 0019, quantity 50.

Trade-in Customers: The products in this announcement are available at a one-time upgrade price for those customers currently licensed for selected competitive products. Customers must provide an original proof of purchase (front of user manual, front of cartridge insert, or, copy of purchase invoice/bill of sale). Specify the appropriate OTC trade-in feature numbers with the desired quantity represented by the sum of MSUs of the designated machines.

                                                         One-
                                                         Time
                                                         Trade-In
                                                         Charge
                                        Program          Feature
Description                             Number           Number
 
DB2 Bind Manager -- Trade-In            5655-D38
 
 1 -- 45 MSUs                                            0013
 46 -- 175 MSUs                                          0014
 176 -- 315 MSUs                                         0015
 316+ MSUs                                               0016
 176 -- 315 MSUs (quantity 250)                          0017
 316+ MSUs (quantity 250)                                0018
 
                                                         One-
                                                         Time
                                                         Trade-In
                                                         Charge
                                        Program          Feature
Description                             Number           Number
 
DB2 Web Query Tool                      5655-E71
 -- Trade-In
 
 1 -- 45 MSUs                                            0026
 46 -- 175 MSUs                                          0027
 176 -- 315 MSUs                                         0028
 316+ MSUs                                               0029
 176 -- 315 MSUs (quantity 250)                          0030
 316+ MSUs (quantity 250)                                0031
 
IMS Program Restart                     5655-E14
 Facility -- Trade-In
 
 1 -- 45 MSUs                                            0022
 46 -- 175 MSUs                                          0023
 176 -- 315 MSUs                                         0024
 316+ MSUs                                               0025
 176 -- 315 MSUs (quantity 250)                          0026
 316+ MSUs (quantity 250)                                0027
 
IMS Connect -- Trade-In                 5655-E51
 
 1 -- 45 MSUs                                            0024
 46 -- 175 MSUs                                          0025
 176 -- 315 MSUs                                         0026
 316+ MSUs                                               0027
 176 -- 315 MSUs (quantity 250)                          0028
 316+ MSUs (quantity 250)                                0029

Subscription and Support: To receive voice technical support via telephone (voice support for defects during normal business hours) and future versions and 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 number with the desired quantity represented by the sum of MSUs of the designated machines.

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                5655-E98
 for DB2 Bind Manager
 
 1 -- 45 MSUs                                            0004
 46 -- 175 MSUs                                          0001
 176 -- 315 MSUs                                         0005
 316+ MSUs                                               0002
 176 -- 315 MSUs (quantity 250)                          0006
 316+ MSUs (quantity 250)                                0003
 
                                                         Annual
                                                         Support
                                                         Charge
                                        Program          Feature
Description                             Number           Number
 
Subscription and Support                5655-E91
 for DB2 Web Query Tool
 
 1 -- 45 MSUs                                            0006
 46 -- 175 MSUs                                          0005
 176 -- 315 MSUs                                         0003
 316+ MSUs                                               0001
 176 -- 315 MSUs (quantity 250)                          0004
 316+ MSUs (quantity 250)                                0002
 
Subscription and Support for            5655-E17
 IMS Program Restart Facility
 
 1 -- 45 MSUs                                            0003
 46 -- 175 MSUs                                          0006
 176 -- 315 MSUs                                         0004
 316+ MSUs                                               0001
 176 -- 315 MSUs (quantity 250)                          0005
 316+ MSUs (quantity 250)                                0002
 
Subscription and Support                5655-E34
 for IMS Connect
 
 1 -- 45 MSUs                                            0001
 46 -- 175 MSUs                                          0006
 176 -- 315 MSUs                                         0004
 316+ MSUs                                               0002
 176 -- 315 MSUs (quantity 250)                          0005
 316+ MSUs (quantity 250)                                0003

Basic Machine-Readable Material

 
                        Feature
Environment             Number               Distribution Medium
 
DB2 Bind Manager (5655-D38)
 
 OS/390                 5801                 9/6250 tape
 OS/390                 5802                 3480 tape cartridge
 OS/390                 5260                 4-mm DAT cartridge
 
DB2 Web Query Tool (5655-E71)
 
 OS/390                 5809                 CD-ROM
 
IMS Program Restart Facility (5655-E14)
 
 OS/390                 5801                 9/6250 tape
 OS/390                 5802                 3480 tape cartridge
 OS/390                 6124                 4-mm DAT cartridge
 
IMS Connect (5655-E51)
 
 OS/390                 5801                 9/6250 tape
 OS/390                 5802                 3480 tape cartridge
 OS/390                 6135                 4-mm DAT cartridge

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.

Terms and Conditions

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

For the subscription and support offering — IBM Agreement for Acquisition of Programs and Support (Z125-5790), or IBM International Agreement for Acquisition of Support (Z125-6011), or IBM International Agreement for Acquisition of Programs and Support (Z125-5599) with the Attachment for Support and its Addendum for Support for Database Tools (Z125-6336).

Limited Warranty Applies: Yes

Program Services: Available until November 30, 2003

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

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

 
IMS is a trademark of International Business Machines Corporation in the United States or other countries or both.
 
DB2, OS/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 in the United States and other countries exclusively through X/Open Company Limited.
 
Other company, product, and service names may be trademarks or service marks of others.