Results 1 to 5 of 5
  1. #1
    Join Date
    Jan 2008
    Posts
    96

    Unanswered: Moving data from SAN to local disk

    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

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    It sounds like it should work. Make sure you do an offline backup.

    Andy

  3. #3
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You might want to test it first to make sure that you have the processes down.

    Andy

  4. #4
    Join Date
    May 2007
    Location
    somewhere in dbforums
    Posts
    221
    Quote Originally Posted by rangupt
    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
    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
    IBM Certified Database Associate, DB2 9 for LUW

  5. #5
    Join Date
    Sep 2007
    Location
    Moscow
    Posts
    41
    Quote Originally Posted by rangupt
    I know we cannot have 2 file systems with the same name mounted on the server. Would this process work in this situation?
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •