Purpose of the HALDB modeling and migration tools

After migration, some organizations want to rebalance or split partitions to manage their HALDBs more effectively. These tasks can require extensive analysis of your existing databases and current and future requirements.

This analysis can be difficult and time-consuming, even for experienced DBAs. You must collect current information about your existing databases or partitions and evaluate it according to many parameters. Because some parameters interact with each other, a change in one parameter can require changes in others. You must also consider and accommodate the potential for database growth and change over time.

After determining the correct parameters to use, you must create all of the elements to set up the new or changed HALDB structures. Manual creation of the JCL, control statements, and definitions consumes time and is prone to error. The HALDB modeling and migration tools automate and simplify these tasks.

For example, you can use the Generate Model wizard to propose a set of HALDB parameter values to use for converting an existing full-function database. The tool automatically gathers information about the database, processes the information against your proposed values, and reports the results as a set of recommendations. After viewing the recommendations, you can change your proposed values and request another analysis, using the same or refreshed database information. You can repeat this process as many times as needed to determine the best values for your database.

You can then use the sample JCL, control statements, and DBRC definitions that the tool generated to set up the new HALDB. This automated generation reduces the time and effort required for creating setup elements and ensures that they are free of errors and omissions.