Appendix D. Diagnosing Problems

Inevitably when working with any kind of software, you will encounter at one point or another some problem or performance degradation that you must resolve. This appendix describes how to investigate issues you may encounter while working with DB2 and how to troubleshoot them using DB2 diagnostic information.

In this appendix, you learn about

• The big picture of DB2 problem diagnosis

• Obtaining more information about an error message, including how to use the help (?) command

• Collecting diagnostic information: First Occurrence Data Capture (FODC) and other troubleshooting tools

• The db2support tool

• The trace facility

• Searching for known problems

Problem Diagnosis: The Big Picture

Figure D.1 provides an ...

Get DB2 Essentials: Understanding DB2 in a Big Data World, Third 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.