Verify the migrated databases

Run sp_iqcheckdb to verify the consistency of the databases.

In this step, you run the IQ 15.1 version of sp_iqcheckdb, which uses input parameters, rather than database options, to specify the type of database consistency checking.

Running sp_iqcheckdb

Start the database using the read-only switch, -iqro 1.

When starting the coordinator in 15.1, use the same port used by the 12.6 or 12.7 writer server.
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:
```
dbisql -c "..." "sp_iqcheckdb ('verify database')" >& filename
```
where “...” represents startup parameters for your database.
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.