var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Query on Tablespace
Hi have a test database for which i have the tablespace under more than 1 folder /directory
TBS 1 -- /home/db2inst1/node22/tbdkdl.....
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 ...
on a redirected restore you could change the Tablespace-Container files.
thanks nvk !
how do i go with re-directed restore, info any docs available pl. share
will it work incase of a relocatedb ?
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.