Verify the 12.x databases before migration

Sybase recommends that you run sp_iqcheckdb to verify the consistency of your 12.x databases before you migrate.

In this step, run the IQ 12.6 or 12.7 version of sp_iqcheckdb, depending on the version from which you are migrating. These versions of sp_iqcheckdb use input parameters, rather than database options, to specify the type of database consistency checking.

Running sp_iqcheckdb

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 by typing the following:
```
sp_iqcheckdb 'verify database' >& filename
```
Issue a COMMIT statement.

For information on interpreting the sp_iqcheckdb results and corrective action, refer to Chapter 13, “System Recovery and Database Repair,” in System Administration Guide: Volume 1. If you need to contact Sybase Technical Support, you must provide the output from sp_iqcheckdb.