What are the basic steps to RESTRUCTURE a database?

Products

• 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