Multiple Tablespaces

[Christos Kalantzis]

Hi Everyone,

I have a question about tablespaces....

Does having Multiple tablespaces (ie..one for indexes, one for large
tables and one for smaller tables) realy help out performance
considering my containers are all on the same disks?

Does the performance out-weigh the complexity of the design/maintenace
of the database?

DB2 8.2 Express
Suse Linux 9.2
Dual CPU
4GB RAM
Thanks a lot,
Christos

[Mark A]

"Christos Kalantzis" <ch*******@intertrade.com> wrote in message
news:VHOGd.106385$dv1.30541@edtnps89...

Hi Everyone,

I have a question about tablespaces....

Does having Multiple tablespaces (ie..one for indexes, one for large
tables and one for smaller tables) realy help out performance
considering my containers are all on the same disks?

Does the performance out-weigh the complexity of the design/maintenace
of the database?

DB2 8.2 Express
Suse Linux 9.2
Dual CPU
4GB RAM
Thanks a lot,
Christos

It might help a little to have indexes on a different tablespace than the
table. Disk drives do have more than one platter/read-write head. A lot
depends on your bufferpool hit ratio (usually a function of the bufferpool
size). If you aren't doing much synchronous I/O, then tablespace
configuration tuning is vastly over-rated.