Tuning DB2 text indexes for a Sametime Advanced Server

The database administrator should monitor the DMS tablespaces and add additional storage as needed. The default tablespace creation scripts allow the tablespaces to automatically grow to a set size. This set size can be changed, or additional files can be added to the tablespace as needed.

The database administrator may want to do additional maintenance on the full text indexes that are maintained outside of the database. The text indexes can be altered after they are created to modify the frequency of updates. Incremental commits can be configured if the update transactions become too large, and the indexes can be reorganized. If for any reason, a text index becomes corrupted, re-running dbtext.bat or dbtext.sh will drop all text indexes and recreate them.

Dropping a database does not automatically drop the text indexes. If the database administrator decides to drop a database that contains text indexes, the administrator should also run the script dropdbtext.bat or dropdbtext.sh to drop the text indexes first. If the indexes are not dropped, entries for them should be cleaned out of the DB2 ctedem.dat file.