Dropping a table without previously calling SYSPROC.SYSTS_DROP
When you drop a table without first calling the SYSPROC.SYSTS_DROP stored procedure, the result is orphaned full-text indexes (metadata in Db2® tables and collections on the text search server).
About this task
Recreation of the identical table without previously calling the SYSPROC.SYSTS_DROP stored procedure for full-text indexes results in a situation where text search functions always return 0 results, and administration stored procedures might succeed but do not have any effect.
Procedure
To detect and delete the orphaned full-text indexes: