(C) IBM Corp. 1996, 1999
Text Extender: Administration and Programming
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 ]