ALTER TABLE statements are used as needed for deferred creation of referential integrities.

The unload database operation (using the unloaddb command) handles all data types, including decimal data, large objects, and User Data Types (UDTs). More information can be found in Considerations When Loading Large Objects (see page Considerations When Loading Large Objects) and Column Name and Format Specifications (see page Column Name and Format Specifications).

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).

Like tables, these are recreated to the original time stamp order.

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 page iiprocedures Catalog).