Questions about Restructure and multiple physical databases.
Article ID: 38188
Updated On:
Products
Issue/Introduction
Question:
The customer has one global schema that maps to several databases.
The same programs are used to access all DBs.
He ask me to create new record and set as member of existing record.
Than he ask me to restructure only one DB in order to test his programs.
My doubt is if the same programs without recompilation can access all DBs (restructured and NOT restructured) .
Can the same programs access both databases without any problems.
Answer:
You are adding a new record and set and restructuring the existing OWNER of the new set to add the Pointers for the new set.
The Subschema you generate will have a new PREFIX Length for the existing owner.
If that Subschema load module is used to access a database that has not been restructured to match, then any attempt to Obtain the Owner record will get 0353 error-status because the Prefix length will not match.
If that Subschema is used to STORE any of those Owner records into the unrestructured DB that will be a very big problem because you will then have owner records in that DB of both lengths and that will be difficult to fix.
Make sure you do not make the new SS loadmod available for databases that have not been restructured to match
Additional Information:
DATABASE ADMINISTRATION GUIDE - Modifying Schema Entities
Environment
Component:
Feedback
