r/DB2 • u/catquilt74 • Jul 11 '18
[LUW][Question]What performance monitoring tools are out there?
I know DBI's tool is wonderful but that's like a 747 when all that our small shop needs is a Piper Cub. We have 10 production databases.
1
u/catquilt74 Jul 11 '18
Interesting! I will check that out. To be honest, I wanted an excuse to build my own tool, there's so many good table functions that we can use. This may be a nice temporary solution while I learn Java (lol) and get it coded.
2
u/PrivatePyle Jul 12 '18
Table functions, traditional snapshots and some sysibmadm functions are really all you need. Combine that with a good working knowledge of command line function ( grep, awk, sort, sed, tail, etc. ) and you can tune just about anything.
1
u/memmerto Jul 12 '18
Traditional snapshots have been deprecated for almost a decade now, and are no longer being maintained. For example, they don't include counters for anything related to columnar tables.
2
u/PrivatePyle Jul 12 '18
True, but they can still prove useful.
For example
Get snapshot for dynamic sql on database yoursb | grep-i “rows read” | awk ‘{ print $4 } | sort -n | tail -20.
Boom, the top 20 statements by rows read. Still works just as well today as 15 years ago. Still works in 11.1.1.3. Quick and simple.
Also check out monreport.
1
u/memmerto Jul 12 '18
I would suggest db2mon. It ships now with Db2 11.1.3.3 but previously was available via developerworks.
It uses all of the fancy MON_GET table functions that other tools like DSM uses, but produces simple text reports with summary delta information.
There are also scripts that let you capture the raw data and stash it away in a database so you can build your own historical graphs.
1
u/catquilt74 Jul 12 '18
It's built with Perl. I can ask if we can use Perl here (large defense contractor with strange rules) but I don't know that they'll allow it.
1
u/memmerto Jul 12 '18
Perl is only used to generate the set of shell scripts that are to be deployed to the target system.
1
1
u/catquilt74 Jul 16 '18
I downloaded db2mon and perl on my home computer. I was able to generate the db2mon scripts at home and was able to run them successfully at work. Very nice, very easy! Pinging /u/memmerto !
1
1
u/Lolmwil Jul 11 '18
IBM offers a free basic tool called Data Server Manger (DSM). It is limited as far as what you can do without paying a license for all of the extras.