Skip to Main Content
DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition
book

DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition

by Raul F. Chong, Clara Liu
October 2013
Beginner to intermediate content levelBeginner to intermediate
784 pages
20h 55m
English
IBM Press
Content preview from DB2 Essentials: Understanding DB2 in a Big Data World, Third Edition

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL for Data Analysis

SQL for Data Analysis

Cathy Tanimura
Oracle DBA Fundamentals

Oracle DBA Fundamentals

Robert G. Freeman

Publisher Resources

ISBN: 9780133461930Purchase book