This procedure removes invalid text search indexes and their associated collections from the database. An index can become invalid when database operations are executed that affect all of the table content, for example, truncate.
The procedure serves as an alternative to the db2ts CLEANUP FOR TEXT command for the database scope. To remove obsolete collections on the instance level, the command must be used.
The privileges held by the authorization ID of the statement must include the SYSTS_ADM role with DBADM and DATAACCESS authority.
None
>>-SYSTS_CLEANUP--(--options--,---------------------------------> >--message_locale--,--message--)-------------------------------><
The schema is SYSPROC.
CALL SYSPROC.SYSTS_CLEANUP('', 'en_US', ?)
Value of output parameters
--------------------------
Parameter Name : MESSAGE
Parameter Value : Operation completed successfully.
Return Status = 0
SQL0462W Command or routine "SYSTS_CLEANUP" (specific name "*N") has returned a
warning SQLSTATE, with diagnostic text "CIE00212W 2 of 20 collections could not be
deleted. Check db2diag.log for details.". SQLSTATE=01H14