Prevent application performance degradation and attain better free space usage
The more you add, update, and delete records in your IMS database, the more frequently you must reorganize the database to restore data clustering and distribute free space evenly. Otherwise, performance will suffer. Reorganizing a database can require significant time, and usually involves taking the database offline.
IMS Database Solution Pack provides a complete set of high performance tools to unload, load, reorganize, build indexes for, back up, verify, and report on IMS full-function databases.
You can use the following stand-alone high-performance tools to cover each task required for database reorganization:
- IMS HP Unload provides high speed database unloading and other capabilities that are not found in IMS base utilities.
- IMS HP Load provides high speed database loading and other capabilities that are not found in IMS base utilities.
- IMS Index Builder provides capability to rebuild indexes avoiding the need to copy and reorganize.
- IMS HP Prefix Resolution provides high speed database prefix resolution and update for logically related databases.
You can combine these multiple tasks into a single job step to obtain higher performance in batch database reorganization by using IMS Database Reorganization Expert. This tool provides an integrated database reorganization infrastructure for controlling the process in a fast and efficient manner by running unload, load, index building, and image copy tasks concurrently. In addition, this tool provides an advanced function that automates and reduces complex decision making tasks required for the DBAs.