更新db cfg dbheap [英] update db cfg dbheap
问题描述
大家好，
我正在尝试从我的jdbc
代码中更改db2配置参数。当我使用以下内容时：
语句stmt2 = con.createStatement（）;
stmt2.executeUpdate（
" update db cfg for sample使用dbheap 800";
stmt2.close（）;
我得到以下异常：
[IBM] [ CLI驱动程序] [DB2 / NT] SQL0104N意外的令牌update db在BEGIN-OF-STATEMENT之后找到了
。预期的代币可能包括：
"< drop_transf>"。 SQLSTATE = 42601
如何从jdbc更改dbheap参数？
感谢您的帮助
Hello all,
I am trying to change a db2 configuration parameter from within my jdbc
code. When I use the following:
Statement stmt2 = con.createStatement();
stmt2.executeUpdate(
"update db cfg for sample using dbheap 800");
stmt2.close();
I get the following exception:
[IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token "update db" was
found following "BEGIN-OF-STATEMENT". Expected tokens may include:
"<drop_transf>". SQLSTATE=42601
How can I change dbheap parameter from jdbc?
Thanks for your help
推荐答案
" Issam" <是***** @ hotmail.com>在消息中写道
news：11 ********************** @ g44g2000cwa.googlegr oups.com ...
"Issam" <is*****@hotmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
大家好，
我正在尝试从我的jdbc
代码中更改db2配置参数。当我使用以下内容时：
语句stmt2 = con.createStatement（）;
stmt2.executeUpdate（
使用dbheap 800更新db cfg示例）;
stmt2。 close（）;
我得到以下异常：
[IBM] [CLI驱动程序] [DB2 / NT] SQL0104N意外的令牌update db在BEGIN-OF-STATEMENT之后发现了。预期的代币可能包括：
"< drop_transf>"。 SQLSTATE = 42601
如何从jdbc更改dbheap参数？
感谢您的帮助
Hello all,
I am trying to change a db2 configuration parameter from within my jdbc
code. When I use the following:
Statement stmt2 = con.createStatement();
stmt2.executeUpdate(
"update db cfg for sample using dbheap 800");
stmt2.close();
I get the following exception:
[IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token "update db" was
found following "BEGIN-OF-STATEMENT". Expected tokens may include:
"<drop_transf>". SQLSTATE=42601
How can I change dbheap parameter from jdbc?
Thanks for your help
这是一个DB2命令，而不是SQL语句。您需要从
OS命令行（使用db2前面的语句）发出该命令行。我假设从Java那里有一个
的方法，但我不知道怎么做。
That is a DB2 command, not an SQL statement. You need to issue that from a
OS command line (with "db2" prefacing the statement). I assume there is a
way to do that from Java, but I don''t know how.
Mark A写道：
" Issam" <是***** @ hotmail.com>在消息中写道
新闻：11 ********************** @ g44g2000cwa.googlegr oups.com ......
"Issam" <is*****@hotmail.com> wrote in message
news:11**********************@g44g2000cwa.googlegr oups.com...
大家好，
我正在尝试从我的jdbc
代码中更改db2配置参数。当我使用以下内容时：
语句stmt2 = con.createStatement（）;
stmt2.executeUpdate（
使用dbheap 800更新db cfg示例）;
stmt2。 close（）;
我得到以下异常：
[IBM] [CLI驱动程序] [DB2 / NT] SQL0104N意外的令牌update db在BEGIN-OF-STATEMENT之后发现了。预期的代币可能包括：
"< drop_transf>"。 SQLSTATE = 42601
如何从jdbc更改dbheap参数？
感谢您的帮助
Hello all,
I am trying to change a db2 configuration parameter from within my jdbc
code. When I use the following:
Statement stmt2 = con.createStatement();
stmt2.executeUpdate(
"update db cfg for sample using dbheap 800");
stmt2.close();
I get the following exception:
[IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token "update db" was
found following "BEGIN-OF-STATEMENT". Expected tokens may include:
"<drop_transf>". SQLSTATE=42601
How can I change dbheap parameter from jdbc?
Thanks for your help
这是一个DB2命令，而不是SQL语句。您需要从
OS命令行（使用db2前面的语句）发出该命令行。我假设有一种方法可以用Java做到这一点，但我不知道怎么做。
That is a DB2 command, not an SQL statement. You need to issue that from a
OS command line (with "db2" prefacing the statement). I assume there is a
way to do that from Java, but I don''t know how.
http://publib.boulder.ibm.com/infoce ... n / r0012547.htm
干杯
Serge
-
Serge Rielau
DB2 SQL编译器开发
IBM多伦多实验室
http://publib.boulder.ibm.com/infoce...n/r0012547.htm
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
" Serge Rielau" < SR ***** @ ca.ibm.com>在消息中写道
news：3i ************ @ individual.net ...
"Serge Rielau" <sr*****@ca.ibm.com> wrote in message
news:3i************@individual.net...
http://publib.boulder.ibm .com / infoce ... n / r0012547.htm
干杯
Serge
http://publib.boulder.ibm.com/infoce...n/r0012547.htm
Cheers
Serge
另一个新功能FP9未在新内容部分中记录。
Another feature new to FP9 that is not documented in the What''s New section.
这篇关于更新db cfg dbheap的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
