Editing the installtextserver script

Editing the installtextserver script

The installtextserver script is located in the $SYBASE/$SYBASE_FTS/scripts directory. Use a text editor (such as vi or emacs) to open the script, and make your edits. The edits you can make are as follows:

Changing the name of the text_db database. If you use a different name, replace all occurrences of text_db with the appropriate name.

If you change the name of the text_db database, you must also change the name in the defaultDb configuration parameter (see “Modifying the configuration parameters”).

Changing the name of the Enhanced Full-Text Search engine. By default, the installtextserver script defines a Enhanced Full-Text Search engine named “textsvr.” If your Enhanced Full-Text Search engine is named differently, edit this script so that it defines the correct server name.

Adding multiple Enhanced Full-Text Search engines (for information on how this can enhance performance, see “Configuring multiple Enhanced Full-Text Search engines”). If you are initially defining more than one Enhanced Full-Text Search engine, edit the installtextserver script so that it includes all the Enhanced Full-Text Search engine definitions. installtextserver includes the following section for naming the Enhanced Full-Text Search engine you are configuring (“textsvr” by default):

/*
** Add the text server
*/
exec sp_addserver textsvr,sds,textsvr
go

Add an entry for each Enhanced Full-Text Search engine you are configuring. For example, if you are configuring three Enhanced Full-Text Search engines named KRAZYKAT, OFFICAPUP, and MOUSE, replace the default “textsvr” line with the following lines:

exec sp_addserver KRAZYKAT, sds, KRAZYKAT
exec sp_addserver OFFICAPUP, sds, OFFICAPUP
exec sp_addserver MOUSE, sds, MOUSE
go

If you use OmniConnect to communicate with the Enhanced Full-Text Search engine, change the server name specification in the sp_addobjectdef calls for the vesaux and vesauxcol tables to a valid remote server. For example, if your remote server is named REMOTE, change the lines:

exec sp_addobjectdef
"vesaux","SYBASE.master.dbo.vesaux","table"
exec sp_addobjectdef
"vesauxcol","SYBASE.master.dbo.vesauxcol",
"table"

to:

exec sp_addobjectdef
"vesaux","REMOTE.master.dbo.vesaux","table"
exec sp_addobjectdef
"vesauxcol","REMOTE.master.dbo.vesauxcol",
"table"