-20424 TEXT SEARCH SUPPORT IS NOT AVAILABLE reason-code
Explanation
A problem with one of the text search administration
tables used by DB2® was detected.
The reason-code provides more information about
the error situation:
- 1
- One of the text search administration tables was not found (SYSIBMTS.SYSTEXTINDEXES, SYSIBMTS.SYSTEXTCOLUMNS, SYSIBMTS.SYSTEXTSTATUS, SYSIBMTS.SYSTEXTCONNECTINFO, or SYSIBMTS.SYSTEXTSERVERS).
- 2
- There are no rows in the SYSIBMTS.SYSTEXTSTATUS text search administration table.
- 3
- The SYSTEMSTATUS column in the SYSIBMTS.SYSTEXTSTATUS table has a value of -1 indicating that text search support is not installed.
- 4
- The SYSTEMSTATUS column in the SYSIBMTS.SYSTEXTSTATUS table has a value of 0 indicating that the support for text search is 'stopped'.
- 5
- The SYSTEMSTATUS column in the SYSIBMTS.SYSTEXTSTATUS table has an invalid value.
- 6
- There are no rows in the SYSIBMTS.SYSTEXTCONNECTINFO table.
- 7
- No OmniFind servers have been defined.
- 8
- All servers have reached the maximum number of indexes.
- 9
- The DB2 local location name is not defined.
- 10
- The DB2 local host IP address is not defined.
System action
The statement cannot be processed.
Programmer response
Contact your system administrator to make sure that support for text searching is successfully setup on your system.
SQLSTATE
38H11