IBM DB2 Automated Utility Generator Release 3 Offers Enhanced Function and Improved Usability

Software Announcement
October 28, 1997
Announcement Letter Number: 297-446


Table of Contents:



At a Glance

DB 2 AUG includes the following benefits:

  • Generates utilities and commands automatically

  • Allows "lights-out" processing (no intervention required)

  • Eliminates maintenance of obsolete JCL

  • Produces fresh JCL every time; generating only necessary utilities

  • Provides user friendly ISPF front-end panels

  • Reduces CPU usage and resource consumption (DASD, tapes)

  • Reduces outages, JCL failures, and customer downtime

  • Generates intelligent Reorg utility

  • Supports dynamically created or dropped DB2 objects

  • Maintains space allocation

  • Reduces operator/DBA support phone calls with restart function

  • Provides statistics collection and reporting facility

  • Exploits utility and functional enhancements from DB2 Versions 3, 4, and 5
-----------------------------------------
For ordering, contact:
  Your IBM representative, an IBM
  Business Partner, or IBM North America
  Sales Centers at
    800-IBM-CALL  Reference: LE010



Overview

Any installation that uses DB2 (R) can greatly benefit from DB2 Automated Utility Generator (DB2 AUG) (5695-077). DB2 AUG automatically generates most of the DB2 utilities and provides space management functions for monitoring DB2 databases.

DB2 AUG allows unattended generation and management of DB2 utility job streams. This "lights-out" process frees the DB2 database administrators from the tedious and error-prone daily task of creating and maintaining utility JCL job streams.

The DB2 utility JCL is created by DB2 AUG fresh every time and can then be submitted automatically, manually or presented to a batch scheduling system for submission. Once the JCL has executed successfully, it can be disposed of so there are no outdated utility JCL libraries to maintain.

Many savings can be realized by generating only the necessary utilities, which are tailored for a specific DB2 object with regard to the object's status. CPU usage and resource consumption are decreased, and outages and customer downtime that can result from utility failures caused by obsolete JCL are eliminated. Through the use of DB2 AUG's restart function, the middle-of-the-night support phone calls can be dramatically reduced.

DB2 AUG calculates the size of a DB2 object's data set based on the amount of space the object is currently occupying. This virtually eliminates utility failures due to improper space calculations. Using information from the DB2 catalog and the system catalog in conjunction with user-defined criteria and thresholds, DB2 AUG evaluates Reorg requests and generates the appropriate JCL. This eliminates the manual effort required to determine if a Reorg is necessary for an object. The DB2 catalog is also used to build a list of potential objects for utility JCL creation. Therefore, any dynamically created or dropped objects within DB2 are reflected automatically in DB2 AUG.

The statistics collection facility shows the status of DB2 objects.

DB2 AUG Release 3 exploits many of the utility and functional enhancements that were introduced by DB2 Versions 3, 4, and 5.



Intended Customers

DB2 AUG is a DB2 productivity tool useful to all customers currently using or intending to use DB2.



Key Prerequisites

DB2 AUG runs on an MVS/ESA (TM) or OS/390 (TM) platform.



Planned Availability Date

October 31, 1997

------------------------------

This announcement is provided for your information only. For additional information, contact your IBM representative, call 800-IBM-4YOU, or visit the IBM home page at: http://www.ibm.com



DESCRIPTION

DB2 AUG automates the creation of fresh, accurate, and efficient DB2 utility JCL. It increases the productivity of the DB2 database administrators and system support programmers by relieving them of the tedious task of DB2 utility JCL creation and maintenance. By automating the generation of many DB2 utilities and commands, DB2 AUG dramatically improves the database administrator's efficiency, reducing costs and resource consumption (CPU, DASD, tapes), and reducing errors and outages caused by utility failures and obsolete JCL. DB2 AUG can also reduce an installation's support cycle and off-shift support phone calls.

DB2 AUG's "lights out" processing frees the database administrator from many tasks. DB2 AUG's generator program uses a set of DB2 scheduling tables. These tables are updated by the database administrator to identify what utilities are to be generated, when the utilities should be generated, and for which DB2 objects. The effort required to define the utility requirements of a new application is reduced to inserting rows into the tables through an ISPF front end. When the JCL has been created, it is then initiated on either a scheduled or unscheduled basis; upon job completion, notification can be sent to the appropriate person and the JCL can then be disposed of when it has run successfully. If the JCL is submitted automatically or through a batch scheduling system, this limits the database administrator's activity to simply checking the completion notification to insure all jobs ran successfully.

When DB2 AUG generates JCL for a DB2 object, it also calculates the size of the corresponding data set based upon the size of the object. As the size of the object changes, it automatically adjusts the size of each output data set. This virtually eliminates utility failures due to improper space calculations.

Utility failures may occur due to other factors besides JCL such as unavailable resources, operator cancellation, locking, and external dependencies. DB2 AUG reduces the impact of DB2 utility failures that may cause data to be unavailable. This is accomplished by a mechanism called the "Help clist," which is designed to assist in the restart process. It has the following functions:

  • Automates first-level problem determination

  • Automatically notifies key personnel that a utility failure has occurred

  • Assists in re-establishing operations after a utility failure by determining the phase in which the utility failed, issuing verbose operator instructions, deleting unnecessary data sets, and editing failing JCL in order to restart with minimal processing
Unnecessary Reorgs can use up a large segment of a limited time window; however, many locations take the approach to "Reorg the object whether it needs it or not." DB2 AUG can automatically detect the need for, and initiate, a Reorg for an object through the use of user-defined filter criteria and thresholds, the DB2 catalog, and the system catalog. If a Reorg is required for an object, DB2 AUG provides the capability to optionally change the primary and secondary allocation for a user-defined object or alter the priqty for a storage group defined object. This change can be upward, to compensate for data volume growth, or downward to remove unused space from an object, possibly improving an object's performance.

DB2 AUG allows an installation to schedule DB2 utility jobs for a target DB2 object:

  • On a daily, weekly or monthly basis
  • According to a defined interval
  • With regard to an installation-defined calendar event
DB2 AUG also contains functions to collect and store statistics about DB2 objects. The information is gathered from the DB2 and ICF catalogs and can be used for problem analysis and growth trending. A comprehensive set of Query Management Facility (QMF (TM)) reports is provided to display the data collected for these statistics from which the database administrator can track historical trends and exception conditions. There are three statistics collection tables that gather information about the following:
  • VSAM data sets that contain DB2 data
  • Physical extents of a DB2 VSAM data set
  • DASD volumes that contain DB2 data
There is also a series of QMF queries, procs, and forms provided. These can be used to list the contents of the DB2 AUG tables, list the DB2 catalog view data, and the statistics reports.

DB2 AUG supports the following utilities and commands:

  • Utilities
      Check Index and Check Data Full and Incremental Copy Mergecopy Modify Recovery Modify Statistics (DB2 Versions 3 and 4 only) Rebind Plans and Packages Recover Reorg Repair Runstats Stospace Quiesce Report DSN1COPY DSN1PRNT DSN1CHKR
  • Commands
      STOP Database START Database (RW, RO, UT, and FORCE) REBIND
Some of the new functions of DB2 AUG Release 3 are:
  • Exploitation of Versions 3, 4, and 5 of DB2
    • Support for the following utility and functional changes in DB2 for OS/390 Version 5 (5655-DB2)
      • Large partitioned table spaces
      • Runstats SAMPLE option
      • Reorg SORTKEYS option
      • Reorg Table Space Inline Image Copy
      • DB2AUG's Load Statistics Inline Image Copy
      • DB2 Catalog and Directory Reorg generation
    • Support for the following utility and functional changes in DB2 Version 3 (5685-DB2) and DB2 Version 4 (5695-DB2):
      • Partition level concurrency processing
      • Copy Concurrent option
      • Quiesce WRITE option
      • Support for logically partitioned indexes
      • Mergecopy RECOVERYDDN option
      • Recover Table Space TOLOGPOINT, LOGONLY, LOCALSITE, and RECOVERYSITE options
      • Reorg KEEPDICTIONARY option
  • The Front End Generate command (GEN option) has been enhanced with:
    • Field-sensitive pop-up help panels
    • Help panels for each detail panel
    • Panel data saved across multiple GEN invocations
  • Other enhancements:
    • Ability to generate a new job for each partition to allow partition independence support

    • Flexible High Level Qualifier definition for output data sets

    • Ability to Reorg all indexes for a specified table space

    • Performance improvements due to a more discriminating SYSIBM.SYSCOPY search

    • Secondary allocation control when recalculating data set size during Reorg

    • Incremental copy percent changed algorithm saves space

    • User modifiable class for SYSUDUMP

    • Separate retention periods for DASD and Tape data sets



Year 2000

This product is Year 2000 Ready. When used in accordance with its associated documentation, it is capable of correctly processing, providing, and/or receiving date data within and between the twentieth and twenty-first centuries, provided all other products, (for example, software, hardware, and firmware) used with the product properly exchange date data with it.



PRODUCT POSITIONING

DB2 AUG is a DB2 productivity tool useful to all customers currently using or intending to use DB2. It is current with DB2 Version 5, exploiting most of the enhancements introduced by DB2 Versions 3, 4, and 5. DB2 AUG Release 3 is Year 2000 Ready.

Trademarks

      MVS/ESA, OS/390, and QMF are trademarks of International
      Business Machines Corporation in the United States or other
      countries or both.
      DB2 is a registered trademark 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.



SUPPLEMENTAL INFORMATION



TECHNICAL INFORMATION



Specified Operating Environment

Hardware Requirements: DB2 (R) AUG Release 3 runs on any IBM processor operating with:

  • MVS/ESA (TM) JES2 (5655-068) Version 5 or MVS (R)/ESA JES3 (5655-069) Version 5

  • OS/390 (TM) Release 1, 2, or 3 (5645-001), or OS/390 Version 2 Release 4 (5647-A01), or any later release
Software Requirements: DB2 AUG Release 3 requires the following environments:
  • MVS/ESA: MVS/ESA JES2 Version 5 (5655-068) or MVS/ESA JES3 Version 5 (5655-069) along with:
    • DFSMS (TM) Version 1 Release 2 (5695-DF1) or MVS Data Facility Product (MVS/DFP (TM)) Version 3 Release 3 (5665-XA3)

    • TSO/Extensions Version 2 Release 5 (5685-025)

    • Interactive System Productivity Facility (ISPF) Version 4 Release 1 (5655-042)

    • System Modification Program Extended (SMP/E) Version 1 Release 8 Modification 1 (5668-949)
    or

  • OS/390: OS/390 Release 1, 2, or 3 (5645-001), or OS/390 Version 2 Release 4 (5647-A01), or any later OS/390 release

  • DATABASE 2 (TM) (DB2) Version 3 Release 1 (5685-DB2), or later
For the optional DB2 AUG/QMF (TM) feature, DB2 AUG Release 3 requires:
  • Query Management Facility (QMF) Version 3 Release 2 (5706-254)
For the optional DB2 AUG/HSM feature, DB2 AUG Release 3 requires:
  • Data Facility Hierarchical Storage Manager (DFHSM) Version 2 Release 6 (5665-329)

  • Data Facility Data Set Services (DFDSS) Version 2 Release 5 (5665-327)
Compatibility: DB2 AUG Release 3 is upwardly compatible with DB2 AUG Release 2. This is accomplished using a migration aid utility that is included with Release 3. Users can migrate to DB2 AUG Release 3 only from DB2 AUG Release 2.



Planning Information

Customer Responsibilities: DB2 AUG Release 3 can be installed and operated in parallel with Release 2 of the product. This allows a customer to perform upgrade verification and validation tests without affecting current DB2 AUG production environments.

Installability: DB2 AUG Release 3 contains several database changes from the prior release. A data migration aid utility is included with Release 3. The prior release of DB2 AUG should be retained until such a time that fall back is not a consideration.



System Integrity

IBM will accept APARs where the installation of DB2 AUG Release 3 introduces an exposure to the system integrity of MVS. Refer to Software Announcement P81-174, dated October 21, 1981. This program is intended to run unauthorized.



Security, Auditability, and Control

The announced program uses the security and auditability features of MVS or OS/390 and DB2.

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



Current Licensees

Current licensees of DB2 AUG will be sent a program reorder form that can be returned directly to IBM Software Manufacturing Solutions (SMS). These reorder forms are scheduled to be mailed by November 14, 1997. Reorder forms returned to SMS will be processed within 10 workdays of receipt. When DB2 AUG Release 3 is available, DB2 AUG Release 2 will no longer be available.



New Licensees

Orders for new licenses will be accepted now.

Shipment of Release 3 will begin on October 31, 1997. Orders for DB2 AUG that ship prior to October 31, 1997, will include DB2 AUG Release 2. Orders that ship after October 31, 1997, will include DB2AUG Release 3.

New users of DB2 AUG should specify:

             Type                    Model

5695 077

Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. For a graduated one-time charge (OTC) or graduated monthly license charge (MLC), specify the feature number below that corresponds to the group that contains the designated machine. Also, specify the feature number of the desired distribution medium.

                      Basic                    Basic
  Group           Graduated OTC            Graduated MLC
  Number          Feature Number           Feature Number

18 0917 0901 20 0918 0902 25 0919 0903 28 0920 0904 29 0921 0905 30 0922 0906 31 0923 0907 32 0924 0908 35 0925 0909 38 0926 0910 40 0927 0911 50 0928 0912 60 0929 0913 70 0930 0914 80 0931 0915

Multiple Operating System -- PR/SM (TM) (MOSP): For a graduated OTC or graduated MLC, specify the feature number below that corresponds to the group that contains the designated machine.

                    MOSP Basic               MOSP Basic
  Group           Graduated OTC            Graduated MLC
  Number          Feature Number           Feature Number

18 0016 0001 20 0017 0002 25 0018 0003 28 0019 0004 29 0020 0005 30 0021 0006 31 0022 0007 32 0023 0008 35 0024 0009 38 0025 0010 40 0026 0011 50 0027 0012 60 0028 0013 70 0029 0014 80 0030 0015

Note: The group can be determined by referring to the Exhibit for IBM System/390 (R) Machines (Z125-3901) associated with the IBM Customer Agreement (Z125-4575).

Entry Support License (ESL): To order an ESL license, specify the program number, feature number 9001 for asset registration, and the applicable ESL OTC feature number. Also specify the feature number of the desired distribution medium.

                                        ESL OTC
                    Program             Feature
Description         Number              Number

ESL OTC 5695-077 2166

Note: ESL machines can be determined by referring to the IBM Entry End User/390 Attachment (Z125-4379).

Parallel Sysplex (TM) License Charge (PSLC) Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. Specify the PSLC Base feature. If applicable, specify the PSLC Level A and PSLC Level B features and quantity. If there is more than one program copy in a Parallel Sysplex, the charge for all copies is associated to one license by specifying the applicable PSLC feature numbers and quantity represented by the sum of the Service Units in Millions (MSUs) in your Parallel Sysplex. For all other program copies, specify the PSLC No-Charge (NC) Identifier feature on the licenses. Also, specify the feature number of the desired distribution medium.

                    PSLC           PSLC Basic License
Machine             Feature        MLC Feature
MSU Capacity        Number         Description

1 0079 PSLC Base, 1 MSU 2 0080 PSLC Base, 2 MSUs

3 0081 PSLC Base, 3 MSUs

4 to 45 0082 PSLC Level A, 1 MSU 0083 PSLC Level A, 42 MSUs

46 or more 0084 PSLC Level B, 1 MSU 0085 PSLC Level B, 10 MSUs 0086 PSLC Level B, 50 MSUs

NA* 0087 PSLC NC Identifier

*     Not Applicable

Example 1: For a single machine with 11 MSUs, the PSLC features would be 0081 -- quantity 1 and 0082 -- quantity 8.

Example 2: For two machines in a Parallel Sysplex that have an aggregation of 60 MSUs, the PSLC features would be:

  • PSLC chargeable license #1: 0081 -- quantity 1, 0083 -- quantity 1, 0084 -- quantity 5, and 0085 -- quantity 1

  • PSLC no-charge license #2: 0087 -- quantity 1
Indexed Monthly License Charge (IMLC) Basic License: To order a basic license, specify the program number and feature number 9001 for asset registration. Specify the IMLC Base 80 MSUs feature and the applicable additional IMLC MSU features and quantity corresponding to the MSU rating of the designated machine. Also, specify the feature number of the desired distribution medium.
IMLC Basic License                 IMLC
MLC Feature                        Feature
Description                        Number

IMLC Base 80 MSUs 0201 IMLC 1 MSU 0202 IMLC 10 MSUs 0203 IMLC 50 MSUs 0204

Single Version Charging: To elect single version charging, the customer must notify and identify to IBM the prior program and replacement program and the designated machine the programs are operating on.

Version-to-Version Upgrade Credit: To upgrade from a prior program acquired for an OTC to a replacement program using a version-to-version upgrade credit, the customer must notify and identify to IBM the applicable prior program and replacement program participating in the upgrade credit.

Basic Machine-Readable Material: To order, select the feature number of the desired distribution medium:

                         Feature        Distribution
Environment              Number         Medium

MVS/ESA, OS/390 5801 9/6250 BPI Tape 5802 3480 Cartridge 5337 4-mm Cartridge

Customization Options: Select the appropriate feature numbers to customize your order to specify the 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 Manufacturing Solutions (SMS) receives the order. SMS will then ship the order via overnight air transportation.

DSLO License: To order a DSLO license, specify the program number, feature number 9901 for asset registration, and the feature number below for the graduated OTC or graduated MLC that corresponds to the group containing the designated machine.

                       DSLO                     DSLO
  Group           Graduated OTC            Graduated MLC
  Number          Feature Number          Feature Numbers

18 0949 0933 20 0950 0934 25 0951 0935 28 0952 0936 29 0953 0937 30 0954 0938 31 0955 0939 32 0956 0940 35 0957 0941 38 0958 0942 40 0959 0943 50 0960 0944 60 0961 0945 70 0962 0946 80 0963 0947

Multiple Operating System -- PR/SM (MOSP): For a graduated OTC or graduated MLC, specify the following feature number below that corresponds to the group that contains the designated machine.

                    MOSP DSLO                MOSP DSLO
  Group           Graduated OTC            Graduated MLC
  Number          Feature Number          Feature Numbers

18 0046 0031 20 0047 0032 25 0048 0033 28 0049 0034 29 0050 0035 30 0051 0036 31 0052 0037 32 0053 0038 35 0054 0039 38 0055 0040 40 0056 0041 50 0057 0042 60 0058 0043 70 0059 0044 80 0060 0045

Ordering a DSLO feature will result in IBM maintaining a record of this customer location as a DSLO user only. All material for the DSLO license will be provided through the basic license location. If a user selects DSLO, no other feature numbers are valid for this order and no program materials or updates will be shipped.

Unlicensed Documentation: A memo, program directory, and one copy of the following publications are supplied automatically with the basic machine-readable material:

                                                       Order
Title                                                  Number

DB2AUG Installation Guide SC23-0590 DB2AUG Reference Guide SC23-0591 DB2AUG Messages and Codes SC23-0592 DB2AUG Licensed Program Specification GC23-0593

Additional copies of unlicensed publications will be available for a fee after availability. These copies may be ordered from your IBM representative, through the System Library Subscription Service (SLSS), or by direct order.

Subsequent updates (technical newsletters or revisions between releases) to the publications shipped with the product will be distributed to the user of record for as long as a license for this software remains in effect. A separate publication order or subscription is not needed.



TERMS AND CONDITIONS

The terms for DB2 AUG, as previously announced in Software Announcement 294-461 294-461,:elink. dated July 26, 1994, licensed under the IBM Customer Agreement are unaffected by this announcement.

Support Line: S/390 (R)



CHARGES

The charges provided in this announcement are suggested retail prices for the U.S. only and are provided for your information only. Dealer prices may vary, and prices may also vary by country. Prices are subject to change without notice. For additional information and current prices, contact your local IBM representative.

Prices for DB2 Automated Utility Generator Release 3 are unaffected by this announcement.

OTC: Customers who pay an OTC for a licensed program receive enhancements and future releases, if any, at no additional charge. Significant new function may be offered as an optional feature and charged for separately. If a replacement program is announced and the customer elects to license the replacement program, a time-based upgrade credit may apply.

Variable Charges:

The applicable graduated OTC or graduated MLC will be based on the group of the designated machine on which the licensed program is licensed for use. If the program is designated to a processor in a group for which no charge is listed, the charge of the next higher group listed applies.

For upgrades of OTC licenses to a machine in a higher group, the upgrade charge will be the difference in the then current charges between the two groups. For downgrades of OTC licenses to a machine in a lower group, there will be no adjustment or refund of OTCs paid.

For upgrades or downgrades of MLC licenses, the MLC applicable to the higher or lower group will apply.

ESL OTC: OTC authorizes use only on IBM Entry End User/390 machines.

For additional product information, refer to Software Announcement 294-461 294-461,:elink. dated July 26,1994.



CALL NOW TO ORDER

To order, contact the IBM North America Sales Centers, your local IBM representative, or your IBM Business Partner (TM).

IBM North America Sales Centers, our national direct marketing organization, can add your name to the mailing list for catalogs of IBM products.

 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@vnet.ibm.com
 Mail:      IBM North America Sales Centers
            Dept. LE010
            P.O. Box 16848
            Atlanta, GA  30321-0848
 Reference: LE010

To identify your local IBM Business Partner or IBM representative, call 800-IBM-4YOU.

Note: Shipments will begin after the planned availability date.

Trademarks

      MVS/ESA, OS/390, DFSMS, MVS/DFP, DATABASE 2, QMF, PR/SM,
      Parallel Sysplex, and Business Partner are trademarks of
      International Business Machines Corporation in the United
      States or other countries or both.
      DB2, MVS, System/390, 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.