Understanding DB2®: Learning Visually with Examples
by Raul F. Chong, Clara Liu, Sylvia F. Qi, Dwaine R. Snow
17.10. Summary
This chapter discussed how to diagnose problems encountered while working with DB2. DB2 reports problems using error messages and codes. The help (?) CLP command is a quick method to obtain more information about a particular error code.
The First Failure Data Capture (FFDC) is a generic term that refers to several diagnostic files that are generated or updated automatically by DB2, like the administration notification log or the file db2diag.log. Use the db2support tool to collect these diagnostic files automatically in a zip file called db2support.zip. For some types of problems, like hangs or crashes, DB2 Technical Support may ask you to collect a DB2 trace.
Check the DB2 documentation; it usually provides the answer to most ...
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.
Read now
Unlock full access