
Chapter 9. Integrated troubleshooting 353
Besides the log files and traces investigation for the problem determination, SQL
statement access plan analysis is also very useful to identify performance
bottlenecks. For example, you could use event monitor to find out the typical or
resource consuming SQL statements, then use SQL Explain utilities to do further
analysis against specific SQL statements. Regarding more information about
DB2 SQL Explain Facilities, refer to the Chapter 7, “SQL Explain facility,” in
Administration Guide: Performance, IBM DB2 Universal Database, Version 8,
SC09-4821.
9.2.2 WAS V5 diagnostic information collection and ...