|
IBM United States
Software Announcement 201-162 May 29, 2001 IBM Data Management Tools Enhanced for DB2 and IMS
At a GlanceNew, 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). OverviewBuilding 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:
Key PrerequisitesThe products in this announcement will operate on any hardware and software configuration that supports the required version of DB2 or IMS. Planned Availability Dates
DescriptionDB2 Bind Manager for z/OS, Version 2DB2 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/OSUsing 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/390IMS 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 DisabilitiesFor software offerings: The following features support use by people with disabilities:
Euro CurrencyThese programs are not impacted by euro currency. Reference InformationThe 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
PublicationsOne 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:
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
Specification Sheets
Technical InformationHardware Requirements
The products in this announcement will operate on any S/390® hardware
configuration that supports the required version of DB2 or IMS.
Software RequirementsThe 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 InformationPackaging: The programs in this announcement are distributed with the following content:
Security, Auditability, and ControlThe 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 InformationNew LicenseesThe 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:
For CBPDO orders, shipments will begin one week after availability.
Value UnitsThe 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
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:
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
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
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 OfferingsMost 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 ConditionsLicensing: 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.
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 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 Educational Allowance Available: Yes, a 15% education allowance applies to qualified education institution customers. 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
|
