NET搜索扩展器 [英] NET SEARCH EXTENDER

问题描述

忍受我。我很平静;拿了一个安踏。我已经等了两个星期写了这个，因为每次我在写这封信之前写的都是

，充其量是令人讨厌的。


我需要使用NET SEARCH EXTENDER的服务。这是IBM（DB2）开发五年以来第一次需要的时间。


我不知道该怎么做。 （Db2 v8.1.2，Windows）我看到我必须

处理索引，缓存，以及其他东西。


信息文件告诉我更糟比什么都没有 - 他们是误导b $ b误导。我在控制面板中尝试了向导。那总是

以SQL语法错误结束。 - 奇怪，因为我没有写SQL！


我试过命令窗口。我设置变量DB2DBDFT和

-g开关，带-i开关，带-all开关，我通过控制面板输入

。每次我尝试执行命令时，错误

消息是未设置可变DB2DBDFT。我重新启动，重置，

重新启动...同样的错误。


我已经搜索了我所知道的每个地方，在我安装的帮助文件和

网络。在NET SEARCH EXTENDER上的典型搜索返回大约60

文件：其中一个赞美该主题的优点，30个在XML扩展器的

主题上，其余的是无关紧要的。


我需要的是如何在列上创建正确的

索引的逐步说明，如何创建缓存专栏，以及如何使用这些索引进行
a搜索。


我找不到能给我这些信息的地方，

虽然有几十个告诉我这个产品多么精彩。


好​​的 - 这是一个很长的信息，但我希望我的极度愤怒能够实现

没有通过，我没有侮辱任何人，而且有人

可以帮助我。


Stan

解决方案

你有同情心。我们从来没有任何文本搜索技术能够正常工作。当数据库变大时，我们得到虚假命中或内部错误的b $ b错误。词干失败可怕（德语，但我们得到了部分修复

复数识别）。我们甚至还有IBM B？bligen实验室的人员现场
。我们开设了PMR，一些是固定的，大多数是永久限制。或者

类似。经过一年多的捣乱，我们终于完成了这项工作，使用了

Oracle。


文档（318页）已经上线了
http://publibfp.boulder.ibm.com/epubs/ pdf / h1267402.pdf 。


" Stanley Sinclair" < ST ************* @ bellsouth.net>在消息中写道

新闻：6f ************************** @ posting.google.c om ...

忍受我。我很平静;拿了一个安踏。我已经等了两个星期来写这个，因为每次我写这封信之前，
最多都是令人讨厌的。

我需要使用NET SEARCH的服务EXTENDER。这是IBM（DB2）开发五年多来的第一次，我需要这个。

我不知道该怎么做。 （Db2 v8.1.2，Windows）我看到我必须处理索引，缓存，以及其他东西。

信息文件告诉我比什么都没有 - 他们是
我试过了命令窗口。我使用-g开关设置变量DB2DBDFT，使用-i开关，使用-all开关，然后通过控制面板输入
。每次我尝试执行命令时，错误
消息都是未设置可变DB2DBDFT。我重新启动，重置，重新启动......同样的错误。

我搜索了我所知道的每个地方，我已安装的帮助文件以及网页上的内容。在NET SEARCH EXTENDER上的典型搜索返回大约60个文件：其中一个赞美该主题的优点，30个在XML扩展器的主题上，其余的是无关紧要的。
<我需要的是如何在列上创建正确的索引，如何创建列的缓存以及如何使用这些索引进行搜索的分步说明。

我找不到能给我这些信息的地方，
虽然有几十个告诉我这个产品有多棒。

好的 - - 这是一个很长的信息，但我希望我的极度愤怒不会通过，我没有侮辱任何人，而且有人可以帮助我。

斯坦

您好Stan，


我想向您提供文档：


Net Search Extender v8.1：
http://publibfp.boulder.ibm.com/epubs/pdf/h1267401.pdf


''第3章。用户场景''给你两个简单的例子如何使用Net

搜索扩展器。


另外请查看样本... / sqllib / samples / db2ext

要创建文本索引等，请运行：

nsesample< databasename>

执行全文搜索：

连接到数据库然后运行：

db2 -tvf搜索


关于DB2DBDFT的问题：

尝试添加以下子句您的命令而不是使用DB2DBDFT：

''...连接到< databasename>''

例如：

db2text" CREATE INDEX db2ext.myTextIndex FOR TEXT ON books（story）

CONNECT TO sample"


当您使用控制中心时，操作失败并且 SQL

语法错误&，你可以点击''显示SQL''查看哪个命令是生成了
？


我希望这会有所帮助。如果您有其他问题，请告诉我。


问候，

Sabine

Stanley Sinclair写道：
< blockquote class =post_quotes>忍受我。我很平静;拿了一个安踏。我已经等了两个星期来写这个，因为每次我写这封信之前，
最多都是令人讨厌的。

我需要使用NET SEARCH的服务EXTENDER。这是IBM（DB2）开发五年多来的第一次，我需要这个。

我不知道该怎么做。 （Db2 v8.1.2，Windows）我看到我必须处理索引，缓存，以及其他东西。

信息文件告诉我比什么都没有 - 他们是
我试过了命令窗口。我使用-g开关设置变量DB2DBDFT，使用-i开关，使用-all开关，然后通过控制面板输入
。每次我尝试执行命令时，错误
消息都是未设置可变DB2DBDFT。我重新启动，重置，重新启动......同样的错误。

我搜索了我所知道的每个地方，我已安装的帮助文件以及网页上的内容。在NET SEARCH EXTENDER上的典型搜索返回大约60个文件：其中一个赞美该主题的优点，30个在XML扩展器的主题上，其余的是无关紧要的。
<我需要的是如何在列上创建正确的索引，如何创建列的缓存以及如何使用这些索引进行搜索的分步说明。

我找不到能给我这些信息的地方，
虽然有几十个告诉我这个产品有多棒。

好的 - - 这是一个很长的信息，但我希望我的极度愤怒不会通过，我没有侮辱任何人，而且有人可以帮助我。

斯坦

安装后启动Net Search Extender的最佳方法是运行提供的样本。
。示例安装在Unix的

安装目录... / sqllib / samples / db2ext或

.... \sqllib\samples\db2ext在Windows上。

有两个样本。管理示例创建一个数据库，数据库中有两个表db2ext.texttab和db2ext.htmltab，并且

加载一些数据。

db2ext .htmltab表用于演示

HTML文档的结构化搜索。为Net Search Extender启用了数据库。

下一步在选定文本上创建Net Search Extender索引

列。

运行以下命令管理样本：

nsesample your_database_name

在Windows上切换到带有db2cmd的DB2命令窗口第一个。

第二个示例可用于运行一组Net Search Extender

搜索创建的索引。

运行以下命令搜索示例：

db2 -tvf搜索

建议运行最新的Fix Pack级别。目前Fix Pack

2是最新级别，需要DB2 V8.1 Fix Pack 2.使用db2level

查找最新的DB2级别和db2text级别来检查网络

搜索Extender级别。

对于Net Search Extender信息，请参阅：
http://gwareview.software.ibm.com/so...rch/index.html

通过支持和下载，您可以访问Fix Pack 2下载站点。

Bear with me. I am being very calm; took a Valium. I have waited two
weeks to write this, because every time I wrote it before the message
was, at best, nasty.

I need to use the services of NET SEARCH EXTENDER. This is the first
time in over five years of IBM (DB2) developing that I need this.

I don''t know how to do it. (Db2 v8.1.2, Windows) I see that I must
deal with indexes, with cache, with other stuff.

The information files tell me worse than nothing -- they are
misleading. I tried through the wizard in control panel. That always
ends with "SQL syntax error" -- strange, since I didn''t write the SQL!

I tried through the command window. I set the variable DB2DBDFT with
the -g switch, with the -i switch, with the -all switch and I entered
via Control Panel. Every time I try to execute a command, the error
message is "Varaible DB2DBDFT is not set." I rebooted, reset,
rebooted ... same error.

I have searched every where I know, in my installed help files and on
the web. The typical search on NET SEARCH EXTENDER returns about 60
files: one of them praises the virtues of the subject, 30 are on the
subject of XML extender, and the rest are irrelevent.

What I need is step-by-step instructions on how to create the proper
index on a column, how to create a cache of the column, and how to do
a search using those indices.

There is no place which I can find that gives me that information,
although there are dozens which tell me how wonderful is this product.

OK -- this is a long message, but I hope that my extreme anger does
not come through, that I have not insulted anyone, and that someone
can help me.

Stan

解决方案

You have my sympathy. We never got any of the text search technologies to
work correctly. When the database got large we got spurious hits or internal
errors. Word stemming failed horribly (German, but we got a partial fix for
plural recognition). We even had somebody from the IBM B?bligen labs
on-site. We opened PMRs, some got fixed, most "permanent restrictions" or
similar. After over a year of messing around, we finally did the job using
Oracle.

The documentation (318 pages) is on line at
http://publibfp.boulder.ibm.com/epubs/pdf/h1267402.pdf.

"Stanley Sinclair" <st*************@bellsouth.net> wrote in message
news:6f**************************@posting.google.c om...

Bear with me. I am being very calm; took a Valium. I have waited two
weeks to write this, because every time I wrote it before the message
was, at best, nasty.

I need to use the services of NET SEARCH EXTENDER. This is the first
time in over five years of IBM (DB2) developing that I need this.

I don''t know how to do it. (Db2 v8.1.2, Windows) I see that I must
deal with indexes, with cache, with other stuff.

The information files tell me worse than nothing -- they are
misleading. I tried through the wizard in control panel. That always
ends with "SQL syntax error" -- strange, since I didn''t write the SQL!

I tried through the command window. I set the variable DB2DBDFT with
the -g switch, with the -i switch, with the -all switch and I entered
via Control Panel. Every time I try to execute a command, the error
message is "Varaible DB2DBDFT is not set." I rebooted, reset,
rebooted ... same error.

I have searched every where I know, in my installed help files and on
the web. The typical search on NET SEARCH EXTENDER returns about 60
files: one of them praises the virtues of the subject, 30 are on the
subject of XML extender, and the rest are irrelevent.

What I need is step-by-step instructions on how to create the proper
index on a column, how to create a cache of the column, and how to do
a search using those indices.

There is no place which I can find that gives me that information,
although there are dozens which tell me how wonderful is this product.

OK -- this is a long message, but I hope that my extreme anger does
not come through, that I have not insulted anyone, and that someone
can help me.

Stan

Hi Stan,

I''d like to point you to the documentation:

Net Search Extender v8.1:
http://publibfp.boulder.ibm.com/epubs/pdf/h1267401.pdf

''Chapter 3. User scenarios'' gives you two simple examples how to use Net
Search Extender.

In addition please look at the sample in .../sqllib/samples/db2ext
To create text indexes etc. run:
nsesample <databasename>
To perform full text search:
connect to the database and then run:
db2 -tvf search

As for your problem with DB2DBDFT:
try to add following clause to your commands instead of using DB2DBDFT:
'' ... connect to <databasename>''
For example:
db2text "CREATE INDEX db2ext.myTextIndex FOR TEXT ON books (story)
CONNECT TO sample"

When you are using the control center and the action fails with "SQL
syntax error", could you klick on ''Show SQL'' to see which command is
generated?

I hope this helps. Please let me know if you have additional questions.

Regards,
Sabine
Stanley Sinclair wrote:

Bear with me. I am being very calm; took a Valium. I have waited two
weeks to write this, because every time I wrote it before the message
was, at best, nasty.

I need to use the services of NET SEARCH EXTENDER. This is the first
time in over five years of IBM (DB2) developing that I need this.

I don''t know how to do it. (Db2 v8.1.2, Windows) I see that I must
deal with indexes, with cache, with other stuff.

The information files tell me worse than nothing -- they are
misleading. I tried through the wizard in control panel. That always
ends with "SQL syntax error" -- strange, since I didn''t write the SQL!

I tried through the command window. I set the variable DB2DBDFT with
the -g switch, with the -i switch, with the -all switch and I entered
via Control Panel. Every time I try to execute a command, the error
message is "Varaible DB2DBDFT is not set." I rebooted, reset,
rebooted ... same error.

I have searched every where I know, in my installed help files and on
the web. The typical search on NET SEARCH EXTENDER returns about 60
files: one of them praises the virtues of the subject, 30 are on the
subject of XML extender, and the rest are irrelevent.

What I need is step-by-step instructions on how to create the proper
index on a column, how to create a cache of the column, and how to do
a search using those indices.

There is no place which I can find that gives me that information,
although there are dozens which tell me how wonderful is this product.

OK -- this is a long message, but I hope that my extreme anger does
not come through, that I have not insulted anyone, and that someone
can help me.

Stan

The best way to start with Net Search Extender after installation is
to run the supplied samples. The samples are installed in the DB2
installation directory .../sqllib/samples/db2ext on Unix or
....\sqllib\samples\db2ext on Windows.
There are two samples. The administration sample creates a database,
two tables db2ext.texttab and db2ext.htmltab within the database and
loads some data.
The db2ext.htmltab table is used to demonstrate structured search on
HTML documents. The database is enabled for Net search Extender.
The next step creates Net Search Extender indexes on selected text
columns.
The following command runs the administration sample :
nsesample your_database_name
On Windows switch to a DB2 command window with "db2cmd" first.
A second sample can be used to run a set of Net Search Extender
searches on the created indexes.
The following command runs the search sample :
db2 -tvf search
It is recommended to run the latest Fix Pack level. Currently Fix Pack
2 is the latest level which requires DB2 V8.1 Fix Pack 2. Use db2level
to find out the latest DB2 level and db2text level to check the Net
Search Extender level.
For Net Search Extender information see :
http://gwareview.software.ibm.com/so...rch/index.html
Via Support and Download you get to the Fix Pack 2 download site.

这篇关于NET搜索扩展器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！