37

I want to run my script in crontab, but I have some problems...

In my script I run this command:

db2 connect to myDB2

This works fine when I run this as db2inst1 user, but when I run this script in db2inst1 crontab, I get this:

db2: command not found.

How can I solve this?

55

To avoid having to type the absolute path to a command, shells introduced the $PATH environment variable, each directory is separated by a : and searches are done from left to right. cron often clears the whole environment, including this $PATH variable. Therefore, the script may behave differently in your cron compared to the behavior in the shell.

Use absolute paths

Run which db2 as db2inst1 user to get the full path for the db2 program. If the output is /usr/bin/db2, your cron command would look like:

/usr/bin/db2 connect to myDB2

Set the PATH variable

Run echo "$PATH" as db2inst1 user to get the $PATH variable and make sure this variable is available in your cron script too. For example, if the output was /usr/local/bin:/usr/bin:/bin, you would put the next line in the top of your shell script:

export PATH="/usr/local/bin:/usr/bin:/bin"
11

As answered in https://askubuntu.com/a/23438/227839, you should set PATH in your shell script:

#!/bin/bash
PATH="/usr/local/bin:/usr/bin:/bin"

# rest of script follows

or in the crontab file, which will apply to all cron jobs:

PATH="/usr/local/bin:/usr/bin:/bin"
0 1 * * * db2 connect to myDB2
1
3

You must define what db2 and myDB2 are, otherwise use the absolute location of 'file' or 'application' which want to run.

Example:

/bin/rm /home/ubuntu/a.txt

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.