Sybase IQ tracks the number of open cursors and allocates memory accordingly. In certain circumstances, USER_RESOURCE_RESERVATION option can be set to adjust the minimum number of current cursors that thinks is currently using the product and hence allocate memory from the temporary cache more sparingly.
This option should only be set after careful analysis shows it is actually required. Contact Sybase Technical Support with details if you need to set this option.
