If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > DB2 > large unix/linux migration

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-23-09, 21:58
spats spats is offline
Registered User
 
Join Date: Jun 2009
Posts: 2
Question 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.
Reply With Quote
  #2 (permalink)  
Old 06-23-09, 23:06
Stealth_DBA Stealth_DBA is offline
Registered User
 
Join Date: May 2009
Posts: 472
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
Reply With Quote
  #3 (permalink)  
Old 06-23-09, 23:48
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
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.
Reply With Quote
  #4 (permalink)  
Old 06-23-09, 23:58
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,196
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
Reply With Quote
  #5 (permalink)  
Old 06-24-09, 03:00
dr_te_z dr_te_z is offline
Registered User
 
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
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
Reply With Quote
  #6 (permalink)  
Old 06-24-09, 07:54
spats spats is offline
Registered User
 
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..
Reply With Quote
  #7 (permalink)  
Old 06-24-09, 09:21
Cougar8000 Cougar8000 is offline
Registered User
 
Join Date: Nov 2005
Location: IL
Posts: 554
Where are you at so we know not to look there
__________________
--
IBM Certified DBA on DB2 for Linux, UNIX, and Windows

DB2 v9.1.0.2 os 5.3.0.0
Reply With Quote
  #8 (permalink)  
Old 06-24-09, 09:38
dr_te_z dr_te_z is offline
Registered User
 
Join Date: Jan 2009
Location: Zoetermeer, Holland
Posts: 555
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On