Unix Technical Forum

Multiple DB2 versions on AIX

This is a discussion on Multiple DB2 versions on AIX within the DB2 forums, part of the Database Server Software category; --> I have a requirement to setup DB2 on a 4 node cluster using Veritas (with the DB2 failover agent). ...


Go Back   Unix Technical Forum > Database Server Software > DB2

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 04:11 AM
Nic
 
Posts: n/a
Default Multiple DB2 versions on AIX

I have a requirement to setup DB2 on a 4 node cluster using Veritas
(with the DB2 failover agent).

I may have a requirement to have more than one database running on the
cluster at a different DB2 version (8.1, 8.2) or Fixpak release (8.1
FP5 and 8.1 FP6 and 8.1 FP7 - for example).

Is this possible? I can't see a way to change the default installation
directory for DB2.

Any help much appreciated.

Regards,
Nic

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 04:11 AM
Mark A
 
Posts: n/a
Default Re: Multiple DB2 versions on AIX

"Nic" <nico_paganini@hotmail.com> wrote in message
news:1110970617.738736.78030@l41g2000cwc.googlegro ups.com...
> I have a requirement to setup DB2 on a 4 node cluster using Veritas
> (with the DB2 failover agent).
>
> I may have a requirement to have more than one database running on the
> cluster at a different DB2 version (8.1, 8.2) or Fixpak release (8.1
> FP5 and 8.1 FP6 and 8.1 FP7 - for example).
>
> Is this possible? I can't see a way to change the default installation
> directory for DB2.
>
> Any help much appreciated.
>
> Regards,
> Nic
>

This is no problem. Use the alternate fixpaks. The original code (or latest
code) stays were it is, but the new alternate fixpak code will be installed
on its own directory. Then you create or upgrade the instance for whatever
version you want by running the instance command from the correct directory.


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-27-2008, 04:11 AM
Nic
 
Posts: n/a
Default Re: Multiple DB2 versions on AIX

Thanks. How many alternate FixPak installations can you have per node?
I may have to try to accomodate 2-3 - is this possible?

If 8.1 binaries get installed into default location (db2_08_01), can I
have a FP5, FP6 and FP7 directory structure for example pointing to the
8.1 code?

Thanks.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 02-27-2008, 04:11 AM
Mark A
 
Posts: n/a
Default Re: Multiple DB2 versions on AIX

"Nic" <nico_paganini@hotmail.com> wrote in message
news:1110986078.471235.12490@z14g2000cwz.googlegro ups.com...
> Thanks. How many alternate FixPak installations can you have per node?
> I may have to try to accomodate 2-3 - is this possible?
>
> If 8.1 binaries get installed into default location (db2_08_01), can I
> have a FP5, FP6 and FP7 directory structure for example pointing to the
> 8.1 code?
>
> Thanks.
>

I don't know if there is a limit. I have seen at least 5 different versions
on the same node.

When you install the alternate fixpak, it will automatically install in the
correct (different) directory name. You don't need to do anything to name
the directory path. For example, if you install Alternate FP7, it will
installed at /opt/IBM/db2/V8.FP7

These directories are for Linux. I think AIX installs DB2 in a different
directory than /opt IIRC.

When you update the instance (or create a new instance) with the new fixpak
level, just go to the correct directory level to run db2iupdt
(/opt/IBM/db2/V8.FP7/instance). That will point the instance to the correct
fixpak.

..


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 02-27-2008, 04:12 AM
Nic
 
Posts: n/a
Default Re: Multiple DB2 versions on AIX

Many thanks for the reply - very useful!

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 07:35 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com