Dropping a database

Before you drop a database with one or more text indexes, issue the following command for each text index:

db2text drop index <index_name> for text

If you do not use this command, you must delete all of the index files manually in index_directory and index_work_directory.

Note that if the indexes belonging to the dropped database were created during an automatic update, you will need to edit the scheduler file ctedem.dat.

To do this, enter the following:

For UNIX:

db2text stop force
cd ~/sqllib/db2ext

or for Windows:

db2text stop force
cd <db2_install_path>\sqllib\<db2_instance_name>\db2ext

Open the file ctedem.dat in the directory and remove all entries referring to the dropped database.