6 byte RID in V9
V8 and prior versions of DB2 limited the size of a RID to be 4 bytes.3 bytes for page and 1 byte for slot number.This limitation placed constraints on the tablespace sizes:
Pagesize--------Tablespace size limitation
4k page 64GB
8k page 128GB
16k page 256GB
32k page 512GB
V9 has 6 byte RID which allows for bigger tablespaces.4 bytes for page and 2 bytes for slot number.
Pagesize--------Tablespace size limitation
4k page 2TB
8k page 4TB
16k page 8TB
32k page 16TB
ALTER TABLESPACE TABLESPACENAME CONVERT TO LARGE statement can be used to convert tablespaces after the migratrion.It should be noted that only DMS tablespaces can be large.So,SMS tablespaces can not be large tablespaces even in V9.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment