excitable
asked on
DB2 V9.1 Backup tablespace and restore to different tablespace with lower page size.
I have a db2 aix tablespace in which the tables requiired no more then 4k page size. Is it possible to create new tablespace(4k) / backup the 16k and then restore to the new tablespace?? Is there a implied constraint in the process.
Thanks.
Thanks.
ASKER
Sorry for being unclear. I have a 16k page size tablespace that I want converted to a 4k page size. I am getting a huge amount of logical i/o and bufferpool thrashing. None of the tables maxlength exceed 4k. Can I do what I want with a tablespace restore or do I have to do a database redirected restore? I guess another way to say this is there an 'into' clause for tablespace restores??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you for the help.
I'm not sure where the '16k' figure came. Is that the page size in the original table?
As long as the container (tablespace) doesn't change, you can always back up a DB2 database on a server and restore it (as is) to a similar server. (You can't restore a windows backup to Z/OS, etc.)
If the underlying container is going to change (e.g. you're going to change the page size) you need to be a bit more creatiive. DB2 will have to build the tables, not just restore them.
I'm curious about the decrease in page size. If the database does a LOT of random I/O, the smaller page size could get you better performance. But in my experience, the larger page size is almost always a winner.
Good Luck,
Kent