Use the db2diag command and filter the DATA section for "sqlcode" followed by the particular code:.
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.
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.
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.
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.
Henrik's response below is right on the money. I have one more problem.