Damage tolerance

 

DB2^® UDB for iSeries™ provides several mechanisms to reduce or eliminate damage caused by disk errors.

For example, mirroring, checksums, and RAID disks can all reduce the possibility of disk problems. The DB2 UDB for iSeries 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.

In the event that a disk error has damaged a small portion of the rows in a table, the DB2 UDB for iSeries database manager allows you to read rows still accessible.

 

Parent topic:

Data integrity