SYSPROC.SYSTS_START

Invoke the SYSPROC.SYSTS_START stored procedure to start Db2 text search functions.

Text search functions include support for SQL queries that use the CONTAINS function, the SCORE function, and the administration stored procedures that are used to maintain text search indexes. If text search functions are not started, Db2 returns SQLCODE -20424 with reason code 4 for the CONTAINS and SCORE functions.

Run the SYSPROC.SYSTS_START stored procedure, each time that a server is added or changed in SYSIBMTS.SYSTEXTSERVERS table. After this stored procedure runs, the start status is made persistent in the SYSIBMTS.SYSTEXTSTATUS table, even if errors occur.

For the text search servers that are contained in the SYSIBMTS.SYSTEXTSERVERS table, TCP/IP names are resolved. Multiple calls of the SYSPROC.SYSTS_START stored procedure are not considered an error because you might need to refresh the address resolution in the SYSIBMTS.SYSTEXTSERVERS table.

Note: All stored procedures can perform COMMIT statements on the current connection. This capability makes it possible to keep changes on the text search server consistent with your Db2 subsystem. After you invoke a stored procedure, you cannot roll back the changes that are made on your Db2 subsystem or the text search server. Rollback in a stored procedure is done only to a savepoint that is set when you invoke the stored procedure.

Prerequisites

Before you invoke the SYSPROC.SYSTS_START stored procedure, verify the following prerequisites:
  • The SYSIBMTS.SYSTEXTSERVERS table contains at least one entry.
  • The SYSIBMTS.SYSTEXTCONNECTINFO table is populated.
  • At least one text search server is running.
  • The distributed data facility (DDF) must be started, even if you call the stored procedure locally on your z/OS® system. The DDF is required to allow the text search server to connect to Db2 to store a text search index.

Authorization

The user ID under which this stored procedure is invoked must have the following privileges:
  • EXECUTE on the procedure
  • EXECUTE on the packages SYSIBMTS.*

Syntax

Read syntax diagramSkip visual syntax diagramSYSTS_START

The schema qualifier is SYSPROC.

Example

This example shows how to use the Db2 CALL statement to invoke the SYSPROC.SYSTS_START stored procedure. This example uses the SYSPROC.SYSTS_START stored procedure to start Db2 text search functions. 



CALL SYSPROC.SYSTS_START()