IBM United States
Software Announcement 200-348
October 10, 2000

IMS Partition DB V2R2 Provides Support for IMS Version 7

 ENUS200-348.PDF (27KB)

(Corrected on October 6, 2000)

Updated the Ordering Information section.

At a Glance

IMS/ESA Partition Support Product:

  • Extends database and index capacity
  • Improves database availability
  • 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 a full set of partition-oriented reorganization utilities

For ordering, contact:

Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: LE001).

Overview

The IMS/ESA® Partition Support Product for MVS/ESA™ V2R2 (IMS™ Partition DB V2R2) extends IMS/ESA database capacity and helps improve database availability. IMS Partition DB V2R2 is transparent to DB application programs and their corresponding PSBs.

Additional Capacity

IMS Partition DB V2R2 extends the data storage capacity of existing HDAM and HIDAM databases from the current 4 GB to 128 GB. IMS Partition DB V2R2 allows a database to be separated into as many as 32 partitions, each having a 4 GB capacity. Now, full-function databases can be incrementally grown up to 128 GB.

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

Higher Availability

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

Enhancements

IMS Partition DB V2R2 provides utilities supporting partitioned databases and partitioned primary and secondary indexes. IMS Partition DB V2R2 utilities include a number of usability enhancements, such as support for dynamic allocation.

IMS Partition DB V2R2 provides support for the IMS Version 7 environment.

Key Prerequisites

Partition DB is designed to support the IMS Version 5, 6, and 7 operating environments.

Planned Availability Date

October 20, 2000

Description

IMS Partition DB V2R2 is designed to extend IMS/ESA database capacity and help improve database availability. IMS Partition DB V2R2 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™ dataset and has a 4 GB 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 program product. Partitions are viewed by these utilities as dataset groups.

  • 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 — this may reduce the distance the DASD arm moves when processing a disorganized database.

Year 2000

This product does not have date dependencies and is Year 2000 ready.

Euro Currency

This program is not impacted by euro currency.

Hardware and Software Support Services

SmoothStart™/Installation Services

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

Trademarks

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

Technical Information

Specified Operating Environment

Hardware Requirements

IMS™ Partition DB V2R2 is designed to operate on any hardware supporting IMS Versions 5, 6, and 7.

Software Requirements

IMS Partition DB operates with the following IMS versions and requires SMP/E Version 1 (5668-949) for installation.

  • IMS V5R1 (5695-176)
  • IMS V6R1 (5655-158)
  • IMS V7R1 (5655-B01)

Security, Auditability, and Control

The announced program uses the security and auditability features of the supported IMS and/or MVS™ systems. The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.

Customer Financing

IBM Global Financing offers attractive financing to credit-qualified commercial and government customers and Business Partners in more than 40 countries around the world. IBM Global Financing is provided by the IBM Credit Corporation in the United States. Offerings, rates, terms, and availability may vary by country. Contact your local IBM Global Financing organization. Country organizations are listed on the Web at:

Ordering Information

Current Licensees

Current licensees of IMS Partition DB will be sent a program reorder form that may be returned directly to IBM Software Delivery Fulfillment (SDF). These reorder forms are scheduled to be mailed two weeks after planned availability. Reorder forms returned to SDF will be processed within 10 workdays of receipt. When the new release is available, the prior release will no longer be available.

New Licensees

Orders for new licenses can be placed now.

Shipment will not occur before availability date.

Unless a later date is specified, orders entered before the planned availability date will be assigned a schedule date of one week following availability.

Shipment will begin on the planned availability date.

  • Orders that ship before the planned availability will receive IMS Partition DB Release 1.
  • Orders that ship after the planned availability date will receive IMS Partition DB Release 2.

New users of IMS Partition DB should specify:

          Type           Model
 
          5697           D85

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

                                                         ESL OTC
Program                                                  Feature
Number                     Description                   Number
 
5697-D85                   Partition DB                  0001

ESL 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. If applicable, specify the PSLC Level A, PSLC Level B, PSLC Level C, and PSLC Level D features and quantity.

If there is more than one program copy in a Parallel Sysplex, the charge for all copies is associated to one license 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 (NC) Identifier feature on the licenses.

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

                        PSLC               PSLC Basic License
Machine                 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
 
                        PSLC               PSLC Basic License
Machine                 Feature            MLC Feature
MSU Capacity            Number             Description
 
46 -- 175               0067               PSLC Level B, 1 MSU
                        0068               PSLC Level B, 10 MSUs
                        0069               PSLC Level B, 50 MSUs
 
176 -- 315              1000               PSLC Level C, 1 MSU
                        1001               PSLC Level C, 10 MSUs
                        1002               PSLC Level C, 50 MSUs
 
316 or more             1003               PSLC Level D, 1 MSU
                        1004               PSLC Level D, 50 MSUs
 
NA                      0070               PSLC NC ID

Growth Opportunity License Charge (GOLC): To order a GOLC software, specify the program number, feature number 9001 for asset registration, and the GOLC monthly charge feature number from the table below. Also, specify the feature number for the desired distribution medium.

                                     GOLC
          GOLC                       Feature
          Category                   Number
 
          H30                        3000
          H50                        3001
          H70                        3002

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.

Basic Machine-Readable Material

                              Feature            Distribution
Environment                   Number             Medium
 
Partition DB IMS V5           5801               9/6250 bpi tape
Partition DB IMS V5           5802               3480 cartridge
Partition DB IMS V5           5045               4-mm cartridge
Partition DB IMS V6           5811               9/6250 bpi tape
Partition DB IMS V6           5812               3480 cartridge
Partition DB IMS V6           5047               4-mm cartridge
Partition DB IMS V7           5821               9/6250 bpi tape
Partition DB IMS V7           5822               3480 cartridge
Partition DB IMS V7           5042               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)
 
                                                    Feature
Description                                         Number
 
Ship Media Only (suppresses initial                 3470
 shipment of documentation)
 
Ship Documentation Only (suppresses                 3471
 initial shipment of media)
 
Satellite Electronic Delivery                       3450
 
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 SDF receives the order. SDF 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                               GC26-9500
 Information Manual
IMS Partition DB Licensed                              GC26-9503
 Program 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

The terms for Partition DB, as previously announced (Software Announcement 298-384 , dated September 29, 1998) licensed under the IBM Customer Agreement are unaffected by this announcement.

Support Line: No

Prices

The prices 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. Entry Support License OTC: An OTC authorizes use only on IBM Entry End User/390 machines.

For additional product information, refer to Software Announcement 298-384 , dated September 29, 1998.

Order Now

 Use Priority/Reference Code: LE001
 
 Phone:     800-IBM-CALL
 Fax:       800-2IBM-FAX
 Internet:  ibm_direct@us.ibm.com
 Mail:      IBM Atlanta Sales Center
            Dept. LE001
            P.O. Box 2690
            Atlanta, GA  30301-2690

You can also contact your local IBM Business Partner or IBM representative. To identify them, 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.
 
Parallel Sysplex is a registered trademark 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.