Verify the Legacy Databases Before Migration

Verify the consistency of your Sybase IQ 12.7/12.6 database before you migrate.

Start version 12.6 or 12.7 and connect to your database.
Issue a CHECKPOINT command.
Run sp_iqcheckdb in verify mode.
```
sp_iqcheckdb 'verify database'
```
If you run the procedure from Interactive SQL, redirect output to a file:
```
sp_iqcheckdb 'verify database' >& filename
```
Issue a COMMIT statement.

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.