IMS Partition DB Version 2 Helps Improve Capacity and Availability

Software Announcement
September 29, 1998
Announcement Letter Number: 298-384


Table of Contents:

(Corrected on January 27, 1999)

In the Description section, the text under Simple Database Conversion was revised.

At a Glance

IMS/ESA Partition Support Product delivers on:

  • Extended database and index capacity
  • Improved database availability
IMS/ESA Partition Support Product:
  • Is transparent to application programs
  • Supports:
    • Up to 32 4-gigabyte partitions
    • Secondary Indexes
    • Logical Relationships
    • DBRC
  • Features simple conversion from current full function databases
  • Is supported by basic utilities provided with the IMS product
  • Is supported by the IBM System/Utilities Data Base Tools
  • Includes full set of partition-oriented reorganization utilities
-----------------------------------------
For ordering, contact:
  Your IBM representative, an IBM
  Business Partner, or IBM North America
  Sales Centers at
    800-IBM-CALL  Reference: LE010

EXTRA! EXTRA! . . .

Subscribe to IBM iSource, your electronic source for customized IBM information! Go to our web site at http://www.ibm.com/isource or send an e-mail to info@isource.ibm.com with the word SUBSCRIBE in the body.



Overview

Need more capacity?

The IMS/ESA (R) Partition Support Product for MVS/ESA (TM) (Partition DB) extends the data storage capacity of existing HDAM and HIDAM databases from the current 4 gigabyte limit to a full 128 gigabytes. Partition DB allows a database to be separated into as many as 32 partitions, each having a 4 gigabyte capacity. Now, full-function databases can be incrementally grown up to 128 gigabytes.

Partition DB Version 2 provides support for partitioned primary and secondary indexes, removing an inhibitor to realizing the full capacity value of database partitioning. Partition DB Version 2 also provides support for partitioned SHISAM and HISAM root only databases.

Need higher availability?

Partition DB can help improve availability. With partitioned databases, partitions can be reorganized independently or in parallel, helping to reduce the time the database is unavailable.

Partition DB Version 2 provides utilities supporting partitioned databases and partitioned primary and secondary indexes. Partition DB Version 2 utilities include a number of usability enhancements, including support for dynamic allocation.

Partition DB leads the way in providing improved capacity and availability for IMS (TM) Full Function database customers. Partition DB is transparent to DB application programs and their corresponding PSBs.



Intended Customers

Partition DB is intended for IMS/ESA full-function customers seeking:

  • Incremental growth beyond the 4 gigabyte limit

  • Extended operability and manageability

  • Higher availability



Key Prerequisites

Partition DB is designed to operate in IMS/ESA Version 5 and Version 6 environments. CICS (R) customers must use DB Control (DBCTL) rather than Local DL/I.

Previous Program Information

Previous Program Name and Number: 5697-A06 IMS/ESA Partition Support Product Version 1



Planned Availability Date

November 13, 1998

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

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

IMS/ESA Partition Support Product is designed to extend IMS/ESA database capacity and help improve database availability. Partition DB features include:

  • Application Program Transparency

    Partitioned databases are completely transparent to application programs. A single PCB is used to access the database. No PSB changes are required and no PSBgen needs to be performed. Minimal changes are required to the DBD to define the partitions, and a subsequent ACBgen is required; however, these changes do not affect the application program.

  • Increased Database Capacity

    A partitioned database may have from 1 to 32 partitions. Each partition is an MVS (TM) dataset and has a 4 gigabyte capacity.

  • Higher Availability

    Partition DB provides a set of fast partition reorganization utilities. The utilities include an unload, load, and index builder, and may be used to reorganize a single partition, multiple partitions in parallel, or the entire database.

  • Secondary Index Support

    Partitioned databases have the same secondary index capability as current non-partitioned databases. All application program DL/I calls using a PCB with secondary indexing will work as they currently do. Current HDCAMS DEFINE statements do not need to be changed.

    Partitioning imposes two implementation restrictions. Shared secondary indexes are not supported (that is, the CONST operand in the DBD's XDFLD macro is not supported). Secondly, secondary indexes with non-unique keys (that is, secondary indexes requiring a VSAM KSDS and ESDS pair) are not supported.

  • Dynamic Addition of Secondary Indexes

    Secondary indexes may be added to (or deleted from) a partitioned database without unloading the target database. Creating a new secondary index requires altering the target DBD, creating a new index DBD, and executing the Partition DB supplied Index Build utility.

  • Logical Relationship Support

    Support for logical relationships requires the use of symbolic pointing. All logical segments within a partitioned database must be accessed with symbolic pointers and all logical children must be physically paired.

  • DBRC Support

    Partitioned databases may be registered with DBRC. DBRC will view a partitioned database as a non-partitioned database with dataset groups.

  • Data Sharing Support

    Partitioned databases are fully supported by all IMS data sharing facilities.

  • IMS Utility Support

    Partitioned databases are fully supported by all database utilities supplied with the IMS/ESA program product. Partitions are viewed by these utilities as dataset groups. IMS System Utilities/Database Tools (5685-093) also supports partitioned databases.

  • Sustained Performance

    The processing performance of a partitioned database will usually be comparable to that of the same data in a non-partitioned database. However, the performance of a partitioned database could be improved over a non-partitioned database since partitioning would allow the data to spread over several datasets (and DASD volumes) thereby possibly reducing DASD arm contention. Additionally, all segments for a given database record are always stored in the same partition, which may reduce the distance the DASD arm moves when processing a disorganized database.

  • Simple Database Conversion

    Conversion of existing databases is achieved by simply unloading the existing database, changing the DBD, and reloading the database.



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 20th and 21st centuries, provided that all products (for example, hardware, software, and firmware) used with the product properly exchange accurate date data with it.



HARDWARE AND SOFTWARE SUPPORT SERVICES



SmoothStart (TM)/Installation Services

IBM SmoothStart or Installation Services will not be provided for the IMS Partition DB.

Trademarks

      MVS/ESA, IMS, MVS, and SmoothStart are trademarks of
      International Business Machines Corporation in the United
      States or other countries or both.
      IMS/ESA and CICS 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.



SUPPLEMENTAL INFORMATION



TECHNICAL INFORMATION



Specified Operating Environment

Hardware Requirements: Partition DB is designed to operate on any hardware supporting IMS/ESA (R) Version 5 or Version 6.

Software Requirements: Partition DB supports the following IMS/ESA Versions and requires SMP/E Version 1 (5668-949) for installation.

  • IMS/ESA Version 5 Release 1 (5695-176)
  • IMS/ESA Version 6 Release 1 (5655-158)
Note: OS/390 (R) (5645-001) is a valid substitute for all programs included in the OS/390 Base.



Security, Auditability, and Control

The announced program uses the security and auditability features of the supported IMS (TM) and/or MVS (TM) systems. 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



New Licensees

Orders for new licenses will be accepted now.

Shipment will begin on the planned availability date.

New users of IMS Partition DB should specify:

         Type           Model

5697 D85

Basic License: Specify the feature number of the desired distribution medium shown below.

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
                                          One-Time Charge
Program Number/Description                 Feature Number

5697-D85 IMS Partition DB 0001

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

Parallel Sysplex (R) 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
Machines            Feature        MLC Feature
MSU Capacity        Number         Description

1 0062 PSLC Base, 1 MSU 2 0063 PSLC Base, 2 MSUs 3 0064 PSLC Base, 3 MSUs

4 -- 45 0065 PSLC Level A, 1 MSU 0066 PSLC Level A, 42 MSUs

46 -- 175 0067 PSLC Level B, 1 MSU 0068 PSLC Level B, 10 MSUs 0069 PSLC Level B, 50 MSUs

176 or 1000 PSLC Level C, 1 MSU more 1001 PSLC Level C, 10 MSUs 1002 PSLC Level C, 50 MSUs

Not/Applicable 0070 PSLC N/C ID

Example 1: A single machine with 11 MSU PSLC program features is 0064, quantity 1 and 0065, quantity 8

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

  • PSLC Chargeable Program #1 -- 0064, quantity 1, 0066, quantity 1, 0067, quantity 5, and 0068, quantity 1.
  • PSLC No-Charge Program #2 -- 0070, quantity 1
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 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

IMS Partition DB - V5 5801 9/6250 bpi tape IMS Partition DB - V5 5802 3480 cartridge IMS Partition DB - V5 5045 4-mm cartridge IMS Partition DB - V6 5811 9/6250 bpi tape IMS Partition DB - V6 5812 3480 cartridge IMS Partition DB - V6 5047 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 Delivery Solutions (SDS) receives the order. SDS will then ship the order via overnight air transportation.

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

                                                  Order
Title                                             Number

IMS Partition DB User's Guide SC26-9501 IMS Partition DB Utilities User's Guide SC26-9502 IMS Partition DB General Information GC26-9500 Manual IMS Partition DB Licensed Program GC26-9503 Specification

Additional copies of unlicensed publications are available for a fee immediately. 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

Licensing: IBM Customer Agreement

Variable Charges Apply: No

Indexed Monthly License Charge (IMLC) Applies: No

Installation License or Location License Applies: No

Usage Restriction Applies: No

Educational Allowance: Yes, to qualified education customers.

Volume Discount: Not applicable

Version-To-Version Upgrade Credits Apply: Yes

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

5697-A06 IMS Partition 5697-D85 IMS Partition Yes DB Version 1 DB Version 2 5697-D85 IMS Partition To a follow-, Yes DB Version 2 on if any

Warranted: Yes

Licensed Program Materials Availability

  • Restricted Materials of IBM: None
  • Non-Restricted Source Materials: None
  • Object Code Only (OCO): All
Testing Period: Two months (Basic License Only)

Program Services

Support Center applies:            Yes
                                   Access is available through
                                    the IBM Support Center

Available until discontinued: 12 months' written notice

APAR Mailing Address: IBM Corporation 555 Bailey Ave San Jose, CA 95141



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.

                                One-Time Charge
Entry End User/390
  Entry Support License:             $1,598

MSU
Capacity     Description                          Charge

1 PSLC Base, 1 MSU $258 2 PSLC Base, 2 MSUs 435

3 PSLC Base, 3 MSUs 687

MSU
Capacity     Description                          Charge

4 -- 45 PSLC Level A, 1 MSU $ 31 PSLC Level A, 42 MSUs 1,302

46 -- 175 PSLC Level B, 1 MSU 12 PSLC Level B, 10 MSUs 120 PSLC Level B, 50 MSUs 600

176 or PSLC Level C, 1 MSU 9 more PSLC Level C, 10 MSUs 90 PSLC Level C, 50 MSUs 450

Note: For information regarding effective date, refer to Software Announcement 298-355 dated September 29, 1998.

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 the IBM North America Sales Centers, your local IBM representative, or your IBM Business Partner.

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 2690
            Atlanta, GA  30301-2690
 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

      IMS and MVS are trademarks of International Business Machines
      Corporation in the United States or other countries or both.
      IMS/ESA, OS/390, and Parallel Sysplex 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.