Create Process

Use the Create Process to recreate a DB2 database or selected database objects using archived object definitions in an Archive File.

The Create facility allows a user with the appropriate authorizations to create database tables and other objects and to grant access privileges for those created objects. Users for whom the appropriate privileges are granted can then restore archived data into the new tables or views using Archive Restore or DB2 Load.

A user with necessary authorizations can use Archive Restore or DB2 Load to create tables and all subordinate objects (Primary Keys, Relationships, Indexes, Views, Aliases, Synonyms, Column Field Procedure Names, Triggers, User Defined Types and Functions, and Stored Procedures) that have been archived. Neither the Archive Restore Process or the DB2 Load Process creates subordinate objects for a table that already exists, however. Use the Create facility to create subordinate objects for existing tables.