The administration notification file

Diagnostic information about errors is recorded in the administration notification file. This information is used for problem determination and is intended for Db2® technical support.

The administration notification file contains text information logged by the Db2 database system as well as by Db2 Spatial Extender. It is located in the directory specified by the diagpath database manager configuration parameter. On Windows operating systems, the Db2 administration notification file is found in the event log and can be reviewed through the Windows Event Viewer.

The information that the Db2 database manager records in the administration log is determined by the diaglevel and notifylevel settings.

Use a text editor to view the file on the machine where you suspect a problem to have occurred. The most recent events recorded are the furthest down the file. Generally, each entry contains the following parts:
  • A timestamp.
  • The location reporting the error. Application identifiers allow you to match up entries pertaining to an application on the logs of servers and clients.
  • A diagnostic message (usually beginning with "DIA" or "ADM") explaining the error.
  • Any available supporting data, such as SQLCA data structures and pointers to the location of any extra dump or trap files.

If the database is behaving normally, this type of information is not important and can be ignored.

The administration notification file grows continuously. When it gets too large, back it up and then erase the file. A new file is generated automatically the next time it is required by the system.