DB2 Version 10.1 for Linux, UNIX, and Windows

Issuing text search commands

You can issue commands by running the db2ts command shell or by calling one of the administrative SQL routines that is a stored procedure for DB2® Text Search.

About this task

To use the db2ts command shell, pass the command string as a parameter. The db2ts command shell acts like the DB2 command shell in that a command must contain the connection information if a remote database is used. Unlike the DB2 command shell, however, db2ts does not provide a session; instead, each command is a separate unit and thus must establish a connection separately. You do not have to specify the database connection if you are running the command locally for the default database specified using the DB2DBDFT environment variable. Set the DB2DBDFT environment variable at the operating system level. If you also set it using the db2set command, ensure that the same value is used.

Using an administrative SQL routine enables you to issue administration calls from a DB2 client on which you have not installed DB2 Text Search. You can call either the generic SYSTS_ADMIN_CMD administrative SQL routine with a command string as a parameter or the specific administrative SQL routine for that command.

Note: Error messages resulting from db2ts commands are written in the client locale, but messages resulting from the administrative routines are written in the locale specified by the message-locale argument or in en_US if you do not specify a locale.

Because some commands are not related to a specific database, for example, START FOR TEXT and STOP FOR TEXT, you can run them only using the db2ts command shell.