db2ts START FOR TEXT command

The db2ts START FOR TEXT command starts the Db2® Text Search instance services that support other Db2 Text Search administration commands and the ability to reference text search indexes in SQL queries.

The db2ts START FOR TEXT command also includes starting processes for rich text support on the host machine running the Db2 Text Search server, if the server is configured for rich text support.

This command must be issued from the Db2 database server.

To start instance services in a partitioned database environment using an integrated text search setup, you must run the command on the integrated text search server host machine. By default, the integrated text search server host machine is the host of the lowest-numbered database partition server.

Authorization

Instance owner. No database privilege is required

Command syntax

Read syntax diagramSkip visual syntax diagramSTART FOR TEXT STATUSVERIFY

Command parameters

STATUS
Verifies the status of the Db2 Text Search server. A verbose informational message is returned indicating the STARTED or STOPPED status of the server.
VERIFY
Verifies the started status of the Db2 Text Search server and exits with a standard message and return code 0 indicating that the operation is successful. A non-zero code is returned for any other state of the text search server or if the status cannot be verified.

Examples

  • Check that the text search server is started.
     Linux/UNIX:
$ db2ts START FOR TEXT VERIFY
CIE00001 Operation completed successfully.

$ echo $?
0

Windows:
C:\> db2ts START FOR TEXT VERIFY
CIE00001 Operation completed successfully.

C:\> echo %ERRORLEVEL%
0

Usage notes

  • In a partitioned database environment, the db2ts START FOR TEXT command with theSTATUS and VERIFY parameters can be issued on any one of the partition server hosts. To start the instance services, you must run the db2ts START FOR TEXT command on the integrated text search server host machine. The integrated text search server host machine is the host of the lowest-numbered database partition server. If custom collection directories are used, ensure that no lower numbered partitions are created later. This restriction is especially relevant for Linux® and UNIX platforms. If you configure Db2 Text Search when creating an instance, the configuration initially determines the integrated text search server host. That configuration must always remain the host of the lowest-numbered database partition server.
  • On Windows platforms, there is a Windows service associated with each Db2 instance for Db2 Text Search. The service name can be determined by issuing the following command:
    DB2TS - <instance name>[-<partition number>]
    . Apart from the using the db2ts START FOR TEXT command, you can also start the service using the Control Panel or the NET START command.