Recreating Text Indexes in the Database

You must recreate all of your text indexes after changing the db.cfg file parameters. The dbmaint command syntax used in this procedure generates and executes DDL to implement the parameter values set in the db.cfg file, and drops and creates only the text indexes in the database.

Caution: 

If you are working with critical data, do not use the update (-U) mode without first examining the DDL. Instead, the preferred method is to direct the output to a file that you can examine, edit if necessary, and then issue to the database through the database's SQL utility.

Note: 

If the CHANGE_TRACKING parameter in the db.cfg file is set to AUTO, you do not need to run dbtextindex. The index will be repopulated when a row is changed. In other cases, you will need to use this procedure to recreate the text indexes.

Recreate text indexes in Lawson

At a Landmark command prompt, type