DISABLE DATABASE

This command undoes DB2 Net Search Extender changes to a database.

Authorization

You must run this command as a database administrator to disable the database. This requires you having DBADM authority.

Command syntax

Read syntax diagramSkip visual syntax diagram>>-DISABLE-DATABASE-FOR-TEXT--+-------+------------------------->
                              '-FORCE-'

>--+----------------------+------------------------------------><
   '-|connection-options|-'

connection-options:

|--+--------------------------------------------------------------+--|
   '-CONNECT-TO--database-name--+-------------------------------+-'
                                '-USER--userid--USING--password-'

Command parameters

CONNECT TO database-name
The name of the database that is a target for this command. You can omit this parameter, if DB2DBDFT is set and the user is running the command under a user ID with the necessary DB2 authorizations.
USER userid USING password
Use a password and userid to connect to the database.
FORCE
Forces the dropping of all DB2 Net Search Extender indexes in the database. See DROP INDEX for more information.

Usage

This command resets the connected database, so that it can no longer be used by other DB2 Net Search Extender commands. If full-text indexes exist in the database, this command fails unless the FORCE option is used.

This command does not remove DBADM authority from the DB2 instance owner.

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 occurr. 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:

Changes to the database
The following modifications made in the database to enable DB2 Net Search Extender are deleted:
  • The DB2 Net Search Extender catalog views in the database.
  • All the database objects created by DB2 Net Search Extender.
Changes to the file system and shared memory
If you use the FORCE option, the index files are deleted.

If you use the FORCE option, the cache is deleted for any activated cache of indexes. See DROP INDEX for further information.