db2relocatedb trouble

[Ilja Booij]

Hi all,

I'm having trouble using the db2relocatedb command. I have to move a
database which was created under the db2inst1 user home dir, to a
separate partition. Following the instructions in the DB2 online
manuals, I have come up with the following config file for
db2relocatedb:

DB_NAME=IPI
DB_PATH=/db2home/db2inst1,/database
INSTANCE=db2inst1

When I execute db2relocatedb I get the following message:
[db2inst1@db2 db2inst1]$ db2relocatedb -f relocatedb.cfg
DBT1006N The file/device
"/database/db2inst1/NODE0000/sqldbdir/sqldbdir" could not be opened.

Can anyone tell what I'm doing wrong here?

BTW, I'm running DB2 UDB 8.1 on RedHat Linux 8.0

Thanks,
Ilja Booij
--
IC&S
Stadhouderslaan 57
3583 JD Utrecht

[Bill]

The db2relocatedb command doesn't actually relocate any files or create any
directories. You need to create the database path directories yourself and
move the files over. Then run the db2relocatedb command to tell DB2 what
you did. When you create the directories make sure they are owned by the
instance user and the permissions match the old directory permissions.
"Ilja Booij" <il**@ilja-booijs-computer.local> wrote in message
news:slrnc0kupm.cnv.il**@ilja-booijs-computer.local...

Hi all,

I'm having trouble using the db2relocatedb command. I have to move a
database which was created under the db2inst1 user home dir, to a
separate partition. Following the instructions in the DB2 online
manuals, I have come up with the following config file for
db2relocatedb:

DB_NAME=IPI
DB_PATH=/db2home/db2inst1,/database
INSTANCE=db2inst1

When I execute db2relocatedb I get the following message:
[db2inst1@db2 db2inst1]$ db2relocatedb -f relocatedb.cfg
DBT1006N The file/device
"/database/db2inst1/NODE0000/sqldbdir/sqldbdir" could not be opened.

Can anyone tell what I'm doing wrong here?

BTW, I'm running DB2 UDB 8.1 on RedHat Linux 8.0

Thanks,
Ilja Booij
--
IC&S
Stadhouderslaan 57
3583 JD Utrecht

[Ilja Booij]

Hi,
(inline reply)
In article <wM******************@newssvr16.news.prodigy.com >, Bill wrote:

The db2relocatedb command doesn't actually relocate any files or create any
directories. You need to create the database path directories yourself and
move the files over. Then run the db2relocatedb command to tell DB2 what
you did. When you create the directories make sure they are owned by the
instance user and the permissions match the old directory permissions.

I was under the impression that db2relocatedb would do this for me :)
Your answer clears things up a lot, thanks!

Ilja