Database considerations
Depending on the type of database that we use, there might be extra considerations or tasks to complete before and after you migrate the data. Review the information that is tailored for the database type to ensure the migration process completes successfully.
- Oracle: Disabling the auto space advisor background task
To prevent deadlocks during migration, complete a task to disable the Oracle background task called "Auto Space Advisor" before the run the upgrade-profile task during migration using the Configuration Wizard. After completing migration, we can enable "Auto Space Advisor" as a post-migration task.
- DB2
Database migration is one of the most time consuming portions of the migration process. If we are migrating from DB2 , review the following topics to improve the speed of the database migration process.