Configuring and using snapshot monitoring

The snapshot monitor can be used to take a picture of the database usage statistics and connected applications at a specific point-in-time. Being used regularly, you can identify trends and act proactively on potential problems.

Getting ready

The information you can collect depends on the monitor switches. If you are not logged in as instance owner, you must have proper authority to capture a database snapshot.

How to do it...

1. Get current settings for monitor switches with the following command:

   [db2inst1@nodedb21 ~]$ db2 get monitor switches
   
               Monitor Recording Switches
   
   Switch list for db partition number 0
   Buffer Pool Activity Information  (BUFFERPOOL) = OFF
   Lock Information                        (LOCK) = OFF
   Sorting Information                     (SORT) = OFF
   SQL Statement Information          (STATEMENT) = OFF
   Table Activity Information             (TABLE) = OFF
   Take Timestamp Information         (TIMESTAMP) = ON  09/17/2011 05:44:48...