DB2 10.5 for Linux, UNIX, and Windows

Committing batches for DB2 Text Search

DB2® Text Search now provides more options for finer control of update processing.

In addition to specifying the batch size for a COMMIT operation, you can also determine how many commit cycles should be 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 have been enhanced to support this functions:

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

The following DB2 Text Search stored procedures have also been improved to handle the COMMIT operation for batches:

SYSTS_CREATE procedure
SYSTS_ALTER procedure
SYSTS_UPDATE procedure