® is a database management system that stores information used by IBM Sametime
® Advanced. A database that has the potential to grow large requires some ongoing tuning by a database administrator.
About this task
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 wish 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
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
to drop the text indexes first. If the indexes are not dropped, entries for them should be cleaned out of the DB2 ctedem.dat
Parent topic: Tuning DB2 for Sametime Advanced
Maintaining text indexes
Dropping a database