Hi All
I am working with db2 v8.2 and aix 5.3

I am trying to write a shell script to check db2diag.log for Severe error and email to dba, I wrote as follow

#! /usr/bin/ksh
. /home/dba/.profile


SCRDIR=/home/dba
cd $SCRDIR

. ~insti1/sqllib/db2profile
TIMESTAMP=`date +%Y-%m-%d.%H:%M
LOGFILE="/home/dba/DBBOX-db2diag.$TIMESTAMP"
db2diag -g db:= -gi LEVEL=Severe >> $LOGFILE
cat $LOGFILE | mail -s "Checking error @ $( hostname ) --DBA@xxx.com $TIMESTAMP"

it works manually fine but when I put the job on crontab to check every 5 minutes and send email, always LOGFILE is empty

Please help I rid off this issue .

Thanks

Do you mean that the file on disk is empty or doesn't exist - or the email doesn't contain the respective details? If the file on disk is empty, you should verify under whose authority the cronjob is running. Maybe that user doesn't have the necessary privileges to create the file and write to it?

Hi Stolze,

I seems db2diag command does not work under crontab job and as result LOGFILE is empty, I created crontab job under "dba" i wrote other crontab jobs all works fine, it seems crontab can not read db2diag.log (because manually works fine).

I will try to resolve the problem , just in case could you please help me I write script and run manually (search for "severe" error every 5 min if found send email ).

Thank you in advance.

Have you verified that "db2diag" cannot be run from a cronjob? Have you verified that the cronjob is running as user "dba"? Try to write your LOGFILE to a file under /tmp/ to take privilege issues out of the picture. You should also write any error messages to a file under /tmp/ to see of something goes wrong there.

It works under cron if you use the -readfile option:

db2diag -l severe -H 12d -readfile $HOME/sqllib/db2dump/db2diag.log > $HOME/scripts/db2diag.report

Marcus you are genius , it works fine , I was on this issue more than 3 days.

Thank you guys all .

Hi guys,

In continuation wit the thread, I also have th same issue, where db2diag doesnt work under cronjob even after adding -readfile option, Here is the syntax used :

db2diag -l error -H 300m -readfile /db2inst1/dba/db2diag.log >> /db2inst1/script/sch_script/error_log.txt

Also, the user db2inst1 has r/w rights, but db2diag doesnt gets executed.

Please help...........

Thanks very much.

in crontab job : also execute the profile to set the path to sqllib...
otherwise you have to specify the complete path for db2diag executable