Home | Previous Page | Next Page   Migration to a Later Version of a Database Server > Converting to Dynamic Server 10.0 >

Verify the Integrity of the Data

Use the oncheck utility to verify the integrity of the data before you make a level-0 backup. If you find any problems with the data, fix them before you make the backup. You can verify the integrity of the reserve pages, extents, system catalog tables, data, and indexes.

To obtain the database names, use the following statements with DB–Access: 

DATABASE sysmaster;
SELECT name FROM sysdatabases;

Table 20 lists the commands that verify the data integrity.

Table 20. Commands for Verifying the Data Integrity
Action oncheck Command
Check reserve pages oncheck -cr
Check extents oncheck -ce
Check system catalog tables oncheck -cc database_name
Check data oncheck -cD database_name
Check indexes oncheck -cI database_name

For information on oncheck, see the IBM Informix: Dynamic Server Administrator's Guide.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]