Process Recommendations › Ways to Improve Processes › Subject Matter Experts › Migration Expert

Migration Expert

A migration may fail because of several reasons. Failed migrations take more than twice as long as successful migrations because they result in a DB2 rollback. Trial migrations are equivalent to a failed migration because they also result in a DB2 rollback. You want to reduce the failure rate and number of trial migrates because migrations may cause DB2 contention on the entire encyclopedia. You can do at least three things to eliminate or reduce the number of unsuccessful migrations:

• Understand the rules of migration. For each object, know its enabling and companion object.
• Keep migration aggregate sets small to avoid repeat migration attempts of many objects if one object fails.
• Use reports, such as those discussed in the following section, to understand the model and objects to be migrated.

Each project should have a migration expert who is thoroughly trained in the rules and best practices of migration. This prevents a large number of failed migrations and reduces or eliminates the need for trial migrations. The migration expert should implement a request process to aid in the scheduling of migrations. The process should prevent the need for large migrations by allowing for incremental movement of changed objects.