Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2012
    Posts
    82

    Unanswered: Moving tempspace to another directory

    I am using db2 9.1 .The tempspace is still in the /home dir

    we are getting a FILESYSTEM Full error.

    when I run a query and I see the filesystem fill up.


    I need to move the tempspace to a large file system like /db which is a different mount


    How can I accomplish this? I am new to db2 and dont know much about tablespaces and how to move them

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Not sure what you mean by tempspace. If you're talking about a system temporary tablespace, the solution is simple: create a new tablespace with the same page size in the desired location, then drop the original tablespace.

Posting Permissions

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