Tablespace containers question?

[Hemant Shah]

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.

[Pierre Saint-Jacques]

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.

[Hemant Shah]

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.