Verify the migrated databases

Run sp_iqcheckdb to verify the consistency of the databases.

NoteIn 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.

StepsRunning sp_iqcheckdb

  1. 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.

  2. Issue a CHECKPOINT command.

  3. 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.

  4. Issue a COMMIT statement.

NoteFor 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.