ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

What are the basic steps to RESTRUCTURE a database?


Article ID: 221614


Updated On:




What are the basic steps to RESTRUCTURE a database


IDMS 19.0 and all releases of IDMS


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