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
Jean-Marc Blaise wrote:
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