[求助]IQ跑存储过程总是报1006042错误,甚至IQ服务自动关闭(有图)
<p>IQ安装在window 2003 server下 机器内存3G</p><p>cfg参数iqmc 512、iqtc 256</p><p>长时间跑存储过程后,报1006042错误,并且严重时IQ服务会当掉,自动关闭。</p><p>请大家帮忙解决一下,老是出现这个问题,该如何设置,或是需要打补丁?</p><p><br/><br/></p> 这里没有人知道吗,高手都不在吗 <p>32位操作系统吗?可能是内存问题, 3GB内存如果不修改Windows的boot.ini是用不到的,可以作如下修改后重启Server和数据库:</p><p></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 36pt;"><font size="3"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">可以通过修改</span><span lang="EN-US"><font face="Times New Roman">boot.ini</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">文件,添加</span><span lang="EN-US"><font face="Times New Roman">/3GB</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">选项,将内存的寻址空间扩大到</span><span lang="EN-US"><font face="Times New Roman">4GB</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">,此文件在启动盘根目录,属性是系统隐含,查找该文件时,需要修改资源管理器的“工具”-》“文件夹选项”-》“查看”,</span><font face="Times New Roman"></font><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman";">打开对系统和隐含文件的限制,修改后</span></font></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 36pt;"><span lang="EN-US"><p><font face="Times New Roman" size="3"> </font></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; TEXT-INDENT: 36pt;"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Courier; mso-bidi-font-family: Courier;"><span style="mso-spacerun: yes;"> </span> timeout=5 default=multi(0)disk(0)rdisk(0)</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; mso-pagination: none; mso-layout-grid-align: none;"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Courier; mso-bidi-font-family: Courier;">partition(1)\WINNT<p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; mso-pagination: none; mso-layout-grid-align: none;"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Courier; mso-bidi-font-family: Courier;"> multi(0)disk(0)rdisk(0)<p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; mso-pagination: none; mso-layout-grid-align: none;"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Courier; mso-bidi-font-family: Courier;">partition(1)\WINNT="Microsoft Windows 2000<p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; mso-pagination: none; mso-layout-grid-align: none;"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Courier; mso-bidi-font-family: Courier;">Professional"<p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt; mso-pagination: none; mso-layout-grid-align: none;"><span lang="EN-US" style="FONT-SIZE: 9pt; FONT-FAMILY: Courier; mso-bidi-font-family: Courier;">/fastdetect /3GB</span><span lang="EN-US" style="FONT-SIZE: 10pt;"><p></p></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 36pt;"><span lang="EN-US"><p><font face="Times New Roman" size="3"> </font></p></span></p><p></p>
页:
[1]