containers in the same FS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jean-Marc Blaise - 11 Jan 2006 21:27 GMT

IBM recommends to place each ts container on a different physical disk.

What about the impacts if all containers (DMS) are in the same FS (supported
by multiple disks) ?

Does DB2 preallocate doing // IO, so we could assume to have, for 2
containers as exemple:

Ext1ct1, Ext1ct2, Ext2ct1, Ext2ct2

or will we get ct1 allocated first, then ct2 ?

Thanks for your help,

JM

Reply to this Message

Phil Sherman - 12 Jan 2006 16:34 GMT

The general rule is to divide up data evenly between containers. Using
multiple disks allows parallel I/O to the different containers. When you
have multiple containers on a single disk (or set of disks - I assume
RAID) then the potential performance benefit of multiple containers is
lost.

DMS initially allocates the entire container size which will tie up the
entire space no matter how little data is actually stored.

You can now also add additional containers at a later date if your
initial set fills up. Commands also exist to resize DMS containers.

Phil Sherman

> IBM recommends to place each ts container on a different physical disk.
>
[quoted text clipped - 11 lines]
>
> JM

Reply to this Message