IMS Index Builder -- One Step To Higher Availability

Software Announcement
August 26, 1997
Announcement Letter Number: 297-315


Table of Contents:



At a Glance

IMS Index Builder compliments the existing IMS Tools by providing price/performance function that can help further reduce IMS service time. IMS IB:

  • Reduces time needed to maintain primary and secondary indices

  • Reduces time needed to create secondary indices

  • Executes as one JOB step for all Index Build functions

  • Builds multiple indices in a single step

  • Provides ISPF front end for easy JCL generation

  • Is compatible with standard IMS utilities, IBM IMS/VS System Utilities/Data Base Tools, and third party utilities

  • Year 2000 Ready
-----------------------------------------
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 %+%Start_URL%+% http://www.ibm.com/isource or send an e-mail to %+%Start_EML%+% info@isource.ibm.com with the word SUBSCRIBE in the body.



Overview

IMS (TM) Index Builder (IMS IB) can help you simplify index recovery and maintenance, reduce index maintenance time, and eliminate the need to image copy index databases. IMS IB provides an easy-to-use, one-step procedure for the maintenance of IMS secondary indices and HIDAM primary indices. IMS IB, a high performance utility, takes full advantage of CMOS 390 technology which reduces the time to build one or more indices. IMS IB uses both parallel sort and parallel load whenever multiple indices are being built. This powerful feature can significantly reduce the time needed to build multiple indices of a single database.

With IMS IB, you can now create and recover new indices without the need to do a database reorganization. In addition, you can eliminate image copies of index databases since IMS IB provides for the recreation of indices from the source database. And that is not all! Using IMS IB with the following IMS/VS System Utilities/Data Base Tools (5685-093) features, or comparable utilities, can significantly reduce your database reorganization time and improve database availability.

  • High Speed Sequential Retrieval (HSSR)

  • Fast Reorganization Reload (FRR)

  • Fast Prefix Resolution (FPR)
IMS IB is affordable, simple, easy to use, and can help you improve database availability for indexed IMS databases in just one step. Can you afford to be without it?



Intended Customers

IMS/ESA (R) customers using indexed databases and seeking:

  • Improved database availability
  • Index management capabilities



Key Prerequisites

IMS Index Builder can be used on multiple versions of IMS and is supported on IMS/ESA Version 4, or later. IMS Index Builder is installed by System Modification Program (SMP/E).

Price

Refer to the Charges section.

Planned Availability Date

September 12, 1997

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

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: %+%Start_URL%+% http://www.ibm.com



DESCRIPTION

With IMS Index Builder you are just one step away from higher database availability. IMS IB provides a new process for the maintenance and recovery of IMS secondary indices. The current multi-step process is replaced by a fast one-step job operation capable of building multiple indices. In addition, databases with logical relationships can benefit when the IMS IB Split function is used. IMS IB is designed to:

  • Rebuild secondary indices using DLI scan

    IMS IB can be used to rebuild secondary indices of a single physical IMS database by using DLI to scan the database. This feature can be used to:

    • Recover one or more damaged secondary indices and avoid a full blown database reorganization

    • Avoid taking image copies of secondary indices by using IMS IB to recover the indices after recovering the physical database
  • Rebuild secondary indices using DFSURWF1

    IMS IB can be used to rebuild secondary indices as part of the standard IMS reorganization process. IMS IB uses, as input, the output from the IMS reorganization utility or from the initial database load. This output file is referred to as DFSURWF1. This file contains information to rebuild secondary indices and perform prefix resolution.

  • Split DFSURWF1 File

    The DFSURWF1 file contains records to rebuild secondary indices as well as perform prefix resolution. IMS IB provides an option allowing the user to specify an optional output file where records needed for prefix resolution can be split off and written out as they are read in. This greatly decreases the size of the sort needed to perform prefix resolution. In addition, IMS IB closes and deallocates the output file so that it is immediately available for prefix resolution processing.

  • Rebuild IMS secondary indices using output DFSURIDX

    IMS IB can use the DFSURIDX output file from prefix resolution to rebuild secondary indices. This option is provided for compatibility only and is not recommended since performance will not be optimized.

  • Initialize empty IMS secondary indices

    IMS IB always checks the secondary index being rebuilt to see if it is empty when processing completes. If it is, IMS IB will automatically mark the index as available for update processing.

  • Create one or more new secondary indices of an existing IMS database

    IMS IB can be used to create new secondary indices for an existing IMS database by using the DLI scan feature, and specifying the new and old DBD structures as input. In one pass, multiple secondary indices can be added to a database.

  • Rebuild primary indices for HIDAM database

    When the primary index of a HIDAM database has been corrupted, IMS IB can be used to rebuild it, if:

    • The root segment of the HIDAM database has been defined with Physical Twin Pointers
    • The first record of the existing corrupted primary index is accessible to DLI
Under these conditions, the HIDAM primary index can be recovered quickly using the IMS Index Builder.

Used with the basic IMS utilities or in conjunction with other high performance IMS utilities, IMS IB provides affordable function that can help simplify IMS database maintenance and improve database availability. Can you afford to be without it?



Year 2000

This product does not have date dependencies and is, therefore, Year 2000 Ready.

Trademarks

      IMS is a trademark 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.



SUPPLEMENTAL INFORMATION



TECHNICAL INFORMATION



Specified Operating Environment

Hardware Requirements: The IMS (TM) Index Builder (IB) is designed to operate on any hardware supporting the following minimum software versions.

  • MVS/ESA (TM) SP (TM) Version 5 Release 2
  • IMS/ESA (R) Database Manager Version 4 Release 1
Software Requirements: The minimum versions and releases of programs listed below are required for installing and operating the IMS Index Builder. Follow-on versions or releases of these products can be used unless otherwise stated.
  • MVS/ESA SP Version 5 Release 2 (5655-068 or 5655-069)

  • IMS/ESA Database Manager Version 4 Release 1 (5685-012)
Note: OS/390 (TM) (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 and/or MVS (R) 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

The following advance publications will be available as indicated. To order, contact your IBM representative.

                              Order          Availability
Title                         Number         Date

IMS Index Builder SC26-9086 August 29, 1997 User Guide IMS Index Builder LPS GC26-9087 August 29, 1997



New Licensees

Orders for new licenses will be accepted now.

Shipment will begin on the planned availability date.

New users of IMS IB should specify:

         Type           Model

5697 C33

Basic License: 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.

                 One-Time Charge            Monthly License Charge
                     Feature                       Feature
Group                 Number                        Number

18 1261 1246 20 1262 1247 25 1263 1248 28 1264 1249 29 1265 1250 30 1266 1251 31 1267 1252 32 1268 1253 35 1269 1254 38 1270 1255 40 1271 1256 50 1272 1257 60 1273 1258 70 1274 1259 80 1275 1260

Multiple Operating System -- PR/SM (TM) (MOSP): For a graduated one-time charge or graduated monthly license charge, specify the following feature number corresponding to the group that contains the designated machine.

                    MOSP Basic
                    Graduated                MOSP Basic Graduated
                     One-Time               Monthly License Charge
                     Feature                       Feature
Group                 Number                        Number

18 1312 1276 20 1314 1277 25 1315 1278 28 1316 1279 29 1317 1301 30 1318 1302 31 1319 1303 32 1320 1304 35 1321 1305 38 1322 1306 40 1323 1307 50 1324 1308 60 1325 1309 70 1326 1310 80 1327 1311

Note: The group can be determined by referring to either the Exhibit for IBM System/390 (R) Machines (Z125-3901) or the Exhibit for Non-IBM Machines (Z125-3902) that are 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 OTC feature number. Also specify the feature number of the desired distribution medium.

                      Program           ESL One-Time Charge
Description           Number               Feature Number

IMS/ESA Index 5697-C33 1245 Builder

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

1 1569 PSLC Base, 1 MSU 2 1570 PSLC Base, 2 MSUs 3 1552 PSLC Base, 3 MSUs

4 -- 45 1553 PSLC Level A, 1 MSU 1554 PSLC Level A, 42 MSUs

46 or more 1555 PSLC Level B, 1 MSU 1556 PSLC Level B, 10 MSUs 1557 PSLC Level B, 50 MSUs

Not/Applicable 1558 PSLC N/C ID

Example 1: A single machine with 11 MSUs PSLC program features is 1552, quantity 1 and 1553, quantity 8

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

  • PSLC chargeable program 1
    • 1552 quantity 1, 1554 quantity 1, 1555 quantity 5 and 1556 quantity 1
  • PSLC no charge program 2
    • 1558 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 features 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

1548 IMLC Base 80 MSUs 1549 IMLC 1 MSU 1550 IMLC 10 MSUs 1551 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        Distribution
Environment              Number         Medium

IMS Index Builder 5032 9/6250 bpi tape IMS Index Builder 5033 3480 cartridge IMS Index Builder 5034 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) Feature Description Number

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 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
                 One-Time Charge            Monthly License Charge
                     Feature                       Feature
Group                 Number                        Number

18 1343 1328 20 1344 1329 25 1345 1330 28 1346 1331 29 1347 1332 30 1348 1333 31 1349 1334 32 1350 1335 35 1351 1336 38 1352 1337 40 1353 1338 50 1354 1339 60 1355 1340 70 1356 1341 80 1357 1342

Multiple Operating System -- PR/SM (MOSP): For a graduated one-time charge or graduated monthly license charge, specify the following feature number corresponding to the group that contains the designated machine.

                    MOSP DSLO                     MOSP DSLO
                    Graduated                     Graduated
                 One-Time Charge            Monthly License Charge
                     Feature                       Feature
Group                 Number                        Number

18 1373 1358 20 1374 1359 25 1375 1360 28 1376 1361 29 1377 1362 30 1378 1363 31 1379 1364 32 1540 1365 35 1541 1366 38 1542 1367 MOSP DSLO MOSP DSLO Graduated Graduated One-Time Charge Monthly License Charge Feature Feature Group Number Number

40 1543 1368 50 1544 1369 60 1545 1370 70 1546 1371 80 1547 1372

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 will be provided through the basic license location. 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 Index Builder User Guide SC26-9086 IMS Index Builder LPS GC26-9087

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: Yes

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-C33 IMS Index Builder To a follow-on if any Yes

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 Avenue San Jose, CA 95141

Services for DSLO Licenses: Provided through Basic License location



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.

Program Number 5697-C33

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

18 $ 3,085 $ 2,315 $ 63 $ 47 20 4,475 3,355 92 69 25 5,820 4,365 120 90 28 7,970 5,980 165 124 29 10,360 7,770 215 161 30 13,470 10,100 280 210 31 16,570 12,430 345 259 32 21,210 15,910 442 332 35 24,390 18,290 508 381 38 28,050 21,040 584 438 40 32,260 24,200 672 504 50 40,320 30,240 840 630 60 50,400 37,800 1,050 788 70 63,000 47,250 1,315 986 80 78,750 59,060 1,645 1,235

                                          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,085 $ 2,315 $ 63 $ 47 20 3,780 2,835 78 59 25 5,150 3,865 106 80 28 6,895 5,170 143 107 29 9,165 6,875 190 143 30 11,920 8,940 248 186 31 15,020 11,270 313 235 32 18,890 14,170 394 296 35 22,800 17,100 475 356 38 26,220 19,670 546 410 40 30,160 22,620 628 471 50 36,290 27,220 756 567 60 45,360 34,020 945 709 70 56,700 42,530 1,185 889 80 70,880 53,160 1,480 1,110

                                             One-Time
                                             Charge

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

                                                           Monthly
                                                           License
MSU Capacity       Description                             Charge

1 PSLC Base, 1 MSU $165 2 PSLC Base, 2 MSUs 280

3 PSLC Base, 3 MSUs 442

4 -- 45 PSLC Level A, 1 MSU 20 PSLC Level A, 42 MSUs 840

46 or more PSLC Level B, 1 MSU 8 PSLC Level B, 10 MSUs 80 PSLC Level B, 50 MSUs 400

Indexed                                 Indexed
Monthly License                         Monthly License
Description                             Charge

IMLC Base 80 MSUs $1,572 IMLC 1 MSU 8 IMLC 10 MSUs 80 IMLC 50 MSUs 400

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

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 16848
            Atlanta, GA  30321-0848
 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, MVS/ESA, SP, OS/390, PR/SM, Parallel Sysplex, and Business
      Partner are trademarks of International Business Machines
      Corporation in the United States or other countries or both.
      IMS/ESA, MVS, and System/390 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.