Verifying the Migrated Database

To verify simplex migration, start the migrated database in read-only mode and perform post-migration tasks.

1. Start the 16.0 database in read-only mode:

   start_iq -iqro 1

   When starting the coordinator in 16.0, use the same port as the 12.7 writer server.

2. Issue a CHECKPOINT command.
3. Run the 16.0 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.
4. Issue a COMMIT statement.
5. 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 to the 12.7 catalog , copy all the .before_schema_reload files to the same file without the .before_schema_load file extension.

6. After you perform the read-only checks, stop the database server and restart in write mode.