Verifying the Migrated Multiplex Database

Verify the migrated database in read-only mode and correct any errors.

  1. Start the database using the read-only switch, -iqro 1. Start the coordinator (the 12.7 write server) using both -iqro 1 and single node mode, -iqmpx_sn 1.

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

  2. Issue a CHECKPOINT command.
  3. Run sp_iqcheckdb in verify mode:
    sp_iqcheckdb 'verify database'
  4. Issue a COMMIT statement.

The server is currently in read-only mode, and cannot complete some post migration tasks. Additionally, the verification reports some problems with Block Count Mismatch, Blocks Leaked, and Unallocated Blocks in Use. No other segments of the verify database should report any errors.

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

Examine the sp_iqcheckdb report for errors. If you need to contact SAP Sybase Technical Support, you must provide the output from sp_iqcheckdb.