|
IBM United States
Software Announcement 201-056 March 6, 2001 IBM Database Tools: Your Best Choice for Continuous Improvement with More Power and More Function
(Corrected on March 16, 2001) In the Planning Information and Ordering Information sections, the media for machine-readable material was amended. (Corrected on March 7, 2001)
In the Overview, the announcement number 201-050 was corrected.
At a GlanceNew, improved, and repositioned IBM database tools for your DB2 and IMS installations can help you:
New capabilities are being announced in each of the following IBM database tool categories:
For ordering, contact: Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: LE001). OverviewBuilding on a strengthened focus on data management tools, IBM announces new tools and functions which further complement IBM's premier DB2® Universal Database (UDB) for OS/390® and IMS™ database engines. With committed focus, IBM seeks to be your preferred supplier of tools by providing affordable, high-performance, and functionally rich products. New, repositioned, and improved products Following the direction established by the announcements made in September 2000, IBM is offering new and repositioned competitive products, function-rich new versions, significant new function available via the service stream for existing tools, and improved integration for tools presentation and data exchange between the tools. This announcement includes:
For a complete list of these products, refer to the Description section. In a separate announcement, IBM DB2 Universal Database® Server for z/OS, Version 7 Utilities is being introduced. Refer to Software Announcement 201-050 , dated March 6, 2001, for details on the three subsets available:
In September 2000, 34 new or enhanced products were announced in the following functional areas:
In December 2000, the following IMS tools were added to the database administration area. For details refer to Software Announcement 200-451 , dated December 19, 2000.
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 DateRefer to the Description section for planned availability dates for each new product, version, or PTF. DescriptionSummaryTo further enhance the productivity of your DB2 and IMS database systems, new products, versions and PTFs are being made available in the following categories.
IBM Tools for Database AdministrationDB2 Administration Tool for OS/390, Version 2.1 PTFs provide the following enhancements to the product.
DB2 Log Archive Compression Tool for z/OS makes highly compressed off-site copies of DB2 logs allowing administrators to reduce the volume of archived logs resulting in:
Archive Log Compression uses high performance compression technology designed especially for DB2 logs to maximize the:
Administrators may elect to keep SQL UNDO entries in the log to be compressed and achieve very high compression rates. Or they may choose to have DB2 Archive Log Compression remove SQL UNDO (which is not needed for disaster recovery) in order to obtain even higher rates of compression. DB2 Automation Tool for z/OS helps you realize the full potential of your DB2 system by continuously and automatically coordinating the execution of specific DB2 utilities on an around-the-clock basis. The primary capabilities provided are:
Now, without relying on repeated manual interventions, every DB2 administrator is able to add maximum value to the enterprise by extracting full performance constantly from even the most heavily-used database environment. DB2 Log Analysis Tool for OS/390 PTFs add the following ease-of-use and reporting enhancements to this tool's existing capabilities for tracking and selectively reversing changes to DB2 data:
DB2 Object Comparison Tool for z/OS helps you keep your test and development system as a mirror image of the production system. New applications, application modifications, or mistakes can cause DB2 objects in one of these systems to have different attributes than on other systems. DB2 Object Comparison Tool allows you to compare objects (and dependent objects) from one source to another. Once a difference file is generated, the product can be used to generate the DB2 commands needed to bring the catalogs back into synchronization. Masking and ignore files are supported to account for intentional differences and/or naming conventions that exist between the two sets of objects to be compared. For example, primary/secondary quantities usually are different between a test and production system. Likewise, the same object might have an owner name of TESTxxx on the test system and an owner name of PRODxxx on the production system. Use of the mask and or ignore files allow you to compare only on real differences that might exist. "Version files" are used for comparison. A version file is created from either a file of DDL or from objects in a DB2 catalog. The "known-to-be-correct" source version file is compared to a target version file that may be back level. Using version files as a base you may compare DDL, catalog object definitions, and/or other version files in any pair-wise combination desired. The ability to do comparisons with previously generated version files gives you the opportunity to:
DB2 Object Comparison runs as an extension to DB2 Administration Tool for OS/390, Version 2.1 and consists of:
DB2 Table Editor for z/OS, Version 4.1 provides the widest choice and most robust features available in the industry for the entire range of enterprise table editing needs. DB2 Forms has been renamed DB2 Table Editor to better describe the major functions that it provides. As a result, this new version is DB2 Table Editor for z/OS, Version 4.1 rather than DB2 Forms for z/OS, Version 4.1. The major facilities provided are:
DB2 Table Editor for z/OS now allows you to edit tables directly from the DB2 Control Center using:
Windows and Java™ Users also have the following facilities:
IMS Database Control Suite for z/OS, Version 2.1 is a day-to-day IMS database environment management tool for Database Administrators, System Programmers, and Application Support Specialists. It allows these users to collect and build the data required to generate JCL for database backup/recovery/reorganization management using standard IMS utilities and IBM high performance IMS tools products. IMS Database Control Suite has been remodeled to:
The product supports:
IMS Database Repair Facility for OS/390 PTF extends support to IMS Fast Path Databases. IMS Database Repair Facility is a powerful tool that interactively repairs VSAM- and OSAM-organized IMS databases containing pointer or data errors. The product's interactive capabilities let you make the repair quickly, which means that the affected database needs to be taken off-line only for a brief period. IMS Database Repair Facility features both VSAM and OSAM pointer repair, pointer navigation, and a backout safety feature. Driven by an ISPF front-end, this tool is a powerful addition to any System Programmer or DBA workbench. IMS Fast Path Online Tools for z/OS, Version 2.1 are the perfect extension to the IMS Fast Path Basic Tools. This product includes:
The DEDB Online Pointer Checker functions as an online interface to the IMS Fast Path Tools DEDB Pointer Checker and DEDB Tuning Aid. It accesses the DEDB area dataset online using Fast Path utility services. The output of this utility is a set of sequential files which are input into DEDB Pointer Checker/Tuning Aid. Online Pointer Checker provides the following:
DEDB Online Data Extract provides IMS DEDB users with an easy-to-use, flexible tool to extract data from a DEDB area while the area is online. The product functions in read-only mode, and uses locking protocols to ensure a consistent view of the data. The specification of which segments to extract allows comparisons of data offset into a segment against supplied values. More than one comparison per segment type is supported and the ability to write a subset of the matching segment's data to the output file is supported. DEDB Online Data Extract uses standard IMS data access techniques ensuring it will function correctly with all DEDB facilities, including data sharing, MADS, VSO, Shared VSO, EQE, and IMS V7 EEQE support. DEDB Online Data Extract also can write output data in a format compatible with the IMS Fast Path Basic Tools Reload utility. This powerful utility can be used:
IMS Fast Path Online Tools Version 2 provides a new utility called Fast Path Online Area Extender. This new utility allows you to dynamically expand the size of a DEDB area online via expanding the SDEP portion OR the IOVF portion (if sdeps are NOT defined) of the DEDB area. This allows 24x7 availability of an IMS Fast Path DEDB area. IMS High Performance Pointer Checker for OS/390 PTF gives you the ability to set the following new thresholds:
The space monitor utility indicates over-threshold values on the Pointer
Checker reports. This is very useful information to database
administrators. Messages are issued when any thresholds values are
exceeded.
IBM Tools for Database Recovery and Replication ManagementDB2 Change Accumulation Tool for z/OS provides DB2 administrators with a powerful tool for backing up database objects in the most precise and least disruptive manner possible by:
IMS Image Copy Extensions for OS/390 PTF supports a One Step full function database HASH Check function. Only an ICE image copy step with the HASH check option is needed for the full-function database HASH Check. This means that the DBD analysis program step, Hash Evaluation program step, PSBLIB, DBDEFCTL data set, or PROCCTL data set are no longer required. One Step full function HASH Check can be invoked from the FABJMAIN program. It cannot be invoked from the IMS compatible JCL. However, full function HASH check JCL can still be used. In order to submit the One Step full function database HASH Check the following actions are required and restrictions apply.
IMS Online Recovery Service for z/OS , in a single pass of the input data, manages the accumulation and merging of recovery related database data for the recovery of:
Data sets, including image copy, change accumulation and logs are processed in parallel while multiple database data sets are updated simultaneously. IMS Online Recovery Service allows you to recover shared IMS databases directly from image copies and log data sets if change accumulation data sets are not available. In fact, IMS Online Recovery Service even uses incomplete change accumulation data sets for recovery if they are the latest copy available. In addition, a new timestamp recovery function provides recovery to any prior point in time, regardless of database allocation ranges.
IMS commands control IMS Online Recovery Service, and recovery can be
initiated through the IMS Automated Operator Interface.
IBM Database Tools for Performance ManagementDB2 SQL Performance Analyzer for OS/390 PTFs
IBM Database Tools for Application ManagementDB2 Bind Manager for OS/390 PTF provides the following enhancements to the Path Checker function.
Subscription and Support (S&S)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. This support is subject to the terms of the IBM International Program License Agreement (IPLA) contained in the program package. This base support includes resolution of defects in the IBM program. This support is provided via mail or fax and is available until the end of service date listed in this announcement. IBM is also providing S&S for these products via a separately purchased offering under the terms of the IBM International Agreement for Acquisition of Support (IAAS). This offering:
To take full advantage of S&S, it must be ordered at the aggregated
quantity of the product license.
License Agreement
These products are licensed under the IBM Program License Agreement
(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® SupportLine is an option for those customers who desire added
services.
Value Unit Charges for Data Management Tools
Value Unit Pricing is a new pricing model for Data Management Tools. For
a complete description of this new model refer to Software Announcement
201-057
, dated March 6, 2001.
Accessibility by People with DisabilitiesThe following features support use by people with disabilities:
Euro CurrencyThese programs are not impacted by euro currency.
Trademarks
Offering InformationProduct information will be available on day of announcement through Offering Information (OITOOL) at: PublicationsOne copy of the following publications is supplied automatically with the basic machine-readable material.
Order
Title Number
DB2(R) Archive Log Compression (5655-F54) GC27-1188
License Information
DB2 Automation Tool (5697-G63) GC27-1190
License Information
DB2 Change Accumulation Tool (5655-F55) GC27-1196
License Information
DB2 Object Comparison Tool (5697-G64) GC27-1198
License Information
DB2 Table Editor 4.1 (5697-G65) GC27-1200
License Information
IMS(TM) Database Control Suite 2.1 (5655-F76) GC27-1182
License Information
IMS Fast Path Online Tools 2.1 (5655-F78) GC27-1183
License Information
IMS Online Recovery Service (5655-E50) GC27-0945
License Information
The following publications are not orderable in hardcopy . They are available only on the internet.
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
DB2 Archive Log Compression (5655-F54)
User's Guide SC27-1187
DB2 Automation Tool (5697-G63)
User's Guide SC27-1189
DB2 Bind Manager (5655-D38)
User's Guide SC27-0899-01
DB2 Change Accumulation Tool (5655-F55)
User's Guide SC27-1191
DB2 Log Analysis (5655-E66)
User's Guide SC27-0967-01
DB2 Object Comparison Tool (5697-G64)
User's Guide SC27-1197
DB2 SQL Performance Analyzer (5697-F57)
User's Guide SC27-1002-01
Installation Guide SC27-1003-01
DB2 Table Editor 4.1 (5697-G65)
User's Guide SC27-1199
IMS Database Control Suite 2.1 (5655-F76)
User's Guide SC27-1181
IMS Database Repair Facility (5655-E03)
User's Guide SC27-0942-01
IMS Fast Path Online Tools 2.1 (5655-F78)
User's Guide SC27-1184
IMS High Performance Checker (5655-E09)
User's Guide SC27-0921-01
IMS Image Copy Extensions (5655-E10)
User's Guide SC27-0924-01
IMS Online Recovery Service (5655-E50)
User's Guide SC27-0944
The following material is available on the internet at: Overview Brochure
Technical InformationSpecified Operating EnvironmentHardware 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) or later. The IMS products in this announcement will operate on any OS/390 or z/OS software configuration that supports IMS Version 5 (5695-176) or later, except as noted below.
Product Required Software
IMS Fast Path Online IMS Version 6 (5655-158)
Tools for z/OS or
IMS Version 7 (5655-B01)
IMS Online Recovery IMS Version 7 (5655-B01)
Service for z/OS
Planning InformationThe 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 InformationThe products in this announcement have one charge unit — Value Units.
Translation from MSUs to Value Units
Value
MSUs Units/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*1.00 + 42*0.45 + 130*0.36 + 140*0.27 + 685*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 that are measured on MSU capacity. Information on MSU capacities can be found in the IBM System/370, System/390 and IBM e(logo)server 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
There will be a tool 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). 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 (OTC) feature number(s) with the desired quantity represented by the sum of Value Units of all the machines the program is running on. Existing Customers: When adding additional capacity to a previous order Value Units would be determined as an extension of the aggregate MSUs.
OTC
Program Feature
Description Number Number
DB2 Archive Log Compression Tool 5655-F54
One Value Unit 0017
250 Value Units 0018
DB2 Automation Tool 5697-G63
One Value Unit 0013
250 Value Units 0014
DB2 Change Accumulation Tool 5655-F55
One Value Unit 0013
250 Value Units 0014
DB2 Object Comparison Tool 5697-G64
One Value Unit 0013
250 Value Units 0014
DB2 Table Editor 4.1 5697-G65
One Value Unit 0013
250 Value Units 0014
IMS Database Control Suite 2.1 5655-F76
One Value Unit 0013
250 Value Units 0014
IMS Fast Path Online Tools 2.1 5655-F78
One Value Unit 0013
250 Value Units 0014
IMS Online Recovery Service 5655-E50
One Value Unit 0031
250 Value Units 0032
Note that customers who purchased Subscription and Support for DB2 Forms for OS/390, Version 3 (5655-E84) are entitled to receive DB2 Table Editor 4.1, since the name of DB2 Forms was changed to DB2 Table Editor with this announcement. Also, note that the Subscription and Support PID for both DB2 Table Editor for z/OS, Version 4.1 and DB2 Forms for OS/390, Version 3.1 is 5655-E84. Example 1: For IMS Online Recovery Service, machines with 200 MSUs require 76 Value Units and would order feature number 0031, quantity 76. Refer to below. Translation from MSUs to Value Units
Value
Units/ Value
MSUs * MSU = Units
Base 3 * 1.00 = 3.00
Tier A 42 * .45 = 18.90
Tier B 130 * .36 = 46.80
Tier C 25 * .27 = 6.75
Tier D 0 * .20 = .00
Total 200 76
Example 2: For IMS Online Recovery Service, machines with 1100 MSUs require 264 Value Units and would order feature number 0031, quantity 14 and feature number 0032, quantity 1. Translation from MSUs to Value Units
Value
Units/ Value
MSUs * MSU = Units
Base 3 * 1.00 = 3.00
Tier A 42 * .45 = 18.90
Tier B 130 * .36 = 46.80
Tier C 140 * .27 = 37.80
Tier D 785 * .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 Online Recovery Service, adding 200 MSUs to a prior order would require 40 Value Units and would order feature number 0031, quantity 40. Refer to below. Translation from MSUs to Value Units
Value
Units/ Value
MSUs * MSU = Units
Base 0 * 1.00 = .00
Tier A 0 * .45 = .00
Tier B 0 * .36 = .00
Tier C 0 * .27 = .00
Tier D 200 * .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 76 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 automatically renew annually unless cancelled by the customer.
Annual
Support
Charge
Program Feature
Description Number Number
Subscription and Support for 5655-E73
DB2 Archive Compression Tool
One Value Unit 0007
250 Value Units 0008
Subscription and Support for 5655-E38
DB2 Automation Tool
One Value Unit 0007
250 Value Units 0008
Annual
Support
Charge
Program Feature
Description Number Number
Subscription and Support for 5655-E48
DB2 Change Accumulation Tool
One Value Unit 0007
250 Value Units 0008
Subscription and Support for 5655-E40
DB2 Object Comparison Tool
One Value Unit 0007
250 Value Units 0008
Subscription and Support for 5655-E84
DB2 Table Editor 4.1
One Value Unit 0007
250 Value Units 0008
Annual
Support
Charge
Program Feature
Description Number Number
Subscription and Support for 5655-F75
IMS Database Control Suite 2.1
One Value Unit 0007
250 Value Units 0008
Subscription and Support for 5655-E25
IMS Fast Path Online Tools 2.1
One Value Unit 0007
250 Value Units 0008
Subscription and Support for 5655-E33
IMS Online Recovery Service
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
Product Number Distribution Medium
DB2 Archive Log Compression 5655-F54 5802 3480 tape cartridge
Tool
Subscription and Support for 5655-E73 6481 Hardcopy publication
DB2 Archive Log Compression
Tool
DB2 Automation Tool 5697-G63 5802 3480 tape cartridge
Subscription and Support for 5655-E38 6478 Hardcopy publication
DB2 Automation Tool
DB2 Change Accumulation Tool 5655-F55 5802 3480 tape cartridge
Subscription and Support for 5655-E48 6468 Hardcopy publication
DB2 Change Accumulation Tool
DB2 Object Comparison Tool 5697-G64 5802 3480 tape cartridge
Subscription and Support for 5655-E40 6479 Hardcopy publication
DB2 Object Comparison Tool
DB2 Table Editor 4.1 5697-G65 5802 3480 tape cartridge
Subscription and Support for 5655-E84 6156 Hardcopy publication
DB2 Table Editor 4.1
IMS Database Control Suite 2.1 5655-F76 5802 3480 tape cartridge
Subscription and Support for 5655-F75 6471 Hardcopy publication
IMS Database Control Suite 2.1
IMS Fast Path Online Tools 5655-F78 5802 3480 tape cartridge
Subscription and Support for 5655-E25 6209 Hardcopy publication
IMS Fast Path Online Tools
IMS Online Recovery Service 5655-E50 5802 3480 tape cartridge
Subscription and Support for 5655-E33 6475 Hardcopy publication
IMS Online Recovery Service
Basic License: To order, specify the program number, feature number 9001 for asset registration, and the 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 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.
Customized OfferingsMost product media is shipped only via Customized Offerings (that is, CBPDO, ServerPac, Systempac®). Terms and ConditionsLicensing: IBM International Program License Agreement. PoEs are required for all authorized use. These products are licensed under the IBM Program License Agreement (IPLA), and the associated Agreement for Acquisition of Support, and the Addendum for Support for Database Tools (Z125-6336) can be found at: 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. Program Services: Available until March 31, 2004 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, 15% education allowance applies to qualified education institution customers.
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
|
