Turning on full-text indexing in the Meeting Room Center
By default, the Meeting Room Center searches the Meeting Room Center database for rooms without using an index. If the database becomes too big, your deployment might experience performance degradation during searches. You can enable full-text indexing on the room name and owner name fields for enhanced performance on large datasets.
About this task
Full-text indexing is only used when you explicitly search for listed meeting rooms from the meeting room search box. It is not used when you search for hidden rooms, access My Meeting Rooms or access a Selected Contact's Meeting Rooms. Full-text indexes are created for both the room name and owner name.
Full-text indexes are updated every 12 hours. Rooms created in the past 24 hours cannot be found by their full-text index, but can be found by a limited table scan. This action avoids missing a room because the index has not been created, yet. Once a room has been live for more than 24 hours, full-text indexing is available.
Follow these steps to enable full-text indexing:
Procedure
What to do next
If you restart the server, the service does not restart automatically.
On Windows, you can go into Services and change the DB2TS service to start automatically. From the Start menu, click Run, and type services.msc, and change the DB2TS services to start automatically.
On Linux, you can edit one of the startup scripts
to start db2ts when you restart. The command to start db2ts is db2ts
start for text
.
For more information on DB2 maintenance, see Best Practices for DB2 maintenance in Sametime.