Friday, December 18, 2009

Optimize the use of OMEGAMON DB2

Object Analysis is one of the most powerful and useful features of OMEGAMON DB2. Object Analysis will gather information on DB2 subsystem getpage and I/O activity, and in turn break out and correlate that information by DB2 object and by DB2 application. Object Analysis is a great tool for understanding where the DB2 database and application 'hot spots' may be happening. What makes Object Analysis nice is that it provides great information, but it does it without running expensive DB2 I/O traces.
A way to optimize Object Analysis usage is to use it when needed. If no one is looking at the data at the moment there may be no need to have it on. The user has the ability to turn it on when needed, and shut it back off when finished. In the RKD2PAR start up options for OMEGAMON DB2 all you need to do is make sure that the Event Manager is started (that portion always needs to be enabled for Object Analysis to run), but let the users manually start Object Analysis when they need it (you can see the options on the screen shot here).

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.