Specifies an upper bound (in MB) on the amount of heap memory subsequent loads can use.
0 – 2000
0 (zero)
DBA permissions are not required to set this option. Can be set temporary, for an individual connection, or for the PUBLIC group. Takes effect immediately.
This option specifies an upper bound (in MB) on the amount of heap memory subsequent loads can use. The default setting, 0, means that there is no upper bound, and Sybase IQ can use as much heap memory as necessary to perform the load. A nonzero value means that the user has set an upper bound. The maximum upper bound is 2000MB (2GB). This option is typically used for LOAD statements, but affects all operations where loads, inserts, or updates occur, including SYNCHRONIZE, DELETE, INSERT and UPDATE operations.
