Troubleshooting Guide

Using the Administrative Tools Log

Errors and warnings generated by DB2's graphical administrative tools are logged to an ASCII file. This file contains entries from all of the tools, including the Control Center.

Notes

• This file grows continuously. Keep this in mind, if lack of disk space is a problem.
• You can specify where the log file is stored with the following command:

  set DBTLOG_FILE=location
  

  • If location is a file name with a fully qualified path, the file is stored at that location.
  • If location contains a file name only, the file has that name, and is located in the directory specified by the DB2INSTPROF registry value. If this directory is read-only or does not exist, the file is located in the directory specified by the registry value DB2PATH.
  • If you do not use the set DBTLOG_FILE command or do not specify a value for location, the file's name is dbtcc.log, and it is stored in the directory specified by the DB2INSTPROF or DB2PATH registry values (as described above).
  For example, the following command will store the log file in d:\aelog.txt:

  set DBTTRACE_FILE=d:\aelog.txt
  

• If a log file cannot be opened for any reason, then an error message indicating this will appear on the screen.
• Occasionally, DB2 Customer Support may require more information than is in this log and request a DB2 tools trace. See Administration Tools Trace, for more information.

Administrative Tools Log File Sample

The following sample illustrates an administrative tools log file. Note that each entry is written to the file on a single line. In this example, the entries are truncated to fit on the page.

*------------ QDB2/2 SQL03010 Control Center Admin Engine Log Feb 17 09:48:58 1997 (1) ----* >ERR : (2) 09:49:10 (3) pid=22406 (4) tid=3 (5) [IBM][CLI Driver] SQL1032N No start (6) >SEV : 09:49:11 pid=22406 tid=1 Nonzero sqlcode at ..\\admin\aecm.cpp(357) - SQL ERROR ... *------------ End of Control Center Admin Engine Log Feb 17 09:49:28 1997 (7) ----* *------------ QDB2/2 SQL03010 Control Center Admin Engine Log Feb 17 09:49:28 1997 -------* >ERR : 09:50:11 pid=22410 tid=1 SQL Command: select schemaname, owner, remarks from sys... >ERR : 09:50:11 pid=22410 tid=1 [IBM][CLI Driver][DB2/2] SQL0204N "SYSCAT.SCHEMATA" ... >Warn: 09:50:12 pid=22410 tid=1 Nonzero sqlcode at ..\admin\aelist.cpp(2097) - No data ... *------------ End of Control Center Admin Engine Log Feb 17 11:44:12 1997 -----------*

Legend:

(1)

A line indicating when the tool was started

(2)

The type of message (Informational, Warning, Error, or Severe)

(3)

A timestamp

(4)

The process ID

(5)

The thread ID

(6)

An SQL code and message text (truncated in this example)

(7)

A line indicating when the tool was closed