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

. $INSTHOME/sqllib/db2profile

should be the first line in your script ... (You'll not need to export DB2INSTANCE)

Cheers
Sathyaram

Thank you Satyaram

Cheers
-Rac