Db2 for z/OS and its ecosystem

 View Only

Improved reliability and contention relief for online migration to Db2 12

By Jennie Chang posted Thu May 21, 2020 03:15 PM

  
By John Lyle, Chris Leung, and Jennie Chang.

With the End of Support (EOS) for Db2 11 for z/OS approaching on March 31st, 2021, migrating to Db2 12 will soon be an essential step to take if you haven't done so already. New instrumentation is now available in Db2 11 and Db2 12 to identify applications that might be incompatible with online migration, allowing you to take appropriate actions beforehand to minimize the possibility of a failed migration. With this improved reliability and contention relief for online migration, you can migrate to Db2 12 with greater confidence in a smoother experience.

Specifically, Db2 11 and Db2 12 introduce a new DISPLAY BLOCKERS command and new BLOCKING_THREADS table function that identify locks and claims that active threads hold against any specified databases, which might interfere with migration processing. The new command and table function can be used for both system and non-system databases.

In addition to release migrations, the command and function can also be used to identify applications that might interfere with function level CATMAINT jobs or function level activation in Db2 12.

The DISPLAY BLOCKERS command displays a summary report of all locks and claims held against the databases specified in the command. The report includes information such as the type of lock or claim, the name of the object that contains it, and the length of time that it has been held. The command also includes an optional DETAIL keyword -- if specified, the command displays a detailed report with additional information about each lock or claim. For more information on what is included in the output report, see DSNT369I.

Likewise, the BLOCKING_THREADS built-in table function returns a table that contains one row for each lock or claim held against databases specified in the input parameter. The table contains information similar to that of the DISPLAY BLOCKERS report.

If incompatible applications are identified, you can then either fix the applications to become compatible or schedule the migration around the incompatible applications. For more information on using the new command and function, and details on recommended actions to take if incompatible applications are found, see Identify applications that are incompatible with online migration.

John Lyle and Chris Leung are Software Developers for Db2 for z/OS Development.
Jennie Chang is an Information Developer for Db2 for z/OS.



Sign in and subscribe to always get the latest news about Db2 for z/OS from the IBM lab: http://ibm.biz/db2znews-subscribe



#Db2forz/OS
#db2z/os
#Db2Znews
0 comments
28 views

Permalink