Db2diag.log how to read

Use the db2diag command and filter the DATA section for "sqlcode" followed by the particular code:.

db2diag.log how to read

Sign up using Facebook. Post as a guest Name. Can U plz help me? You probably have the full documentation of the db2diag tool. Hot Network Questions.

How to read archived db2diag.log?

Sign up using Email and Password. But the details for all the errors are different and I need to have one generalized command to fetch all the errors of level Severe and saying that No storage available in Database heap memory, so that i can monitor my diaglog and i can avoid Db crash in future. You could then format the output and extract only the part of the log records you need.

db2diag.log how to read

Can any one help me with the command? Use the db2diag command and filter the DATA section for "sqlcode" followed by the particular code: Sign up or log in Sign up using Google. If you want to keep this for the purpose of root cause analysis, it is always better to save or examine the entire db2diag.

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service , privacy policy and cookie policy , and that your continued use of the website is subject to these policies. Sometimes problems begin far before they result in an SQL code, and the preceding diagnostic messages might be quite important.

db2diag.log how to read

Stack Overflow works best with JavaScript enabled. And as per IBM its a bug in 10. By using our site, you acknowledge that you have read and understand our Cookie Policy , Privacy Policy , and our Terms of Service.

How to Check and Monitor db2diag.log in AIX and Windows

And the errors that got captured are showing No storage available in database heap memory. I tried grepping for a particular word and that was the only option left i guess. A generalized command for monitoring this error.

db2diag.log how to read

Henrik's response below is right on the money. I have one more problem.

db2diag.log how to read