Use this checklist before you decide if a restore is required:
Has data been lost or corrupted?
Does a committed transaction error need to be undone?
Is the database server down or has a disk failed?
Is a storage space or chunk down or inconsistent?
Review the following files and outputs to obtain information
about your system:
The onstat -d and onstat -l outputs
The database server message log
The ON–Bar activity log
The storage-manager logs
The oncheck output (Dynamic Server) or onutilCHECK output (Extended Parallel Server)
The oncfg files
The physical data layout (disks)
The database schema (dbschema command)
The af* files (assertion failures), if
any
The core dump files, if any
The xcfg file
The ism_chk.pl report
The ism_chk.pl report
is useful when you investigate backup or restore problems. For details,
see the IBM Informix: Storage Manager Administrator's Guide.
Estimate how long the restore will take.
Determine whether a warm or cold restore is needed. If you need
to take the database server offline for the restore, ask your client
users to log off the system.
If you suspect a problem with the storage manager or the XBSA connection, the
operating system, or the storage media, contact your vendor.