DB2 10.5 for Linux, UNIX, and Windows

Set manual command locks for DB2 Text Search

You can apply administrative operations one at a time to a specific text index. To prevent conflicts, a command lock is automatically sent when an operation starts and is removed when an operation ends. However, text indexes might also be affected by operations that are not managed through DB2® Text Search. For such cases you can now set the command lock manually.

To set a lock manually, use the db2ts SET COMMAND LOCKS command or the SYSPROC.SYSTS_ADMIN_CMD() stored procedure.

You can issue the command as follows for an index i1:
```
db2ts set command locks for index i1 for text
```

Alternatively, issue the stored procedure as follows:

db2 "call sysproc.systs_admin_cmd('set command locks for index i1 for text', 'en_US', ?)"