请高手指点“创建储存过程报catalog node出错”

semite

一个最简单的储存过程。

1. CREATE PROCEDURE getTEXT (IN in_put smallint,OUT out_put smallint)
   
2. language sql
   
3. begin
   
4. select int(12/in_put) into out_put from sysibm.sysdummy1;
   
5. end@

复制代码

结果运行
db2 -td@ -vf getText.sql
报错：
＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃
db2 -td@ -vf getText.sql
CREATE PROCEDURE getTEXT (IN in_put smallint,OUT out_put smallint)
language sql
begin
select int(12/in_put) into out_put from sysibm.sysdummy1;
end
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0901N The SQL statement failed because of a non-severe system error.
Subsequent SQL statements can be processed. (Reason "CREATE PROCEDURE with
LANGUAGE SQL only allowed at catalog node".) SQLSTATE=58004
＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃＃

指点一下，为什么会这样啊？
我现在无论什么储存过程都不能创建了


感激不尽。。。。

semite

而且很郁闷的是，这个语句几天前都可以运行成功的。
不知道为什么就报这种错误了。

semite

继续请教大家.