Excel sheet to monitor your diaglog – Try it today

by on November 11, 2011

Monitoring diaglog is a typical daily DBA chore. But sometimes it is tedious to go through the volume of data in the diaglog .  As mentioned in my previous blog post Monitoring diaglog , there are different ways to keep track of diaglog

We have come up with an excel sheet that will automatically generate graphical reports to monitor diaglog. This is not ODBC connection method and we will talk about that in the coming up posts.Please follow the below steps , use it and give us your feedback

Below are the 3 simple steps you will be doing to handle this utility:

1)Connect to your database
2)Run the following query. This will generate a del file called test.del in the present working directory

db2 “export to test.del of del  SELECT T.* , ‘#’ FROM TABLE ( PD_GET_LOG_MSGS( CURRENT_TIMESTAMP – 15 DAYS)) AS T  where msgseverity IN (‘E’,'C’)”

3)Run the following code snippet on the del file (Please run it from the directory where you have the del file)

cat test.del | tr -d ‘\n’ | tr “#” “\n” | sed ‘s/\”\”\”,”$/\”/g’   > test.del


4)Please insert the del file using the SELECT FILE button on the excel sheet (Chart tab)

5)You should see data on data tab and report on chart tab .. Errors are in yellow color and Severe messages in red colour

NOTE: You can change the number of days you want in the query

NOTE: Please report any errors to nivasniche@gmail.com


———->> Download the excel sheet by entering your email below<<————


{ 2 comments… read them below or add one }

Amr Roushdi November 13, 2011 at 6:16 pm

It is a nice idea . However this is for UNIX only . Do u have a win flavor ?? windows does not have cat or SED .
also it would be nice to make a zip / targz file containing the excell sheet as well as the export , cat ..SEd

Thanks for this effort


nivas November 13, 2011 at 11:06 pm

Thanks for your feedback.. We are working on some modifications and will definitely consider your points


Cancel reply

Leave a Comment

Previous post:

Next post: