Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / July 2006

Tip: Looking for answers? Try searching our database.

Question about tablespace and container design

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Michel Esber - 25 Jul 2006 14:54 GMT
Hello,

LUW V8 FP 11 running Linux RH AS4 Update 3.

In regards to performance and IO parallelism, does it matter if I
create a tablespace with a single big container, or is it better to
create it with several smaller containers ?

Any ideas and links to the proper documentation is greatly appreciated.

Thanks in advance.
Ian - 25 Jul 2006 15:40 GMT
> Hello,
>
[quoted text clipped - 5 lines]
>
> Any ideas and links to the proper documentation is greatly appreciated.

There isn't a lot of generic documentation on this - most
recommendations are specific to the type of storage your system is
using.

However:  I generally prefer to have 1 container per physical storage
device (individual disk or RAID array), using DB2_PARALLEL_IO when
appropriate.

With large RAID arrays and SAN storage, you do have to be careful
because you may have multiple LUNs that reside on the same RAID array.
Putting 1 container/LUN when you have multiple LUNs from a single
RAID array can create I/O contention issues.
Phil Sherman - 25 Jul 2006 16:13 GMT
From a performance and parallelism viewpoint, multiple containers can
be of benefit if each container is located on a separate disk drive.
This allows parallel I/O when doing scans.

If you place two containers on a single disk drive, then, as data is
read from each container, a seek operation will be needed. Seeks are a
relatively slow operation and should be avoided as much as possible when
doing scans. When containers are located on separate disks, we expect to
read data from each disk drive in turn. If the system has the capacity
to do this concurrently from multiple drives, then the overall transfer
rate can be significantly improved.

Large raid5 disk subsystems, while using multiple disk drives, appear to
the operating system as a single disk. Placing multiple containers on
these doesn't provide the same benefits as separate disk drives will.
Raid5 can, with judicious matching of prefetch parameters to the
physical characteristics of the raid array, provide scan performance
enhancements similar to using multiple containers on different physical
disk drives.

Suggested reading:
Administration Guide: Planning  - Chapter 5

Phil Sherman

> Hello,
>
[quoted text clipped - 7 lines]
>
> Thanks in advance.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.