IMS Index Builder -- One Step To Higher Availability
August 26, 1997
Announcement Letter Number: 297-315
Table of Contents:
- At a Glance
- SUPPLEMENTAL INFORMATION
- TECHNICAL INFORMATION
- ORDERING INFORMATION
- TERMS AND CONDITIONS
- CALL NOW TO ORDER
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%+% email@example.com with the word SUBSCRIBE in the body.
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/ESA (R) customers using indexed databases and seeking:
- Improved database availability
- Index management capabilities
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).
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
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
- Recover one or more damaged secondary indices and avoid a full blown database reorganization
- 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
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
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?
This product does not have date dependencies and is, therefore, Year 2000 Ready.
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.
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
- MVS/ESA SP Version 5 Release 2 (5655-068 or 5655-069)
- IMS/ESA Database Manager Version 4 Release 1 (5685-012)
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.
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
Orders for new licenses will be accepted now.
Shipment will begin on the planned availability date.
New users of IMS IB should specify:
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
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
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
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 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.
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
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 Avenue San Jose, CA 95141
Services for DSLO Licenses: Provided through Basic License location
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
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.
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: firstname.lastname@example.org 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.
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.