
Chapter 7. Database server monitoring 179
...
The db2exfmt and Visual Explain utilities require the DB2 Explain tables to be
created for each user who is executing the explain commands. The db2expln and
dynexpln utilities allow dynamic SQL to be explained without using DB2 Explain
tables. Further details about the db2expln, dynexpln, and Visual Explain utilities
can be found at the DB2 Information Center:
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp
7.1.4 DB2 UDB diagnostic log
DB2 UDB provides a diagnostic capturing mechanism. It writes information into a
file called
db2diag.log. By default, this file is located in:
On UNIX platf ...