Which of these database tools could be used to monitor critical or disruptive events in DB2 UDB LUW environment? Please see body of text.
Posted on 2016-07-30
Hi DB2 gurus,
I am trying to compile a simple score to assist in determining the type of tool I will like to have for my new brand new DB2 environment. I have worked with a few but I do need some assistance from the experts in this group. my question is this:
Given the following critical events in a DB2 database environment, which of the following tools that follows can be used to investigate each event?
What I am looking for is this: I am looking to match a specific type of DB2 system event like I listed in this post and the best tool that can do the best job in monitoring for that event. The more event type a tool can monitor, it rates high or higher depending on how many event that it tool totals. Can anyone contribute in this regard?
Log space ,temp space, database data ,database log ,home file system utilization exceeds threshold.
Pre-defined Key words appear in the system (db2diag.log) files denoting a critical event occurring.
Time to get a lock exceeds a threshold.
Connection can not be made to the database.
Percentage of applications waiting for the Locks.
Memory Usage exceeds threshold.
Scheduled benchmarks queries exceeds threshold.
Required process not executing.
Swap space exceeds a threshold.
Any and all your considered experience and comment will be highly appreciated.