[Last Call] Learn how to a build a cloud-first strategyRegister Now


DB2 Diag

Posted on 2011-10-10
Medium Priority
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

ID: 36945878
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
theo kouwenhoven earned 1000 total points
ID: 36958078
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

data_bits earned 1000 total points
ID: 37041287
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 143

Expert Comment

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

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

November 2009 Recently, a question came up in the DB2 forum regarding the date format in DB2 UDB for AS/400.  Apparently in UDB LUW (Linux/Unix/Windows), the date format is a system-wide setting, and is not controlled at the session level.  I'm n…
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…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

829 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