IBM United States
Software Announcement 200-300
September 12, 2000
Maximize Your e-business Opportunities with IBM Tools for Database Application Environments
(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.
For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: LE001).
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:
Let IBM give you the edge by providing you with the ability to:
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.
Planned Availability Dates
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.
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.
IBM IMS Connect
IMS Connect provides enhanced IMS TCP/IP support including:
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:
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.
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.
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 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
Specified Operating Environment
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.
The products in this announcement will operate on any software configuration containing the prerequisite IMS or DB2 versions.
IBM DB2 Bind Manager is distributed with the following content:
IBM DB2 Web Query Tool is distributed with the following content:
IBM IMS Program Restart Facility V2 is distributed with the following content:
IBM IMS Connect is distributed with the following content:
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.
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.
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
Subsequent orders for additional MSUs are considered independent transactions. MSU quantities previously ordered are not accumulated to determine an ordering tier.
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
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
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).
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.