473,376 Members | 1,030 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,376 software developers and data experts.

Maximum number of STRIPE SETS in a Tablespace

I have an OLTP database that has a tablespace that will start out at about 1
TB, but may grow to 75 TB's in size over the next 5 years. When I add new
containers (on a new mount point), I want to use the BEGIN NEW STRIPE SET
command to avoid rebalancing.

Anyone know the maximum number of STRIPE SET's that can be created for a
tablespace.
Aug 6 '08 #1
5 4127
"Mark A" <no****@nowhere.comwrote in message
news:YR*****************@bignews8.bellsouth.net...
>I have an OLTP database that has a tablespace that will start out at about
1 TB, but may grow to 75 TB's in size over the next 5 years. When I add new
containers (on a new mount point), I want to use the BEGIN NEW STRIPE SET
command to avoid rebalancing.

Anyone know the maximum number of STRIPE SET's that can be created for a
tablespace.
Correction:

The maximum size of a large tablespace is 16 TB's, so even though my
database will grow to 75 TB's, I will be using multiple tablespaces to stay
under the 16 TB limit. But I still need to add a lot of STRIPE SETs over
time, and need to know the maximum number per tablespace.
Aug 6 '08 #2
On 8月6日, 下午10时56分, "Mark A" <nob...@nowhere.comwrote:
"Mark A" <nob...@nowhere.comwrote in message

news:YR*****************@bignews8.bellsouth.net...
I have an OLTP database that has a tablespace that will start out at about
1 TB, but may grow to 75 TB's in size over the next 5 years. When I add new
containers (on a new mount point), I want to use the BEGIN NEW STRIPE SET
command to avoid rebalancing.
Anyone know the maximum number of STRIPE SET's that can be created for a
tablespace.

Correction:

The maximum size of a large tablespace is 16 TB's, so even though my
database will grow to 75 TB's, I will be using multiple tablespaces to stay
under the 16 TB limit. But I still need to add a lot of STRIPE SETs over
time, and need to know the maximum number per tablespace.
OH,db2 has this limited?
How can we break it?
add another tablespace?
Aug 9 '08 #3
>"Ajean" <je*********@gmail.comwrote in message
>news:eb2c1b24-16d7-4f4c-b4cd->9f**********@z6g2000pre.googlegroups.com...
OH,db2 has this limited?
How can we break it?
add another tablespace?
I need to know how many time I can extend a tablespace by adding new
containers in a new stripe set to avoid rebalancing. I don't care about the
maximum tablespace size of 16TB, it is not relevant to my question.
Aug 9 '08 #4
On Aug 8, 10:47 pm, "Mark A" <nob...@nowhere.comwrote:
"Ajean" <jean.luc...@gmail.comwrote in message
news:eb2c1b24-16d7-4f4c-b4cd->9f8507af7__BEGIN_MASK_n#9g02mG7!__...__********** ************@z6g2000pre.googlegroups.com...
OH,db2 has this limited?
How can we break it?
add another tablespace?

I need to know how many time I can extend a tablespace by adding new
containers in a new stripe set to avoid rebalancing. I don't care about the
maximum tablespace size of 16TB, it is not relevant to my question.
Hi Mark,

There is in fact a limit but it is not a specific number of stripe
sets. The limit is on the size of the tablespace's map (which is
limited to about 44K in V9.1 and later). This map is made up of one
or more ranges (you can see this as part of a tablespace snapshot) and
generally you have one range per stripe set (if all of the containers
within a stripe set are the same size then there is only range; you
get more ranges if the containers have different sizes -- which is not
recommended).

The size of each individual range in a tablespace (and this is where
the 'it depends' part comes in) is based on the maximum number of
containers in any of the stripe sets in the tablespace (as an aside,
if you're creating multiple stripe sets then ideally you will have the
same number of containers in each stripe set, so as to give you
consistent striping across the tablespace).

I won't get into the specifics of the formula here but let's consider
an example where you have 4 containers per stripe set. In that case,
you'll be able to fit about 750 ranges (stripe sets, assuming one
range per stripe set) in the tablespace. If you have a specific
configuration in mind then let me know.

Hope that helps.

Kelly Schlamb
Aug 13 '08 #5
<ks******@ca.ibm.comwrote in message
news:41**********************************@25g2000h sx.googlegroups.com...
Hi Mark,

There is in fact a limit but it is not a specific number of stripe
sets. The limit is on the size of the tablespace's map (which is
limited to about 44K in V9.1 and later). This map is made up of one
or more ranges (you can see this as part of a tablespace snapshot) and
generally you have one range per stripe set (if all of the containers
within a stripe set are the same size then there is only range; you
get more ranges if the containers have different sizes -- which is not
recommended).

The size of each individual range in a tablespace (and this is where
the 'it depends' part comes in) is based on the maximum number of
containers in any of the stripe sets in the tablespace (as an aside,
if you're creating multiple stripe sets then ideally you will have the
same number of containers in each stripe set, so as to give you
consistent striping across the tablespace).

I won't get into the specifics of the formula here but let's consider
an example where you have 4 containers per stripe set. In that case,
you'll be able to fit about 750 ranges (stripe sets, assuming one
range per stripe set) in the tablespace. If you have a specific
configuration in mind then let me know.

Hope that helps.

Kelly Schlamb
Thanks.
Aug 13 '08 #6

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Bob Parnes | last post by:
In its default configuration, my version of pylint (0.5.0) sets the maximum number of class attributes at 7. This seems low to me, but I can see how an excessive number might make maintenance more...
1
by: Kevin McDaniel | last post by:
I was wondering if anyone has heard of problems with the Export utility writing dump files on stripe-sets. I'm not sure if the stripe-set is configured correctly or not, but everytime I place my...
1
by: valexena | last post by:
Which clause in a create user statement restricts the number of tables a user can add to a tablespace? -- Posted via http://dbforums.com
2
by: xixi | last post by:
hi, i would like to choose dms type tablespace for the user data , the server is db2 udb v8.1 on windows 64 bit, the volume created is use stripe type, so it will cross the data on two different...
2
by: Kums | last post by:
What is the maximum permissible size of a database? Is there any limitation. What is the maximum # of tablespace's allowed in a database? Thanks for your response.
2
by: p175 | last post by:
Hi folks, I've tried reading just about every post I can on raid stiping / extent size etc and I'm just getting myself more confused than ever. Here's my situation. On a Windows Server 2000...
2
by: ari | last post by:
Hi! Normally Google helps a lot with these simple questions, but now I cannot get correct search words. So I try here: I have db2 udb 8.1 fix pack 6, and it is on windows 2003 server. -...
6
by: =?Utf-8?B?U2hhcm9u?= | last post by:
I'm using the VScrollBar and set it as follow: m_vScrollBar.Minimum = -19602; m_vScrollBar.Maximum = 0; m_vScrollBar.SmallChange = 1; m_vScrollBar.LargeChange = 1089; m_vScrollBar.Value =...
2
by: Woody Ling | last post by:
I am now using db2 v8.2 64bits without DPF. I want to create a very large table which is about 1000G and the record length is suitable for 32K page size. I find in the manual that the maximum size...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.