Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    63

    Unanswered: tablespace location

    Is there a way to move tablespace location from one directory to another without having to drop and recreate the tables on it.

    Thanks,
    toby

  2. #2
    Join Date
    Sep 2003
    Posts
    237
    Would a UNIX Link( linking current directory or file, to intended destnation) work in your case?
    mota

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: tablespace location

    db2relocatedb command should do the job for you , on LUW platforms



    HTH

    Sathyaram



    Originally posted by toby25
    Is there a way to move tablespace location from one directory to another without having to drop and recreate the tables on it.

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

Posting Permissions

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