By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,585 Members | 2,235 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,585 IT Pros & Developers. It's quick & easy.

Where does DB2 UDB v 8 for UNIX write its application log files?

P: n/a
Hi, I'm new to DB2, currently working on Sybase. Is there a flat-text log
file where DB2 writes to at startup and when it wishes to log problems like
failed logins, expired passwords etc?

(The equivalent in Sybase is the Sybase errorlog.)

--
Regards,

Simon Mc
(remove "nospam" to reply)
Nov 12 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
Ian
Simon Mc wrote:
Hi, I'm new to DB2, currently working on Sybase. Is there a flat-text log
file where DB2 writes to at startup and when it wishes to log problems like
failed logins, expired passwords etc?

(The equivalent in Sybase is the Sybase errorlog.)


It writes to db2diag.log and <instance>.nfy files in the
<instancehome>/sqllib/db2dump directory

Nov 12 '05 #2

P: n/a
On Windows db2diag.log file is located on:
<db2 installation directory>\<instance name>

Also useful:
db2diag -- tool you can use to filter diagnostic messages.

Regards,
Artur Wronski

Nov 12 '05 #3

P: n/a
Just one thing more. Not all activities you can be interested in are
logged to db2diag.log.

Look for db2audit utility if you need more.

Artur Wronski

Nov 12 '05 #4

P: n/a
Artur wrote:
On Windows db2diag.log file is located on:
<db2 installation directory>\<instance name>

Also useful:
db2diag -- tool you can use to filter diagnostic messages.


And the true reference to the directory is shown in the database maneger
configuration, option DIAGPATH.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 12 '05 #5

P: n/a
Knut Stolze wrote:
And the true reference to the directory is shown in the database maneger
configuration, option DIAGPATH.


Of course when it is set, DIAGPATH by defualt is null
Cheers :-)
A.W.

Nov 12 '05 #6

P: n/a
Artur wrote:
Knut Stolze wrote:
And the true reference to the directory is shown in the database maneger
configuration, option DIAGPATH.


Of course when it is set, DIAGPATH by defualt is null
Cheers :-)


You are correct on Windows. On AIX and Linux, you will find that the
DIAGPATH is set implicitly when the instance is created. So you can rely
on that information on non-Windows systems.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 12 '05 #7

P: n/a
Thanks for all your useful replies.

Simon Mc.
"Knut Stolze" <st****@de.ibm.com> wrote in message
news:di**********@lc03.rz.uni-jena.de...
Artur wrote:
Knut Stolze wrote:
And the true reference to the directory is shown in the database maneger
configuration, option DIAGPATH.


Of course when it is set, DIAGPATH by defualt is null
Cheers :-)


You are correct on Windows. On AIX and Linux, you will find that the
DIAGPATH is set implicitly when the instance is created. So you can rely
on that information on non-Windows systems.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Nov 12 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.