Return
-
Title
What data won't be collected by the DB2 agent if the monitored switches are not on? -
Description
What data won't be collected by the DB2 agent if the monitored switches are not turned on?
-
Cause
The DB2 database cartridge indicates that the following monitored switches must be turned on: UOW, STATEMENT, LOCK, SORT, TABLE, BUFFERPOOL and TIMESTAMP -
Resolution
If the switches are not turned on for the monitored host, then the relevant data will not be collected on dropdowns and on the database homepage.
For example from the drilldowns:
- Unit of Work metrics from UOW switch (Activity > Current Agents)
- Top SQL from the STATEMENT switch (Activity > Top SQL)
- Locks from the LOCK switch (Activity > Locks (Current) and Activity (History))
- Sort metrics from the SORT switch (Activity > Top Tables)
- Table Activity from the TABLE switch (Activity > Tope Tables)
- Memory Pool data from the BUFFERPOOL switch (Memory > Buffer Pools and Storage > Tablespaces Bufferpool Activities)
- Time related metrics from the TIMESTAMP switch (Multiple areas including Activity > Top Tables and Activity > Current Agents)