In this chapter, we build on the information covered in Chapter 11, concentrating on evaluating and tuning DB2 instance and database configuration parameters based on output from the DB2 monitoring facilities. We’ll use data from the following DB2 facilities and tools:
SQL administrative routines
SQL convenience views
Health Center and Health Monitor
You’ll learn how to use the output from these monitoring facilities, and I’ll recommend which monitoring facilities to use for various performance problems. We’ll also discuss how to arrive at specific tuning and performance recommendations, examine the new DB2 9 Self Tuning Memory Manager ...