473,899 Members | 4,299 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

NET SEARCH EXTENDER

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
Nov 12 '05
16 7052
st************* @bellsouth.net (Stanley Sinclair) wrote in message news:<6f******* *************** ****@posting.go ogle.com>...
The wizard ends everyting with a ;,
and the Command Window rejects anything which ends in a ;.
That's obviously because you've not set the CLP statement terminator
on. This really is beginners' stuff.
Some things which were in parentheses must not be; some things should,
or should not, be in "" "" marks or ' ' marks.
Can't comment, this is so vague.
When I tried to set DB2DBDFT (?) it would be set, but when I ran
something using it, the message up to this time, is "DB2DBDFT not
set."
Again, not very easy to comment about "something" .
After creating a new instance, per your suggestions, error messages
concerning instances appeared after anything. (I always rebooted.) I
could not get back to the instance in which my main databases exist,
threatening the end of my carrer.
Oh dear, how dramatic.
The command db2set did nothing for
DB2INSTANCE.

Complete disaster.
That's because DB2INSTANCE is a shell variable, not part of the DB2
Registry. This is all covered in any basic DBA course, as
I must quote Mark at the beginning of this thread:

"We never got any of the text search technologies to work correctly...
After over a year of messing around, we finally did the job using
Oracle."

Sadly, that's where I'm going.


DG
Nov 12 '05 #11
Dear Mr Guy,

First, please read the first lines of the first item in this thread.
I'm afraid that I, again, got carried away in some of the things that
I said.

However, it would have been very pleasant if you were to help instead
of trying to poke fun of me in your superiority.
The wizard ends everyting with a ;,
and the Command Window rejects anything which ends in a ;.


That's obviously because you've not set the CLP statement terminator
on. This really is beginners' stuff.


Why could you not just tell me exactly how to do that, and then I
would no longer be such a beginner? I'm not, in fact a beginner, but
have not dealt with this before. I see many messages in this forum
which begin with "Newbie," etc, all of which being politely answered.
Some things which were in parentheses must not be; some things should,
or should not, be in "" "" marks or ' ' marks.


Can't comment, this is so vague.


That was a statement, not a question. Requiring no comment. It just
said that the SQL generated by the wizard required editing before it
would be accepted by the CLP.
When I tried to set DB2DBDFT (?) it would be set, but when I ran
something using it, the message up to this time, is "DB2DBDFT not
set."


Again, not very easy to comment about "something" .


Sorry. For "something" read "anything."
After creating a new instance, per your suggestions, error messages
concerning instances appeared after anything. (I always rebooted.) I
could not get back to the instance in which my main databases exist,
threatening the end of my carrer.


Oh dear, how dramatic.


I am sorry for the melodramatics. But instead of sarcasm, couldn't
you tell me how to solve the problem? The only reasons why you would
not do so are: You don't know, or, you are concentrating on insulting
me and showing how great you are.
The command db2set did nothing for
DB2INSTANCE.

Complete disaster.


That's because DB2INSTANCE is a shell variable, not part of the DB2
Registry. This is all covered in any basic DBA course, as


But, Mr Guy, you are unwilling to tell me how to catch up. My last
formal course was at ver 2. I have read all that I can since. Please
complete your statement, "This is all covered in any basic DBA course,
as . . ." I hope it includes the names of courses I can attend
without leaving home.

With best wishes.

Stanley Sinclair
Nov 12 '05 #12
See answers imbedded ######## . Some text snipped.

Stanley Sinclair wrote:
The wizard ends everyting with a ;,
and the Command Window rejects anything which ends in a ;.
That's obviously because you've not set the CLP statement terminator
on. This really is beginners' stuff.

Why could you not just tell me exactly how to do that, and then I
would no longer be such a beginner? I'm not, in fact a beginner, but
have not dealt with this before. I see many messages in this forum
which begin with "Newbie," etc, all of which being politely answered.

########### Set the terminator by going to the tools option on the
option bar, select settings and then follow thru to set. The default
terminator is generally pre-selected as ;
########### When you work from the command line, the db2 -td function
allows you to set the terminator. As in-- db2 td% If you don't specify
anythin char. then ; is assumed.
Some things which were in parentheses must not be; some things should,
or should not, be in "" "" marks or ' ' marks.
Can't comment, this is so vague.

That was a statement, not a question. Requiring no comment. It just
said that the SQL generated by the wizard required editing before it
would be accepted by the CLP.

########### The wizard or show command option will both show "funny"
SQL. Generally, you should strip any double or single quotes except.
Exceptions: Double quotes at the start of the statement and at the end,
as in: db2 "select ........ order by col1".
Also, watch out if stmt. has where clauses and values are in it the all
literals will be in single quotes, as in where col1 = 'yourname'
Thsi is explained in the SQL Ref. for statements and COmmand ref. for
commands structure and options.
When I tried to set DB2DBDFT (?) it would be set, but when I ran
something using it, the message up to this time, is "DB2DBDFT not
set."
Again, not very easy to comment about "something" .

Sorry. For "something" read "anything."

########### DB2DBDFT should be set with db2set command and use the
-i parm which specifies for which instance the default db applies. And
yes, you may have multiple DB2DBDFT but only one per instance. Again,
look at the online Command Rer. manual.
After creating a new instance, per your suggestions, error messages
concerning instances appeared after anything. (I always rebooted.) I
could not get back to the instance in which my main databases exist,
threatenin g the end of my carrer. ########### If my carreer was threatened, I'd probably mention a few
odd error messages as opposed to something and or anything. We can't
help if we don't know what is going on. What error messages and when
they appeared what were you trying to do.
When you reboot, DB2 will look for which instance to make active when
any application stats.
1) did you set the instance on the command line with
set db2instance=ins tname Then that's the default and it must have
the DB2DBDFT default dbname catalogued.
2) Uses the default value set at the global profile register in:
db2set DB2INSTDEF instname
Same thing with having the db catalogued.
3) Uses the default value set in the OS environment variables, either
at install or after. On a command line, do:
echo %DB2INSTANCE% and if it has been set it will come back with it.
In Windows, check both the user and system registry.

Oh dear, how dramatic.

I am sorry for the melodramatics. But instead of sarcasm, couldn't
you tell me how to solve the problem? The only reasons why you would
not do so are: You don't know, or, you are concentrating on insulting
me and showing how great you are.

The command db2set did nothing for
DB2INSTANC E.
######### db2set DB2INSTDEF This is documented in the online Command
Ref.
Complete disaster.

######### I shouldn't wonder
That's because DB2INSTANCE is a shell variable, not part of the DB2
Registry. This is all covered in any basic DBA course, as

######### It may covered in any bsic course (I know Iteach them) but
it is not well documented and hard to grasp, even when well explained.

But, Mr Guy, you are unwilling to tell me how to catch up. My last
formal course was at ver 2. I have read all that I can since. Please
complete your statement, "This is all covered in any basic DBA course,
as . . ." I hope it includes the names of courses I can attend
without leaving home. ######### Stanley, if your last class is on V2, quite a lot of things
have changed and just by looking at the IBM DB2 site, you could find
that they have both comp. based courses (no travel) as well as Web based
(no travel) courses. All of the Docs. for DB2 are on line and can be
searched in a much easier fashion then paper docs. As you can do
contextual searches, you can find all the manuals and their sections
where DB2INSTANCE or DB2INSTDEF or db2set,, are discussed.

HTH, Pierre.
With best wishes.

Stanley Sinclair


--
Pierre Saint-Jacques
IBM DB2 Cerified Solutions Expert - Administration
SES Consultants Inc.

Nov 12 '05 #13
Hi Stan,

I suppose the problem with the setting of the DB2INSTANCE variable is
solved now. Is the NSE service registered for the newly created instance,
and can you start it with db2text start?

Did you already try to run the sample?

The DB2DBDFT variable must be set as environment variable to be
interpreted by NSE. (not via db2set)
But you don't necessarily need the variable, as stated in my first
posting:
>>>>>>>>>>> >>>>>>> Problem with DB2DBDFT:
try to add following clause to your commands instead of using DB2DBDFT:
' ... connect to <databasename >'
For example:
db2text "CREATE INDEX db2ext.myTextIn dex FOR TEXT ON books (story)
CONNECT TO sample">>>>>>>>>>> >>>>>>>

To see a list of the NSE administration commands:
db2text help
To see the syntax for a specific command:
db2text help <command>
For example:
db2text help enable

Please feel free to contact me directly if you need additional help with
NSE.

Kind regards,
Sabine
Stanley Sinclair wrote:
I tried to respond to p.*********@vid eotron.ca, but the message was
repeatedly refused with error "not our customer."

I wrote in French, as I am an expatriate québecois; I didn't want to
post it here. It was a thank-you and a request for information about
videotron and SES Consultants.

Stan


Nov 12 '05 #14
st************* @bellsouth.net (Stanley Sinclair) wrote in message news:<6f******* *************** ****@posting.go ogle.com>...
Dear Mr Guy,

First, please read the first lines of the first item in this thread.
I'm afraid that I, again, got carried away in some of the things that
I said.
As you said, this was is your first post, not the subsequent ones (one
of which I replied to). So now you're saying that your apology should
not have been seen as an apology for past posts, so much as a
declaration of intent for future ones?
However, it would have been very pleasant if you were to help instead
of trying to poke fun of me in your superiority.


If I was poking fun it was in response to the attitude you struck.
It's one to say that you want help, qite another to start slagging off
a product and blaming it for nearly losing your job, when it's quite
obvious you have next to no knowledge of the basics (and I did check
your other posts before replying BTW). There may be genuine problems
with Net Search Extender, I don't know; but reading your post I wasn't
very convinced.

Bottom line is you are likely to have just as many problems (if not
more) with Oracle unless you have a deeper Oracle background - it's a
famously tricky product to administer, whereas you might find SQL
Server a bit easier than both Oracle and DB2. Good luck with it
anyway.
DG
Nov 12 '05 #15
Dear Mr Guy,

I wish I could say that I'm sorry for upsetting you, but I'm not. In
your writings in this thread you have said nothing that would help me,
only criticism and sarcasm.

The purpose of this forum is for those without certain knowledge to
request that knowledge from those with the knowledge. No matter how
elementary. (I have been working mostly on interfaces for the past
few years, and am out-of-touch with newer database techniques and
processes. But I believe that, with a little help I can quickly be up
to speed.)

If you have knowledge which could have helped me, you have very
studiously kept it to yourself.

Well, now: Please relax, giggle to yourself, but do not respond.

SS
Nov 12 '05 #16
I tried to respond to p.*********@vid eotron.ca, but the message was
repeatedly refused with error "not our customer."

I wrote in French, as I am an expatriate québecois; I didn't want to
post it here. It was a thank-you and a request for information about
videotron and SES Consultants.

Stan
Nov 12 '05 #17

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2114
by: Stanley Sinclair | last post by:
I have a table in V8.1.2 (Windows) which contains about 17,000 constant rows. One column contains a string of about 20 English words. I need to find all rows which contain three words specified by their first letters. For example, if I am looking for rows containing Jon (or Jonathan) and Will (or William) and Terry (or Terri or Terrance), the SQL would be: SELECT col1 FROM MYTAB WHERE col2 LIKE '%Jon%' AND col2 LIKE '%Will%' AND...
2
2140
by: Lan W via DBMonster.com | last post by:
Hi, I try to install Db2 Net Search Extender on my Db2 workgroup server edition on windows machine. When I verify the installation from command window as typed >nsesampla.bat sample, I received the following error: DB2text.exe - Entry point not found. The procedure entry point sqlogmblk could not be located in the dynamic link library DB2SYS.dll. Does anyone have idea onhow to fix it? Thanks very much!
0
1230
by: Ralf Gross | last post by:
Hi, I'm looking for the Net Search Extender version for linux. We have a company license for db2 and I got a white box with about 100 CDs in it. I think it's the 'development edition' (IBM DB2 Universal DEV. ED. 8.1 Media Pack Deutsch). I successfully installed 8.1 with FP 10. In the box I found the Net Search Extender disc for Windows and Unix operation systems, but nothing for linux.
8
3480
by: ignatova | last post by:
Hello, I have been using IBM Net Search Extender to perform full text searches on text columns in relational tables in DB2 without any problems until now. However it doesn't seam to function properly for text indexes created on attributes of typed tables. Here are the issued commands: //create UDT db2 CREATE TYPE CompMetadata_T AS (dummy Integer,Text CLOB(100K),
1
351
by: 2803stan | last post by:
I hear that DB2 V9.1 has dropped, or will soon drop Net Search Extender. I have occasion to require quick search for a particular word of several columns of data, and very many rows. What is there to replace this indexing feature? SS
0
1339
by: pike | last post by:
Hi Can anyone confirm whether DB2 9 Net Search Extender is compatible with DB2 v8.2? If it isn't, can someone provide me with a link to the trial software download page for a version of DB2 Net Search Extender that is compatible? Thank you.
1
1727
by: ting ting | last post by:
I am using ASP.net 2.0 and I want to search a list of about 2,000 items in a list. I used a listsearch extender to search item fastly. However, it is still a bit not smooth enough to search. So I want to use a textbox for the users to type and check the listbox value by Javascript. However, it is very slow also. Can anybody help on searching and auto complete the search item more quickly??
0
871
by: bhagawansharma | last post by:
hi friends i want to use a text box for the user to type letters and query the database to get some results and populate in a list box. Is it possible to do that. like .. using lest search extender control of ajax but i am not able to integrate textbox with lest search extender in .net .how to do that any body can suggest me. thank & regard bhagawan sharma .
2
2822
by: =?Utf-8?B?UGF1bA==?= | last post by:
Hi I am using a list search extender and have the control it is assigned to as a control in a template column in a gridview. Anyhow for some reason the type to search section that normally appears right above the control is not appearing right above the control. Although always lined up vertically it randomly appears in different locations outside the gridview on the web page. Any suggestions, thanks -- Paul G Software engineer.
0
9997
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9845
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
10976
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
10497
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
8043
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7204
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5891
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
4721
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
3320
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.