[db2 9.1 on SunOS.]
Hello,

I am trying to rename the db; also i want to change its location to different directory structure.

I am using "db2relocatedb" to do this & getting "<dir> could not be open" error.
See the steps which i followed:

1) made relo.cfg file with following containts:

DB_NAME=NEWDB,RELOC_DB
DB_PATH=/export/home/db2inst1/,/export/home/db2inst1/Relocated
INSTANCE=db2inst1,db2inst1

2) executed d cmd:

db2relocatedb -f relo.cfg

After this it throws following error:

DBT1006N The file/device "/export/home/db2inst1/Relocated/db2inst1/NODE0000/sqldbdir/sqldbdir" could not be opened.


I tried with creating this directory structure, still problem persist.

Even, i tried on WINDOWS m/c, here also it is giving the same message!!

I used reloc.cfg as follow on WINDOWS

DB_NAME=good,bad
DB_PATH=D:\,C:\
INSTANCE=db2,db2


Please suggest where i am going wrong?

have you tried to do a simple restore with redirect
set container path
restore continue
see infodoc for details on redirected restore

i have used relocatedb many times to change name but same dbpath and it works fine in that case.
maybe this could be the reason bugging u
http://www.mydatabasesupport.com/for...b-trouble.html

Yes, i got it.

I am able to successfully change db name & its path.

Thanks for help.