IBM Support

Can the Full Text Indexer be stopped from running during the day, even by users with manager access to their databases, but allow the Index to be updated overnight?

Technote (troubleshooting)


Problem

An administrator wants to stop their users from updating the Full Text Index of their databases throughout the day as this is affecting the server performance. However, they want their users to maintain manager access to their databases and they want the Full Text Index to be updated on schedule overnight.

Is this possible?

Symptom

A server is being overloaded during the day due to multiple users requesting updates to their Full Text Indexes during the day. The administrator does not want to reduce their ACL access from manager and also wants to be able to update the indexes overnight on schedule.


Cause

Server being overloaded by multiple Full Text Index update requests from users with Manager access to their databases.

Resolving the problem

Reducing the ACL access level to Editor for the users will prevent them from being able to manually request Full Text Index updates, but in some cases this is not an option.

Alternatively, there is a parameter that can be set that will stop all Full Text Indexing for all databases on the server regardless of what access a user has. This setting is :

UPDATE_NO_FULLTEXT=1

This can be configured into a Program Document - allowing you to schedule when it is enabled and disabled. The settings for the program document would be like this, the first one will enable Full text indexing on the server :

Basics Tab:
Program Name: nserver
Command line: -c "set config UPDATE_NO_FULLTEXT=0"
Server to run on: specify your server
Schedule Tab:
Enabled/disabled: ENABLED
Run at times: specify the time to enable this each day
Repeat interval: 0 minutes (run once only)
Days of week: Sun, Mon, Tue, Wed, Thu, Fri, Sat

Then to disable the Full Text Indexing you will need to run :

Basics Tab:
Program Name: nserver
Command line: -c "set config UPDATE_NO_FULLTEXT=1"
Server to run on: specify your server
Schedule Tab:
Enabled/disabled: ENABLED
Run at times: specify the time to enable this each day
Repeat interval: 0 minutes (run once only)
Days of week: Sun, Mon, Tue, Wed, Thu, Fri, Sat

Using the above you will be able to specify when the Full Text Indexer will be able to run on a server. Existing Full Text Indexes will remain and will function as normal, but new documents and updates will not be updated.

The indexes will only be updated either when the nightly UPDALL is run (set by default to run at 2am in the NOTES.INI) or whenever needed as UPDALL can be scheduled through a program document as well.

Document information

More support for: IBM Domino
Full Text Index

Software version: 8.0, 8.5

Operating system(s): AIX, IBM i, Linux, Solaris, Windows, z/OS

Reference #: 1571557

Modified date: 19 November 2013