SYSPROC.SYSTS_STOP

Invoke the SYSPROC.SYSTS_STOP stored procedure to stop Db2 text search functions.

After this stored procedure runs successfully, SQL queries that use the CONTAINS function, the SCORE function, and administration stored procedures that are used for index maintenance will fail without trying to contact a text search server.

The stopped status is made persistent in the SYSIBMTS.SYSTEXTSTATUS table, even if errors occur.

After you invoke the SYSPROC.SYSTS_STOP stored procedure, invocations of the SYSPROC.SYSTS_UPDATE stored procedure fail until you invoke the SYSPROC.SYSTS_START stored procedure again. Updates that are made to columns with a text search index continue to be captured by Db2, even while the SYSPROC.SYSTS_STOP stored procedure is running. SQL queries and administration stored procedures that are currently running are not affected.

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.

Prerequisite

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

The schema qualifier is SYSPROC.

Example

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



CALL SYSPROC.SYSTS_STOP()