FP3: New DB2 Text Search configuration options control index updates

In DB2® Version 10.1 Fix Pack 3 and later fix packs, you can use the INITIALMODE and LOGTYPE options of the INDEX CONFIGURATION parameter of the CREATE INDEX command to control update processing.

Use the INITIALMODE option to run the initial update after you create the index. For example, you might use the INITIALMODE option if you are creating the initial index as part of a migration step. However, you can use this option for the first update operation or defer its use.

The LOGTYPE option determines how the log table is managed. The basic value for this option adds triggers to recognize changes. The custom value does not add triggers and requires more measures to identify changes that require incremental updates.

You must set one of these options when you create an index.