Using db2mtrk—DB2 memory tracker

With the help of this tool we can monitor agents, applications, databases, and instance memory structures. It is very useful for monitoring memory consumption at peak times or to gather information about memory utilization during data processing.

Getting ready

In this recipe, we will gather information about memory consumption at instance and database level.

How to do it...

1. To see how memory is allocated per component for the current instance, issue the following command:

   [db2inst1@nodedb21 ~]$ db2mtrk -i
   Tracking Memory on: 2011/08/09 at 21:38:07
   
   Memory for instance
   
     other       fcmbp       monh
     17.2M       832.0K      640.0K
   [db2inst1@nodedb21 ~]$
   

   Here, the –i option is used for showing the memory used by the current instance. The truth is that the previous listing appears a little cryptic. For more detailed information regarding the memory usage use the –v switch . With this option, we can display verbose memory usage information.

2. Now reissue the command...