[求助]数据加载问题
<p>往IQ数据库加载数据的时候，提示出错信息：</p><p>Error at line 1</p><p>main Bufman:All buffer cache pages are in use,ask your DBA to increase the size of buffer cache;</p><p>buffer={unknow buffer} page={unknow page}.</p><p>--(s_blockmap.cxx 3132)</p><p></p><p>数据加载语句为</p><p>set temporary option CONVERSION_ERROR = 'OFF';</p><p>load table jxcgoodslist (<br/>jglseq '|' ,<br/>jgldate '|' ,<br/>jgltype '|' ,<br/>jglbatchseq '|' ,<br/>jglbillno '|' ,<br/>jgldms '|'<br/>)<br/>FROM<br/>'/home1/usr/iq/loadjxc/s1205/jnjxc200607.txt'<br/>QUOTES OFF<br/>ESCAPES OFF<br/>NOTIFY 100000<br/>ROW DELIMITED BY '\x0a'<br/>Ignore Constraint DATA VALUE 200, ALL 200<br/>Message Log '/data/iqspace/lkl/lkl.iqmsg'<br/>Row Log '/data/iqspace/lkl/row.log'<br/>WITH CHECKPOINT ON;<br/></p><p>增加了<span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: "Times New Roman"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">IQ</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman";">数据库空间</span>和<span lang="EN-US" style="FONT-SIZE: 10.5pt; FONT-FAMILY: "Times New Roman"; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">IQ</span><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman";">数据库临时空间 也还不行。</span></p><p><span style="FONT-SIZE: 10.5pt; FONT-FAMILY: 宋体; mso-bidi-font-size: 12.0pt; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA; mso-ascii-font-family: "Times New Roman"; mso-hansi-font-family: "Times New Roman"; mso-bidi-font-family: "Times New Roman";">是怎么回事呢？</span></p>[此贴子已经被作者于2007-3-20 17:13:34编辑过]
<p>set option public.os_file_cache_buffering = off;</p><p>试试看</p> <p>我这样运行，还是出现了相同的错误</p><p>不过真的谢谢你，有人回复好高兴啊，看到了希望</p><p>set option public.os_file_cache_buffering = 'OFF';</p><p>set temporary option CONVERSION_ERROR = 'OFF';</p><p>load table jxcgoodslist (<br/>jglseq '|' ,<br/>jgldate '|' ,<br/>jgltype '|' ,<br/>jglbatchseq '|' ,<br/>jglbillno '|' ,<br/>jgldms '|'<br/>)<br/>FROM<br/>'/home1/usr/iq/loadjxc/s1205/jnjxc200607.txt'<br/>QUOTES OFF<br/>ESCAPES OFF<br/>NOTIFY 100000<br/>ROW DELIMITED BY '\x0a'<br/>Ignore Constraint DATA VALUE 200, ALL 200<br/>Message Log '/data/iqspace/lkl/lkl.iqmsg'<br/>Row Log '/data/iqspace/lkl/row.log'<br/>WITH CHECKPOINT ON;</p> <p>set temporary option Temp_Cache_Memory_MB = 0;</p><p>在试试这个</p> <p>导入语句：</p><p>set temporary option Temp_Cache_Memory_MB = 0;</p><p>set temporary option CONVERSION_ERROR = 'OFF';</p><p>load table jxcgoodslist (</p><p>……</p><p>还是出错了：</p><p>Error at line 1</p><p>Only PUBLIC settings are allowed for option 'Temp_Cache_Memory_MB'</p><p>放在这里不对嘛？</p> 不好意思，是我写错了<p>set option public.Temp_Cache_Memory_MB = 128;</p><p></p> <p>把这个语句放在第一行执行。还是出现了开始的错误</p><p>Error at line 1</p><p>main Bufman:All buffer cache pages are in use,ask your DBA to increase the size of buffer cache;</p><p>buffer={unknow buffer} page={unknow page}.</p><p>--(s_blockmap.cxx 3132)</p><p>是不是我增加空间增的不对呢？怎么检查数据已经占用了多少空间呢？</p><p>$ l<br/>总用量 7.9G<br/>-rw------- 1 iq iq 32K 12月 12 17:48 core.3090<br/>-rw-r--r-- 1 iq iq 1000M 3月 26 16:08 lkl02.iqtmp<br/>-rw-r--r-- 1 iq iq 516 12月 12 17:12 lkl.cfg<br/>-rw------- 1 iq iq 2.6M 3月 26 16:09 lkl.db<br/>-rw-r--r-- 1 iq iq 2.0G 3月 26 16:09 lkldbs01.iq<br/>-rw-r--r-- 1 iq iq 2.0G 3月 26 16:09 lkldbs02.iq<br/>-rw-r--r-- 1 iq iq 2.0G 3月 26 16:09 lkldbs03.iq<br/>-rw-r--r-- 1 iq iq 1.4M 3月 26 16:09 lkl.iqmsg<br/>-rw-r--r-- 1 iq iq 1000M 3月 26 16:08 lkl.iqtmp<br/>-rw------- 1 iq iq 320K 3月 26 16:09 lkl.log<br/>-rw-r--r-- 1 iq iq 23K 3月 26 16:09 row.log<br/>$ pwd<br/>/data/iqspace/lkl<br/></p><p></p> <p>sp_iqstatus在客户端运行这个命令：</p><p><br/>19 ' Main IQ Blocks Used:','4522 of 5632, 80%=35Mb, Max Block#: 5185'</p><p><br/>其中第19项，如上，的百分比就是当前数据库已经使用的空间。</p><p>可以将你的数据'/home1/usr/iq/loadjxc/s1205/jnjxc200607.txt'的记录数减少点，用10条数据试试看。</p> <p>导入10条数据是可以的。</p><p>导入10万条数据就出现这个错误。</p><p>运行sp_iqstatus;结果入图，能看出是因为什么问题导致的吗？</p><p></p><p>刚刚接触IQ，什么都不懂，有什么好的书介绍吗？<br/></p> <p>顺便问一下，你在QQ群1450980 1185914里嘛</p> <p>10条可以的话就把这个参数在加大：</p><p>set option public.Temp_Cache_Memory_MB = 1280;</p><p>最大可以到9512</p> <p>不行，插10条数据的时候我没有加这个语句就成功了。</p><p>set option public.Temp_Cache_Memory_MB = 9512;</p><p>把这个语句加上去，出同样的错误。</p>
页:
[1]
2