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.
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.