1.

What are the monitoring elements in Db2?

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.



Discussion

No Comment Found