There're several DB2 instances hosted on AIX servers. What're prerequisites need to enable DB2 monitoring on AIX as client? Is agent / plugin required to install on AIX servers? Current version of DB2 and AIX is shown below. We want to monitor the following metrics of DB2 DB:
DB2: 11.x
AIX: 7.1 (powerpc)
Nagios XI: 5.4.13
Nagios Core: 4.2.4
1. Long running queries ( queries running > 60 sec)
2. Top Queries consuming high in resources and slow in nature.
3. Blocking session to be monitor (if block is not release in few seconds)
4. Consistent increase of locks require to be monitor and alerted.
5. Table/Index fragmentation
DB2 monitoring on AIX
-
benjaminsmith
- Posts: 5324
- Joined: Wed Aug 22, 2018 4:39 pm
- Location: saint paul
Re: DB2 monitoring on AIX
Hi,
The best option for DB2 monitoring would be one of the community plugins found on the Nagios Exchange.
https://exchange.nagios.org/directory/P ... abases/DB2
For step by step instructions on downloading and configuring a plugin in Nagios Xi, take a look at the following guide.
Managing Plugins In Nagios XI
Reference:
https://www.nagios.com/solutions/db2-monitoring/
The best option for DB2 monitoring would be one of the community plugins found on the Nagios Exchange.
https://exchange.nagios.org/directory/P ... abases/DB2
For step by step instructions on downloading and configuring a plugin in Nagios Xi, take a look at the following guide.
Managing Plugins In Nagios XI
Reference:
https://www.nagios.com/solutions/db2-monitoring/
As of May 25th, 2018, all communications with Nagios Enterprises and its employees are covered under our new Privacy Policy.
Be sure to check out our Knowledgebase for helpful articles and solutions!
Be sure to check out our Knowledgebase for helpful articles and solutions!