Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2007
    Posts
    62

    Unanswered: Move DMS Container from one dir to another ?

    Hi,

    How to move container from one dir to another ?

    thanks
    Vilius

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    DB2RELOCATEDB command. - Refer documentation.

    HTH

    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    ...or perform a redirected restore.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Add containers (large enough to hold everything) on the new location and wait for the "rebalance" to finish. 50% of your data is transferred now.
    Drop the old/original containers. The next rebalance operation will transfer the remaining 50% of your data.
    There is a performance impact, but the database does not have to be brought down.

  5. #5
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    What you can do is:

    1) alter tablespace to add a new container of the same size (specify a different filesystem/directory) and specify "begin new stripe set" so that rebalancing doesn't kick in

    2) alter tablespace to remove the original container


    At the end, all data will be moved from the original container to the new container without rebalancing.

Posting Permissions

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