Hi ,
I am trying to run this script in crontab but I get errors. When I run it explicitly like ./monitor_tblsp from another location then it runs fine . I am messing somewhere with paths but I don't know where and how . Please help .
Here is the error part
./monitor_tblsp[14]: touch: not found [No such file or directory]
./monitor_tblsp[15]: chmod: not found [No such file or directory]
./monitor_tblsp[16]: touch: not found [No such file or directory]
./monitor_tblsp[17]: chmod: not found [No such file or directory]
./monitor_tblsp[18]: touch: not found [No such file or directory]
./monitor_tblsp[19]: chmod: not found [No such file or directory]
Database Connection Information
Database server = DB2/LINUXX8664 9.5.0
SQL authorization ID = DB2ADMIN
Local database alias = WAG_HUB
TSP NAME TOTAL SPACE USED SPACE % USED
./monitor_tblsp: line 31: cat: not found
./monitor_tblsp[61]: sort: not found [No such file or directory]
./monitor_tblsp[68]: /tmp/tmp_fsps.out: cannot open [No such file or directory]
./monitor_tblsp[69]: rm: not found [No such file or directory]
./monitor_tblsp[70]: rm: not found [No such file or directory]
./monitor_tblsp: line 71: rm: not found
Here is some of the lines from the script
more monitor_tblsp
#!/bin/ksh
#Script to find tablespace usage
PATH=/usr/bin::/home/db2admin/sqllib/bin:/home/db2admin/sqllib/adm:/home/db2admin/sqllib/misc
DB2INSTANCE=db2admin
LD_LIBRARY_PATH=:/home/db2admin/sqllib/lib:/usr/lib:/lib
export PATH DB2INSTANCE
tmpfile_listts=/tmp/tmp_tsls.out
tmpfile_fsps=/tmp/tmp_fsps.out
tmpfile_fsps_sort=/tmp/tmp_fsps_sort.out
touch ${tmpfile_listts}
chmod 660 ${tmpfile_listts}
touch ${tmpfile_fsps}
chmod 660 ${tmpfile_fsps}
touch ${tmpfile_fsps_sort}
chmod 660 ${tmpfile_fsps_sort}
Thanks in advance !
