Damage tolerance

The Db2 for i database provides several mechanisms to reduce or eliminate damage caused by disk errors.

For example, mirroring, checksums, and Redundant Array of Independent Disks (RAID) can all reduce the possibility of disk problems. The Db2 for i functions also have a certain amount of tolerance to damage caused by disk errors or system errors.

A DROP operation always succeeds, regardless of the damage. This ensures that should damage occur, at least the table, view, SQL package, index, procedure, function, or distinct type can be deleted and restored or created again.

If a disk error has damaged a small portion of the rows in a table, the Db2 for i database manager allows you to read rows that are still accessible.