(C) IBM Corp. 2000
DB2 Net Search Extender Administration and User's Guide
Summary |
---|
- When
- When you no longer intend to make text searches in this database.
- Command
- DISABLE DATABASE FOR TEXT
- Authorization
- DBADM on the database
|
When DB2 Net Search Extender prepares the database for use, certain
administrative changes are made. This section describes functions that
help you to reverse this process.
To disable the connected database, use the following command:
db2text DISABLE DATABASE FOR TEXT
When you disable a database, you also delete the following objects:
- The DB2 Net Search Extender catalog views that were created when the
database was enabled.
- The declaration of DB2 Net Search Extender's SQL functions
(UDFs).
To disable the database and remove all the text indexes, use the following
command:
db2text DISABLE DATABASE for text force
|
---|
Note
Disabling a database will fail if there are any text indexes defined in the
database. It is recommended to remove these indexes one by one and then
check if any problems occur. If you use the disable database for text
force command, it only guarantees that Net Search Extender catalog tables in
the database are removed.
However, if some of the indexes can not be completely dropped, there may
still be resources that need to be manually cleaned up. These
include:
- Files in the index, work and cache directory
- Scheduler entries in ctedem.dat
- Where an index was created using the replication capture option, the
IBMSNAP_SIGNAL, IBMSNAP_PRUNE_SET, and IBMSNAP_PRUNCNTL entries in the tables
of the remote database must be manually deleted. These entries can be
easily identified using APPLY_QUAL="NSE"||<instance name> and
TARGET_SERVER= <database name> command.
In the following example, the instance is DB2 and the database
is SAMPLE.
DELETE FROM <ccSchema>.IBMSNAP_SIGNAL
WHERE SIGNAL_INPUT_IN IN
(SELECT MAP_ID FROM <ccSchema>.IBMSNAP_PRUNCNTL
WHERE APPLY_QUAL= 'NSEDB2' AND TARGET_SERVER= 'SAMPLE');
DELETE FROM <ccSchema>.IBMSNAP_PRUNCNTL
WHERE APPLY_QUAL= 'NSEDB2' AND TARGET_SERVER= 'SAMPLE';
DELETE FROM <ccschema>.IBMSNAP_PRUNE_SET
WHERE APPLY_QUAL= 'NSEDB2' AND TARGET_SERVER= 'SAMPLE';
|
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]