Verify the 12.x databases before migration

Sybase recommends that you run sp_iqcheckdb to verify the consistency of your 12.x databases before you migrate.

NoteIn this step, run the IQ 12.6 or 12.7 version of sp_iqcheckdb, depending on the version from which you are migrating. These versions of sp_iqcheckdb use input parameters, rather than database options, to specify the type of database consistency checking.

StepsRunning sp_iqcheckdb

  1. Start version 12.6 or 12.7 and connect to your database.

  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:

    sp_iqcheckdb 'verify database' >& filename
    
  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.