DATABASE 2 Administration Tool for MVS/ESA Improves with Release 2

August 27, 1996
Announcement Number: 296-294


Document's Table of Contents:




At a Glance

Dramatically reduce the effort required to support DB2. Use DB2 Admin to:

  • Display and interpret objects in the DB2 catalog

  • Execute dynamic SQL statements

  • Generate JCL and run DB2 utilities

  • Issue DB2 commands against databases and table spaces

  • Manage SQLIDs

  • Perform complex performance and space utilization queries

  • Simplify system administration functions
DB2 Admin fully supports DB2 Version 4.1.
-----------------------------------------
For ordering, contact:
  Your IBM representative, an IBM Authorized
  Business Partner, or IBM DIRECT at
    800-IBM-CALL  Reference: LE010



Overview

As the number and complexity of DATABASE 2(TM) (DB2(R)) MVS/ESA(TM) applications and systems increase, having the right DB2 tools has never been more important.

DB2 Administration Tool for MVS/ESA is the right tool to help you get the most from your DB2 system. DB2 Admin's comprehensive set of database management functions helps DB2 systems personnel efficiently and effectively manage your DB2 environment by:

  • Saving time in DB2 administration
  • Simplifying routine day-to-day DB2 tasks
  • Increasing knowledge and understanding of your DB2 system
DB2 Admin exploits the functionality of DB2 Version 4.1 by providing panels and options that allow you to quickly see new pertinent catalog information. DB2 Admin works on a data sharing group member level.

DB2 Admin Release 2 provides usability enhancements, lower overhead costs, better error recovery, and more extensive online help. Highlights include:

  • Calculation and display of the hit ratios of the buffer pools
  • Display of all indexes and index columns for a table
  • Improved DB2 Admin print capabilities
  • EXPLAIN of long SQL statements
  • Reuse of DB2 commands
  • User initiated stopping of SQL processing
With the power packed capabilities of DB2 Admin Release 2, there's never been a better time than now to consider ordering DB2 Admin.



Intended Customers

DB2 Admin Tool helps DB2 MVS(R) system personnel understand DB2 catalog information and perform a full range of database management functions and tasks to help ensure high performing DB2 applications. DB2 Admin is recommended for catalog query and database management on the DB2 MVS/ESA platform.



Key Prerequisites

DB2 Admin is designed for use with DB2 Version 2.3, DB2 Version 3.1, and DB2 Version 4.1. TSO/E, ISPF, and PL/I Library are required. Refer to the Technical Information section for additional information.

Planned Availability Date

August 30, 1996

Program Number

5688-515



DESCRIPTION

DB2 Admin offers a robust set of database management functions for DB2 MVS systems personnel. As your enterprise expands its DB2 usage and systems environment, you may need to manage multiple complex DB2 systems, perhaps in several locations. DB2 Admin simplifies database administration and allows you to manage these systems more efficiently and effectively.

DB2 Admin is an easy-to-use ISPF panel driven tool which overviews DB2 system tables and provides relevant DB2 catalog information in a logical format. Designed to be an interactive and intuitive tool to learn and use, DB2 Admin integrates with DB2 utilities and simplifies creation of DB2 utility jobs. Among DB2 Admin's strengths is the extensive support to simplify understanding and analysis of the DB2 catalog and allow you to intelligently act on the information presented. The abundant DB2 catalog query capabilities in DB2 Admin include:

  • Predefined select criteria (predicates) for most commonly used SELECTs on the catalog
  • DB2 objects authorization and relationships can be shown
  • GRANT and REVOKE on the objects
  • BIND, REBIND and FREE for selected plans and packages
  • Display of the static SQL for selected Database Request Modules (DBRMs) and packages
DB2 Admin Release 2 offers new panels and options for DB2 Version 4.1 including:
  • Partition independence
  • Type 2 indexes
  • Row locking
  • Maximum number of user locks
  • Read through locks
  • Parallel query processing
  • DFSMS(TM) Concurrent Copy
  • Stored procedures
  • Outer Join
  • Table check constraints
  • User defined default values
  • Cancel thread
  • Dynamic rules BIND option
  • Restrict on DROP
  • New REFERENCES privilege
DB2 Admin's power packed functionality still includes:
  • Display of the DDL for existing views
  • Generation of DB2 utility jobs for selected objects (COPY, REORG, RUNSTATS for selected TABLESPACEs)
  • Support of DB2 Distributed Database Facilities (DDF) including remote DB2 catalog support, ALIAS support and Communications Data Base (CDB)
  • Catalog functions can optionally run on tables containing a copy of the system catalog
  • Functions for administration of the Resource Limit tables (RLIMIT)
  • Dynamic SQL statement execution without knowing the exact SQL syntax
  • COMMIT/ROLLBACK issued before each display
  • Ability to be extended to display/update any DB2 table. A sample function is provided with the product.
  • Ability to issue any DB2 command. The commands are passed to IFI and the result is shown in ISPF browse.
  • A quick EXPLAIN function that can show the inserted rows in the PLAN_TABLE.
  • Ability to save results of a SQL SELECT as ISPF tables.
  • Ability to (re)display the saved tables.
  • Ability to print selected columns from the ISPF tables.
This product uses no new attachment interfaces.



PRODUCT POSITIONING

All DB2 MVS/ESA customers should consider using DB2 Admin to reduce time and effort to manage and administer DB2 MVS/ESA databases.



TECHNICAL INFORMATION



Specified Operating Environment

Hardware Requirements: DB2 Admin will operate on any hardware supporting DB2 Version 2 Release 3 or higher.

Software Requirements

DB2 Admin requires the following software:

  • DB2 Version 2 Release 3 for MVS/ESA (5665-DB2) or DB2 Version 3 for MVS/ESA (5685-DB2) or DB2 Version 4 for MVS/ESA (5695-DB2)
  • ISPF Version 3 Release 3 (5685-054) or ISPF Version 4 (5655-042) or subsequent releases
  • ISPF/PDF Version 3 Release 3 or subsequent releases (5665-402)
  • PL/I (one of the following):
    • OS PL/I Version 2 Release 3 Compiler, Library and Interactive Test Facility (5668-909)
    • OS PL/I Version 2 Compiler and Library (5668-910)
    • OS PL/I Version 2 Library Only (5668-911)
    • LE/370 Version 1 Release 2 or subsequent releases (5688-198)
  • TSO/E Version 2 Release 1 through Release 4 (5685-025)
  • MVS/ESA SP(TM)-JES2 Version 4 Release 2.2 or subsequent releases (5695-047)
  • SMP/E Release 8 (5668-949) or subsequent releases (required for installation only)
  • SMP/E Release 8 (5668-949) or subsequent releases
Note: OS/390(TM) (5645-001) is a valid substitute for all programs included in the OS/390 Base.

Compatibility: DB2 Admin Release 2 is fully compatible and supports DB2 Version 2.3, DB2 Version 3.1, and DB2 Version 4.1. DB2 Admin will provide support for DB2 Version 4.2, announced in a preview on April 2, 1996, when it becomes generally available.

The catalog contents and structure depend on the version and release of DB2. DB2 Admin takes this into account and reflects the appropriate view.



Planning Information

Installability: DB2 Admin is designed to be easy to install. All DB2 Admin Release 1 customers should migrate to Release 2 at their earliest convenience in order to reap all the advantages provided in Release 2. Migration is made easier by eliminating unnecessary rework. The optional user customization made to DB2 Admin Release 1 can be saved and applied to Release 2.



Security, Auditability, and Control

The announced program uses the security and auditability features of the supported DB2 and/or MVS/ESA systems.

User management is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.



ORDERING INFORMATION

The following publications will be available on August 30, 1996, and can be ordered from your IBM representative.

                                                  Order
Title                                             Number

DB2 Admin User's Guide SC26-8428 DB2 Admin Licensed Program Specification GC26-8429 DB2 Admin Demonstration Diskette SN68-1322



Current Licensees

Current licensees of DB2 Administration Tool for MVS/ESA Release 1 will receive this update from IBM Software Manufacturing Solutions (SMS) automatically. The shipment of Release 2 is scheduled to be completed by September 20, 1996.



New Licensees

Orders for new licenses will be accepted now.

Shipment will begin on the planned availability date.

  • Orders that ship prior to the planned availability will receive DB2 Administration Tool Release 1.

  • Orders that ship after the planned availability date will receive DB2 Administration Tool Release 2.
New users of DB2 Admin should specify:
          Type        Model

5688 515

Basic License

To order a basic license, specify the program number and feature number 9001 for asset registration. For a graduated one-time charge or graduated monthly license charge, specify one of the following feature numbers as applicable and corresponding to the group that contains the designated machine:

                    Basic                     Basic
                  Graduated             Graduated Monthly
               One-Time Charge            License Charge
Group           Feature Number            Feature Number

18 0122 0121 20 0015 0001 25 0016 0002 28 0017 0003 29 0018 0004 30 0019 0005 31 0020 0006 32 0021 0007 35 0022 0008 38 0023 0009 Basic Basic Graduated Graduated Monthly One-Time Charge License Charge Group Feature Number Feature Number

40 0024 0010 50 0025 0011 60 0026 0012 70 0027 0013 80 0028 0014

Multiple Operating System -- PR/SM(TM) (MOSP): For a graduated one-time charge or graduated monthly license charge, specify the feature numbers corresponding to the group that contains the designated machine.

                  MOSP Basic                MOSP Basic
                  Graduated             Graduated Monthly
               One-Time Charge            License Charge
Group           Feature Number            Feature Number

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

Note: The group can be determined by referring to either the Exhibit for IBM System/370(TM) and System/390(R) Machines (Z125-3901) or the Exhibit for Non-IBM Machines (Z125-3902) that are 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 one-time charge feature number.

Program                                ESL One-Time Charge
Number            Description             Feature Number

5688-515 MVS/ESA 0120

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 and applicable PSLC Level A and PSLC Level B features and quantity.

In a Parallel Sysplex, if there is more than one program copy, the charge for all copies should be associated with one copy by specifying the applicable PSLC feature numbers and quantity represented by the sum of the Service Units in Millions (MSU's) in your Parallel Sysplex. For all other program copies specify the PSLC No Charge (N/C) Identifier feature.

                    PSLC           PSLC Basic License
Machine(s)          Feature        MLC Feature
MSU Capacity        Number         Description

3 0113 PSLC Base, 3 MSU

4 -- 45 0114 PSLC Level A, 1 MSU 0115 PSLC Level A, 42 MSU

46 or more 0116 PSLC Level B, 1 MSU 0117 PSLC Level B, 10 MSU 0118 PSLC Level B, 50 MSU

Not/Applicable 0119 PSLC N/C ID

Example 1: A single machine with 11 MSU's PSLC program features are 0113, quantity 1 and 0114, quantity 8.

Example 2: Two machines with 60 aggregate MSU's in a Parallel Sysplex PSLC program features are:

  • PSLC chargeable program #1 -- 0113 quantity 1, 0115 quantity 1, 0116 quantity 5 and 0117 quantity 1
  • PSLC no charge program #2 -- 0119 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 MSU feature and the applicable additional IMLC MSU feature(s) and quantity corresponding to the MSU rating of the designated machine.
          IMLC             IMLC Basic License
          Feature          MLC Feature
          Number           Description

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

Version-To-Version Upgrade Credit: To upgrade from a prior program acquired for a one-time charge 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
Environment          Number           Distribution Medium

DB2 Admin 5891 9/6250 BPI tape DB2 Admin 5892 3480 tape cartridge DB2 Admin 7538 4-mm tape cartridge

Customization Options:

Select the appropriate feature number(s) 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, and for future updates, specify feature numbers 3470 to ship media only, and 3480 to ship media updates only. If publication updates are required, order an MES to remove feature number 3480, and the publications will ship with the next release for the program.

                                                    Feature
Description                                         Number

Initial Shipments

Serial Number Only (suppresses shipment of media and documentation) 3444

Ship Media Only (suppresses initial shipment of documentation) 3470

Ship Documentation Only (suppresses initial shipment of media) 3471

Update Shipments

Ship Media Updates Only (suppresses update shipment of documentation) 3480

Ship Documentation Only (suppresses update shipment of media) 3481

Suppress Updates (suppresses update shipment of media and documentation) 3482

Expedite Shipments

Local IBM Office Expedite (for IBM use only) 3445

Customer Expedite Process Charge ($30 charge for each product) 3446

Expedite shipments will be processed to receive 72 hour delivery from the time IBM Software Distribution (ISMD) receives the order. ISMD 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 for a graduated one-time charge or graduated monthly license charge that corresponds to the group containing the designated machine.

                     DSLO                      DSLO
                  Graduated             Graduated Monthly
               One-Time-Charge            License Charge
Group           Feature Number            Feature Number

18 0126 0125 20 0071 0057 25 0072 0058 28 0073 0059 29 0074 0060 30 0075 0061 31 0076 0062 32 0077 0063 35 0078 0064 38 0079 0065 40 0080 0066 50 0081 0067 60 0082 0068 70 0083 0069 80 0084 0070

Multiple Operating System -- PR/SM (MOSP): For a graduated one-time charge or graduated monthly license charge, specify the feature number corresponding to the group that contains the designated machine.

                  MOSP DSLO                 MOSP DSLO
                  Graduated             Graduated Monthly
               One-Time Charge            License Charge
Group           Feature Number           Feature Numbers

18 0128 0127 20 0099 0085 25 0100 0086 28 0101 0087 29 0102 0088 30 0103 0089 31 0104 0090 32 0105 0091 35 0106 0092 38 0107 0093 40 0108 0094 50 0109 0095 60 0110 0096 70 0111 0097 80 0112 0098

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 must be ordered by the basic licensee. 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 program directory and one copy of the following publications are supplied automatically with the basic machine-readable material:

                                                  Order
Title                                             Number

DB2 Admin for MVS/ESA User's Guide SC26-8428 DB2 Admin Licensed Program Specification GC26-8429 DB2 Admin Demonstration Diskette SN68-1322

Additional copies of unlicensed publications will be available for a fee after product 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 Admin Tool, as previously announced (Software Announcement 295-320), licensed under the IBM Customer Agreement are unaffected by this announcement.

Program Currency: Program services previously announced for DB2 Administration Tool for MVS/ESA Release 1 will be available until September 30, 1998.



CHARGES

Current charges are not affected. For additional information, refer to Software Announcement 295-320, dated June 27, 1995.

One-Time Charge: Customers who pay a one-time charge 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 and replace the prior program, a time-based upgrade credit may apply.

Variable Charges: The applicable graduated one-time charge or graduated monthly license charge 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 above, the charge of the next higher group listed applies.

For upgrades of one-time charge 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 one-time charge licenses to a machine in a lower group, there will be no adjustment or refund of one-time.

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

Entry Support License One-Time Charge: One-time charge authorizes use only on IBM Entry End User/390 Machines.



CALL NOW TO ORDER

To order, contact IBM Direct, your local IBM representative, or your IBM Authorized Business Partner.

IBM Direct, our national direct marketing organization, can also arrange to put your name on the mailing list for catalogs of IBM products.

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

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

Note: Shipments will begin after the planned availability date.

(TM)  Trademark of International Business Machines Corporation in the
      United States or other countries or both.
(R)   Registered trademark of International Business Machines
      Corporation in the United States or other countries or both.