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.
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.
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
dbtextindex -Ucd dataarea
For more information on DDLs, see Using the Build Data Definition Language Utility to Fix Dictionary Mismatches and Finding and Fixing Dictionary Issues.