Tablespace containers question?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Hemant Shah - 29 Jun 2006 21:38 GMT

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.

Signature

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.

Reply to this Message

Pierre Saint-Jacques - 30 Jun 2006 05:06 GMT

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.

Signature

Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515

>
> Folks,
[quoted text clipped - 8 lines]
>
> Thanks.

Reply to this Message

Hemant Shah - 30 Jun 2006 17:20 GMT

> Various docs and publications recommend 1 container per array for RAID
> and/or SAN.
[quoted text clipped - 4 lines]
> extents in it.
> HTH, Pierre.

Thanks for the info.

>> Folks,
>>
[quoted text clipped - 7 lines]
>>
>> Thanks.

Signature

Reply to this Message