Db2 Text Search file descriptors

For Db2 Text Search index updates and queries, system resources such as file descriptors are consumed to handle multiple index update and search requests.

In a typical system, the number of open file descriptors per process may be limited to a relatively small number like 1024, which can result in the text search server running out of file descriptors. If this occurs, the search and update requests will fail.

To resolve this error
  • Check the server logs for an exception with the message string similar to too many open files.
  • On UNIX systems, check the system limits with ulimit -a.
To increase file descriptors, follow these steps:
  1. Shut down the text search server.
  2. Increase the number of file descriptors per process by following your operating system manual. This increase in file descriptors must be sufficient to accommodate all requests across login sessions.
  3. Restart the text search server.