Results 1 to 12 of 12
  1. #1
    Join Date
    Jul 2008
    Posts
    131

    Unanswered: diagnostic log for v9.5

    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?

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    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

  3. #3
    Join Date
    Jul 2008
    Posts
    131
    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???

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    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.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    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
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  6. #6
    Join Date
    Jul 2008
    Posts
    131
    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

  7. #7
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Diaglog path for v9.5

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

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

    Have Fun,
    DBFinder

  8. #8
    Join Date
    Jul 2008
    Posts
    131
    hey thanks, i din't did the search for hidden files and folders(just needed to apply comman sense).......:-)

  9. #9
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    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.
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  10. #10
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    On DB2 9.5 for Windows, the DIAGPATH is blank by default.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  11. #11
    Join Date
    Jan 2007
    Location
    Jena, Germany
    Posts
    2,721
    Ah! It's too good that I wrote "on Linux" ;-)
    Knut Stolze
    IBM DB2 Analytics Accelerator
    IBM Germany Research & Development

  12. #12
    Join Date
    Jul 2008
    Posts
    131
    friendzzzzzzz,
    the directory path is specified by parameter 'db2instprof' on windows.
    just execute the following command: db2set -all

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •