Topic
  • 12 replies
  • Latest Post - ‏2012-05-29T13:33:30Z by CalvinM
PankajSabharwal
PankajSabharwal
5 Posts

Pinned topic DB2iauto not working as expected for DB2 V9.5 and DB29.7 on RHEL 6.2

‏2012-05-24T16:44:24Z |
We are having 3 instances of DB2 running on RHEL 6.2 machine.
db2inst1 V9.5
db2inst2 V9.7
db2inst3 V9.7

I am trying to enable autostart on all 3 instances after we reboot the complete system but that is not working as expected. I am using db2iauto command to enable restart. After running db2iauto for all 3 instances individually I see that after reboot only db2inst1 is up and other 2 instances were not able to pick up after reboot.
After this I turned OFF db2iauto for db2inst1 and turned ON db2iauto only db2inst2 (V9.7) but still it was not able to pickup after reboot tough db2inst1 was up again.

I have scripts to make autorestart possible from /etc/init.d but would really like db2iauto to work properly.
Updated on 2012-05-29T13:33:30Z at 2012-05-29T13:33:30Z by CalvinM
  • mor
    mor
    520 Posts

    Re: DB2iauto not working as expected for DB2 V9.5 and DB29.7 on RHEL 6.2

    ‏2012-05-24T16:59:41Z  
    When you run db2iauto - are you 'root' ?
    Also, do you use the absolute-pathname to each version's db2iauto executable when you run it?
  • PankajSabharwal
    PankajSabharwal
    5 Posts

    Re: DB2iauto not working as expected for DB2 V9.5 and DB29.7 on RHEL 6.2

    ‏2012-05-24T17:30:04Z  
    • mor
    • ‏2012-05-24T16:59:41Z
    When you run db2iauto - are you 'root' ?
    Also, do you use the absolute-pathname to each version's db2iauto executable when you run it?
    Hi,

    Thanks for looking into this.

    No, I am running the db2iauto command with the instance owner ID eg:- If I wasnt to enable DB2AUTOSTART for db2inst2 then I am running it as db2inst2.

    Also I am running db2iauto from /home/db2inst2/sqllib and I see that it is successful. I guess we can verify this by db2set like

    db2inst2@rcc-pok-idg-2210 sqllib$ db2set DB2AUTOSTART -i db2inst2
    YES
  • mor
    mor
    520 Posts

    Re: DB2iauto not working as expected for DB2 V9.5 and DB29.7 on RHEL 6.2

    ‏2012-05-24T18:07:24Z  
    Hi,

    Thanks for looking into this.

    No, I am running the db2iauto command with the instance owner ID eg:- If I wasnt to enable DB2AUTOSTART for db2inst2 then I am running it as db2inst2.

    Also I am running db2iauto from /home/db2inst2/sqllib and I see that it is successful. I guess we can verify this by db2set like

    db2inst2@rcc-pok-idg-2210 sqllib$ db2set DB2AUTOSTART -i db2inst2
    YES
    Try sudo or su to root, then using the absolute pathname to each version of db2iauto (example /opt/ibm/db2/V9.5/... and /opt/ibm/db2/V9.7/... )
    Sometimes security settings or additional security software get in the way.
  • PankajSabharwal
    PankajSabharwal
    5 Posts

    Re: DB2iauto not working as expected for DB2 V9.5 and DB29.7 on RHEL 6.2

    ‏2012-05-24T20:20:09Z  
    • mor
    • ‏2012-05-24T18:07:24Z
    Try sudo or su to root, then using the absolute pathname to each version of db2iauto (example /opt/ibm/db2/V9.5/... and /opt/ibm/db2/V9.7/... )
    Sometimes security settings or additional security software get in the way.
    I ran db2iauto individually from each absolute path for V9.5 and V9.7 as a root. Still I can see only on db2inst1 coming up and not db2inst2,db2inst3.
  • mor
    mor
    520 Posts

    Re: DB2iauto not working as expected for DB2 V9.5 and DB29.7 on RHEL 6.2

    ‏2012-05-25T11:38:35Z  
    I ran db2iauto individually from each absolute path for V9.5 and V9.7 as a root. Still I can see only on db2inst1 coming up and not db2inst2,db2inst3.
    Please post the output of these two commands:
    cat /etc/redhat-release
    uname -a

    I have an RHEL 6.2 environment, which currently has 2 instances of V9.7, both autostart properly after I used db2iauto -on while running as root. I wonder if having 2 different versions of DB2 is significant? Seems doubtful.
  • mor
    mor
    520 Posts

    Re: DB2iauto not working as expected for DB2 V9.5 and DB29.7 on RHEL 6.2

    ‏2012-05-25T11:38:37Z  
    I ran db2iauto individually from each absolute path for V9.5 and V9.7 as a root. Still I can see only on db2inst1 coming up and not db2inst2,db2inst3.
    Please post the output of these two commands:
    cat /etc/redhat-release
    uname -a

    I have an RHEL 6.2 environment, which currently has 2 instances of V9.7, both autostart properly after I used db2iauto -on while running as root. I wonder if having 2 different versions of DB2 is significant? Seems doubtful.
  • PankajSabharwal
    PankajSabharwal
    5 Posts

    Re: DB2iauto not working as expected for DB2 V9.5 and DB29.7 on RHEL 6.2

    ‏2012-05-25T13:15:14Z  
    • mor
    • ‏2012-05-25T11:38:37Z
    Please post the output of these two commands:
    cat /etc/redhat-release
    uname -a

    I have an RHEL 6.2 environment, which currently has 2 instances of V9.7, both autostart properly after I used db2iauto -on while running as root. I wonder if having 2 different versions of DB2 is significant? Seems doubtful.
    Please find below output.

    root@rcc-pok-idg-2210 ~# cat /etc/redhat-release
    Red Hat Enterprise Linux Server release 6.2 (Santiago)
    root@rcc-pok-idg-2210 ~# uname -a
    Linux rcc-pok-idg-2210.cloud9.ibm.com 2.6.32-220.el6.x86_64 #1 SMP Wed Nov 9 08:03:13 EST 2011 x86_64 x86_64 x86_64 GNU/Linux
    I am not sure about running 2 different versions of DB2 on same Linux server is making difference here.
  • mor
    mor
    520 Posts

    Re: DB2iauto not working as expected for DB2 V9.5 and DB29.7 on RHEL 6.2

    ‏2012-05-25T14:06:08Z  
    Please find below output.

    root@rcc-pok-idg-2210 ~# cat /etc/redhat-release
    Red Hat Enterprise Linux Server release 6.2 (Santiago)
    root@rcc-pok-idg-2210 ~# uname -a
    Linux rcc-pok-idg-2210.cloud9.ibm.com 2.6.32-220.el6.x86_64 #1 SMP Wed Nov 9 08:03:13 EST 2011 x86_64 x86_64 x86_64 GNU/Linux
    I am not sure about running 2 different versions of DB2 on same Linux server is making difference here.
    I have almost the exact name redhat-release and a slightly newer kernel.
    My DB2 v9.7 is at fixpack 5 and I have no problems with autostarting multiple instances via db2iauto -on (ran it as root).
    So I suspect you either have a fixpack issue or an environment issue.
    When db2iauto -on runs, are there any messages added to /var/log/messages ?
  • PankajSabharwal
    PankajSabharwal
    5 Posts

    Re: DB2iauto not working as expected for DB2 V9.5 and DB29.7 on RHEL 6.2

    ‏2012-05-25T15:59:41Z  
    • mor
    • ‏2012-05-25T14:06:08Z
    I have almost the exact name redhat-release and a slightly newer kernel.
    My DB2 v9.7 is at fixpack 5 and I have no problems with autostarting multiple instances via db2iauto -on (ran it as root).
    So I suspect you either have a fixpack issue or an environment issue.
    When db2iauto -on runs, are there any messages added to /var/log/messages ?
    I ran db2iauto for all 3 instances again as root and there was no activity in the /var/log/messages.
    Unfortunately I am out of ideas but as you suggested I will compare the versions of OS against DB2 again.
  • mor
    mor
    520 Posts

    Re: DB2iauto not working as expected for DB2 V9.5 and DB29.7 on RHEL 6.2

    ‏2012-05-26T10:42:41Z  
    I ran db2iauto for all 3 instances again as root and there was no activity in the /var/log/messages.
    Unfortunately I am out of ideas but as you suggested I will compare the versions of OS against DB2 again.
    As db2iauto is just a simple shell script that sets the DB2AUTOSTART registry variable, you might want to check the registry settings for all your instances (db2set -all for each instance owner).
    Expect to see [i] DB2AUTOSTART=YES for each of those instances for which you ran db2iauto -on.
  • mor
    mor
    520 Posts

    Re: DB2iauto not working as expected for DB2 V9.5 and DB29.7 on RHEL 6.2

    ‏2012-05-26T11:38:01Z  
    • mor
    • ‏2012-05-26T10:42:41Z
    As db2iauto is just a simple shell script that sets the DB2AUTOSTART registry variable, you might want to check the registry settings for all your instances (db2set -all for each instance owner).
    Expect to see [i] DB2AUTOSTART=YES for each of those instances for which you ran db2iauto -on.
    If all your instances show DB2AUTOSTART=yes in their registry
    then check what's happening with the FMC.

    It may be that whatever FMC is running is only checking the DB2AUTOSTART of its own version of DB2.

    If you run:
    ps -ef | grep db2fmc
    does it show the V9.5 one or the V9.7 one?

    Is it only that version's instance(s) that autostart?

    What happens if you try both FMCs?

    (root)
    /opt/ibm/db2/V9.7/bin/db2fmcu -u -p /opt/ibm/db2/V9.7/bin/db2fmcd
    /opt/ibm/db2/V9.5/bin/db2fmcu -u -p /opt/ibm/db2/V9.5/bin/db2fmcd
  • CalvinM
    CalvinM
    27 Posts

    Re: DB2iauto not working as expected for DB2 V9.5 and DB29.7 on RHEL 6.2

    ‏2012-05-29T13:33:30Z  
    I ran db2iauto for all 3 instances again as root and there was no activity in the /var/log/messages.
    Unfortunately I am out of ideas but as you suggested I will compare the versions of OS against DB2 again.
    I have ran into the same issue before. There is a problem with autostart db2 on Linux 6 Servers. Check out this.
    https://www-304.ibm.com/support/docview.wss?uid=swg21497220