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

DPF related info

P: n/a
VMK
Guys,
Couple of days ago when I asked to attend db2 session, there instructor
told me a different thing, I just want to confirm that is true or not.

Here we go...

In DPF if we configure a tablespace(4K Page size) across multiple
partitions, each partition supports 64GB(Max). This is what he said, is
this right or wrong???

Lets say ... if we configure 4KB page size across 4 partitions. i.e.,
4partitions * 64GB(Max) = 256GB
So a Tablespace(4kb page size) can support 256GB here depending upon
partitions, is it true???

Practically to test it, I do not have much space, Please do comment on
this.

Regards
VMK

Oct 2 '06 #1
Share this Question
Share on Google+
3 Replies


P: n/a
It is unclear as to exactly what you are asking for ... "each partition
supports 64GB(Max)". 64GB(Max) what? Table size? Tablespace size?
Database Size?

For tablespaces (since you mention that), in V8, max tablespace size for
4K pages was 64GB, but if you increase pagesize to 32K, you can get
512GB tablespace. In V9, max tablespace size for DMS tablespace for 4K
pages is 2048GB and for 32K pages is 16384GB.

Larry Edelstein

VMK wrote:
Guys,
Couple of days ago when I asked to attend db2 session, there instructor
told me a different thing, I just want to confirm that is true or not.

Here we go...

In DPF if we configure a tablespace(4K Page size) across multiple
partitions, each partition supports 64GB(Max). This is what he said, is
this right or wrong???

Lets say ... if we configure 4KB page size across 4 partitions. i.e.,
4partitions * 64GB(Max) = 256GB
So a Tablespace(4kb page size) can support 256GB here depending upon
partitions, is it true???

Practically to test it, I do not have much space, Please do comment on
this.

Regards
VMK
Oct 2 '06 #2

P: n/a
"VMK" <vm*****@gmail.comwrote in message
news:11**********************@h48g2000cwc.googlegr oups.com...
Guys,
Couple of days ago when I asked to attend db2 session, there instructor
told me a different thing, I just want to confirm that is true or not.

Here we go...

In DPF if we configure a tablespace(4K Page size) across multiple
partitions, each partition supports 64GB(Max). This is what he said, is
this right or wrong???

Lets say ... if we configure 4KB page size across 4 partitions. i.e.,
4partitions * 64GB(Max) = 256GB
So a Tablespace(4kb page size) can support 256GB here depending upon
partitions, is it true???

Practically to test it, I do not have much space, Please do comment on
this.
Regards
VMK
Each partition has its own tablespace, so if you have 4 partitions using a
4K page size, then the table can be up to 256GB in size (assuming even
distribution of data).

If you have a data warehouse, and are expecting a lot of table scans in the
queries that will access the data, then you might want to consider a larger
page size. However if you row size is too small, then a larger page size
might waste a lot of space because of the 255 rows per page limit.

Oct 2 '06 #3

P: n/a
VMK
--- Larry

Am talking about tablespace size...
--- Mark

Thank you. Got it now.

Oct 2 '06 #4

This discussion thread is closed

Replies have been disabled for this discussion.