(C) IBM Corp. 1996, 1999
Text Extender: Administration and Programming
When text is prepared for use by Text Extender, certain administrative
changes are made. This section describes functions that help you to
reverse this process.
Summary |
---|
- When
- When you no longer intend to make text searches in a text column.
- Command
- DISABLE TEXT COLUMN
- Authorization
- ALTER, SELECT, UPDATE on the table
|
Example:
db2tx "DISABLE TEXT COLUMN db2tx.sample
HANDLE commenthandle"
When you disable a text column, the following occurs:
- If this is a multi-index table, that is, the column has its own text index
and log table, then the index, the log table, and the log table triggers are
deleted.
- If this is a common-index table, that is, there is one index shared by all
text columns, then the terms for this column's documents are removed from
the common index. If this is the only remaining enabled text column in
the table, then the index, the log table, and the log table triggers are
deleted.
Summary |
---|
- When
- When you no longer intend to make text searches in a set of external text
files.
- Command
- DISABLE TEXT FILES
- Authorization
- ALTER, SELECT, UPDATE on the table
|
Example:
db2tx "DISABLE TEXT FILES db2tx.sample
HANDLE commenthandle"
When you disable external text files, the following occurs:
- The index for this handle column is deleted.
- The log table and triggers are deleted.
Summary |
---|
- When
- When you no longer intend to make text searches in a text table.
- Command
- DISABLE TEXT TABLE
- Authorization
- ALTER, SELECT, UPDATE on the table
|
Example:
db2tx "DISABLE TEXT TABLE db2tx.sample"
When you disable a text table, the following occurs:
- If there is a common index for the text columns of the table, this index
is deleted. If, instead, there are individual indexes for each text
column, all the indexes for the text columns are deleted.
- The common log table used to automatically record which text documents are
to be indexed is deleted. If, instead, there are individual log tables
for each text column, all the log tables are deleted.
- The triggers used to maintain the log tables are deleted.
- The content of the handle columns is set to null.
Summary |
---|
- When
- When you no longer intend to make text searches in this database.
- Command
- DISABLE DATABASE
- Authorization
- SYSADM or DBADM on the database
|
To disable the connected database , enter:
db2tx "DISABLE DATABASE"
When you disable a database, the following objects are deleted:
- The Text Extender catalog view that was created when the database was
enabled
- The declaration of Text Extender's user-defined functions (UDFs), and
user-defined distinct types (UDTs) for this database
- All indexes related to any of this database's text tables or text
columns
- The log tables used to automatically record which text documents are to be
indexed, and the triggers used to maintain them.
Because handle columns cannot be deleted, and the handle column is of a
distinct type, some distinct types are not deleted.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]