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
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:
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.
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.
Assemble the base restructuring table
Link edit the base restructuring table
Execute the RESTRUCTURE utility statement
to restructure the database. Use a subschema that was compiled under the old schema.
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.
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.
Validate the restructure
using IDMSDBAN, CA OLQ, CA Culprit, or some other retrieval program.
Recompile, under the new schema, all subschemas that use the changed records or sets
Alter all access modules referencing changed records or owner and member records of changed sets.
Drop and recreate SQL views of records whose element descriptions have changed.
See RESTRUCTURE doc in UTILITIES