Results 1 to 4 of 4

Thread: Move a DB

  1. #1
    Join Date
    Feb 2006
    Posts
    13

    Unanswered: Move a DB

    I have a 1.6gb database on my 'D' drive and wish to move it to the 'C' drive.

    What is the best way of moving it so that it does not disrupt db2? Please be as detailed as possible.

    Thanks in advance

  2. #2
    Join Date
    Jan 2003
    Posts
    1,605
    Hi,
    I think it is the only way to backup, drop and restore database at new location.
    Hope this helps,
    Grofaty

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    You could use either backup/restore, as Grofaty has mentioned, or the db2relocatedb command.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433
    db2relocatedb is what u need

    check out the whole article on it
    http://www-128.ibm.com/developerwork...amb/index.html

    Rahul Singh

Posting Permissions

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