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"
