Monitoring a Db2 data sharing group

Monitoring Db2 data sharing increases the complexity of both the environment and the number of tuning knobs that need to be analyzed and optimized.

The first key requirement is to be able to focus on the level of data that is required to understand how the data sharing group is performing, or to solve a particular problem. Since a data sharing group consists of multiple Db2 members, and these members work together and share resources, viewing each Db2 individually is no longer adequate.

These scenarios show you how to look at all members concurrently so that you can easily compare activity and resource usage across the group. You can also access summarized data for the whole group, such as group buffer pool activity, total database I/O to the shared tables, or global lock contention. Of course, you will still drill down to an individual Db2 member for details as needed.

This section contains the following topics:

Important

This practice session takes approximately one hour to complete.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*