DB2 Version 10.1 for Linux, UNIX, and Windows

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.