IBM United States
Software Announcement 201-162
May 29, 2001
IBM Data Management Tools Enhanced for DB2 and IMS
At a Glance
New, improved, and repositioned database tools for your DB2 and IMS installations can help you:
New capabilities are being announced in each of these categories:
For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: YE001).
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:
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
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:
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:
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:
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:
These programs are not impacted by euro currency.
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.
Product information is available through Offering Information (OITOOL) at:
One copy of the following publications is supplied automatically with the basic machine-readable material.
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:
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:
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).
Security, Auditability, and Control
The announced programs use the security and auditability features of the host operating system software.
The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.
The 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:
The products in this announcement have one charge unit 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
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.
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:
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
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
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.
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
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.
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.
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
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.
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
Use Priority/Reference Code: YE001 Phone: 800-IBM-CALL Fax: 800-2IBM-FAX Internet: firstname.lastname@example.org 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.