Easy-to-use, one-step procedure for building all IMS indexes
Overview
Streamline index creation, maintenance and recovery
IMS™ Index Builder for z/OS® streamlines rebuilding IMS primary, secondary, and HALDB ILDS indexes using advanced sorting and parallel processing. Create multiple indexes in a single job step and rebuild indexes without unload and reload processes.
Features
Simplify index creation and recovery
IMS™ Index Builder for z/OS® minimizes index creation elapsed time in building one or more indexes and maximizes high database availability. It issues IMS commands internally to take IMS databases offline and online for the minimal amount of time necessary to ensure there are no updates while the IMS indexes are being rebuilt.
IMS Index Builder uses a number of parallel sort algorithms including buffered sorts to reduce I/O activity and improve performance. These sophisticated algorithms help ensure the rebuilding of an IMS index is faster than the process of image copying and recovering the IMS index.
IMS Index Builder supports both non-partitioned and partitioned databases. It scans supported HD and HISAM databases to build primary and secondary indexes and creates new secondary index databases for non-partitioned systems. It also creates indexes for HDAM, HIDAM, HISAM, PHDAM and PHIDAM databases.
When an IMS database is reorganized or recovered, IMS Index Builder rebuilds the indexes. Integrated with IMS High Performance Prefix Resolution, it extracts data to resolve database prefixes for logical relationships. It's part of three IBM® IMS Solutions: IMS Database Solution Pack, IMS Database Utility Solution and IMS Recovery Solution Pack.
IMS Index Builder generates statistical reports and stores them in the IMS Tool Knowledge Base (ITKB) repository, enabling centralized access to index data, historical analysis, trend tracking, and more informed database administration decisions.
IMS Index Builder invokes its driver by the job-step executable, which initiates the MAS, analyzes input, processes database control tables and attaches common services. In the final step, multiple SAS are initiated to perform scans and sorts in parallel, indexes are loaded and DBRC registration is completed.
Use cases
Accelerate indexing with less effort
Reduce the effort and time required to build, maintain, and recover IMS indexes. Teams can streamline administration workflows, shorten processing windows, eliminate unnecessary steps, and support efficient database operations with fewer manual tasks.
When recovery or maintenance is required, administrators can create and rebuild IMS indexes more efficiently, reducing effort and keeping database operations moving.
Tight processing windows become easier to manage as teams complete index tasks faster than traditional methods, improving operational efficiency.
Database administrators can avoid image copying index data sets, simplifying maintenance workflows and reducing the time spent on routine activities.
New and experienced administrators can get index tasks running more quickly through a streamlined front end, reducing setup effort and improving productivity.
Resources
Discover expert resources
Access datasheet, videos and support documentation to explore new capabilities and gain deeper insights that help streamline deployment, configuration and ongoing operations for IMS Index Builder for z/OS.
IBM IMS is a high-performance hierarchical database and transaction manager for z/OS designed to secure and scale critical business applications.