Query on Tablespace

alwayssathya · #1 (**permalink**) 03-25-11, 01:11

Hi have a test database for which i have the tablespace under more than 1 folder /directory

TBS 1 -- /home/db2inst1/node22/tbdkdl.....
and
later i started it to grow uner /opt/db2inst1/node22/tbdknk..

So i just have a doubt, when i take a backup and restore the database into other server, is it possible to make the tablespace under single directory which has a huge amount of space ...

nvk@vhv · #2 (**permalink**) 03-25-11, 04:42

Yes,

on a redirected restore you could change the Tablespace-Container files.

alwayssathya · #3 (**permalink**) 03-25-11, 05:42

thanks nvk !

how do i go with re-directed restore, info any docs available pl. share

will it work incase of a relocatedb ?

nvk@vhv · #4 (**permalink**) 03-25-11, 08:30

RESTORE DATABASE - IBM DB2 9.7 for Linux, UNIX, and Windows

restore db <DBNAME> from ... redirect generate script <FILENAME>
Aftwards you can edit the generated Script and adjust the number and location of containers.

Internet Services

Web Development

Digital Marketing

Consumer Tech