Q and A

Asked and Answered

Q. I read your article regarding snapshot and event monitoring and am looking for more information. Once we take a snapshot, I see a lot of information. Where can I find documentation that will help me understand what it all means?

Roger Sanders responds:

The best advice I can give you is to look at the "System Monitor Guide and Reference" manual that comes with the DB2 documentation. You can access this manual from the IBM Web site (http://www.ibm.com/ software/ data/db2/ udb/ad/ db2irfp7/ db2ir164.htm).

If you know how to interpret C code, you can look at the header file db2ApiDf.h that comes with the application development client. This file contains codes that can be used to parse the stream of monitor data that is returned by the db2GetSnapshot() API.

Read the Distributed DBA columns on performance monitoring: Part 1, Part 2, and Part 3.

See a complete archive of reader/author Q&As .