Reloading Order
When using the copy.in script, database objects are reloaded in the following order:
• Users, groups, and roles (only when recreating the iidbdb)
• Tables
ALTER TABLE statements are used as needed for deferred creation of referential integrities.
• Data
• Table permissions
Permissions are recreated to the original time stamp order, and can or cannot be those of the table owner (depending on the grant options for the table).
• Indexes, index modifications, and integrities
• Views and related permissions
Like tables, these are recreated to the original time stamp order.
• Synonyms
• Database procedures and related permissions
Procedures depend on tables, views, events, and synonyms. Procedures can also see other procedures. To handle reloading of procedures, two passes are made during the unload database process through the iiprocedures catalog (see
iiprocedures Catalog).
• Comments