Hi,
In crontab I have the following line:
-----------------------------------------------------------------------
32 15 * * * db2 -tvf '/home/db2inst1/query.sql' > a.out
-----------------------------------------------------------------------
Make that
-
In crontab I have the following line:
-
-----------------------------------------------------------------------
-
32 15 * * * . ~/.profile ; db2 -tvf '/home/db2inst1/query.sql' > a.out
-
-----------------------------------------------------------------------
-
When running from crontab, the DB2 environment is missing. Setting it by premitting a ". ~/.profile" should fix this.
Regards, Bernd