DB2 Version 10.1 for Linux, UNIX, and Windows

FP3: Committing batches for DB2 Text Search workloads

In DB2® Version 10.1 Fix Pack 3 and later fix packs, DB2 Text Search provides more options for finer control of update processing.

In addition to specifying the batch size for a commit operation, you can determine how many commit cycles are completed during one update session. You can also specify whether the commit size is based on the number of rows or the time passed, in hours.

The following DB2 Text Search commands are enhanced to support these functions:

CREATE INDEX FOR TEXT
ALTER INDEX FOR TEXT
UPDATE INDEX FOR TEXT

The following DB2 Text Search stored procedures are improved to enhance the commit operation for batches:

SYSTS_CREATE procedure
SYSTS_ALTER procedure
SYSTS_UPDATE procedure