Verify the migrated databases

Run sp_iqcheckdb to verify the consistency of the databases.

In this step, you run the IQ 15.2 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.2, 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 entering:
```
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, see 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.