Migrating IBM DB2 for Windows/Unix Objects

From DBArtisan
Jump to: navigation, search

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.

Nodegroups

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.