Start your Sybase IQ 12.7/12.6 database, then use
sp_iqcheckdb to verify that your database is clean and error-free.
- Start and connect to your Sybase IQ 12.7/12.6 database.
- Issue a CHECKPOINT command.
- Run the sp_iqcheckdb stored
procedure in verify mode: sp_iqcheckdb 'verify database’
If you run the procedure from Interactive SQL, redirect
output to a file by entering: dbisql -c "..." "sp_iqcheckdb ('verify database')" >& filename
where “...” represents startup parameters
for your database.
- Issue a COMMIT statement.
- Check sp_iqcheckdb results
for errors. Repair any index and allocation problems.
- Use the SQL backup command to back up the Sybase IQ 12.7/12.6 database.
- Shut down your Sybase IQ 12.7/12.6 server.
Note: For information on interpreting the sp_iqcheckdb results
and corrective action, see System Administration Guide: Volume 1 > System Recovery
and Database Repair. If you need to contact
Sybase Technical Support, you must provide the output from sp_iqcheckdb.