(Ep. 11) – Exploring the Db2 Error Log

The error log can be intimidating. Sometimes the error log seems to have too much information to parse, sometimes it doesn’t seem to have enough. This episode will cover how to find the error log, how to effectively mine information found inside, and some oddball tips to help you along.

Timestamps:
00:44 – Where is it the error log?
02:16 – What is in the error log?
03:43 – Cool ways to look up error codes
06:35 – Command line walkthrough
09:59 – How to use PD_GET_DIAG_HIST

GitHub Repository:
https://github.com/MKrafick/DiscoverDB2

PARSE_DIAG.ksh
A quick script that takes a database name and pulls 24 hours of
DB2DIAG.log details via PD_GET_DIAG_HIST.

Useful Links:
(Blog) DB2 Error Logging – https://tinyurl.com/ybxgzzs8
(Blog) db2diag tool for Parsing the Diagnostic Log – https://tinyurl.com/7q3pnqu