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

 ENUS201-050.PDF (52KB)

(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 Glance

With Version 7, DB2 UDB Server for OS/390 utilities provide:

  • Object Lists, Pattern Matching, and Dynamic Allocation to improve user productivity
  • DB2 Cross Family Load capability via LOAD support for input from SQL SELECT statement
  • A new UNLOAD Utility that allows data to be unloaded from active tables and image copies
  • Improved data availability in Online REORG
  • Improved data load performance with LOAD Partition Parallelism
  • A historical perspective to space utilization and DB2 cost-based optimizer access path statistics
  • The ability for data to be loaded concurrent with application access to the same data with Online LOAD RESUME

For ordering, contact:

Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: LE001).

Overview

The 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:

  • DB2 Operational Utilities
  • DB2 Diagnostic and Recovery Utilities
  • DB2 Utilities Suite (combining the functions of DB2 Operational Utilities and DB2 Diagnostic and Recovery Utilities)

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 Prerequisites

The products in this announcement will operate on any hardware configuration that supports DB2 for OS/390 and z/OS, Version 7.

Planned Availability Date

March 30, 2001

Description

Improved Usability

As 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:

  • RUNSTATS utility
  • Inline statistics gathering of the LOAD, REORG, and REBUILD utilities

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 Scalability

With 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:

  1. Use SQL SELECT to produce input directly into LOAD. This enhancement delivers a DB2 family cross-loader function. Use any DRDA®-compliant server as a data input source for populating your tables in DB2 for OS/390 and z/OS. Your input can even come from non-DB2 data sources by using DataJoiner® for access to data from sources as diverse as Oracle and Sybase, as well as the entire DB2 Family of database servers.
  2. In prior releases, many customers would run individual LOAD utilities at the partition level in order to take advantage of multiple processors. Now this same function can be performed with a single LOAD job with multiple partitions loaded in parallel and with added efficiency building secondary indexes.
  3. The LOAD utility may now be run with improved data availability by specifying SHRLEVEL CHANGE. This allows LOAD to be used concurrently with queries and applications.

DB2 Operational Utilities

The 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:

  • Copy — to make full or incremental backups of your table spaces and indexes
  • Load — to load your tables
  • Rebuild Index — to create or rebuild your indexes
  • Recover — to restore your table spaces and indexes from backup copies and apply log records since the backup
  • Reorg Tablespace — to reorder your data, reclaim space, and restore free space
  • Reorg Index — to reorder your indexes
  • Runstats — to collect space and access path statistics on table spaces and indexes
  • Stospace — to collect space used statistics for DB2 managed table spaces and indexes
  • Unload — to unload your tables, table spaces, and backup copies

DB2 Diagnostic and Recovery Utilities

IBM 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:

  • Archiving data
  • Point in time recovery
  • Online recovery
  • Added image copy capabilities
  • Replication of data among sites to where it is needed can enable your distributed applications

For normal backup and recovery operations, the tools now include the separately ordered DB2 Diagnostic and Recovery Utilities product with the following functions:

  • Check Data — to check consistency among referentially related tables
  • Check Index — to check consistency between data and indexes
  • Check LOB — to check the consistency of LOB table spaces
  • Copy — to make full or incremental backups of your table spaces and indexes
  • CopyToCopy — to make additional backups of your table spaces and indexes asynchronously
  • Mergecopy — to merge incremental or full and incremental backup copies
  • Modify Recovery — to remove obsolete backup information from DB2
  • Modify Statistics — to remove obsolete historical statistics
  • Rebuild Index — to create or rebuild your indexes
  • Recover — to restore your table spaces and indexes from backup copies and apply log records since the backup

DB2 Utilities Suite

Purchase 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:

  • DB2 Operational Utilities
    and
  • DB2 Diagnostic and Recovery Utilities

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:

  • Includes and extends the support services provided in the base support to include technical support via telephone during normal business hours.
  • Entitles customers to future releases and versions at no additional charge. Note, customers are not entitled for new products.

    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 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 Currency

These programs are not impacted by euro currency.

Trademarks

 
DB2 Universal Database, OS/390, DB2, DRDA, DataJoiner, and S/390 are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
Other company, product, and service names may be trademarks or service marks of others.

Offering Information

Product information is available through Offering Information (OITOOL) at:

Publications

For 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 Information

Hardware 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 Requirements

SMP/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 Information

Packaging: The programs in this announcement are distributed with the following content:

  • Basic machine-readable material on the customer-selected distribution medium (either 9/6250 tape, 3480 tape cartridge, or 4-mm DAT cartridge)
  • Program Directory
  • Proof of Entitlement (PoE)
  • International Program Agreement (IPLA)
  • License Information

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.

Ordering Information

The 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:

    3x5.25+42x0.83+130x0.35+140x0.26+685x0.20=
    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:

  • MP3000 models:
    • H30=21.00 Value Units
    • H50=22.00 Value Units
    • H70=26.00 Value Units
  • P/390, R/390, IBM 3006 = 9.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 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 Offerings

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

Licensing: 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.

Limited Warranty Applies: Yes

Program Services: Available until March 31, 2004

Money-Back Guarantee: Two-month, money-back guarantee

Copy and Use on Home/Portable Computer: No

Volume Orders (IVO): No

Passport Advantage Applies: No

Passport Advantage Subscription Applies: No

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

Variable Charges Apply: No

Educational Allowance Available: Yes, a 15% education allowance applies to qualified education institution customers.

Prices

Contact your IBM representative for charges information for this announcement.

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

 
S/370 is a trademark of International Business Machines Corporation in the United States or other countries or both.
 
DB2, OS/390, DB2 Universal Database, System 370, System 390, Systempac, AIX, and AS/400 are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
 
UNIX is a registered trademark is a registered trademark of the Open Company in the United States and other countries.
 
Other company, product, and service names may be trademarks or service marks of others.