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: NoJunkMailshah@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.

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" <shah@typhoon.xnet.com> a écrit dans le message de news:
e81dp0$eha$1@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: NoJunkMailshah@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.

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" <shah@typhoon.xnet.com> a écrit dans le message de news:
> e81dp0$eha$1@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: NoJunkMailshah@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: NoJunkMailshah@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.