Setting Database Options

Adjust the configurable settings of a database to change the way the database behaves or performs.

Prerequisites

Database Version	Database Privileges
SAP Sybase IQ 15.3 and 15.4	View database options only – none. Modify database options – you must have DBA authority.
SAP Sybase IQ 16.0	View database options only – none. Modify database options – Depending on the option being modified, you must have one of: SET ANY PUBLIC OPTION system privilege SET ANY SECURITY OPTION system privilege SET ANY SYSTEM OPTION system privilege

Database Version

Database Privileges

SAP Sybase IQ 15.3 and 15.4

View database options only – none.

Modify database options – you must have DBA authority.

SAP Sybase IQ 16.0

View database options only – none.

Modify database options – Depending on the option being modified, you must have one of:

SET ANY PUBLIC OPTION system privilege
SET ANY SECURITY OPTION system privilege
SET ANY SYSTEM OPTION system privilege

The SAP Sybase IQ resource is authenticated and running.

Task

Some database options can only be set at one level, be it database (PUBLIC) or user, while others can be set at either level.

For database options that can be set at either level, when set at the user level, the setting overrides the current value for that user only. When set it at the database level, the value becomes the new default, and is applied to any existing users who have not had the option overridden at the user level.

For information on the level at each option can be set and the system privilege required, in the SAP Sybase IQ 16.x documentation, see the alphabetical list of Database options in IQ-product-name Reference: Building Blocks, Tables, and Procedures.

In the Perspective Resources view, select the resource, and select Resource > Administration Console.
In the left pane, expand IQ Servers > Schema Objects, and then select Databases.
Select a database from the right pane and either:
- Click the drop-down arrow to the right of the name and select Options, or,
- From the Administration Console menu bar, select Resource > Options.
The Options for Database "X" view appears.
Click in the Setting column to modify an option value.
Do one of:
- Click OK to update any changes to the database and exit the properties view.
- Click Apply to update any changes to the database, but remain in the properties view.
- Click Cancel to cancel any changes not updated to the database and exit the properties view.