Friends,
The requirement is DB2LOOK should run in cron job every mid night in EEE.
Script
====
DATE_HOUR=`date +"%y%m%d.%H.%M.%S"`
DB2INSTANCE=db21
export DB2INSTANCE
/db21/sqllib/bin/db2look -d edwtest1 -u db21 -l -o /db21/DB/db2look
/dlt$DATE_HOUR.out 2> /tmp/test
Crontab
=====
04 19 * * * /db21/DB/scripts/db2look.ksh > /dev/null 2<&1
/tmp/test
======
-- Output is sent to file: /db21/DB/db2look/dlt031107.19.04.00.out
sh: db2_all: not found.
Any solutions.....
-Rac