Dropping a table or a database does not automatically drop the text search collections. Before dropping a table or database, use the following steps to ensure all artifacts are removed:
Listing 26. Command to drop text-search indices
db2ts "DROP INDEX myschema.mytitleidx FOR TEXT" db2ts "DROP INDEX myschema.myxmlidx FOR TEXT"
Disabling the database for text-search drops the system tables and views that maintain text-search metadata:
Listing 27. Command to disable the database for text search
db2ts "DISABLE DATABASE FOR TEXT"
disable command fails if a text-search
index still exists in the database. You can enforce the command by
using the force option
disable database for text force, but it is
recommended to remove text search indices with the
drop index for text command.
Stop the text-search instance services to stop the processes that were started for supporting full text search:
Listing 28. Command to stop text-search services
db2ts "STOP FOR TEXT"
Finally, you can drop the test database to conclude this tutorial:
Listing 29. Disconnect from and drop the test database
DISCONNECT CURRENT DROP DATABASE mytstest