Just want to make sure, does the database monitor program automatically update the regular indexes as well as the Metamorph indexes?
Here is what I understand by reading the manual (correct me if I am wrong), if we want to have the indexes monitored and updated using all defaults, we don't have to start the chkind program specifically. The database monitor program will do chkind automatically.
If we want to check the indexes (both metamorph and nonmetamorph) more often, and update if there is 10k of changed data instead of 1 meg of new data, what do we need to do? set the parameters in the SYSMETAINDEX table and run chkind specifically?
One more question, we are using Texis on solaris 2.7, where can I find the texis.cnf file, it's not under /usr/local/morph3.
Regular indexes are maintained during inserts and deletes, and do not need any updating. Only Metamorph indexes require periodic updating after a number of updates.
The database monitor will perform the task of chkind automatically (since Dec. 1999), so you do not need to run chkind by hand.
To check indexes more often, and for smaller amounts of data you should update the SYSMETAINDEX table to indicate the parameters for each Metamorph index. The database monitor will use these values when it runs, and will update from SYSMETAINDEX while running, so you do not need to invoke chkind.
Texis.cnf should be in the install directory, /usr/local/morph3 is the default. If it does not exist then default values will be used.
