I am trying to run db2diag -A filename to archive
db2diag.log in /db2/SID/db2dump folder. It works fine from command
line, but does not work in crontab. I made a script that the crontab will
call. I get a db2 command not found error. I read on forum to add
-readfile option. I need help where to add this option.
My command in the script is
db2diag -A /backup/dump_xxx
this works fine from the command but not in the script, where should I add
the -readfile option.
Thanks a lot for the help.

Make sure that the instance profile ($INSTANCE_HOME/sqllib/db2profile) is executed by cron prior to db2diag. The easiest approach would be to schedule a script similar to this:

My guess is that the first line of you script need to load the DB2 profile:

Andy

are you suggesting I add
/db2/db2<SID>/sqllib/db2dump
the physical location as the first line after #!/bin/sh entry

The reason you are getting the command not found error is because your DB2 environment is not set up properly through cron. By loading the profile as the fist line, like we have suggested, this will fix the problem.

Andy

No, this is not at all what I am suggesting. Must be a trick question...

Yes, you need the -readfile option to make it work in cron. This is due to some sadistic IBM programmer who owes 2 weeks of my life back that it took me to figure this out.

db2diag -A /directory_name_for_archive_file
where do I put -readfile option
db2diag -A -readfile /directory_name_for_archive_file
because it says after -A option other options are overlooked

The readfile option has nothing to do with a file name, which is why it is so stupid.

db2diag -level Error,Severe,Critical -H 60m -readfile

This returns all Error,Severe,Critical errors in the last 60 minutes. The doc on this command is pathetic.

Thanks Marcus - you're absolutely right about the solution. If you're trying to use
db2diag in a script that crontab invokes, use the -readfile parameter. I can't tell you how many variations of running sqllib/db2profile and other things within the script I've tried, but -readfile worked right away.