Resource Issues

Resource issues may include insufficient disk space, insufficient number of threads, thread stack overflow, and unused system resources.

• Insufficient Disk Space
  The Sybase IQ server does not wait for additional space on an out-of-dbspace condition, but instead rolls back either the entire transaction or rolls back to a savepoint.
• Monitoring Disk Space Usage
  You can use an event handler to monitor disk space usage and notify you when available space is running low.
• Insufficient Threads
  The required number of server threads may not be available for your query.
• Stack Overflow
  You may experience problems if the thread stack overflows.
• Unused Semaphores and Shared Memory Left After Abnormal Exit
  Abnormal exits may leave unused semaphores and shared memory.
• Insufficient Procedure Identifiers
  Sybase IQ assigns internal catalog proc_ids for procedures sequentially and unused proc_ids are not reused.
• Insufficient Buffers
  If the resource manager determines that there is not enough cache to complete an operation, then the operation is not started, and Insufficient buffers is returned.