IBM DB2 Automated Utility Generator Release 3 Offers Enhanced Function and Improved Usability
October 28, 1997
Announcement Letter Number: 297-446
Table of Contents:
- At a Glance
- PRODUCT POSITIONING
- SUPPLEMENTAL INFORMATION
- TECHNICAL INFORMATION
- ORDERING INFORMATION
- TERMS AND CONDITIONS
- CALL NOW TO ORDER
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
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.
DB2 AUG is a DB2 productivity tool useful to all customers currently using or intending to use DB2.
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
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
- 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
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
- VSAM data sets that contain DB2 data
- Physical extents of a DB2 VSAM data set
- DASD volumes that contain DB2 data
DB2 AUG supports the following utilities and commands:
Check Index and Check Data
Full and Incremental Copy
Modify Statistics (DB2 Versions 3 and 4 only)
Rebind Plans and Packages
START Database (RW, RO, UT, and FORCE)
- 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
- Support for the following utility and functional changes in DB2 for OS/390 Version 5 (5655-DB2)
- The Front End Generate command (GEN option) has been enhanced
- 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
- Secondary allocation control when recalculating data set size
- Incremental copy percent changed algorithm saves space
- User modifiable class for SYSUDUMP
- Separate retention periods for DASD and Tape data sets
- Ability to generate a new job for each partition to allow partition independence support
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.
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.
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.
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
- 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)
- DFSMS (TM) Version 1 Release 2 (5695-DF1) or MVS Data Facility Product (MVS/DFP (TM)) Version 3 Release 3 (5665-XA3)
- 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
- Query Management Facility (QMF) Version 3 Release 2 (5706-254)
- Data Facility Hierarchical Storage Manager (DFHSM) Version 2
Release 6 (5665-329)
- Data Facility Data Set Services (DFDSS) Version 2 Release 5 (5665-327)
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.
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.
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.
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:
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
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
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)
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)
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.
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)
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.
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.
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: firstname.lastname@example.org 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.
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.