Many DBAs don't know about the db2top tool. It's a tool to monitor a db2 instance or a db2 DPF environment with ease and efficiency.
The db2top interface is similar to the topas tool much used in UNIX. In a DPF environment, it combines the db2 snapshot information from all partitions and offers a unified view, thereby making it easy to monitor such complex systems.
The fact that it was specifically designed for DPF environments does not prevent you from using it in your single partition environment. It works brilliantly in non-DPF environments as well.
It can be customized by modifying its configuration file .db2toprc.
It can be downloaded from the IBM alphaworks website and you can get more information/documentation about it here.
Note: It is available for UNIX and LINUX environments only. If you want to use it to monitor a database on windows, create a catalog to the windows database on a unix/linux box and there you go.
CAUTION: It could make you even lazier and make you completely forget that snapshot command syntax :-)
UPDATE: db2top is now included with FixPak 2 for DB2 9.5 and FixPak 17 for DB2 v8.1





