Followng Error is reported afte making recommanded changes.
Its seems that db2 goes to move all database talespace to newstorae path. while my requirment is to move specific tablespace on new storage path, please advise.
A bit change in my tesing, now i am using a new UAT server for this activity. following i have also attached new configration file.
$ db2relocatedb -f relocatedb.cfg
DBT1006N The file/device "/test/FUNTST/db2inst1/NODE0000/FUNTST/T0000000/C0000000.CAT" could not be opened.
it seems that your tablespace uses automatic storage.
You can check it by this query:
select TBSP_USING_AUTO_STORAGE from sysibmadm.snaptbsp where tbsp_id=5
If so, you are not able to relocate this particular tablespace apart from other automatic storage tablespaces.
If you want to relocate just this tablespace, don't use db2relocatedb.
Just move all containers manually from:
and create a symlink:
I have checked the provided query on all tablespaces its values shows "1" that mean Automatic Storage is enable against them.
The symbolic link is a good solution for temporary basis, is their any other way can i fix the solution on perminent basis because i am now going to deploy my database on production.
I have also read alternate solution for it i.e. is Restore redirect. but unfortunatly it was not working. If you steps about it please post.
The symbolic link is a good solution for temporary basis, is their any other way can i fix the solution on perminent basis
Farhan, another way is much more complex.
If you want to have freedom to relocate the containers of a tablespace, you have to have it not using automatic storage.
There is no easy way to convert an automatic storage tablespace to nonautomatic. You have to create a new tablespace, recreate and reload all your tables from the old one to achieve the goal. Manually or "semi-manually" using the ADMIN_MOVE_TABLE procedure.