executing db2diag remotely

engee · 11-05-2009, 02:43 AM

Hi guys,

I've run into a bit of a problem here, I've got this script that runs db2diag on the various instances on the server, it works like a charm when I execute it locally, but when I execute it remotely via our scheduler it seems something is missing. The script runs fine without any errors (that I can see) with the only downside that db2diag doesn't generate anything, just empty logs.

Code:

function check_error
{
     if [ "$VERBOSE_LOGGING" = 'high' ]; then
          set -vx
     fi

db2diag -time $TIME1 -l Error|egrep -v -p -f db2.exclude>$f1

     if [ -s "$f1"  ]; then
          /usr/bin/mail -s "New errors in $db2inst on $HOST" $db2diagmail < $f1
     else
          echo $TIME1 > ${db2inst}/time.error
     fi
}

Result is the same if I 2>&1 to a logfile instead of egrepping.

Could it be the environment not being properly set even though .profile is executed earlier in the script?

Have any of you guys experienced the same or a similar issue, or got any clues about what might be causing this?

MBybee · 11-18-2009, 06:10 PM

How are you executing it when you call it remotely?

engee · 11-26-2009, 09:38 AM

Quote:

Originally Posted by MBybee

How are you executing it when you call it remotely?

I get the same "result" when I'm submitting it via crontab, so I dare say it's environmental, don't suppose you've got a good checklist I can lend?

MBybee · 11-30-2009, 10:27 AM

Quote:

Originally Posted by engee

I get the same "result" when I'm submitting it via crontab, so I dare say it's environmental, don't suppose you've got a good checklist I can lend?

You might want to try using 'readfile':

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

That, and make sure you have the profile set, the environment set, etc etc.

<edit>Here's a pub lib link that has all the switches: http://publib.boulder.ibm.com/infoce...c/r0011728.htm </edit>