General Page
Reorganize IMS databases while they remain online
IBM® IMS™ Online Reorganization Facility for z/OS® reorganizes many types of IMS databases while they remain accessible to applications. Using this product, the IMS Database Administrator (DBA) can now reorganize an IMS database while allowing full IMS application access to the database.
IMS Online Reorganization Facility for z/OS handles all of the tasks required to reorganize an IMS database including: unloading and reloading the data, resolving database prefixes, rebuilding secondary indexing, validating database pointers and image copying the reorganized database.
Benefits
Cover all your reorganization needs | Get all the necessary reorganization procedures in one simple step – eliminating the need for operator intervention during and after reorganization finishes. |
Reduce database downtime | Decrease database downtime from hours to seconds – improving database availability for 24x7x365 applications. |
Reorganize several database types | Reorganize HDAM, HIDAM, HISAM, SHISAM, PHDAM, and PHIDAM database types. |
Learn more about the IMS online reorganization process
End-to-end reorganization solution | IBM® IMS™ Online Reorganization Facility for z/OS® analyzes and evaluates space management conditions against user-defined policies to determine when thresholds have been breached. It detects problems before they can negatively impact IMS applications. You can schedule when you want to reorganize online databases by predefining an online reorganization window, helping save DBA resources, CPU time and increasing database availability. |
Verification | The verification phase is the first phase of the online reorganization process. IMS Online Reorganization Facility for z/OS uses this phase to validate that the IMS database can be reorganized. The tool checks the IMS release and component levels, the DBRC registration and database DBD definitions, the tool control statements, and the shadow and temporary data sets are allocated correctly. The reorganization continues if this verification step completes successfully. |
Copy | The IMS databases are briefly paused to allow the database buffers to be flushed to the IMS database data sets. This ensures that the latest updates are captured in the original IMS database data sets. Then the original IMS database data sets are copied to the shadow IMS database data sets. When this copy is completed, a second brief pause is performed to capture any updates that were made to the original IMS database data sets. These updates are also applied to the shadow data sets. |
Reorganization | Once the shadow IMS database data sets are created, they are unloaded using the unload tool and reloaded using the load tool. If there are secondary indexes, they are also rebuilt. Internal logical relationships are resolved and updated using the prefix resolution tool. The reorganized IMS shadow databases are image copied with the image copy tool and can be pointer checked with the pointer checker tool. |
Takeover | When the reorganization of the shadow data sets has completed, the original IMS database data sets are swapped with the reorganized shadow IMS database data sets. IMS DBRC is notified with the REORG database status. If the IMS DBD database definitions change, the IMS Online Reorganization Facility performs an ACBGEN. Finally, the IMS database is restarted internally by the tool with the /START command and the takeover phase is completed. |
Completion | In the completion step, the final reports are created and the shadow IMS database data sets are deleted. |
You may also be interested in
IMS Database Solution Pack for z/OS
Support online database reorganizations to support 24x7 availability, and manage full-function IMS databases and HALDBs.
|
IMS Tools
Enhance the performance of your IMS systems with on demand, application-specific database and transaction management tools.
|
Get information about how to maintain and use the product.
|
Find solutions by using Support Search or open a Support Case.
|
Other resources
IBM Developer Community
Explore technical topics, find trial software and join the community.
|
IMS Tools Product Documentation
IMS Tools product publication, program directories, and other related technical content in PDF format.
|
IMS Tools Solution Packs Frequently Asked Questions
Find the answers to and learn hints and tips for optimal setup of IMS Tools solution packs.
|
IMS Tools Video Playlist
This list of videos includes demos and webcasts for IBM IMS and related products and technologies.
|
What's new
Learn about the latest product news and information.
|
Was this topic helpful?
Document Information
Modified date:
08 September 2020
UID
ibm16263145