- 论坛徽章:
- 0
|
服务器是 IBM xSeries 346, CPU：XEON3.0×1，MEM：2G
OS：WINDOWS2000 SERVER SP4；
Database：IBM DB2 版本8.2“DB2通用数据库，版本8.2（版本8.1修订包7）”
在安装应用软件建表时发生DB2服务停止，并出现如下错误提示：
=====================================
安装失败：[IBM][JDBC Driver] CLI0601E 语句句柄无效或语句已关闭。SQLSTATE=S1000
=====================================
请教如何解决这个问题，谢谢！
我曾进行过如下参数调整：
-----------------------------------------------------------
-- 数据库管理器配置参数
-- Database Manager Configuration
-----------------------------------------------------------
update dbm cfg using aslheapsz 256;
update dbm cfg using sheapthres 20000 ;
update dbm cfg using maxagents 100;
update dbm cfg using NUM_POOLAGENTS 30;
-----------------------------------------------------------
-- 数据库配置参数
-- Database Configuration
-----------------------------------------------------------
update database configuration for NC30 using DBHEAP 4096;
update database configuration for NC30 using logbufsz 512;
update database configuration for NC30 using CATALOGCACHE_SZ 1024;
update database configuration for NC30 using locklist 4096;
update database configuration for NC30 using app_ctl_heap_sz 2048;
update database configuration for NC30 using sortheap 2048;
update database configuration for ncdata00 using stmtheap 2048;
update database configuration for ncdata00 using applheapsz 1024;
update database configuration for ncdata00 using pckcachesz 10240;
update database configuration for ncdata00 using maxlocks 18;
update database configuration for ncdata00 using NUM_IOCLEANERS 3;
update database configuration for ncdata00 using NUM_IOSERVERS 3;
update database configuration for ncdata00 using MAXAPPLS 50;
update database configuration for ncdata00 using AVG_APPLS 30;
update database configuration for ncdata00 using logfilsiz 4096;
update database configuration for ncdata00 using logprimary 12;
update database configuration for ncdata00 using LOGSECOND 100;
update database configuration for ncdata00 using MINCOMMIT 2; |
|
免费注册
发表于 2005-09-20 16:27
