Checking database and server startup option values

When diagnosing server startup, resource, or processing issues, you may need to check the current values of database options and server startup options. For the connected user, the sp_iqcheckoptions stored procedure displays a list of the current value and the default value of database options that have been changed from the default. sp_iqcheckoptions also lists server startup options that have been changed from the default values.

When sp_iqcheckoptions is run, the DBA sees all options set on a permanent basis for all groups and users and sees temporary options set for DBA. Non-DBA users see their own temporary options. All users see non-default server startup options.

The sp_iqcheckoptions stored procedure requires no parameters. In Interactive SQL, run the following command:

sp_iqcheckoptions

The system table DBA.SYSOPTIONDEFAULTS contains all of the names and default values of the Sybase IQ and ASA options. You can query this table, if you need to see all option default values.

For more information, see “sp_iqcheckoptions procedure” in Chapter 10, “System Procedures” and “Finding option settings” in Chapter 2, “Database Options” of the Sybase IQ Reference Manual.