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...
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