Insufficient threads [CR 478486]

The following should be appended to “Insufficient threads” in the section “Resource issues,” in Chapter 1, “Troubleshooting Hints,” in the Sybase IQ Troubleshooting and Recovery Guide.

If the server runs out of threads or if sufficient threads are not available to a connection during a restore, Sybase IQ may return the error Ran out of threads. Start up server with more threads. (SQLCODE -1012024). The RESTORE command will try to allocate a “team” of threads for the restore operation. Sybase IQ will try to allocate at least one thread per backup device plus two threads per CPU, plus one thread to the “team” for the restore. Make sure that enough threads have been allocated on a per connection and per team basis as well as to the server. See “MAX_IQ_THREADS_PER_TEAM option” and “MAX_IQ_THREADS_PER_CONNECTION option” in Chapter 2, “Database Options,” in the Sybase IQ Reference Manual.