db2 tablespace size and performance impact

Posted by jrhickey on Server Fault See other posts from Server Fault or by jrhickey
Published on 2010-06-17T16:40:10Z Indexed on 2010/06/17 16:43 UTC
Read the original article Hit count: 134

Filed under:
|

Originally when we began moving to db2 LUW we ran into some issues where our tables were too big to fit into the default 4K table space. As a result of "pressure" to get it done we just went with a 32K default table space and put ALL of our tables there.

What impact would that have if any? I talked to one person who said that it would possible make out database MUCH larger than it needed to be. Is that true? What about memory? Would there be any benefit to moving the smaller tables back to a 4K table space? I have looked around in forums and what not but cannot seem to find a good answer.

© Server Fault or respective owner

Related posts about database-adminstration

Related posts about db2