l5066113
发表于 2007-3-27 13:16:49
<p>set option public.Temp_Cache_Memory_MB = 128;</p><p>这种没有加temporary的option是只要set一次就会永久有效，以后的load语句就不用加了。</p><p>set option public.Load_Memory_MB = 0;</p><p>运行完命令后，在运行set命令，看看所对应的option的值更改了没有，然后在commit一次，在执行load试试看。</p><p>一般来讲，Temporary IQ Buffers要比Main IQ Buffers大，但你的是Temporary IQ Buffers小，想看看你lkl.cfg里的内容。</p>
skylamia
发表于 2007-3-27 13:47:58
<p>运行set命令</p><p>Temp_Cache_Memory_MB = 9512</p><p>Load_Memory_MB = 0</p><p></p><p>lkl.cfg 内容：</p><p># lkl.cfg<br/># ------------------------------------------------------------<br/># Default startup parameters for the ASIQ demo database<br/># ------------------------------------------------------------</p><p>-n lkl<br/>-x tcpip{port=2640}</p><p># The following parameters are also found in the configuration file<br/># $ASDIR/scripts/default.cfg. Any parameters not specified below<br/># and not in the start up parameter list, will be added by start_asiq<br/># using default.cfg as a guide.</p><p>-c 32m<br/>-gc 20<br/>-gd all<br/>-gl all<br/>-gm 10<br/>-gp 4096<br/>-ti 4400<br/></p><p></p>
l5066113
发表于 2007-3-27 13:55:45
<p>在lkl.cfg里加以下两个参数：</p><p>-iqtc 2048</p><p>-iqmc 1024</p><p>保存，将IQ数据库stop，在start，然后在执行load语句。</p>
skylamia
发表于 2007-3-27 14:04:17
加上这两句，数据库启动失败
skylamia
发表于 2007-3-27 14:07:52
<p>Starting server lkl on lklbak at port 2640</p><p>Run Directory : /data/iqspace/lkl<br/>Server Exe : /home1/usr/iq/ASIQ-12_5/bin/asiqsrv12<br/>Server Output Log : /home1/usr/iq/ASIQ-12_5/logfiles/lkl.021.srvlog<br/>Server Version : 12.5.0/ESD 15<br/>OpenClient Version : 12.5/P-EBF11318 ESD #13<br/>User Parameters : @lkl.cfg lkl.db<br/>Default Parameters : -gn 25</p><p>I. 03/27 14:06:49. Adaptive Server IQ<br/>I. 03/27 14:06:49. Version 12.5<br/>I. 03/27 14:06:49. (32bit mode)<br/>I. 03/27 14:06:49. Copyright 1991-2005 by Sybase, Inc. All rights reserved</p><p>I. 03/27 14:06:49. 32768K of memory used for caching<br/>I. 03/27 14:06:49. Minimum cache size: 32768K, maximum cache size: 32768K<br/>I. 03/27 14:06:49. Using a maximum page size of 4096 bytes<br/>I. 03/27 14:06:49. Starting database "lkl" (/data/iqspace/lkl/lkl.db) at Tue Mar<br/> 27 2007 14:06<br/>E. 03/27 14:06:49. Error: All available virtual memory has been used; allocation<br/> cancelled: <br/>E. 03/27 14:06:49. -- (hos_mem.cxx 331)<br/>E. 03/27 14:06:49. All available virtual memory has been used; allocation cancel<br/>led: <br/>E. 03/27 14:06:49. -- (hos_mem.cxx 331)<br/>I. 03/27 14:06:49. Database server stopped at Tue Mar 27 2007 14:06</p><p><br/>=============================================================<br/>IQ server starting with:<br/> 10 connections ( -gm )<br/> 18 cmd resources ( -iqgovern )<br/> 265 threads ( -iqmt )<br/> 200 Kb thread stack size ( -iqtss )<br/> 53000 Kb thread memory size ( -iqmt * -iqtss )<br/> 4 IQ number of cpus ( -iqnumbercpus )<br/>=============================================================</p><p>DBSPAWN ERROR: -84<br/>Specified database is invalid</p><p>Server failed to start.<br/></p>
l5066113
发表于 2007-3-27 14:22:46
<p>I. 03/27 14:06:49. 32768K of memory used for caching<br/>I. 03/27 14:06:49. Minimum cache size: 32768K, maximum cache size: 32768K<br/>I. 03/27 14:06:49. Using a maximum page size of 4096 bytes</p><p>E. 03/27 14:06:49. Error: All available virtual memory has been used; allocation<br/> cancelled: <br/>你IQ服务器的内存有多大？</p>
skylamia
发表于 2007-3-27 14:50:04
<p>Mem: 2068728K av, 2022148K used, 46580K free, 0K shrd, 77152K buff</p><p>好像是可用内存太小了</p>
l5066113
发表于 2007-3-27 15:15:34
<p>是的，内存太小了。</p><p>这两个参数：-iqtc、-iqmc就是设置IQ的Temporary Cache和Main Cache，单位是Mb，一般Temporary Cache要设置成Main Cache的2倍。</p>
skylamia
发表于 2007-3-27 15:39:07
<p>恩。真的非常感谢你:))</p><p>等一下把服务器重启一次再看看:))</p>
skylamia
发表于 2007-3-27 15:40:08
不过为什么之前我导入很多个同样大小的数据文件。然后到那个才出错呢
l5066113
发表于 2007-3-27 15:57:55
<p>这个就不知道了，可能之前有什么操作占用很多内存而且没有释放，导致这次Load时内存就不够了。</p>