We used db2relocatedb commands to relocate the files from a directory to another. This is what we did:
1. shutdown instance
2. copy over the files to the new locations
3. run db2relocatedb -f relocate.cfg
4. db2start
db2relocatedb did not give any errors. However, when I do a list tablespace containers or db2 get snapshot for tablesaces show that DB2 is still using files from the old location.
We run DB2 v 8.1 (fixpack 6a) on Windows 2003.
DB2 & UDB email list listserv db2-l LazyDBA home page