Documentation
(C) IBM Corp. 1996, 1999

Text Extender: Administration and Programming

UPDATE INDEX

This command starts indexing immediately. It brings the index up to date to reflect the current contents of the text column(s) with which the index is associated.

To have updates on external files reflected in the index, you must force a "change" entry to be placed in the log table by issuing an update statement on the corresponding handle column. See Updating an index for external files for an example.

Authorization

You must have at least one of the following for the table:

ALTER privilege

SELECT privilege

UPDATE privilege.

Command syntax

>>-UPDATE INDEX--table-name----+-----------------------------+-->
                               '-HANDLE--handle-column-name--'
 
>-----+---------------------+----------------------------------><
      '-COMMITCOUNT--count--'
 

Command parameters

table-name
The name of the text table in the connected database that contains the text column whose index is to be updated. This can also be the name of a common-index table. The name must include an explicit schema name (qualifier) unless the schema name is the same as your user ID.

HANDLE handle-column-name
If this is a common-index table, the handle-column-name is not required and is ignored. The index to be updated is associated with the whole table and not with an individual text column.

If this is a multi-index table, then handle-column-name is the name of the handle column whose index is to be updated.

COMMITCOUNT count
A value from 500 to 1000000 indicating the number of inserts or updates after which DB2 UDB must issue an intermediate commit statement. This can avoid a situation in which there is insufficient log space when enabling large tables, or columns, or a large number of external files.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]