DB2 UDB Monitoring

I’ve started work on a UDB snapshot monitoring tool to gather and retain information from database servers. Only minimal thought has gone into reporting at the moment, but this will probably be web based.
The current proof of concept code can set the required monitor switches, gather all of the key snapshot data from the Admin API (db2GetSnapshot) and produce formatted reports. This represents most of the tedious grind work, so now it’s time to move onto the interesting bits and pieces – specifically:
  • Multi-threaded snapshot gatherer
  • TCP/IP communications between gatherer threads and the data store engine.
  • Data store engine.
  • (Probably) Apache / PHP front end with self refreshing pages showing status information

Don’t come to the habit of writing down one or two lines of your essay, changing idea regularly as required for topic for a while, writing an additional line, and staying back for a coffee break. Take a seat, turn off your cell phone – and even also your internet connection if you have – and put together your plan and collect all your examples on paper. Then start writing.

This entry was posted in DB2, DB2 Monitoring, DB2 Tools, James Gill and tagged , , , . Bookmark the permalink.