This chapter describes the syntax of administration commands for the text table owner.
Creating and maintaining a text index describes how to use these commands.
The commands are a variation of the DB2TEXT command. These allow the owner of a table to create and manipulate full-text indexes on columns of the table.
Command | Purpose | Page |
---|---|---|
ACTIVATE CACHE | Activates the cache so that search operations using the stored procedure are possible | ACTIVATE CACHE |
ALTER INDEX | Changes the characteristics of an index | ALTER INDEX |
CLEAR EVENTS | Deletes index events from an index event table used during index update | CLEAR EVENTS |
CREATE INDEX | Creates a full-text index | CREATE INDEX |
DEACTIVATE CACHE | Deactivates the cache so that search operations using the stored procedure are no longer possible | DEACTIVATE CACHE |
DB2EXTTH (Utility) | Compiles the thesaurus definition file | DB2EXTTH (Utility) |
DROP INDEX | Drops a full-text index for a text column | DROP INDEX |
ENABLE DATABASE | Enables the current database to create full-text indexes | ENABLE DATABASE |
UPDATE INDEX | Starts the indexing process based on the current contents of the text columns | UPDATE INDEX |
HELP | Displays the list of DB2TEXT command options | HELP |
COPYRIGHT | Displays the Net Search Extender product and copyright information | COPYRIGHT |
If no database connection has been specified as part of the db2text command, the db2text executable causes an implicit connection to be made to the default database specified in the environment variable DB2DBDFT.