Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197

    Smile 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.....
    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 ...

  2. #2
    Join Date
    Jan 2010
    Posts
    335
    Yes,

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

  3. #3
    Join Date
    Aug 2010
    Location
    Singapore
    Posts
    197
    thanks nvk !

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

    will it work incase of a relocatedb ?

  4. #4
    Join Date
    Jan 2010
    Posts
    335
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •