Not enough server threads available for this query的处理
Error:
UDA-SQL-0107 A general exception has occurred during the operation "fetch". [Sybase][ODBC Driver][Sybase IQ]Not enough server threads available for this query. UDA-CUR-0000 Unable to fetch the row
[@more@]Reference:
Fix:
Sybase DBhad been config with higher server value as below and db restart completed:
=============================================================
IQ server starting with:
500 connections ( -gm )
14 cmd resources ( -iqgovern )
1400 threads ( -iqmt ) 512 Kb thread stack size ( -iqtss )
716800 Kb thread memory size ( -iqmt * -iqtss )
2 IQ number of cpus ( -iqnumbercpus )
0 MB maximum size of IQMSG file ( -iqmsgsz )
0 copies of IQMSG file archives ( -iqmsgnum )
=============================================================
IQ server starting with:
500 connections ( -gm )
14 cmd resources ( -iqgovern )
1400 threads ( -iqmt ) 512 Kb thread stack size ( -iqtss )
716800 Kb thread memory size ( -iqmt * -iqtss )
2 IQ number of cpus ( -iqnumbercpus )
0 MB maximum size of IQMSG file ( -iqmsgsz )
0 copies of IQMSG file archives ( -iqmsgnum )
=============================================================
dynamic option for dwadm user:
SET OPTION dwadm.MAX_IQ_THREADS_PER_CONNECTION = 1000;
SET OPTION dwadm.MAX_IQ_THREADS_PER_TEAM = 500;
SET OPTION dwadm.MAX_IQ_THREADS_PER_TEAM = 500;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/640706/viewspace-1047952/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
