Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012

    Unanswered: DB2 Automatic storage issue.

    I have a db running on 9.5 linux server.

    The issue we are have is that the default Table spaces created by the DB are places in the /home dir.

    Is there anyway to shift them to the other directory. These tablespaces are using automatic storage. the tablespaces are


    also can I just drop the tempspace 1 table space and create it somewhere else... without effecting the db??

  2. #2
    Join Date
    Jun 2003
    Toronto, Canada
    Provided Answers: 1
    Quote Originally Posted by junaid377 View Post
    Is there anyway to shift them to the other directory.
    Consider a redirected restore or use the db2relocatedb utility.

  3. #3
    Join Date
    Jan 2009
    you can add another storage path. drop this storage path and do a rebalance of all the tablespaces. Temp tablespaces you can create it again in the new path and drop the old one. The drop storage path command does not drop it until all the user tablespaces are removed from that tablespace. After drop storage path do a rebalance and that path is removed after that.or simpler soln is redirected restore.
    Last edited by sharaths_81; 04-16-12 at 05:10. Reason: for more information

Posting Permissions

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