|
IBM United States
Software Announcement 201-050 March 6, 2001 IBM DB2 Universal Database Server for OS/390 and z/OS, Version 7 Utilities Deliver Improved Usability, Availability, and Performance for Managing your Databases
(Corrected on April 3, 2001) Corrected Value Units for Non-MSU-based S/390 Processors. (Corrected on March 22, 2001)
Corrected MP 3000 Models Value Units.
At a GlanceWith Version 7, DB2 UDB Server for OS/390 utilities provide:
For ordering, contact: Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: LE001). OverviewThe DB2 Universal Database® (UDB) Server for OS/390® and z/OS, Version 7 utilities programs deliver improved usability, availability, and performance for managing your DB2® for OS/390 databases. A basic set of core utilities has been included as part of DB2 since Version 1 was first delivered. These utilities initially provided a basic level of services to allow customers to manage data. Some customers have preferred to obtain such functions, however, from independent software vendors that have developed utility and tools offerings that offered additional performance, function, and features beyond that contained in the DB2 core utilities. With recent releases of DB2 for OS/390, in response to clear customer demand, IBM has invested in the improvement of these core utilities. With DB2 UDB Server for OS/390 and z/OS, Version 7, these utility functions have been separated from the base product and are now offered as the following individual products:
These new products augment the rich Database Tools functions previously announced. For an overview of the enhanced focus on database tools, refer to Software Announcement 200-307 , dated September 12, 2000. Key PrerequisitesThe products in this announcement will operate on any hardware configuration that supports DB2 for OS/390 and z/OS, Version 7. DescriptionImproved UsabilityAs customers grow their enterprise, they typically do so without an increase in IT staffing. As applications require new table space and indexes, the IT staff typically is required to include these in their scheduled maintenance jobs. In DB2 UDB for OS/390 and z/OS, Version 7 you can take advantage of object wildcarding to dynamically build lists of table space and indexes on which the utilities should execute. A key companion to this is the ability to dynamically allocate the work and output data sets required by each utility. The space can either be calculated by the utility or the user can override the space allocations. Many customers want to analyze their table space and index sizes over a period of time in order to predict future space growth and when utilities such as REORG or RUNSTATS might be needed. In Version 7, you can also keep historical data with the:
You don't have to change those hundreds of utilities you already have to
take advantage of this new option, it can be enabled with a system
parameter.
Improved Performance, Availability, and ScalabilityWith each release, DB2 for OS/390 delivers improvements for performance, availability, and scalability. In DB2 UDB for OS/390 and z/OS, Version 7 you can take advantage of a new utility, UNLOAD, which provides faster data unloading than was available with the DSNTIAUL program. In addition to the unload functions of REORG UNLOAD EXTERNAL, you can also unload data from an image copy, invoke row sampling, specify field selection, and ordering, as well as using parallelism when unloading multiple partitions. Online REORG is enhanced for data availability. Now, the time required to invoke a dataset rename has been eliminated. Instead you can specify a new keyword FASTSWITCH, which will leave the data set name unchanged, but update the catalog to reference the newly reorganized dataset. When hundreds of table spaces and index objects are involved, the time savings can become quite significant. Also, parallelism is added to the BUILD2 phase. This makes it possible to process logical partitions simultaneously and shorten the elapsed time required for this phase of the Online REORG. The LOAD utility is improved in three ways:
DB2 Operational UtilitiesThe IBM Database Administration Tools announced September 12, 2000, address common tasks required to service and support database operations. These tasks include unloading, reloading, reorganizing, copying, and catalog management. The performance of many of these are critical in meeting your company's availability commitments. These tools now include the separately ordered DB2 Operational Utilities product with the following functions:
DB2 Diagnostic and Recovery UtilitiesIBM Tools for Database Recovery and Replication announced September 12, 2000, address many customer requirements for additional backup and recovery needs that require special solutions. These additional needs may include:
For normal backup and recovery operations, the tools now include the separately ordered DB2 Diagnostic and Recovery Utilities product with the following functions:
DB2 Utilities SuitePurchase the set of DB2 utilities that best meets your DB2 management requirements. The DB2 Utilities Suite is a separately ordered product that includes all the functions provided by:
Utility Support for Your DB2 Catalog Data
DB2 UDB for OS/390 and z/OS, Version 7 delivers the DB2 Utilities
Suite in support of your catalog data. DB2 catalog data is critical for
all database reference and application design. To sustain the high
availability of DB2 for OS/390, this product is delivered with each
shipment of DB2 UDB for OS/390, Version 7. Use these powerful
management utilities for all of your DB2 catalog data management tasks.
Subscription & Support (S&S)Base support for these products is included as part of the one-time charge (OTC) for the product and is provided by the IBM Support Center. This support is subject to the terms of the 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:
License Agreement
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® 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.
Euro CurrencyThese programs are not impacted by euro currency.
Trademarks
PublicationsFor each of the products in this announcement, the only publication supplied with the basic machine-readable material is the License Information (LI) publication.
Order
Title Number
DB2(R) Operational Utilities (5655-E63)
License Information GC27-1146
Program Directory GI10-8383
DB2 Diagnostic and Recovery Utilities (5655-E62)
License Information GC27-1145
Program Directory GI10-8382
DB2 Utilities Suite (5697-E98)
License Information GC27-1147
Program Directory GI10-8240
DB2 UDB for OS/390® and z/OS Version 7 (5675-DB2) This product supplies the following DB2 Utilities information:
Order
Title Number
DB2 UDB for OS/390 and z/OS SC26-9945
Version 7 Utility Guide and Reference
Technical InformationHardware Requirements
The products in this announcement will operate on any S/390® hardware
configuration that supports DB2 for OS/390 and z/OS, Version 7.
Software RequirementsSMP/E Version 1 (5668-949) is required to install the products in this announcement.
The products will operate on any OS/390 software configuration that
supports DB2 for OS/390 and z/OS, Version 7.
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 InformationThe products in this announcement have one charge unit — value units. Translation from MSUs to Value Units
.-------+-------+---------------. | | MSUs |Value Units/MSU| |-------+-------+---------------| |Base | 1-3| 5.25 | |Tier A | 4-45| .83 | |Tier B | 46-175| .35 | |Tier C |176-315| .26 | |Tier D |316+ | .20 | '-------+-------+---------------' The total number of value units is calculated according to the following example: If the customer has installed 1,000 MSUs, the applicable value units would be:
270 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:
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 OTC feature numbers 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 Operational Utilities 5655-E63
1 Value Unit 0013
250 Value Units 0014
DB2 Diagnostic and Recovery 5655-E62
Utilities
1 Value Unit 0013
250 Value Units 0014
DB2 Utilities Suite 5697-E98
1 Value Unit 0013
250 Value Units 0014
Example 1: For DB2 Utilities Suite, machines with 200 MSUs require 103 value units and would order feature number 0013, quantity 103. Refer to the table below.
.--------------------------------------------. | Translation from MSUs to Value Units | |------+-------------------------------------| | |MSUs Value Units/MSU Value Units | |Base | 3 x 5.25 = 15.75 | |Tier A| 42 x .83 = 34.86 | |Tier B|130 x .35 = 45.50 | |Tier C| 25 x .26 = 6.50 | |Tier D| 0 x .20 = .00 | |------+-------------------------------------| |Total |200 103 | '------+-------------------------------------' Example 2: For DB2 Utilities Suite, machines with 1,000 MSUs require 270 value units and would order feature number 0013, quantity 20, and feature number 0014, quantity 1.
.---------------------------------------------. | Translation from MSUs to Value Units | |------+--------------------------------------| | | MSUs Value Units/MSU Value Units | |Base | 3 x 5.25 = 15.75 | |Tier A| 42 x .83 = 34.86 | |Tier B| 130 x .35 = 45.50 | |Tier C| 140 x .26 = 36.40 | |Tier D| 685 x .20 = 137.00 | |------+--------------------------------------| |Total |1000 270 | '------+--------------------------------------' Subscription and Support: To receive voice technical support via telephone during normal business hours, and future releases and versions at no additional charge, Subscription and Support must be ordered. The capacity of Subscription and Support (Value Units) must be the same as the capacity ordered for the product license. To order, specify the support program number and feature number 9001 for asset registration. Specify the annual support charge (ASC) 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 renew automatically annually unless cancelled by the customer.
ASC
Program Feature
Description Number Number
Subscription and Support for 5655-E83
DB2 Operational Utilities
1 Value Unit 0007
250 Value Units 0008
Subscription and Support for 5655-E82
DB2 Diagnostic and Recovery
Utilities
1 Value Unit 0007
250 Value Units 0008
Subscription and Support for 5648-D68
DB2 Utilities Suite
1 Value Unit 0007
250 Value Units 0008
Basic Machine-Readable Material: The environment for all the products in this announcement is OS/390 or z/OS. The distribution feature numbers are listed in the following table.
.--------------------+--------+-------+--------------------. | |Product |Feature| | |Product |Number |Number |Distribution Medium | |--------------------+--------+-------+--------------------| |DB2 Operational |5655-E63| 5802 |3480 tape cartridge | | Utilities | | | | |--------------------+--------+-------+--------------------| |Subscription and |5655-E83| 6231 |Hardcopy publication| | Support for | | | | | DB2 Operational | | | | | Utilities | | | | |--------------------+--------+-------+--------------------| |DB2 Diagnostic and |5655-E62| 5802 |3480 tape cartridge | | Recovery Utilities| | | | |--------------------+--------+-------+--------------------| |Subscription and |5655-E82| 6232 |Hardcopy publication| | Support for | | | | | DB2 Diagnostic and| | | | | Recovery Utilities| | | | |--------------------+--------+-------+--------------------| |DB2 Utilities Suite |5697-E98| 5802 |3480 tape cartridge | |--------------------+--------+-------+--------------------| |Subscription and |5655-E83| 6000 |Hardcopy publication| | Support for | | | | | DB2 Utilities | | | | | Suite | | | | '--------------------+--------+-------+--------------------' 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®). Non-customized items (CDs, diskettes, source media, media kits) will continue to be shipped via the stand-alone product. Terms and ConditionsLicensing: IPLA. PoEs 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 that 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. 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 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: 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
|
