Chapter 7. Monitoring and tuning of DB2 UDB V8 253
can set up what should be done in a case of an alert so that the system can heal
itself.
The
Memory Visualizer is a part of the Health Center. With the Memory
Visualizer you can monitor the memory usage like sort heaps, buffer pools, and
caches. It displays the memory allocation for a particular instance and all of its
databases. Because many of the memory configuration parameters are dynamic,
you can change these parameters and monitor if your change has the expected
result.
7.1.6 Design Advisor
Indexes play an important part in tuning the performance. An index is good when
retrieving data because data access is, in general, much faster through an index
than scanning an entire table to find ...