I want something simple and easy to use, and FREE. Can I get my hands on something already developed? Should I use SMF/RMF records as input?
There are a lot of performance products on the market that can help you to gain an understanding of the CPU utilization of your DB2 subsystems, but of course, the vendors who wrote those products will need to be paid for the functionality. Vendors like BMC Software, Computer Associates, Quest Software, and even IBM offer performance monitoring and tuning solutions that can help you to get the information you desire.
If you want something for free, you might be able to write a rudimentary performance tool that reads SMF records to report on CPU usage and utilization. But that means you will need to understand the layout of the DB2 trace records and spend a significant amount of time writing the code yourself.
You might try SHARE (www.share.org) to see if they have some shareware that might give you some useful information. At one time they used to distribute a tape of useful programs that were user-written and supported (perhaps not supported though). Good luck!
Dig Deeper on IBM DB2 management
Related Q&A from Craig S. Mullins
Our expert suggests that the best way to pass the SAP BW exam is to have hands-on job experience. But that's not all he has to say about ... Continue Reading
To export data from a DB2 table to a flat file, you need to run an export specifying the proper file format. The export utility exports data from a ... Continue Reading
Craig Mullins recommends two specific resources for learning how to create and support Binary Large Objects (BLOB) in DB2. Continue Reading