See if db2relocatedb command helps
Originally posted by Peter SandsPete> Hi,
> One of our development databases have a few tablespaces that are SMS,
> that points to ( /home/dbas/..), I want to change these so they point
> to another filesystem where our DMS tablespaces reside. Can I add
> another SMS to one of these tablesspaces that points to anohter
> filesystem, then delete the other SMS that points to (/home/db2as..).
> OR do I have to do a restore (redirect) to accomplish this.
> aix 5.2
> db2 v 8
DB2 discussion also at [url]http://www.dbforums.com/f8[/url]
Posted via [url]http://dbforums.com[/url]