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 a DBA executes sp_iqcheckoptions he or she sees all options that are set on a permanent basis for all roles 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, execute:
sp_iqcheckoptions
The system table DBO.SYSOPTIONDEFAULTS contains all of the names and default values of the SAP Sybase IQ and SQL Anywhere options. You can query this table, to see all option default values.