469,578 Members | 1,705 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Tablespace containers question?


Folks,

I have questions about using multiple containers in a table space.

Currently we are using JBODS (Just Bunch Of DiskS) for table spaces on the
DB2 server. I have setup table spaces spread across multiple disks for
performance. When we move to a SAN or RAID array should I still setup
multiple LVs and use them as containers or just one container will give me
same performance?

Thanks.

--
Hemant Shah /"\ ASCII ribbon campaign
E-mail: No************@xnet.com \ / ---------------------
X against HTML mail
TO REPLY, REMOVE NoJunkMail / \ and postings
FROM MY E-MAIL ADDRESS.
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind, Above opinions are mine only.
it's backed up on tape somewhere. Others can have their own.
Jun 29 '06 #1
2 1354
Various docs and publications recommend 1 container per array for RAID
and/or SAN.
Remeber to set the DB2_PARALLEL_IO registry variable and ensure that extents
can fit in stripe size.
E.G.: tblsp page 4k, extent 8 then the stripe size should be 32k or 64k.
Conversely if your sys admins have already set the stripe size then fit the
extents in it.
HTH, Pierre.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Hemant Shah" <sh**@typhoon.xnet.com> a écrit dans le message de news:
e8**********@new7.xnet.com...

Folks,

I have questions about using multiple containers in a table space.

Currently we are using JBODS (Just Bunch Of DiskS) for table spaces on the
DB2 server. I have setup table spaces spread across multiple disks for
performance. When we move to a SAN or RAID array should I still setup
multiple LVs and use them as containers or just one container will give me
same performance?

Thanks.

--
Hemant Shah /"\ ASCII ribbon campaign
E-mail: No************@xnet.com \ / ---------------------
X against HTML mail
TO REPLY, REMOVE NoJunkMail / \ and postings
FROM MY E-MAIL ADDRESS.
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind, Above opinions are mine only.
it's backed up on tape somewhere. Others can have their own.


Jun 30 '06 #2
While stranded on information super highway Pierre Saint-Jacques wrote:
Various docs and publications recommend 1 container per array for RAID
and/or SAN.
Remeber to set the DB2_PARALLEL_IO registry variable and ensure that extents
can fit in stripe size.
E.G.: tblsp page 4k, extent 8 then the stripe size should be 32k or 64k.
Conversely if your sys admins have already set the stripe size then fit the
extents in it.
HTH, Pierre.

Thanks for the info.

--
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
"Hemant Shah" <sh**@typhoon.xnet.com> a écrit dans le message de news:
e8**********@new7.xnet.com...

Folks,

I have questions about using multiple containers in a table space.

Currently we are using JBODS (Just Bunch Of DiskS) for table spaces on the
DB2 server. I have setup table spaces spread across multiple disks for
performance. When we move to a SAN or RAID array should I still setup
multiple LVs and use them as containers or just one container will give me
same performance?

Thanks.

--
Hemant Shah /"\ ASCII ribbon campaign
E-mail: No************@xnet.com \ / ---------------------
X against HTML mail
TO REPLY, REMOVE NoJunkMail / \ and postings
FROM MY E-MAIL ADDRESS.
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind, Above opinions are mine only.
it's backed up on tape somewhere. Others can have their own.


--
Hemant Shah /"\ ASCII ribbon campaign
E-mail: No************@xnet.com \ / ---------------------
X against HTML mail
TO REPLY, REMOVE NoJunkMail / \ and postings
FROM MY E-MAIL ADDRESS.
-----------------[DO NOT SEND UNSOLICITED BULK E-MAIL]------------------
I haven't lost my mind, Above opinions are mine only.
it's backed up on tape somewhere. Others can have their own.
Jun 30 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Ulrich Sprick | last post: by
1 post views Thread by Eugene | last post: by
2 posts views Thread by maricel | last post: by
4 posts views Thread by duoduo | last post: by
4 posts views Thread by mairhtin o'feannag | last post: by
7 posts views Thread by CCC via DBMonster.com | last post: by
2 posts views Thread by db2dude | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.