|
Answer» The monitoring elements in Db2 are as follows : - Counter: This records a precise count of the NUMBER of times an activity or event has occurred in the database system. For example, the pool_col_l_reads monitor element records the number of column-organized page requests from the buffer pool for regular and LARGE tablespaces.
- Gauge: This represents the current value for a monitoring element based on how MUCH of something is happening or is used. For example, the num_locks_held monitoring element shows how many locks are being currently HELD in the database.
- Watermark: This represents the HIGHEST value for a given monitoring element. For example, the connections_top monitoring element shows the highest number of simultaneous connections to the database since the database's activation.
- Text: This represents the text value that monitoring elements report. For example, the bp_name monitoring element states the name of the buffer pool.
- Timestamp: This monitor element represents the time that an event happened.
For example, the last_backup monitoring element lists the date and time that thelatest database backup was completed.
|