db2ts CLEAR COMMAND LOCKS command
Removes all command locks for a specific text search index
or for all text search indexes in the database. A command lock is
created at the beginning of a text search index command, and is destroyed
when it is done. It prevents undesirable conflict between different
commands.
db2ts CLEAR EVENTS FOR TEXT command
This command deletes indexing events from an index's event
table used for administration. The name of this table can be found
in the view SYSIBMTS.TSINDEXES in column EVENTVIEWNAME.
db2ts CREATE INDEX command
The db2ts CREATE INDEX command creates
a text search index for a text column. You can then search the column
data by using text search functions.
db2ts DISABLE DATABASE FOR TEXT command
This command reverses the changes (for example, drops the text-search
related tables and view) made by the command ENABLE DATABASE
FOR TEXT.
db2ts HELP command db2ts HELP displays the list of available DB2 Text Search commands, or the syntax of an individual command.
db2ts RESET PENDING command
Issues a SET INTEGRITY statement
for all text-maintained staging tables that are associated with a
particular table.
db2ts SET COMMAND LOCK command
The db2ts SET COMMAND LOCKS command
creates a manual lock when an administrative operation is applied
on the collection level.
db2ts START FOR TEXT command
The db2ts START FOR
TEXT command starts the DB2 Text Search instance services that support other DB2 Text Search administration commands
and the ability to reference text search indexes in SQL queries.
db2ts STOP FOR TEXT command
The db2ts STOP FOR TEXT command stops DB2 Text Search instance services.
If the running services include processes for rich text support then
those services are stopped as well.
db2ts UPDATE INDEX command
The db2ts UPDATE INDEX command
updates the text search index to reflect the current contents of the
text column with which the index is associated. You can do a search
during the update. However the search operates on the partially updated
index until the update is complete.