Disabling a database for Db2 Text Search

Disable a database when you no longer intend to perform text searches in that database.

About this task

When you disable a database for text search, catalog tables and administrative views are dropped from the SYSIBMTS schema.

To disable a database for text search, use one of the following methods:

Drop any text search indexes defined in the database, using the DROP INDEX command.
To disable a database for text search, use one of the following methods:
- Issue the DISABLE DATABASE FOR TEXT command:
```
	db2ts "DISABLE DATABASE FOR TEXT CONNECT TO databaseName"
```
- Call the SYSPROC.SYSTS_DISABLE procedure:
- ```
	CALL SYSPROC.SYSTS_DISABLE('en_US', ?)
```
Note: Text search indexes can also be dropped using the FORCE option. However, it is possible that some data, specifically a text search collection, will remain after you disable the database. This can occur because the FORCE option allows you to drop text search indexes even if the Db2 Text Search server cannot be reached. Such a remaining collection needs to be explicitly removed with the CLEANUP operation.