470,848 Members | 1,830 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

one performance question...

HI,

I have an performance questions...
is # of tables in one tablespaces matter for performance point of view?

why?
if yes, how many tables in one tablespace is good ?

Thanks for any suggestions?

Nov 12 '05 #1
3 1356
"jane" <es**********@yahoo.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...
HI,

I have an performance questions...
is # of tables in one tablespaces matter for performance point of view?

why?
if yes, how many tables in one tablespace is good ?

Thanks for any suggestions?

There is a big difference on this subject when comparing DB2 for z/OS and
DB2 for Linux, UNIX, and Windows. On the later, it does not matter and is
basically a matter of administrative ease.
Nov 12 '05 #2
Mark A wrote:
"jane" <es**********@yahoo.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...
HI,

I have an performance questions...
is # of tables in one tablespaces matter for performance point of view?

why?
if yes, how many tables in one tablespace is good ?

Thanks for any suggestions?


There is a big difference on this subject when comparing DB2 for z/OS and
DB2 for Linux, UNIX, and Windows. On the later, it does not matter and is
basically a matter of administrative ease.

I usually put small tables together in SMS tablespaces.
Large and heavily used tables I put in separate tablespaces.
One disadvantage of having multiple tables in a tablespace is that if
for some reason the tablespace goes offline, during LOAD for instance,
tables in that tablespace are not available.

--
Anton Versteeg
IBM Netherlands
Nov 12 '05 #3
Thanks all for the info.

My case is I already have 200 tables in one tablespace, I need to
create another 70 tables, they are fact tables.. So I'm considering if
I need to create a separate tablespace or put in the exiting one...

My environment is UDB on AIX.

I'm more concern about read/write performance impact?

Is there any I/O impact about this?

( from OS point of view)?

any suggestion is appreciated.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

115 posts views Thread by Mark Shelor | last post: by
4 posts views Thread by Martin | last post: by
13 posts views Thread by bjarne | last post: by
6 posts views Thread by Mike | last post: by
18 posts views Thread by Rune B | last post: by
5 posts views Thread by Varangian | last post: by
30 posts views Thread by galiorenye | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.