468,257 Members | 1,480 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,257 developers. It's quick & easy.

rid

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
2 4644
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

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

Similar topics

3 posts views Thread by William C. White | last post: by
2 posts views Thread by Albert Ahtenberg | last post: by
3 posts views Thread by James | last post: by
reply views Thread by Ollivier Robert | last post: by
1 post views Thread by Richard Galli | last post: by
4 posts views Thread by Albert Ahtenberg | last post: by
1 post views Thread by inderjit S Gabrie | last post: by
2 posts views Thread by Jack | last post: by
3 posts views Thread by Sandwick | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.