By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,745 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

rid

P: n/a
hi:
in db2 v9,how long the rid?
how structure of the rid?
in a page,what limit of record?

thank you!
Aug 21 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
ni*****@126.com wrote:
in db2 v9,how long the rid?
how structure of the rid?
in a page,what limit of record?
It depends. If you have a REGULAR tablespace, a RID is 4 bytes only (3
bytes page number and 1 byte slot number). If it is a LARGE tablespace,
you have two bytes more. At least 5 bits are used for the page id because
the tablespace limit grows from .5 TB to 16 TB (from regular to large).

The SQL limits in the manual list the impact that regular/large rids have.

http://publib.boulder.ibm.com/infoce...c/r0001029.htm

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
Aug 21 '07 #2

P: n/a

"Knut Stolze" <st****@de.ibm.com>
??????:5i*************@mid.individual.net...
ni*****@126.com wrote:
> in db2 v9,how long the rid?
how structure of the rid?
in a page,what limit of record?

It depends. If you have a REGULAR tablespace, a RID is 4 bytes only (3
bytes page number and 1 byte slot number). If it is a LARGE tablespace,
you have two bytes more. At least 5 bits are used for the page id because
the tablespace limit grows from .5 TB to 16 TB (from regular to large).

The SQL limits in the manual list the impact that regular/large rids have.

http://publib.boulder.ibm.com/infoce...c/r0001029.htm

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
If it is a LARGE tablespace,you have two bytes more. At least 5 bits are
used for the page id ,how to use the other bits?
Aug 22 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.