DATABASE 2 Administration Tool for MVS/ESA Version 1

June 27, 1995
Announcement Number: 295-320


Document's Table of Contents:


Abstract



In Brief . . .

DB2 Admin is a DB2 administration tool for SYSADM, DBADM, and DB2 application developers. DB2 Admin:

  • Contains extensive support for displaying the DB2 catalog
  • Provides extensive support for catalog administration
  • Provides support for table maintenance and application browsing under ISPF using dynamic SQL to access DB2 tables
  • Integrates with DB2 utilities and simplifies creation of DB2 utility jobs
----------------------------------------

DATABASE 2(TM) Administration Tool for MVS/ESA(TM) Version 1 (DB2(R) Admin) is a DB2 administration tool for DB2 system and database administrators and DB2 application developers. The tool provides support for table maintenance and application browsing under Interactive System Productivity Facility (ISPF) using dynamic SQL to access DB2 tables. DB2 Admin is designed to:

  • Increase productivity of the DB2 staff
    • Save time in DB2 administration
    • Provide an overview of DB2 system tables
    • Provide relevant DB2 catalog/directory information quickly and logically
  • To be an interactive, intuitive, easy-to-use DB2 catalog tool
  • Integrate with DB2 utilities
  • Simplify creation of DB2 utility jobs
  • Provide extensive support for displaying the DB2 catalog including:
    • Predefined select criteria (predicates) for most commonly used selects on the catalog.
    • Related objects can be shown by using line commands.
    • Analysis of the information in the catalog.
    • The authorization of DB2 objects can be shown and DB2 Admin can issue GRANT and REVOKE on the objects.
    • BIND, REBIND and FREE can be invoked for selected plans and packages.
    • Display of the static SQL for selected Database Request Modules (DBRMs) and packages.
Price: One-time and monthly license charges apply.

Planned Availability Date: June 30, 1995

(TM)  Trademark of International Business Machines Corporation
(R)   Registered trademark of International Business Machines
      Corporation



DESCRIPTION

DB2 Admin is a DB2 administration tool that provides extensive support for catalog administration.

  • Contains extensive support for displaying the DB2 catalog, including:
    • Predefined select criteria (predicates) for most commonly used selects on the catalog.
    • Related objects can be shown by using line commands.
    • Analysis of the information in the catalog.
    • Display of a DB2 object's authorization. DB2 Admin can issue GRANT and REVOKE on the objects.
    • BIND, REBIND and FREE can be invoked for selected plans and packages.
    • Display of the static SQL for selected DBRMs and packages.
    • Possible display of the DDL for existing views.
    • Generation of DB2 utility jobs for selected objects, that is, COPY, REORG, RUNSTATS for selected TABLESPACEs.
    • Possible issue of DB2 commands (DISPLAY, START, STOP....) against selected DATABASEs or TABLESPACEs.
    • Support for DB2 Version 2 Release 2 Distributed Database Facilities (DDF):
      • Remote DB2 catalog support
      • ALIAS support
      • Administration functions for the Communications Data Base (CDB)
    • The catalog functions can optionally run on tables containing a copy of the system catalog.
    • Functions for administration of the Resource Limit tables (RLIMIT).
  • Can execute any dynamic SQL statement.
  • Will issue COMMIT/ROLLBACK before each display.
  • Can easily be extended to display/update any DB2 table. A sample function is provided with the product.
  • Can issue any DB2 command. The commands are passed to IFI and the result is shown in ISPF browse.
  • Has a quick EXPLAIN function, that is, can issue an EXPLAIN and show the inserted rows in the PLAN_TABLE.
  • Can save results of a SQL SELECT as ISPF tables.
  • Can (re)display the saved tables.
  • Can print selected columns from the ISPF tables.



TECHNICAL INFORMATION



Specified Operating Environment

This product uses only existing attachment interfaces.

Hardware Requirements: The machine configuration required of DB2 Admin is the same as that of DATABASE 2 Version 2 for MVS or DATABASE 2 Version 3 for MVS.

Software Requirements: DB2 Admin requires the following software:

  • DATABASE 2 Version 2 Release 3 for MVS (5665DB2) or DATABASE 2 Version 3 for MVS/ESA (5685DB2)
  • ISPF Version 3 Release 3 or subsequent releases (5685054) and ISPF/PDF Version 3 Release 3 or subsequent releases (5655042) or ISPF Version 4 (5655042)
  • PL/I (one of the following):
    • OS PL/I Version 2 Release 3 Compiler, Library and Interactive Test Facility (5668909)
    • OS PL/I Version 2 Compiler and Library (5668910)
  • IBM SAA(R) AD/Cycle(R) PL/I MVS/ESA and VM Release 1 or subsequent releases (5688235) and LE/370 Version 1 Release 2 or subsequent releases (5688198)
  • TSO/E Version 2 Release 1 through Release 4 (5685025)
  • MVS/ESA SP-JES2 Version 4 Release 2.2 or subsequent releases (5695047)
  • SMP/E(TM) Release 8 (5668949) or a subsequent release (required for installation only)
User Group Requirements: This announcement satisfies or partially satisfies four requirements from one or more of the worldwide user group communities, which include Australasian SHARE/GUIDE (ASG), COMMON, COMMON Europe, GUIDE International, G.U.I.D.E. Europe, Japan GUIDE/SHARE (JGS), Guide Latin American (LAG), SHARE EUROPE and SHARE Incorporated.
  • REQ00041130 -- Catalog Visibility in DB2 V3
  • REQ00002752 -- Recover Utility can use a relative copy number to recover to
  • REQ00002755 -- Have RECOVER TOCOPY also recover indexes
  • REQ00011379 -- Option to specify GDG number in RECOVER TOCOPY statement



Planning Information



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 advance publications are available now. To order, contact your IBM representative.

                                  Order
Title                             Number

DB2 Admin User's Guide SC26-8428 DB2 Admin Licensed Program Specification GC26-8429



New Licensees

Orders for new licenses will be accepted now.

Shipment will begin on the planned availability date.

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.

Also, specify the feature number of the desired distribution medium.

                 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 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 following 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): Specify the program number, feature number 9001 for asset registration and the applicable ESL one-time charge feature number. Also specify the feature number of the desired distribution medium (specify the 1/4-inch, 9/1600 or 9/6250 media feature code).

                                               ESL
Program                                  One-Time Charge
Number             Description            Feature Number

5688-515 MVS/ESA 0120

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

Parallel Sysplex 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 (MSUs) in your Parallel Sysplex. For all other program copies, specify the PSLC No Charge (N/C) Identifier feature.

Also, specify the feature number of the desired distribution medium.

                  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

registration 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 MSUs 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
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

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. In the future if publication updates were 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 Manufacturing Solutions (ISMS) receives the order. ISMS 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 following feature number corresponding to the group that contains the designated machine.

               MOSP DSLO                MOSP DSLO
               Graduated                Graduated
            One-Time Charge       Monthly 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

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.

Displayable Softcopy Publications: The DB2 Admin User's Guide is offered in displayable softcopy form. All unlicensed manuals are included. The files are shipped on the Transaction Processing and Data CD-ROM (SK2T-0730).

These displayable manuals can be used with the BookManager(R) READ licensed programs in any of the supported environments. Terms and Conditions for use of the machine-readable files are shipped with the files.

If you wish to receive one FREE copy of the IBM Online Books for the Transaction Processing and Data CKit CD-ROM, please order through one of the prerequisite base products as follows:

  • Program Number 5665-DB2 Feature 7040 or
  • Program Number 5685-DB2 Feature 7040
In the United States, you may call the ISMS Field Support toll free number, 800-879-2755 and select the option for Software Assistance, to request an MES order. They will add the respective 7040 feature to the active license and ship a CD-ROM. Once a customer is registered for the CD-ROM feature, it will guarantee the shipment of all future updates of the Software CD-ROM Collection Kit. Please ensure that ISMS is supplied with the customer number, serial number, product number, and feature code.

If you wish to order additional copies of the IBM Online Books Transaction Processing and Data CKit on CD-ROM, please place an order for program product 5636-PUB and the following two feature codes:

  • CD-ROM Annual Publication Charge -- Feature 2023
  • CD-ROM Media -- Feature 5023
This order must be placed on AAS via the local IBM office. Current and active licensees of 5636-PUB will always receive free updates to the Softcopy CD-ROM Collection Kit.

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

Licensing: The program in this announcement is licensed under the terms of the IBM Customer Agreement.

Variable Charges Apply: Yes

System/390 Multiple Operating Systems -- PR/SM (MOSP): Charge Option Attachment applies for graduated charge programs licensed to a qualifying machine.

Parallel Sysplex License Charge (PSLC): The Parallel Sysplex License Charge applies.

Installation License or Location License Applies: No. A separate license is required for each machine on which the licensed program materials will be used.

Entry End-User/390 Attachment Applies: Yes. Terms and conditions applicable to basic and DSLO licenses also apply to Entry Support License.

Educational Allowance: A 15% educational allowance is applicable toward eligible license charges and is available to qualifying institutions in accordance with the Educational Allowance Attachment.

The educational allowance may not be added to any other discount or allowance.

Volume Discount: Not applicable

Version Upgrades: Version-To-Version Upgrade Credits Apply: Yes.

                                                      Single
Replaced                  Replacement                 Version
Program      Program      Program       Program       Charging
Number       Name         Number        Name          Applies

5688-515 DB2 Admin To all follow-on, if any N/A

Warranted: Yes

Licensed Program Materials Availability: Restricted Materials -- No. This licensed program will be available without source licensed program materials for some modules. These modules will be available in object code. The remaining modules will be available with source licensed program materials.

Please refer to publication SC26-8428 available on June 30, 1995, for the identity of those components with some or all modules available without source licensed programs materials.

Testing Period: Basic License -- Two months. DSLO -- Not applicable.

Program Services: Central Service, including the IBM Support Center, will be available until discontinued by IBM upon six months' written notice.

Central service, including the IBM Support Center, for DSLO licenses will be provided only through the customer location designated for the basic license.



CHARGES

Program Number 5688-515

Basic DSLO Basic DSLO Graduated Graduated Monthly Monthly One-Time One-Time License License Group Charge Charge Charge Charge

18 $ 1,920 $ 1,440 $ 40 $ 30 20 2,735 2,050 57 43 25 3,550 2,665 74 56 28 4,895 3,670 102 77 29 6,385 4,790 133 100 30 8,305 6,230 173 130 31 10,220 7,665 213 160 32 13,060 9,795 272 204 35 15,020 11,270 313 235 38 17,280 12,960 360 270 40 19,820 14,870 413 310 50 24,820 18,620 517 388 60 31,010 23,260 646 485 70 38,780 29,090 808 606 80 48,480 36,360 1,010 758

                                         MOSP         MOSP
            MOSP          MOSP           Basic        DSLO
            Basic         DSLO           Graduated    Graduated
            Graduated     Graduated      Monthly      Monthly
            One-Time      One-Time       License      License
Group       Charge        Charge         Charge       Charge

18 $ 1,870 $ 1,405 $ 39 $ 29 20 2,330 1,750 49 36 25 3,145 2,360 66 49 28 4,225 3,170 88 66 29 5,640 4,230 118 88 30 7,345 5,510 153 115 31 9,265 6,950 193 145 32 11,640 8,730 243 182 35 14,040 10,530 293 219 38 16,150 12,110 337 252 40 18,550 13,910 387 290 50 22,320 16,740 465 349 60 27,910 20,930 582 436 70 34,900 26,180 727 545 80 43,630 32,720 909 682

MSU
Capacity       Description                  Charge

3 PSLC Base, 3 MSU $272

4 -- 45 PSLC Level A, 1 MSU 12 PSLC Level A, 42 MSU 504

46 or more PSLC Level B, 1 MSU 5 PSLC Level B, 10 MSU 50 PSLC Level B, 50 MSU 250

                                   One-Time
                                   Charge

Entry Support License $632

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.