Hello,

Does DB2 keep checksums of data, such as data page checksums, extent
checksums, etc? - Or is it solely up to the file system or storage
hardware to maintain such physical integrity structures?

--
Troels

On May 5, 3:26*am, Troels Arvin <tro... (AT) arvin (DOT) dk> wrote:
DB2 stores checksums in the pages and an admin can check in advance
before a user encounters an error whether the data pages are OK. See
here for more information:

Comparison of INSPECT and DART
http://publib.boulder.ibm.com/infoce.../c0020763.html

Henrik

Yes. Each page has a checksum that is generated before the write and
checked and recalculated at page read time so that DB2 can ensure no
corruption has happened.
The following explains it:
http://www-01.ibm.com/support/docvie...id=swg21215588

Goog luck, Pierre.




On May 5, 3:26*am, Troels Arvin <tro... (AT) arvin (DOT) dk> wrote: