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 > DB2 Version migration

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 06-30-10, 11:59
blazer789 blazer789 is offline
Registered User
 
Join Date: Jun 2009
Posts: 221
DB2 Version migration

What is the reason why IBM recommends to take an offline backup and not an online backup when we do version migrations like from V9.1 - V9.5 or V9.5 - V9.7.
Reply With Quote
  #2 (permalink)  
Old 06-30-10, 12:33
dbzTHEdinosaur dbzTHEdinosaur is offline
Registered User
 
Join Date: Jun 2007
Location: germany
Posts: 96
__________________
Dick Brenholtz, Ami in Deutschland

Last edited by dbzTHEdinosaur; 06-30-10 at 12:33. Reason: add additional comment
Reply With Quote
  #3 (permalink)  
Old 06-30-10, 13:18
Marcus_A Marcus_A is offline
Registered User
 
Join Date: May 2003
Location: USA
Posts: 5,198
Restoring an online backup requires rolling forward the logs. Log formats can change from one release to the next.
__________________
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
  #4 (permalink)  
Old 06-30-10, 13:19
blazer789 blazer789 is offline
Registered User
 
Join Date: Jun 2009
Posts: 221
I don't think that correctly answers my question.

Here is my scenario. I am upgrading a database from 9.5 to 9.7 [AIX] . To take a back up of the database, it takes 2 hours. Incase I need to take an offline backup before the upgrade, the outage time increases. The reason why I am thinking of online backup is to skip the extra 2 hour outage window.

Whatever backup we take, if wee need to backout our changes, we need to recreate an instance under db2 V9.5 and restore the database. For this restore, either online or offline backup should work.

I know that we cannot rollfoward 9.5 log files on to 9.7 database but at the same time, we cannot restore 9.5 backup on to 9.7 instance - so what is the point in taking offline backup ?
Reply With Quote
  #5 (permalink)  
Old 06-30-10, 13:26
blazer789 blazer789 is offline
Registered User
 
Join Date: Jun 2009
Posts: 221
Andy, do you mean, we can restore 9.5 database backup on to 9.7 instance?
Reply With Quote
  #6 (permalink)  
Old 06-30-10, 13:45
ARWinner ARWinner is offline
Registered User
 
Join Date: Jan 2003
Posts: 3,575
Quote:
Originally Posted by blazer789 View Post
Andy, do you mean, we can restore 9.5 database backup on to 9.7 instance?
Yes you can. As long as it is an offline backup.

Andy
Reply With Quote
  #7 (permalink)  
Old 06-30-10, 15:15
blazer789 blazer789 is offline
Registered User
 
Join Date: Jun 2009
Posts: 221
Okay. I have an offline backup which was taken a day before. Probably I can take an incremental offline backup te reduce the outage window.
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