What are the basic steps to RESTRUCTURE a database?

book

Article ID: 221614

calendar_today

Updated On:

Products

CA IDMS

Issue/Introduction

What are the basic steps to RESTRUCTURE a database

Environment

IDMS 19.0 and all releases of IDMS

Resolution

From the Utilities Doc RESTRUCTURE USAGE section

To restructure a database, follow these steps:
  1. Back up the database
    .
  2. Compile a new schema
     that describes the database after restructuring. The new schema must have a different name or version number from the schema that describes the existing database.
  3. Execute the IDMSRSTC utility
     to generate the IDMSRSTT macro statements that define the changes to be made to the database. Verify that the statements are correct; make any necessary modifications.
  4. Assemble the base restructuring table
    .
  5. Link edit the base restructuring table
    .
  6. Execute the RESTRUCTURE utility statement
     to restructure the database. Use a subschema that was compiled under the old schema.
  7. Compile a subschema under the new schema
    . Give the new subschema a temporary name to distinguish it from the old subschema.
     
    If no new pointers have been added to existing sets, skip to step 10.
  8. Execute the RESTRUCTURE CONNECT utility statement
     to connect the new prior or owner pointers for existing sets in the restructured database. Use a subschema that was compiled under the new schema.
  9. Validate the restructure
     using IDMSDBAN, CA OLQ, CA Culprit, or some other retrieval program.
  10. Recompile, under the new schema, all subschemas that use the changed records or sets
    .
  11. Alter all access modules referencing changed records or owner and member records of changed sets.
  12. Drop and recreate SQL views of records whose element descriptions have changed.

Additional Information

See RESTRUCTURE doc in UTILITIES