Changing Text Index Population Times

The dbtextindex utility generates and executes SQL to alter text indexes so that their population time is spread out or "flattened" over a user specified period. This keeps a smooth period between index updates so no two index updates fire at the same time.

For example, if a text index is scheduled to update every 30 minutes and there are seven text indexes, the normal default an update on the hour and at 30 past the hour. However, after running this utility the first index would be updated at minute 0 and 30; the second at minute 4 and 34; the third at minute 8 and 38; the fourth at minute 12 and 44; the fifth at minute 17 and 47; the sixth at minute 21 and 51; and the final index at minute 25 and 55.

At a Landmark command prompt, type

dbtextindex [-Uqdf] [-i minutes] [-n dbname] DataArea [FileName|ModuleName ...]

where


Option	Description
`DataArea`	The data area where text index schedule should be modified.
`ModuleName`	Modify text index schedules for all files in the module.
`FileName`	Modify a text index schedule for this file. Note: Use module or file name, but not both.
`-U`	Perform the actions on database.
`-d`	Drop the text indexes.
`-c`	Create the text indexes.
`-f`	Flatten text indexes
`-n dbName`	Defining connection to process This will limit the actions to the `dbName` listed in the `db.cfg` file. This allows things to be limited to a single database connection.
`-i minutes`	Specify the interval (in minutes, between 5 and 1440) between updates. For example, use `-i 720` for two updates per day. The default is 30 minutes between updates.
`-q`	Do not print DDL to stdout.