Improved reliability and contention relief for online migration

In Db2 12, you can identify applications that might be incompatible with catalog migrations and updates.

Before scheduling an online migration, you can issue the new DISPLAY BLOCKERS command or invoke the new BLOCKING_THREADS built-in function to identify locks and claims that might interfere with migration processing. This information allows you to take appropriate actions beforehand to minimize the possibility of a failed migration.

The new command and function are also available in Db2 11, and can be used for both system and non-system databases. For more information, see Identify applications that are incompatible with online migration.