SYSPROC.SYSTS_STOP
You can call the SYSPROC.SYSTS_STOP stored procedure to stop DB2® text search functions. This stored procedure sets the SERVERSTATUS value in the catalog QSYS2.SYSTEXTSERVERS to 1 (stopped).
After this stored procedure has completed, SQL queries that use the CONTAINS or SCORE functions or administration stored procedures used for index maintenance return a failure without trying to contact a text search server.
Changes to the based-on table of the index continue to be logged, even when the server is stopped. However, scheduled updates of the index do not occur until SYSPROC.SYSTS_START has been invoked.
Authorization
- *EXECUTE authority on the procedure
- SELECT and UPDATE privileges on the SYSTEXTSERVERS table.
- *EXECUTE authority on the QSYS2 library of the SYSTEXTSERVERS file.
- *JOBCTL authority or QIBM_DB_SQLADM security special function usage.
For information about the system authorities corresponding to SQL privileges, see GRANT (Table or View Privileges).
Syntax
The schema qualifier is SYSPROC.
Parameter
- serverid or aliasname
- Specifies the identifier of the server to be stopped. A serverid or server aliasname is a string. If no identifier is provided, the default is to stop all servers. The identifier string must either be a valid serverid that exists in the SERVERID column, or a valid server aliasname that exists in the ALIASNAME column of the QSYS2.SYSTEXTSERVERS table. If the identifier can be converted to an integer value, it is interpreted as a serverid. If the identifier cannot be converted to an integer value, it is interpreted as a server aliasname.
CALL SYSPROC.SYSTS_STOP().
CALL SYSPROC.SYSTS_STOP(1)
CALL SYSPROC.SYSTS_STOP('LOCAL_SERVER')
CALL SYSPROC.SYSTS_STOP('"local_server"')