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

[Simon Mc]

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)

[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

[Artur]

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

[Artur]

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

[Knut Stolze]

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

[Artur]

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.

[Knut Stolze]

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

[Simon Mc]

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