IMS/ESA Partition DB Has "More" of What You Need

August 27, 1996
Announcement Number: 296-295


Document's Table of Contents:


(Corrected on August 20, 1996) Availability Date for product and publications changed to December 6, 1996.

At a Glance

IMS/ESA Partition Support Product delivers on:

  • Extended database 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 all IBM IMS utilities

  • Is supported by IBM System Utilities/Data Base Tools

  • Includes full set of partition-oriented reorganization utilities
-----------------------------------------
For ordering, contact:
  Your IBM representative, an IBM Authorized
  Business Partner, or IBM DIRECT at
    800-IBM-CALL  Reference: LE010



Overview

Need more capacity? IMS/ESA(R) has "More" with the IMS(TM)/ESA Partition Support Product for MVS/ESA(TM) (Partition DB). 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 experience incremental growth up to 128 gigabytes.

Need more availability? Partition DB can help improve availability. Now you can reorganize each partition independent of other partitions, thus allowing access to those partitions while the reorganization activity is taking place. In addition, multiple partitions may be reorganized concurrently in a multi-task environment reducing the time to reorganize the complete database.

As databases grow larger, Partition DB can help improve manageability. Large databases can be divided into multiple, smaller, more manageable pieces. This offers more flexibility in the allocation and placement of databases on storage devices.

Database partitioning is completely transparent to application programs. No change to the existing application program or its PSB is required. A single PCB is used to access a partitioned database.



Intended Customers

IMS/ESA Partition Support Product is intended for those IMS/ESA full function customers seeking:

  • Incremental growth beyond the 4 gigabyte limit
  • Extended operability and manageability
  • Higher availability



Key Prerequisites

IMS/ESA Partition Support Product is designed to operate in IMS/ESA Version 4 and IMS/ESA Version 5 environments. The Partition Support Utilities require a sort program such as IBM's DFSORT(TM) or equivalent. CICS(TM) customers must use DB Control (DBCTL) rather than Local DL/I.

Planned Availability Date

December 6, 1996

Program Number

5697-A06



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 one to 32 partitions. Each partition is an MVS(R) dataset and has a 4 gigabyte capacity.

  • Higher Availability

    Partition DB provides a fast, partition reorganization facility. This allows the other partitions in the database to be available for processing while one partition is being reorganized. The partition being reorganized is available for read-only processing for most of the reorganization process.

    Additionally, Partition DB provides the ability to reorganize two or more partitions concurrently using MVS/ESA subtasking. This provides the ability to reorganize a complete partitioned database much faster than the same data in a non-partitioned 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. The current HDCAMS DEFINE statements do not need to be changed.

    There are two implementation restrictions imposed by partitioning. The first is shared secondary indexes are not supported (that is, the CONST operand in the DBD's XDFLD macro is not supported). The second is that 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 IMS/ESA. Partitions are viewed by these utilities as dataset groups. IMS System Utilities/Data Base 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.

  • Improved DLI Database Statistics

    The partition reorganization utility generates a number of significant reports including a series of reports showing reorganization results.

  • Simple Database Conversion

    Partition DB provides several conversion aids to assist in the conversion of existing databases to partitioned databases. They include an "Auditor" which examines database candidates for convertibility to partitioned, a HIDAM root key analyzer that helps determine key ranges for partitions, and an HDAM randomizer analyzer to help evaluate the effectiveness of the proposed randomizer for the root keys of a given database.

    Actual conversion of existing databases in achieved by simply unloading the existing database, changing the DBD, and reloading the database. If secondary indexes are present, then the standard IMS-provided utilities must also be run.



PRODUCT POSITIONING

As IMS databases grow larger to support business operations, the need to reach beyond the 4 gigabyte space limitation will become more pressing. Partition DB provides a solution now to enable customers to grow their IMS databases and manage them appropriately. As IMS moves into the future, the partitioning extensions will be incorporated into the IMS base product.



TECHNICAL INFORMATION



Specified Operating Environment

Hardware Requirements: The IMS/ESA Partition Support Product is designed to operate on any hardware supporting IMS/ESA Version 4 or higher.

Software Requirements: The following minimum versions and releases of programs are required for installing and operating the IMS/ESA Partition Support Product. Follow-on versions or releases of these products can be used unless otherwise stated.

  • SMP/E Version 1 Release 5 (5668-949)
  • IMS/ESA Database Manager Version 4 (5685-012)
Note: OS/390(TM) (5645-001) is a valid substitute for all programs included in the OS/390 Base.

Limitations: IMS/ESA Partition Support Product is designed to operate in IMS/ESA Version 4 and IMS/ESA Version 5 environments. The following restrictions apply:

  • Each index (primary or secondary) is stored in a single VSAM KSDS. It must be able to hold all index records for all target segments in all partitions.
  • HDAM root segments must have a key field.
  • Key field in root segment cannot be compressed.
  • DS groups are not supported.
  • Only physically paired logical relationships with symbolic pointers are supported.
  • The *T command code is not supported.
  • IBM's Partial DB Reorg feature is not supported.
  • XRF and RSR are not supported.
  • Hierarchical pointers (PTR=H) are not supported.
  • Shared secondary indexes are not supported.
  • Non-unique secondary indexes are not supported.
  • DOS compatible indexes are not supported.
Performance Considerations: Performance of a partitioned database should be comparable or better than that of the same data in a non-partitioned database. Since each partition is a separate dataset, the data can now spread over more DASD volumes. Additionally, each HDAM partition has its own overflow area which allows those segments placed there to be closer to its root segment. HIDAM segments which would normally be placed at the end of the database would now be placed at the end of the partition containing its root segment.



Planning Information

Installability: To migrate an existing HISAM, HIDAM, or HDAM database to a partitioned HIDAM or HDAM database the following steps are performed:

  1. Unload current database using standard, IBM-provided (DFSURGU0) HD Reorganization Unload utility
  2. Change DBD source adding PART statements
  3. Perform a DBDgen and ACBgen
  4. Reload the database using standard, IBM-provided (DFSURGL0) HD Reorganization Reload utility
  5. Image copy the partitioned database using standard, IBM provided (DFSUDMP0) Image Copy utility
  6. Notify DBRC and alter any JCL
Note: If secondary indexes are present, then the standard IBM provided utilities must also be run. They include the following:
  1. DB Prereorganization
  2. DB Scan
  3. DB Prefix resolution
  4. HISAM Reorganization Unload
  5. HISAM Reorganization Reload
IMS System Utilities/Data Base Tools (5685-093) components, such as High Speed Sequential Retrieval (HSSR) and Fast Reorganization Reload (FRR), may be used in lieu of the standard IMS provided utilities. All IMS System Utilities/Data Base Tools components support the partitioned environment.



Security, Auditability, and Control

This product relies on the security and auditability features of the supported IMS and/or MVS 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 will be available as indicated. To order, contact your IBM representative.

                                Order           Availability
Title                           Number          Date

IMS/ESA Partition Support Product User's Guide and Reference SC26-8870 12/06/96 IMS/ESA Partition Support Product Licensed Program Specification GC26-8871 12/06/96



New Licensees

Orders for new licenses will be accepted now.

Shipment will begin on the planned availability date.

New users of IMS/ESA Partition Support Product should specify:

          Type        Model

5697 A06

Basic License

Table A:

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 1116 1101 20 1117 1102 25 1118 1103 28 1119 1104 29 1120 1105 30 1121 1106 31 1122 1107 32 1123 1108 35 1124 1109 38 1125 1110 40 1126 1111 50 1127 1112 60 1128 1113 70 1129 1114 80 1130 1115

Multiple Operating System -- PR/SM(TM) (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 Basic                MOSP Basic
                  Graduated             Graduated Monthly
               One-Time Charge            License Charge
Group           Feature Number            Feature Number

18 1146 1131 20 1147 1132 25 1148 1133 28 1149 1134 29 1150 1135 30 1151 1136 31 1152 1137 32 1153 1138 35 1154 1139 38 1155 1140 40 1156 1141 50 1157 1142 60 1158 1143 70 1159 1144 80 1160 1145

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 is 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. Also specify the feature number of the desired distribution medium.

Program                                ESL One-Time Charge
Number         Description                Feature Number

5697-A06 IMS/ESA Partition Support Product 1100

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 (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 1161 PSLC Base, 3 MSU

4 -- 45 1162 PSLC Level A, 1 MSU 1163 PSLC Level A, 42 MSU

46 or more 1164 PSLC Level B, 1 MSU 1165 PSLC Level B, 10 MSU 1166 PSLC Level B, 50 MSU

Not/Applicable 1167 PSLC N/C ID

Example 1: A single machine with 11 MSUs PSLC program features are 1161, quantity 1 and 1162, quantity 8.

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

  • PSLC chargeable program #1 -- 1161 quantity 1, 1163 quantity 1, 1164 quantity 5 and 1165 quantity 1
  • PSLC no charge program #2 -- 1167 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.

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

          IMLC           IMLC Basic License
          Feature        MLC Feature
          Number         Description

1168 IMLC Base 80 MSUs 1169 IMLC 1 MSU 1170 IMLC 10 MSUs 1171 IMLC 50 MSUs

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

PSP Basic 5891 9/6250 bpi tape PSP Basic 5892 3480 cartridge PSP Basic 5511 4-mm 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 (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 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 1198 1183 20 1199 1184 25 1200 1185 28 1201 1186 29 1202 1187 30 1203 1188 31 1204 1189 32 1205 1190 35 1206 1191 38 1207 1192 40 1208 1193 50 1209 1194 60 1210 1195 70 1211 1196 80 1212 1197

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 1228 1213 20 1229 1214 25 1230 1215 28 1231 1216 29 1232 1217 30 1233 1218 31 1234 1219 32 1235 1220 35 1236 1221 38 1237 1222 40 1238 1223 50 1239 1224 60 1240 1225 70 1241 1226 80 1242 1227

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

IMS/ESA Partition Support Product User's Guide and Reference SC26-8870 IMS/ESA Partition Support Product Licensed Program Specification GC26-8871

Additional copies of unlicensed publications are available for a fee beginning October 18, 1996, 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: 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.

Indexed Monthly License Charge (IMLC): The Indexed Monthly 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 licenses also apply to Entry Support Licenses.

Educational Allowance: A reduced charge is available to qualified education customers. The educational allowance may not be added to any other discount or allowance.

Volume Discount: Not applicable.

Version-To-Version Upgrade Credits Apply: Yes

                                                     Single
Replaced Program(s)       Replacement Program(s)     Version
Program   Program         Program      Program       Charging
Number    Name            Number       Name          Applies

5697-A06 IMS/ESA To a follow-on if any Yes Partition Support Product V1

Warranted: Yes

Licensed Program Materials Availability: Restricted Materials -- No. This licensed program will be available without source licensed program materials. It will be available in object code.

Testing Period

Basic License -- Two months DSLO -- Not applicable

Program Services: Central Service will be available until discontinued by IBM upon six months' written notice.



CHARGES

Program Number: 5697-A06

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

18 $ 3,670 $ 2,755 $ 77 $ 58 20 5,325 3,995 112 84 25 6,925 5,195 145 109 28 9,485 7,115 198 149 29 12,330 9,250 257 193 30 16,030 12,020 334 251 31 19,720 14,790 411 308 32 25,240 18,930 526 395 35 29,030 21,770 605 454 38 33,390 25,040 696 522 40 38,400 28,800 800 600 50 48,000 36,000 1,000 750 60 60,000 45,000 1,250 938 70 75,000 56,250 1,565 1,175 80 93,750 70,310 1,955 1,465

                                      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 $ 3,670 $ 2,755 $ 77 $ 58 20 4,500 3,375 95 71 25 6,125 4,595 129 97 28 8,205 6,155 172 129 29 10,910 8,185 228 171 30 14,180 10,640 296 222 31 17,880 13,410 373 280 32 22,480 16,860 469 352 35 27,140 20,360 566 425 38 31,210 23,410 651 488 40 35,900 26,930 748 561 50 43,200 32,400 900 675 60 54,000 40,500 1,125 844 70 67,500 50,630 1,410 1,060 80 84,380 63,290 1,760 1,320

                                 One-Time Charge

Entry End User/390 Entry Support License: $1,225

MSU Capacity       Description                Charge

3 PSLC Base, 3 MSU $ 526

4 -- 45 PSLC Level A, 1 MSU 24 PSLC Level A, 42 MSU 1,008

46 or more PSLC Level B, 1 MSU 10 PSLC Level B, 10 MSU 100 PSLC Level B, 50 MSU 500

     IMLC                     IMLC
     Description              Charge

IMLC Base 80 MSUs $1,884 IMLC 1 MSU 10 IMLC 10 MSUs 100 IMLC 50 MSUs 500

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, 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 charges paid.

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.