Solved

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
2
224 Views
Last Modified: 2016-08-16
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?

Critical Events---
Server failure
Database crash
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.

Monitoring Tools:---


Alarm Point
BMC Patrol
DB2 Governor
OPM
WLM
TIVOLI
Ganglia
IP Monitor
NAGIOS

Any and all your considered experience and comment will be highly appreciated.

Thanks

Tonto
0
Comment
Question by:Tonto Okonita
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 35

Accepted Solution

by:
Gary Patterson earned 500 total points
ID: 41756306
I think the scope of the request may be a little big for a forum like this.  As a consultant, I'd charge a client a significant fee for this kind of research project, since it would take a considerable amount of time.

Odds are just about any monitoring tools vendor will come back and tell you "sure, we can do all of those".

Here's my suggestion:

Organize your requirements by MONITORING MECHANISM.  For example: Log monitoring, Service monitoring, IP monitoring, Metric monitoring, etc., and then determine which of your candidate tools offer those capabilities.  NAGIOS, for example is very flexible, and is extendable with user-defined monitoring capabilities - so it can be used for just about any type of monitoring task you may require.  It may require some customization to do that, however.

But I can say the same thing about most robust monitoring tools, so odds are, just about any monitoring tool with broad capabilities, especially the ability to extend with custom scripts, can handle the tasks you've outlined.

If, on the other other hand, you're looking for a tool that can handle your requirements "out of the box" with minimal configuration, then I suggest you contact each vendor, send them your requirements, and request a demo that shows how to set the product up to cove all of your concerns - that's probably the best way to compare.
2
 

Author Closing Comment

by:Tonto Okonita
ID: 41758606
Thanks Gary! Much appreciated.
0

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Moving your enterprise fax infrastructure from in-house fax machines and servers to the cloud makes sense — from both an efficiency and productivity standpoint. But does migrating to a cloud fax solution mean you will no longer be able to send or re…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…
Suggested Courses

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question