SP_WAITTIME configuration parameter
Use the SP_WAITTIME configuration parameter to specify the maximum number of seconds that a thread waits for a dbspace, temporary dbspace, plogspace, sbspace, temporary sbspace, or blobspace space to expand before returning an out-of-space error. Use the SP_WAITTIME configuration parameter to specify the maximum number of seconds that a thread waits for a dbspace, temporary dbspace, sbspace, temporary sbspace, or blobspace space to expand before returning an out-of-space error.
- onconfig.std value
- SP_WAITTIME 30
- values
- 0 - 2147483647
- units
- seconds
- takes effect
- After you edit your onconfig file and restart the database server.
Usage
The time that the server uses to automatically add or expand a chunk can vary widely, depending on various factors such as the size of the chunk, the speed of the associated disk drives, and the load on the system. When HCL OneDB™ automatically adds or expands a chunk to prevent free space from falling below the threshold specified by the SP_THRESHOLD configuration parameter, HCL OneDB forces threads that need the space to wait until it is available. You can change the value of the SP_WAITTIME configuration parameter if you want to change the maximum amount of time that the thread will wait for more space.
A thread will wait for a storage space to expand only if the storage pool contains entries. A thread will not wait if the storage pool is empty.