468,135 Members | 1,467 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,135 developers. It's quick & easy.

Multiple Tablespaces

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
Nov 12 '05 #1
1 1582
"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.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by CK | last post: by
8 posts views Thread by Joachim Mueller | last post: by
reply views Thread by sethwai | last post: by
10 posts views Thread by rAinDeEr | last post: by
3 posts views Thread by dcruncher4 | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.