Verify the Migrated Simplex Database

Start the migrated database in read-only mode and perform post-migration tasks to verify the migration.

Start the Sybase IQ 15.4 database in read-only mode: start_iq -iqro 1

When starting the coordinator in Sybase IQ 15.4, use the same port as the Sybase IQ 12.7/12.6 writer server.
Issue a CHECKPOINT command.
Run the Sybase IQ 15.4 version of 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.
Check sp_iqcheckdb results for errors.

If there is an error, you can revert to the previous database as long as you do not restart the database in write mode. To revert back to the Sybase IQ 12.7 catalog , copy all the .before_schema_reload files to the same file without the .before_schema_load file extension.
Once you have successfully performed the read-only checks, you can stop the database server and restart it in write mode.

Note: For information on interpreting the sp_iqcheckdb results and corrective action, see “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.