在google reader突然瞄到了我在DB2 Express Forum发的贴有人回,大喜!DB2 中的文本检索老是无法start,因为带full-text search功能的DB2是去年年底才出来,网上几乎......
在google reader突然瞄到了我在DB2 Express Forum发的贴有人回,大喜!
DB2 中的文本检索老是无法start,因为带full-text search功能的DB2是去年年底才出来,网上几乎没有这方面的资料,每次在google上搜到的就是我自己发的这个贴,现在终于有高手出手了,项目中文本检索功能的实现终于有希望了。下面是我发的贴,英语很烂:
======================================
I cant start db2 full-text service. When I executed the following command:
db2inst1@server:~$ db2ts start for text
error message:
SQL20427N An error occurred during a text search administration
procedure or command. The error message is "CIE00301 "See db2diag.log.
Error with configuration information." ". SQLSTATE=38H14
I found no useful information in the file "db2diag.log".
There are some information refered the message "CIE00301" in the page:
http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp?topic=/com.ibm.db2.luw.admin.ts.doc/doc/c0053117.html
You receive the message CIE00301 "Insufficient authority" or
CIE00377 "Only instance owner <instance-owner> can use that
command" after issuing a db2ts START FOR TEXT comma
db2inst1 is the owner of db2 instance in my computer,but I cant execute
the command, What can I do to execute the command , Thanks for your
reply!
OS: Linux version 2.6.27-7-server (buildd@yellow) (gcc version 4.3.2 (Ubuntu 4.3.2-1ubuntu10) ) #1 SMP
Ubuntu 8.10 server edition
=========================================
等待了半个月,终于Z-Company老兄出来答疑了:
I have couple of Ubuntus 8.04.2 LTS running db2 with text search. So its proven working combination. Dont they enabled apparmor or SELinux on newer ubuntu versions by default? I cant help with newer ubuntus, our company policy is not to support them and direct these ppl to canonical because canonical is selling db2 support for their linux distribution. also check ownership of ~/sqllib/adm/.fenced 0-byted file it should be db2fenc1:db2fadm1 Did you read document 'Quick start to db2 server' especialy section about configuring kernel? Incorrect kernel cfg can break db2 text search.
Z-Company首先说明Ubuntu 8.04下是可以成功打开db2 full-text search功能,他提出了三种解决方案:
1/2 1 2 下一页 尾页 |