Chapter 18. Diagnosing Problems

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

Problem Diagnosis: The Big Picture

Figure 18.1 provides an overview of the actions that you should perform to investigate any issues you encounter when working with DB2. ...

Get Understanding DB2®: Learning Visually with Examples, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.