DB2 Diag

Posted on 2011-10-10
Last Modified: 2012-05-12
Will there be any issue if I move/remove the db2diag.log file.
Question by:syedmquadri
    LVL 37

    Expert Comment

    there is a configuration parameter that points to the db2diag path, so if you move/ remove the file, a new file will be created in that location
    LVL 16

    Assisted Solution

    by:theo kouwenhoven
    Hi syedmquadri,

    No there isn't any problem as momi_sabag already declared, but!!! if it's a production sever, be carefull, maybe it contains usefull info.
    What we do is rename the db2diag.log file every day, after removing the logfile from the day before,
    So you have always 24 hour info... any problem after that time isn't use full to check (most of the time).


    Accepted Solution

    If you issue this command, the current db2diag.log file will be renamed and a new one restarted:

                  db2diag -A

    There are some other options for this that allow you to save the old db2diag.log file to a different location and/or name. Once "archived", you can compress the file to save space. You need to have sysadm privs since it needs to deal with the db2diag.log file. For more detail about the command, see the reference below.


    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    Suggested Solutions

    Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
    Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
    This video discusses moving either the default database or any database to a new volume.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now