DB2 Version 10.1 for Linux, UNIX, and Windows

FP3: Command locks can be set manually for DB2 Text Search

In DB2® Version 10.1 Fix Pack 3 and later fix packs, you can perform administrative operations one at a time to a specific text index. To prevent conflicts, a command lock is automatically set 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.

For example, for index i1, you can issue the command as follows:

db2ts set command locks for index i1 for text

Alternatively, you can issue the stored procedure as follows:

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