Text search administrative views

Db2® Text Search creates and maintains several administrative views that describe the text search indexes in a database and their properties.

Do not update any of these views unless specifically instructed to do so.

The following views reflect the current configuration of your system:
  • Database-level views:
    • SYSIBMTS.TSDEFAULTS
    • SYSIBMTS.TSLOCKS
    • SYSIBMTS.TSSERVERS
  • Index-level views:
    • SYSIBMTS.TSINDEXES
    • SYSIBMTS.TSCONFIGURATION
    • SYSIBMTS.TSCOLLECTIONNAMES
    • SYSIBMTS.TSEVENT_nnnnnn
    • SYSIBMTS.TSSTAGING_nnnnnn