hello:
in db2 v9,how structure of the rid?
in db2 v9.7,how structure of the rid?
in db2 v9,if the page is 32k,the limit of tablespace is 16T,why in db2 v9.7,is 64T?
thank you!

On 8/18/2010 4:52 AM, ninth wrote:
In 9.7 these two bits have been incorporated into the tablespace size.
Hence the 4 fold increase.

--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

4 bytes for the page number
2 bytes for the slot number

The 2 extra bits were available in the 4 bytes for the page number.

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/