Changing the hierarchical structure of a HALDB database

You can change the hierarchical structure of a HALDB database.

To change the hierarchical structure, you need to:

Procedure

  1. Determine whether the change you are making will affect the code in any application programs. If so, make sure the code gets changed.
  2. Unload your database using your unload program and the existing DBD.
  3. Code a new DBD.
  4. If the change you are making affected the code in application programs, make any necessary changes to the PSBs for those application programs. If you have the DB/DC Data Dictionary, it can help you determine which application programs and PCBs are affected by the DBD changes you have made.
  5. For non-VSAM data sets, delete the old database space and define new database space. For VSAM data sets, delete the space allocated for the old clusters and define space for the new clusters.
  6. Reload your database using your load program and the new DBD. Remember to make an image copy of your database as soon as it is reloaded.
  7. If your database uses logical relationships or secondary indexes, you must run reorganization utilities before and after reloading to resolve prefix information.