Multiple DB2 versions on AIX

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Nic

    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

  • Mark A

    #2
    Re: Multiple DB2 versions on AIX

    "Nic" <nico_paganini@ hotmail.com> wrote in message
    news:1110970617 .738736.78030@l 41g2000cwc.goog legroups.com...[color=blue]
    > 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
    >[/color]
    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.


    Comment

    • Nic

      #3
      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.

      Comment

      • Mark A

        #4
        Re: Multiple DB2 versions on AIX

        "Nic" <nico_paganini@ hotmail.com> wrote in message
        news:1110986078 .471235.12490@z 14g2000cwz.goog legroups.com...[color=blue]
        > 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.
        >[/color]
        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.

        ..


        Comment

        • Nic

          #5
          Re: Multiple DB2 versions on AIX

          Many thanks for the reply - very useful!

          Comment

          Working...