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.
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.
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...