IMS Partition DB Version 2 Helps Improve Capacity and Availability
September 29, 1998
Announcement Letter Number: 298-384
Table of Contents:
- At a Glance
- SUPPLEMENTAL INFORMATION
- TECHNICAL INFORMATION
- ORDERING INFORMATION
- TERMS AND CONDITIONS
- CALL NOW TO ORDER
In the Description section, the text under Simple Database Conversion
At a Glance
IMS/ESA Partition Support Product delivers on:
- Extended database and index 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 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 firstname.lastname@example.org with the word SUBSCRIBE in the body.
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.
Partition DB is intended for IMS/ESA full-function customers seeking:
- Incremental growth beyond the 4 gigabyte limit
- Extended operability and manageability
- Higher availability
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
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.
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.
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.
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)
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.
Orders for new licenses will be accepted now.
Shipment will begin on the planned availability date.
New users of IMS Partition DB should specify:
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
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
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)
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)
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.
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
Licensed Program Materials Availability
- Restricted Materials of IBM: None
- Non-Restricted Source Materials: None
- Object Code Only (OCO): All
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
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.
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: email@example.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.
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.