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
- TECHNICAL INFORMATION
- ORDERING INFORMATION
- TERMS AND CONDITIONS
- CALL NOW TO ORDER
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
----------------------------------------- For ordering, contact: Your IBM representative, an IBM Authorized Business Partner, or IBM DIRECT at 800-IBM-CALL Reference: LE010
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 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
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.
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
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
- 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
- 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.
All DB2 MVS/ESA customers should consider using DB2 Admin to reduce time and effort to manage and administer DB2 MVS/ESA databases.
Specified Operating Environment
Hardware Requirements: DB2 Admin will operate on any hardware supporting DB2 Version 2 Release 3 or higher.
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
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.
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.
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 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.
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.
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
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
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
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
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
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.
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.
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.
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.
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: firstname.lastname@example.org 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.