Relocate DB2 databases

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank - 14 Mar 2006 15:55 GMT

Hi,

I have two databases in DB2 v8.2 (Windows 2003 Server platform) and right
now both databases are on my c-drive.

Unfortunately space on this drive is becoming low and I want to relocate the
databases to my d-drive.

You can change properties of an instance (default database path), but this
applies to new databases.

Can somebody explain to me in detail how to get my databases and logging
files to the d-drive (same db2 folder) please? I am trying to find this info
all over the place, but I cannot find the exact info.

Already I tried to uncatalog one of the databases, copied folder c:\db2 and
its subfolders to the d-drive, but when I issue the command catalog database
X on d: I get an error that there was no informatie or something in the
config file and I cannot get the database back online.

Your help is very much appreciated.

Kind regards,

Frank

PS I know in MS SQL server you just have to detach the database, move the
files (data and log) to the new location and then attach the database, but
it seems DB2 is very different.

Reply to this Message

Ian - 14 Mar 2006 16:29 GMT

> Can somebody explain to me in detail how to get my databases and logging
> files to the d-drive (same db2 folder) please? I am trying to find this info
> all over the place, but I cannot find the exact info.

There are two ways to do it in DB2:

1) backup database and use a redirected restore to tell DB2 to restore
the data on the D: drive

http://publib.boulder.ibm.com/infocenter/db2luw/v8//topic/com.ibm.db2.udb.doc/ad
min/c0006249.htm

2) Use the db2relocatedb command after moving the files manually.

http://publib.boulder.ibm.com/infocenter/db2luw/v8//topic/com.ibm.db2.udb.doc/co
re/r0004500.htm

Note, to move your logfiles, you need to set the NEWLOGPATH database
config parameter. The next time DB2 starts, it will use the new path
for your log files.

Reply to this Message

Dave Hughes - 14 Mar 2006 16:31 GMT

> Hi,
>
[quoted text clipped - 16 lines]
> informatie or something in the config file and I cannot get the
> database back online.

Generally speaking, I get the impression DB2 considers its database
files sacrosanct (it doesn't appreciate the files being tampered with
by anything other than its own tools :-)

I'm really not sure about this, but it's probably worth a shot:

1. Take a back up of the database (BACKUP DB dbname)
2. Drop the database (DROP DB dbname)
3. Create a new database (with the same name as the old one) on your D:
drive (CREATE DB dbname ... ON D ...)
4. Restore the backup into the new database (RESTORE DB dbname ... INTO
...)

HTH,

Dave.

Reply to this Message

Gert van der Kooij - 14 Mar 2006 17:40 GMT

> Hi,
>
[quoted text clipped - 3 lines]
> Unfortunately space on this drive is becoming low and I want to relocate the
> databases to my d-drive.

You can backup the database, drop it and restore it on the new drive
with the command:
db2 "restore <dbname> to 'd:\'"

This is the easiest way if your db isn't very large, otherwise it's
better to use the db2relocatedb. Check the online documentation at
http://tinyurl.com/mmgvt

Reply to this Message