If your SAP Sybase IQ server or database has problems restarting, use this information to diagnose database startup problems, verify the consistency of databases, and repair databases.
If you can restart the server after a failure, verify your database using the sp_iqcheckdb stored procedure, preferably before allowing users to connect
If you have trouble starting a server or database, if the database starts but users are unable to connect to it, or if problems are found during database verification, you may need to perform a forced recovery, restore the database, recover leaked space, or repair indexes.
To determine what type of recovery or repair is needed, you need information from your server log (servername.nnnn.srvlog) and IQ message log (dbname.iqmsg). Be sure to retain this information so you can provide it to Sybase Technical Support if necessary.
For example, if data inconsistency is detected, the dbname.iqmsg file may include detailed diagnostic information.