By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,668 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.

Extentsize/Containers/Tablespace

P: n/a
I am re-doing a database onto V8.7 on a RAID 5 0 array.

That is, in this wildly-striped system, which I'll never understand,
there is one Container in each Tablespace. Most tablespaces are DMS.

ExtentSize is "the number of pages that will be written to a container
before skipping to the next container."

Does this make sense with a single container in each tablespace? Do I
specify EXTENTSIZE = 1? Does the DMS know what to do no matter what I
enter? Should I leave out that parameter?

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Your extent size should be equal to, or a multiple of your RAID stripe
size.

Remember that extent size is expressed in pages and stripe size is
usually in K, so you will have to do the math. For example, if your
RAID stripe size is 64K, then that would be 16 4K pages (assuming the
tablespace page size is 4K) for extent size (or 32 4K pages if you want
a larger multiple).

Check with your UNIX admin to get the RAID stripe size if you can't
find it.

Nov 12 '05 #2

P: n/a
Stanley Sinclair wrote:
I am re-doing a database onto V8.7 on a RAID 5 0 array.

That is, in this wildly-striped system, which I'll never understand,
there is one Container in each Tablespace. Most tablespaces are DMS.

ExtentSize is "the number of pages that will be written to a container
before skipping to the next container."

Does this make sense with a single container in each tablespace? Do I
specify EXTENTSIZE = 1? Does the DMS know what to do no matter what I
enter? Should I leave out that parameter?

NO RAID5!! NO RAID5!! NO RAID5!! NO RAID5!! NO RAID5!! NO RAID5!!

See the web site www.baarf.com for several papers (yes mine among them)
about why RAID5 and RDBMS should NEVER be mixed! RAID10 all the way.

Art S. Kagel
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.