IMS/ESA Partition DB Has "More" of What You Need
August 27, 1996
Announcement Number: 296-295
Document's Table of Contents:
- At a Glance
- TECHNICAL INFORMATION
- ORDERING INFORMATION
- TERMS AND CONDITIONS
- CALL NOW TO ORDER
(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
- Is transparent to application programs
- Up to 32 4-gigabyte partitions
- Secondary Indexes
- Logical Relationships
- 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
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.
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
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
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.
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.
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)
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.
Installability: To migrate an existing HISAM, HIDAM, or HDAM database to a partitioned HIDAM or HDAM database the following steps are performed:
- Unload current database using standard, IBM-provided (DFSURGU0) HD Reorganization Unload utility
- Change DBD source adding PART statements
- Perform a DBDgen and ACBgen
- Reload the database using standard, IBM-provided (DFSURGL0) HD Reorganization Reload utility
- Image copy the partitioned database using standard, IBM provided (DFSUDMP0) Image Copy utility
- Notify DBRC and alter any JCL
- DB Prereorganization
- DB Scan
- DB Prefix resolution
- HISAM Reorganization Unload
- HISAM Reorganization Reload
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.
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
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:
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
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
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 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.
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
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.
Basic License -- Two months DSLO -- Not applicable
Program Services: Central Service will be available until discontinued by IBM upon six months' written notice.
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
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.
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: email@example.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.