Migrating IBM DB2 for OS/390 and z/OS Objects
Go Up to Migration and Object Restrictions/requirements
The table describes the condition(s) that need to be satisfied on the target database to migrate objects:
Object | Condition(s) on Target Database |
---|---|
Aliases |
The login must already exist on the target server. The user must already exist in the target database. |
Indexes |
The base tables must already exist in the target database. |
Procedures |
Any objects referenced by the stored procedure, including tables, views and other stored procedures, must already exist in the target database. The owner of the stored procedure must already exist in the target database. |
Tables |
Any referenced user datatypes must already exist in the target database. Any defaults referenced by the table must already exist in the target database. Any rules referenced by the table must already exist in the target database. If the tables have foreign key references to tables not included in the migration, these tables must already exist in the target database. |
Tablespaces |
The container mappings and directories must already exist on the target server. |
Triggers |
The base tables and their owners must already exist in the target database. Any objects referenced by the trigger, including other tables, views and other stored procedures, must already exist in the target database. |
User Datatypes |
The owner of the user datatype must exist in the target database. |
Users |
The database objects must already exist in the target database. |
Views |
Any objects referenced by the view, including tables and other views, must already exist in the target database. The owner of the view must already exist in the target database. |