Hi Folks,

OS is AIX 5.3 and DB2 v8.1 FP 7

We use to use Lawson finance module and the backend database is DB2 for that. The data is basically Read-only. We need to Move the database from SAN to local Hard disk without changing the names of the file systems. The lawson application breaks if the actual path to data and index changes, so we have to retain the same file system naming conventions but move the data from SAN to local disk.

I know we cannot have 2 file systems with the same name mounted on the server. Would this process work in this situation?

1. Backup the existing database
2. Remove the file systems that are on SAN
3. Recreate the file systems with the same name on local disk
4. Restore the database

Thanks

It sounds like it should work. Make sure you do an offline backup.

Andy

You might want to test it first to make sure that you have the processes down.

Andy

Why not try redirected restore.... works all the time for me
So your list woud be modified to

1. Backup the existing database
2. Redirect Restore the database

Check out the following useful links -
DB2 Basics: Cloning DB2 Databases Using Redirected Restore

DB2 Redirected Restore Scripts

Just one think :

If your database file system reside on it's own AIX volume group, you can try to migrate SAN's hdisk's to local hdisks's with AIX migratepv command when DB2 instance completely stopped
Of course, doing offline backup before.
But this need strong help from your AIX sysadm