470,594 Members | 1,131 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

How to make tables use another tablespace in DB2?

4
I have database with lot of tables (db was not created by mine and pagesize in used tablespace was set to 4K). When adding some tables, I've revealed, that pagesize is too few, because I need rows more than 4005bytes long. So i've created a new buffer with 32K pages, new tablespace, using this buffer... But I can't see how to make all my tables use this new tablespace - it's not editable anywhere!!!

How to make tables use alternative tablespace with minimal steps? I'm new in DB2 and I got few time... :(

P.S. Database version is 9.1.0.356.
Nov 28 '06 #1
2 1728
Navik
4
To cut it short - I've created new db with 32K pages, generated DDL for all tables from old db and run it at new db. Straightforward primitive approach, but it works...
Nov 28 '06 #2
r035198x
13,262 8TB
To cut it short - I've created new db with 32K pages, generated DDL for all tables from old db and run it at new db. Straightforward primitive approach, but it works...
However consider making tablespaces of sizes 4, 8, 16, and 32. If a table can fit into a 8k space, there is no point in putting it into a 32k space.
Dec 1 '06 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by MaRCeLO PeReiRA | last post: by
7 posts views Thread by Ross Mallett | last post: by
2 posts views Thread by db2dude | last post: by
5 posts views Thread by Troels Arvin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.