Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2003
    Posts
    1,605

    Unanswered: Is there any db2diag db2dump file viewer?

    Hi,
    yesterday I had severe problem with DB2 v9.5 on Linux, DB2 was crashing every few minutes. Looking into db2diag.log every time crash appeared there was db2dump file created. Looking into this dump binary files is nightmare - so little info is in clear text that is almost impossible to get any real info. The problem was solved getting tiny information from db2dump file. My question is, is there any tool or something to format db2dump files into human readable format?
    Thanks

  2. #2
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    yes there is, because ibm support uses this to format the trap/dmp...
    it is for service people only .. you can always request ibm support center to have a copy..
    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

  3. #3
    Join Date
    Jan 2003
    Posts
    1,605
    But is this tool available to download without nagging the support channel?

  4. #4
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Dump files are only useful for db2 development (and sometimes db2 support). Trap files on Unix/Linux are readable and can help identify the root cause. If the crash is not due to a db2 bug, then the information in the db2diag.log / OS logs is helpful.

  5. #5
    Join Date
    Jan 2003
    Posts
    1,605
    I have checked all the files, but the only useful info was in 7637.33.000.dump.bin file.

  6. #6
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Out of curiosity, what did you find in the dump file? sql statement?

  7. #7
    Join Date
    Jan 2003
    Posts
    1,605
    Sorry, in dump file I have found out a package name and tables that this package was accessing. That I know that the problem is related to changed primary key done in the same day. Then I have rebind the package using command "db2 rebind package <package_name>" and problem was solved. But in the mean time database was crashed 20-times in more then one hour. Not funny thing at all. I have reported a PMR now after crisis is over and it looks like a bug in DB2 and there is already APAR that recommends installing fixpack 6a for db2 v9.5.

    But if similar problem appears in the future I would like to diagnose the problem much earlier without breaking the nerves. So it would be nice if db2dump file is more readable.
    Last edited by grofaty; 04-20-12 at 13:18.

  8. #8
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    The package name should also be in the db2diag.log. db2diag.log may also contain the sql text (but it gets truncated to x number of char) if the query is responsible for the crash.

Posting Permissions

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