db2clp里不能执行超长的脚本，怎么解决？

[njhart2003]

我们在项目开发时，有几个存储过程的脚本比较长有100K左右，在db2clp里执行“db2 -td@ -vf xxxx.sql”总是不成功，但通过其他工具如questcenter等是可以执行的，我也试过调节db2clp的客户端的缓存设置，但依然保存，各位老大，有啥办法可以使长脚本在db2clp里执行？

[jinxin19831117]

报什么错说下啊

[Eddie005]

up

[eboy2004]

db2batch -d <db name> -a username/password -f <file name>

[njhart2003]

据说db2 V8.2在db2clp里支持的最长脚本为64K，我的那个脚本文件有128K左右，超长了。

[haitao8686]

顶

[DBUncle]

up

[yangxiao_jiang]

请看：
http://www-1.ibm.com/support/docview.wss?rs=71&context=SSEPGG&q1=sql+length&uid=swg21181258&loc

DB21006E The input command is too long. The maximum length is 65535.
Technote (FAQ)

Problem
DB2 v8.2 introduces a new feature that allows statements longer than 64 kilobytes to be processed by the database server. The limit has been increased to 2 megabytes. However, if you try to process a statement longer than 64 kilobytes via CLP or the Command Center, DB21006E is returned.

Cause
Although the database server now accepts statements up to 2 megabytes to be processed, this feature has not yet been propagated to CLP and the Command Center. For these tools, the maximum size a statement can have is still limited to 64 kilobytes.

Solution
The 64 kilobyte limit for statement size on DB2 tools such as CLP and the Command Center is planned to be lifted in an upcoming release of DB2. You can use another application that uses static or dynamic SQL to issue statements longer than 64 kilobytes.

[mana5116]

你可以试验一下在control center里面执行。

还可以试验一下安装其他版本的客户端，比如9

[mana5116]

升级DB2到8.2，在8.2里面限制变为了2M

[微服森林]

我遇到过，具体怎么改忘记了。在网上搜索应该可以找到答案。
类似：db2 update db cfg for tec using stmtheap 8000
也就是修改一下cfg配置文件的一个参数。
祝你好运

[njhart2003]

半年过去了，这个问题还没有解决...

[njhart2003]

答错的、根本不相干的就不给分了，怕误人子弟；
其他友情关注、顶帖的给10分鼓励一下。