Verify the migrated databases

Run sp_iqcheckdb to verify the consistency of the migrated 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. Start the coordinator (the 12.6 or 12.7 write server) using both -iqro 1 and single node mode, -iqmpx_sn 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.

Because we started the server in readonly mode, the server cannot complete some post migration bookkeeping tasks, and the verification will report some problems with Block Count Mismatch, Blocks Leaked and Unallocated Blocks in Use. All other segments of the verify database should not report any errors.

For example:

'** Block Count Mismatch','79','*****'
'** Blocks Leaked','25','*****'
'** Unallocated Blocks in Use','104','*****'

Examine the sp_iqcheckdb report for errors. For information on interpreting the sp_iqcheckdb results and corrective action, refer to Chapter 2, “System Recovery and Database Repair,” in Sybase IQ Troubleshooting and Recovery Guide. If you need to contact Sybase Technical Support, you must provide the output from sp_iqcheckdb.