Set the USER_RESOURCE_RESERVATION option to adjust memory use for the number of current users.
SAP 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 SAP Sybase IQ thinks is currently using the product and hence allocate memory from the temporary cache more sparingly.
Set this option only if required. Contact Technical Support with details if you need to set this option.