O'Reilly logo

Understanding DB2®: Learning Visually with Examples, Second Edition by Dwaine R. Snow, Michael Dang, Xiaomei Wang, Raul F. Chong

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required