AIX定制任务怎么不执行阿！

显示全部楼层 · 2007-9-26 17:05:46

s.sh如下：
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/db2inst1/bin:/usr/bin/X11:/sbin:.:/home/db2inst1/sqllib/bin:/home/db2inst1/sqllib/adm:/home/db2inst1/sqllib/misc:/usr/opt/IMinerX/V9.1/bin
db2 connect to churndb user test using test
db2 -tvf ins.txt
db2 commit
db2 connect reset
ins.txt 如下
insert into test.zte values (100);

然后 crontab -l如下：
* 12 * * * /home/db2inst1/s.sh
这样发现执行不了！
why？
[ 本帖最后由 myfriend2010 于 2008-6-23 12:49 编辑 ]

千问 · 2007-9-26 17:05:46

如果s.sh中将db2 -tvf ins.txt 行替换成db2 insert into test.zte values (100) 则定制任务可以执行成功！
但是如果换成文件的方式就不能执行！ why？

千问 · 2007-9-26 17:05:46

如果手动执行s.sh如下报错：
[db2inst1][/home/db2inst1]>s.sh
Database Connection Information
Database server= DB2/AIX64 9.1.0
SQL authorization ID = TEST
Local database alias = CHURNDB
.B21005EAn error occurred while accessing the file runstatus.sql
DB20000IThe SQL command completed successfully.
DB20000IThe SQL command completed successfully.
s.sh[6]: ^M:not found.
[db2inst1][/home/db2inst1]>cat s.sh
PATH=/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/db2inst1/bin:/usr/bin/X11:/sbin:.:/home/db2inst1/sqllib/bin:/home/db2inst1/sqllib/adm:/home/db2inst1/sqllib/misc:/usr/opt/IMinerX/V9.1/bin
db2 connect to churndb user test using test
db2 -tvf runstatus.sql
db2 commit
db2 connect reset
[db2inst1][/home/db2inst1]>cat runstatus.sql
insert into test.zxttest values(100);

千问 · 2007-9-26 17:05:46

但是这样执行成功：
[db2inst1][/home/db2inst1]>db2 connect to churndb
Database Connection Information
Database server= DB2/AIX64 9.1.0
SQL authorization ID = DB2INST1
Local database alias = CHURNDB
[db2inst1][/home/db2inst1]>db2 -tvf runstatus.sh
DB21005EAn error occurred while accessing the file runstatus.sh.
[db2inst1][/home/db2inst1]>db2 -tvf runstatus.sql
insert into test.zxttest values(100)
DB20000IThe SQL command completed successfully.
[db2inst1][/home/db2inst1]>db2 commit
DB20000IThe SQL command completed successfully.
[db2inst1][/home/db2inst1]>db2 terminate
DB20000IThe TERMINATE command completed successfully.

千问 · 2007-9-26 17:05:46

我猜应该是一个比较低级的错误！但一时半会儿找不出来！

千问 · 2007-9-26 17:05:46

原帖由 myfriend2010 于 2008-6-23 12:55 发表
s.sh[6]: ^M:not found.
[B]^M[/B]
Did you ftp the file?

千问 · 2007-9-26 17:05:46

恩,但是FTP后又手工VI,将那些^M给删掉了的

千问 · 2007-9-26 17:05:46

可能是调用 runstatus.sql 的问题，先确认你手动执行没有问题先
[ 本帖最后由 macrozeng 于 2008-6-23 16:35 编辑 ]

千问 · 2007-9-26 17:05:46

4楼有了啊!
db2inst1][/home/db2inst1]>db2 -tvf runstatus.sql
insert into test.zxttest values(100)
DB20000IThe SQL command completed successfully.
[db2inst1][/home/db2inst1]>db2 commit
DB20000IThe SQL command completed successfully.
[db2inst1][/home/db2inst1]>db2 terminate
DB20000IThe TERMINATE command completed successfully.

千问 · 2007-9-26 17:05:46

add /home/db2inst1 to PATH list, given if your runstatus.sql is in home directory
[ 本帖最后由 wangzhonnew 于 2008-6-24 00:11 编辑 ]