DB2文本检索功能的实现有希望了！

wangwengwu

　　在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 administrationprocedure 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" orCIE00377 "Only instance owner <instance-owner> can use thatcommand" after issuing a db2ts START FOR TEXT comma
db2inst1 is the owner of db2 instance in my computer,but I cant executethe command, What can I do to execute the command ， Thanks for yourreply!
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. 检查apparmor或者SELinux的安全机制，看是否是这些软件将程序权限设置过高。
　　2. 检查~/sqllib/adm/.fenced这个0字节文件的拥有用户和组分别是db2fenc1和db2fadm1。
　　3 阅读文档 "Quick start to db2 server“ 关于内核调节一节，错误的内核设置将会导致DB2全文检索打不开。
　　我这周都试试这几个方法，真不知道Z-company是怎么拥有如此多的思路，可能是实践出真知。