Sybase IQ 12.6 has many new and modified database options. For information on these options, see New Features in Sybase IQ 12.6.
If you have explicitly set database options that adjust performance and want to be sure that the new settings are appropriate for your environment, you may find it helpful to run sp_iqcheckoptions, which displays
Database options whose value is changed from the default
Current value of these options
Default value for the connected user
It is a good idea to run sp_iqcheckoptions and capture its output before and after running ALTER DATABASE UPGRADE.
