Prev: Yellowfin Launches 5.0
Next: reorg pending table
From: Troels Arvin on 5 May 2010 03:26
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
From: Henrik Loeser on 5 May 2010 04:07
On May 5, 3:26 am, Troels Arvin <tro...(a)arvin.dk> wrote:
> 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

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/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.admin.trb.doc/doc/c0020763.html

Henrik
From: Pierre StJ on 5 May 2010 14:17
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/docview.wss?uid=swg21215588

Goog luck, Pierre.




On May 5, 3:26 am, Troels Arvin <tro...(a)arvin.dk> wrote:
> 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

 | 
Pages: 1
Prev: Yellowfin Launches 5.0
Next: reorg pending table