Viewing text search index status

To get information about the current text search indexes within a database, you can query the administrative views or use the Administration Tool.

About this task

Text search index properties can be viewed in the SYSIBMTS.TSINDEXES administrative view. For example, to list all text search indexes with their status, issue the following query:

	db2 "select indschema, indname, indstatus from SYSIBMTS.TSINDEXES"

To check the status of all text search collections and their properties using the Administration Tool, use the following command:

	adminTool status -configPath absolute-path-to-config-folder