Chapter 2. DB2 UDB architecture overview 103
particular health indicator, and a new snapshot command to retrieve a state of an
db2 get alert cfg for database manager
db2 get description for health indicator db.spilled_sorts
db2 get recommendations for health indicator db2.spilled_sort
db2 get health snapshot for database manager
For more details on health indicator attributes, refer to DB2 UDB System Monitor
Guide and Reference, SC09-4847.
2.6.10 Memory Tracker
DB2 UDB Version 8 introduced the Memory Tracker tool db2mtrk, which provides
a complete report of memory utilization for instances, databases and agents. The
Memory Tracker will implicitly attach to the instance, without requiring the user to
explicitly do so.
Figure 2-24 shows instance and database values.
Figure 2-24 Memory Tracker
For more details on Memory Tracker, refer to DB2 UDB Command Reference,
2.6.11 Memory Visualizer
DB2 UDB Version 8 Memory Visualizer is new GUI interface for uncovering and
fixing memory related problems of an instance. Memory Visualizer may be
invoked from “Health Center recommendations”, or independently as its own