To configure text search

  1. Ensure that a full text index catalog is set up for each database, including the one for the Landmark environment and the ones for Landmark applications. For example, in SQL Server Management Studio, navigate to yourSQLServerInstance > Databases > eachDatabase > Storage > Full Text Catalogs. Create full text catalogs if necessary.
  2. To find out which files have text indexes, use the Landmark command

    dbmaint -IE productline

    Review the output of this command for lines stating

    create fulltext index on "dataarea"."filename"

    These statements will repopulate each text index, so you get accurate results from text search.

    These lines indicate the files that have text indexes. You can use this information to tailor the textindexjob command for specific files or modules.

  3. Install the text search component, if it was not installed with the database.
  4. Open the %LARUNDIR%\DATAAREA\db.cfg with a text editor, and set the following parameters:
    1. Specify the name of the text search server using the TEXT_SERVER parameter.
    2. Specify how the Microsoft SQL Server database manages changes to text indexes by setting the value of the CHANGE_TRACKING parameter.
    3. Specify how the Microsoft SQL Server database will manage changes to text indexes by setting the value of the other text index parameters
    4. Save and close the db.cfg file.

    For more information, see Parameters that Support Text Search.

  5. At a Landmark command prompt, type

    textindexjob [-Uqdc] dataarea [filename|module ...]

    where

    Parameter Description
    -U

    Update and create objects directly in the database.

    If you do not use -U, SQL statements are not executed.

    -q Do not print DDL to stdout
    -d Drop selected jobs
    -c Create selected jobs
    dataarea The data area that you want to create a text index population job for.
    filename One or more files that you want to run the text index population job against.
    module One or more modules that you want to run the text index population job against.