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 > Impact of OS upgrade

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 08-24-11, 09:35
db2cap db2cap is offline
Registered User
 
Join Date: May 2010
Posts: 87
Impact of OS upgrade

Hi,
We are in a planning phase of upgrading AIX 5.3 to AIX 6.1 (not installing AIX6.1 from scratch) which has DB2 installed on it. So few questions regarding the same:
1. I know in oracle that we have to relink the oracle binaries after OS upgrade. Is there any similar requirement in DB2 also?
2. Any other precautionary measure to be taken? Please provide your input, like performance degradation on AIX6.1, tuning parameters, etc
3. The same DB2 binaries will work on AIX 6.1 or will I have to reinstall DB2?
Reply With Quote
  #2 (permalink)  
Old 08-24-11, 09:48
n_i n_i is offline
:-)
 
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
As long as your version of DB2 is supported on AIX 6.1, there should be no problem.
Reply With Quote
  #3 (permalink)  
Old 08-24-11, 10:14
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
I recommend to do a db2iupdt after upgrade of the Operating System

-
__________________
Visit the new-look IDUG Website , register to gain access to the excellent content.
Reply With Quote
  #4 (permalink)  
Old 08-25-11, 01:25
db2cap db2cap is offline
Registered User
 
Join Date: May 2010
Posts: 87
Well I have checked the compatibily Matrix and DB2 V9.1 is comaptible with AIX 6.1.

@Sathyaram,
Will db2iupdt help in any way because I understand we use it when we migrate/update DB2. In this case, there is no change in DB2, only the OS will be upgraded.
Can you please share me the link where this is recommended as I am finding nothing on this topic?
Thanks for your response
Reply With Quote
  #5 (permalink)  
Old 08-25-11, 01:55
sathyaram_s sathyaram_s is offline
Super Moderator
 
Join Date: Aug 2001
Location: UK
Posts: 4,534
Honestly, I dont know if db2iupdt is mandatory and have no reference to any documentation. My simple rule of thumb is - any change at the OS level(patch, upgrade, security system update, tsm update etc) , do an db2iupdt.
It doesnt take long and provides a peace of mind that the db2 instance has been revalidated in the new environment.
Reply With Quote
  #6 (permalink)  
Old 08-25-11, 02:13
db2cap db2cap is offline
Registered User
 
Join Date: May 2010
Posts: 87
No Problem sathyaram but the thumb rule makes sense. Thanks
Reply With Quote
  #7 (permalink)  
Old 08-25-11, 11:46
db2girl db2girl is offline
∞∞∞∞∞∞
 
Join Date: Aug 2008
Location: Toronto, Canada
Posts: 1,816
I also suggest db2iupdt after upgrading the OS. It's not required, but if db2start fails following the OS upgrade - execute db2iupdt.This will correct permissions/ownerships on db2 binaries in case they get modified during the upgrade.


Also, check the recommended AIX level here:
https://www-304.ibm.com/support/docv...id=swg21165448
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