Move a DB

chemaster · #1 (**permalink**) 01-15-07, 07:18

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

grofaty · #2 (**permalink**) 01-15-07, 07:39

Hi,
I think it is the only way to backup, drop and restore database at new location.
Hope this helps,
Grofaty

n_i · #3 (**permalink**) 01-15-07, 11:10

You could use either backup/restore, as Grofaty has mentioned, or the db2relocatedb command.

rahul_s80 · #4 (**permalink**) 01-16-07, 01:59

db2relocatedb is what u need

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

Rahul Singh

Internet Services

Web Development

Digital Marketing

Consumer Tech