diagnostic log for v9.5

nittal · #1 (**permalink**) 09-25-08, 08:13

Hi all,
m using db2 ESE v9.5 on windows
by what name is the diagnostic log file(db2diag.log) created in db2 v9.5 on windows. no file found by name 'db2diag' after the installation and also where is the system database directory present, i cant see any folder named db2 in sqllib folder?

ARWinner · #2 (**permalink**) 09-25-08, 08:19

The db2diag.log file is not created during installation. It is created when necessary by the Database Manager.

What do you mean by "System Database Directory"?

Andy

nittal · #3 (**permalink**) 09-26-08, 03:02

Hi,
when you run the following command: 'list db directory on c:' it take the contents from the directory C:\DB2\NODE0000\SQLDBDIR' which we call as local database directory and when give only 'list db directory' the contents of the output are taken from system database directory located at
C:\Program Files\IBM\SQLLIB\DB2\SQLDBDIR
This all m talking about is in db2v8.1 but i cant see any directory with name db2 in db2v9.5 at location C:\Program Files\IBM\SQLLIB\...
so wanted to know from where actually the output of command 'list db directory' comes from????
and i am talking about diagnostic log which we find in other versions with name 'db2diag' but no such file is found in v9.5. is it created by any other name???

Marcus_A · #4 (**permalink**) 09-26-08, 03:37

The file name is db2diag.log and is located in the instance path, not the database path. This is because it has messages for the instance, not just one specific database.

I am not sure about Windows, but on all other OS's it is located in <instance-home>/sqllib/db2dump path. Note that the SQLLIB path mentioned here is not the same SQLLIB path as in the database path.

rahul_s80 · #5 (**permalink**) 09-26-08, 04:45

In 9.5 its saved in totally seperate directory. i think under document and settings folder.
Just have a complete search on ur system for db2diag.log

nittal · #6 (**permalink**) 09-26-08, 05:46

did a search on complete system, no such file found....
I know in linux but not on windows....plz. if anyone know do let me know

DBFinder · #7 (**permalink**) 09-26-08, 06:46

C:\Documents and Settings\All Users\Application Data\IBM\DB2\DB2COPY1\DB2

'Appliction Data' is a hidden folder, That's why !

Have Fun,
DBFinder

nittal · #8 (**permalink**) 09-26-08, 07:01

hey thanks, i din't did the search for hidden files and folders(just needed to apply comman sense).......:-)

stolze · #9 (**permalink**) 09-26-08, 23:56

Quote:

Originally Posted by rahul_s80

In 9.5 its saved in totally seperate directory. i think under document and settings folder.
Just have a complete search on ur system for db2diag.log

You can avoid the search by looking an the DBM CFG parameter named DIAGPATH. In V9.5 on Linux, it is still pointing to sqllib/db2dump/db2diag.log by default.