Diagnostic Error Files
DB2 records warnings and errors as a normal part of its operation. By default, error logs are placed in the sqllib\<instance-name> directory in Windows and OS/2, and in the <instance-owner>/sqllib/db2dump directory in Unix. You can modify the location where errors are logged by setting the DIAGPATH variable in the database manager configuration.
db2diag.log
This is the primary diagnostic log for DB2 UDB and should be the first point of reference for the administrator whenever unexpected errors occur. The DIAGPATH parameter can be used to alter the location that this file is written to. The default location is sqllib/db2dump for UNIX platforms and sqllib/db2 for Windows platforms. The DIAGLEVEL parameter controls exactly ...
Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd 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.
