Results 1 to 8 of 8
  1. #1
    Join Date
    Jun 2009
    Posts
    2

    Question Unanswered: large unix/linux migration

    have 10+ TB on unix. 100's of tables. migration to new data center on linux. only have 2 days to export, ftp, import and rebuild indexes. looking for suggestions.

  2. #2
    Join Date
    May 2009
    Posts
    508
    Provided Answers: 1
    spats, if the operating systems are compatible, you might be able to backup your database on the Unix system and then restore (probably a redirected restore) on the Linux system.

    Check out this link for information on what systems you can backup/restore between:
    IBM DB2 9.5 Information Center for Linux, UNIX, and Windows

  3. #3
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by spats
    looking for suggestions.
    Update your resume and start looking for a new job. You will probably need twice as much time just to transfer 10 TB of stuff by ftp over a dedicated gigabit ethernet link.
    ---
    "It does not work" is not a valid problem statement.

  4. #4
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Set an HADR pair between the datacenters. Or you can you can use the "poor man's" option, log shipping. Both methods will require that you do a backup and restore, but you will have more than 2 days to do it.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

  5. #5
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Quote Originally Posted by Stealth_DBA
    spats, if the operating systems are compatible
    Not only O.S. Look at the prcocessor architicture, especially the 'endianess'. When that differs you cannot use the backup-image. When you make a backup to convert: make sure it is an OFFLINE backup and do not compress.

    Quote Originally Posted by n_i
    transfer 10 TB of stuff by ftp over a dedicated gigabit ethernet link.
    Yep, it would be nice if both could share a NAS/SAN

  6. #6
    Join Date
    Jun 2009
    Posts
    2
    unfortunately, the new hardware has been ordered. We are currently running Big Endian and going to Little Endian which are not compatable for restores.
    Logging is not an option for our warehouse loads.. too slow...many bulk loads, 2k load jobs a night.
    Maybe I should dust-off the resume.....
    Thanks all..

  7. #7
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Where are you at so we know not to look there
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  8. #8
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746

Posting Permissions

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