IBM 51 manual Locating the runtime log files, Locating the DB2 Universal Database runtime logs

Table 12. Remote registry database installation log files

Log File	Description
datastore.out	A log of the SQL statements that are run to create the registry
	database and its tables.
ds_install.log	An ISMP log for installing the files necessary to create the registry
	database.
db_stdout.log	Standard output and standard error logs for creating the registry
db_stderr.log	database. Check db_stdout.log first to see if the registry was
	created successfully.

Locating the runtime log files

The runtime logs for the agent manager are located in the was_install_dir\logs\ app_server_name directory, where app_server_name is the name of the application server. By default, this is Agent Manager.

The runtime logs for WebSphere are located in the WAS_install_dir\logs\server1 directory.

Additional logs are in the was_install_dir/logs/ffdc directory.

Locating the DB2 Universal Database runtime logs

DB2 Universal Database provides several First Failure Data Capture (FFDC) facilities that log information as errors occur. The DB2 Universal Database FFDC facilities are used with CLI and DB2 traces to diagnose problems. The information captured by DB2 Universal Database for FFDC includes:

db2diag.log

When an error occurs, the db2diag.log is updated with information about the error. This is the primary log to use when debugging DB2 Universal Database problems.

db2alert.log

If an error is determined to be an alert, then an entry is made in the db2alert.log file and to the operating system or native logging facility.

dump files

For some error conditions, additional information is logged in external binary dump files named after the failing process ID. These files are intended for DB2 Universal Database Customer Support.

trap files

The database manager generates a trap file if it cannot continue processing because of a trap, segmentation violation, or exception. Trap files contain a function flow of the last steps that were executed before a problem occurred.

Other useful DB2 Universal Database commands include:

db2trc This command gives you the ability to control tracing.

db2support

This command collects environment information and log files and places them into a compressed archive file.

82Tivoli Intelligent Orchestrator Problem Determination and Troubleshooting Guide