Learnings

Wednesday, February 27, 2008

DB2 Deep Compression

Excellent article explaining deep compression in depth for DB2. Looks like this can be a really powerful feature provided one understands how space is used and how it can be reclaimed.
Also, one interesting point that was mentioned in it was that, in DB2, the page number that is used as part of the RID of a row is a tablespace-relative page number and not a table-relative page number. Does this have a bearing on why LOADing into a table locks the whole tablespace? Will take it up as separate topic...

0 Comments:

Post a Comment

<< Home