The Control Center Monitor Utilities are a DBA's best friend. They keep watch over the database while you are busy doing something else. They notify you when exceptional conditions occur and they capture key information that you need to track performance problems and resource consumption.
Whether you are interested in tracking user activity, locking, physical and logical space use, or the database itself, there are monitors designed to give you that information.
The SHOW ACTIVE and SHOW CONNECT monitors collect information that tells you if users have been waiting for database resources. You can choose to set the Monitor Utility to alert you immediately, on the operator's console, if it detects a user in wait state.
The SHOW LOCK monitor records the number of lock buffers in use and who is locking whom. You can also set this monitor to alert you immediately, on the operator's console, if it detects any kind of user locking.
The SHOW LOG, SHOW DBEXTENT, and SHOW DBSPACE monitors record the use of these vital resources. You can direct the SHOW LOG and SHOW DBEXTENT monitors to notify you immediately if their use exceeds the percentage you specify. The COUNTER * monitor records the occurrence of key events in the database and stores this information in the database. You are then free to develop your own custom queries to track statistics; such as, buffer hit ratio or LPAGBUFF and PAGEREAD.