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