SYSIBMTS.SYSTEXTSTATUS administration table

The SYSIBMTS.SYSTEXTSTATUS administration table contains information that is generated after the SYSPROC.SYSTS_START stored procedure is invoked to start Db2 text search functions. This table also indicates whether text search support is enabled.

The following table shows the contents of the SYSIBMTS.SYSTEXTSTATUS administration table.

Table 1. Contents of the SYSIBMTS.SYSTEXTSTATUS administration table
Column name Data type Nullable? Description
SYSTEMSTATUS INTEGER No Indicates the status of Db2 text search functions. This column supports the following values:
  • 0 (zero): Text search functions are stopped.
  • 1: Text search functions are started.
  • -1: Text search functions are not installed.
VERSION INTEGER No The internal version identifier for the text search product.