Database Options That Govern User Resources

Sybase IQ provides a set of database options that the DBA can use to control resources. These options are called resource governors.

How to Set Options

You can set database options using the SET OPTION statement. For syntax, see Reference: Statements and Options.

The following database options can be used to manage resources.

CURSOR_WINDOW_ROWS – Defines the number of cursor rows to buffer.
MAX_CARTESIAN_RESULT – Limits the number of result rows from a query containing a Cartesian join.
MAX_IQ_THREADS_PER_CONNECTION – Sets the number of processing threads available to a connection for use in IQ operations.
TEMP_CACHE_MEMORY_MB – Sets the size of the cache for the IQ Temporary Store. (The server option -iqtc is the recommended way to set the temp cache size.)
QUERY_TEMP_SPACE_LIMIT – Limits the amount of temporary dbspace available to any one query.
QUERY_ROWS_RETURNED_LIMIT – Tells the query optimizer to reject queries that might consume too many resources. If the optimizer estimates that the result set from the query will exceed the value of this option, the optimizer rejects the query and returns an error message.

The following database options affect the engine, but have limited impact on Sybase IQ:

JAVA_HEAP_SIZE – Sets the maximum size (in bytes) of that part of the memory that is allocated to Java applications on a per connection basis.
MAX_CURSOR_COUNT – Limits the number of cursors for a connection.
MAX_STATEMENT_COUNT – Limits the number of prepared statements for a connection.

Database option settings are not inherited through the group structure.