Manages IMS HALDBs with tools for tuning, partitioning, and converting
Overview
IMS™ High Availability Large Database Toolkit (HALDB) for z/OS® helps convert existing IMS full-function databases into IMS HALDB databases. It allows IMS database administrators (DBAs) to simulate changes to partition settings to verify that they are correct before implementation. It also gives DBAs the ability to maintain and tune the HALDB databases.
The IMS HALDB Toolkit supports partition consolidation and partition splitting to accommodate growth or shrinkage of database partitions. The IMS HALDB Toolkit is fully integrated with other IMS High Performance tools to provide special capabilities in the management of IMS HALDB databases.
IMS HALDB Toolkit for z/OS converts IMS full-function databases to IMS High Availability Large Database databases in one step.
IMS HALDB Toolkit for z/OS supports simulation of conversions, partition consolidations and partition splitting to verify changes before they are made.
IMS HALDB Toolkit for z/OS manages IMS HALDB maintenance procedures to optimize IMS HALDB performance and maintainability.
IMS HALDB Toolkit provides special functions to deal with IMS DBRC.Â
Features
IMS High Availability Large Database Toolkit (HALDB) for z/OS can help reduce the time and minimize the skills required to perform application support tasks. The toolkit provides IMS HALDB maintenance, modeling and analysis. It also helps you to maintain 24x7 data availability. The toolkits application functions enable applications to make better use of the HALDB environment. And its system utilities provide capabilities that can help improve HALDB serviceability.
IMS HALDB Toolkit can migrate an IMS full-function database to an IMS HALDB database. First, it can simulate the conversion. It determines the IMS HALDB partition settings that are appropriate for the current IMS full-function database. Then, it can conduct the actual conversion from the IMS full-function database to the IMS HALDB database. This procedure is performed in a single batch step. There is an ISPF interface that generates all necessary substeps in this process.
IMS HALDB Toolkit allows the IMS DBA to consolidate or split partitions where the data is showing signs of growing or shrinking. To ensure the new partition settings are correct, it allows the IMS DBA to simulate the repartitioning before making the change to the IMS HALDB database. It then enables the IMS DBA to set specific thresholds to inform them when maintenance is required for an IMS HALDB database.
IMS HALDB Toolkit improves the performance of IMS HALDB databases. For instance, once an IMS HALDB primary database is reorganized, all secondary index pointers require healing. In IMS, this healing process is performed by using “self-healing”, which means the index is corrected when it is first used. However, since the self-healing procedure can impact performance during peak times, the toolkit provides an offline utility to heal the secondary indexes.
IMS HALDB Toolkit can also help in the conversion of user-partitioned IMS databases to IMS HALDB databases. If there are multiple identical databases with different key ranges, the toolkit transforms the databases into IMS HALDB databases and merge the data into a single IMS HALDB database. This helps users who need secondary indexing but were restricted from using it when the data was split across multiple databases.
IMS HALDB Toolkit provides special functions to deal with IMS DBRC. For example, the tool allows the IMS HALDB DBRC definitions to be cloned or replicated from one IMS RECON data set to another IMS RECON data set. It can also change the high-level data set qualifier name during the replication process. The toolkit also allows a set of production IMS HALDB databases to be allocated and copied from one IMS system to another IMS system.
IMS HALDB Toolkit can migrate an IMS full-function database to an IMS HALDB database. First, it can simulate the conversion. It determines the IMS HALDB partition settings that are appropriate for the current IMS full-function database. Then, it can conduct the actual conversion from the IMS full-function database to the IMS HALDB database. This procedure is performed in a single batch step. There is an ISPF interface that generates all necessary substeps in this process.
IMS HALDB Toolkit allows the IMS DBA to consolidate or split partitions where the data is showing signs of growing or shrinking. To ensure the new partition settings are correct, it allows the IMS DBA to simulate the repartitioning before making the change to the IMS HALDB database. It then enables the IMS DBA to set specific thresholds to inform them when maintenance is required for an IMS HALDB database.
IMS HALDB Toolkit improves the performance of IMS HALDB databases. For instance, once an IMS HALDB primary database is reorganized, all secondary index pointers require healing. In IMS, this healing process is performed by using “self-healing”, which means the index is corrected when it is first used. However, since the self-healing procedure can impact performance during peak times, the toolkit provides an offline utility to heal the secondary indexes.
IMS HALDB Toolkit can also help in the conversion of user-partitioned IMS databases to IMS HALDB databases. If there are multiple identical databases with different key ranges, the toolkit transforms the databases into IMS HALDB databases and merge the data into a single IMS HALDB database. This helps users who need secondary indexing but were restricted from using it when the data was split across multiple databases.
IMS HALDB Toolkit provides special functions to deal with IMS DBRC. For example, the tool allows the IMS HALDB DBRC definitions to be cloned or replicated from one IMS RECON data set to another IMS RECON data set. It can also change the high-level data set qualifier name during the replication process. The toolkit also allows a set of production IMS HALDB databases to be allocated and copied from one IMS system to another IMS system.
Related solutions
Support online database reorganizations to support 24x7 availability, and manage full-function IMS databases and HALDBs.
Support offline database reorganizations and manage full-function IMS databases and HALDBs.
Use a suite of software that provides an integrated solution for simultaneous backup and recovery of multiple datasets and fast path areas.
Enhance the performance of your IMS systems with on-demand, application-specific database and transaction management tools.
Resources
Get information about how to maintain and use the product.
Explore technical topics, find trial software and join the community.
Review IMS Tools product publication, program directories and other related technical content in PDF format.
Watch demos and webcasts for IBM IMS and related products and technologies.