Starting text search functions
To start text search functions, the Db2 database administrator runs a program that calls the SYSPROC.SYSTS_START stored procedure.
About this task
Text search support includes SQL statements that use the CONTAINS function, the SCORE function, and the following administration stored procedures:
- SYSPROC.SYSTS_ALTER
- SYSPROC.SYSTS_CREATE
- SYSPROC.SYSTS_DROP
- SYSPROC.SYSTS_RESTORE
- SYSPROC.SYSTS_START
- SYSPROC.SYSTS_STOP
- SYSPROC.SYSTS_TAKEOVER
- SYSPROC.SYSTS_UPDATE
Procedure
To start text search functions:
Run a program that calls the SYSPROC.SYSTS_START stored
procedure.
You can run a stored procedure by issuing a CALL statement using one of the following tools:
- QMF
- The Db2 for z/OS® command line processor at the UNIX System Services prompt
- The Db2 client's command line editor on your Linux®, UNIX, or Windows workstation
Example
The following example shows a sample program that calls the SYSPROC.SYSTS_START stored procedure:
CALL SYSPROC.SYSTS_START();What to do next
Enable your Db2 for z/OS environment for text search. See Enabling the Db2 for z/OS environment for text search.
You can now also create a text search index. For more information, see Creating a text search index.