Disabling a database

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:

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: