Identifying applications that are incompatible with catalog updates

Before you activate a Db2 function level, you might need to use the CATMAINT utility to tailor the catalog for the target function level. You can identify applications, activities, and Db2 resources that might be incompatible with catalog migrations and updates and take appropriate actions beforehand to minimize the possibility of a failed catalog update.

To identify applications that might interfere with a catalog update, take one of the following actions:

• Issue the DISPLAY BLOCKERS command, which displays locks and claims that active threads hold against specified databases.
  You can use the optional DETAIL keyword to receive additional report information about each lock or claim.
• Invoke the BLOCKING_THREADS built-in function, which returns a table that contains one row for each lock or claim that threads hold against specified databases.