Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2006
    Posts
    20

    Unanswered: Error Log in db2 how to see ?

    I m new to DB2 did finish the training... could some one tell me how can i see the error log ?

  2. #2
    Join Date
    Mar 2006
    Posts
    20
    error log mssg in DB2

  3. #3
    Join Date
    Nov 2004
    Posts
    374

    eror log

    do you mean : db2diag.log ?
    this is located by default in ../sqllib/db2dump (unix)
    ../sqllib/instancename/ (windows)
    do : db2 get dbm cfg <--- check diagpath = location of db2diag.log
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  4. #4
    Join Date
    Mar 2006
    Posts
    20
    Thanks Guy Przytula

    Some further queries - How many types of error logs are there in DB2?
    If a Backup Job fails I get an email backup failed, as a DBA how can i move further to see the detail error..? In SQL Server we use to see through job history & sqlserver error log Is there any kind of similar error log in DB2?

  5. #5
    Join Date
    Sep 2011
    Posts
    57

    Question Also ask

    Hi, i'm looking for the table that contains error log. I mean data system. I wanna make a query to this data.

    Regards.

  6. #6
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    I hope you also finished the db2 training - it should be a mandatory prereq before coming to a forum to understand at least what you are doing.
    all messages are in diag.log or in db2dump directory - there are no sysibmadm views for this - you can extract complete messages from diaglog with db2diag tool
    db2diag - db2diag logs analysis tool
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

Posting Permissions

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