This chapter describes how to investigate issues you may encounter while working with DB2 and how to isolate them using the diagnostic information that is provided by DB2. Once you isolate the problem, you can determine its root cause, and search for possible solutions and workarounds including previously reported problems.
In this chapter you will learn about:
The big picture of DB2 problem diagnosis
Obtaining more information about an error message
Collecting diagnostic information: First Failure Data Capture (FFDC)
The db2support tool
The trace facility
Figure 18.1 provides an overview of the actions that you should perform to investigate any issues you encounter when working with DB2. ...