Heh,

thanks for putting me on the correct path. You are 100% correct.

the pscount code which is being returned is a value of 5. This is
unfortunately too much. The amount of processes returned from DB2 9.5 are
actually 4 and therefore the db2 resource script will fail because the "
test $pscount -ge 5 " looks for the amount of db2 processess greater and
equal to 5. Set the value to 3 and you will be set :)

Thanks


On Fri, Aug 14, 2009 at 1:54 PM, Dejan Muhamedagic <[email protected]>wrote:

> Hi,
>
> On Fri, Aug 14, 2009 at 01:32:22PM +0200, Timothy Carr wrote:
> > Hi All,
> >
> > I've setup linux HA and its working pretty well with my disks being
> migrated
> > when i need it to and VIP working nicely.
> > The problem I seem to have is getting DB2 to startup with the OCF
> resource
> > agent.
> >
> >
> > crmd[6031]: 2009/08/14_13:06:51 info: do_lrm_rsc_op: Performing
> > op=db2poc_monitor_0 key=5:27162:7:596c511b-85e0-40b6-b1df-2ef28e41fa94)
> > lrmd[6028]: 2009/08/14_13:06:51 info: rsc:db2poc: monitor
> > crmd[6031]: 2009/08/14_13:06:52 info: process_lrm_event: LRM operation
> > db2poc_monitor_0 (call=47, rc=7) complete
> > crmd[6031]: 2009/08/14_13:06:55 info: do_lrm_rsc_op: Performing
> > op=db2poc_start_0 key=19:27162:0:596c511b-85e0-40b6-b1df-2ef28e41fa94)
> > lrmd[6028]: 2009/08/14_13:06:55 info: rsc:db2poc: start
> > db2[20759]:    2009/08/14_13:07:02 INFO: DB2 UDB instance db2poc started:
> > 08/14/2009 13:07:02     0   0   SQL1063N  DB2START processing was
> > successful.
> > SQL1063N  DB2START processing was successful.
> > db2[20759]:    2009/08/14_13:07:02 ERROR: DB2 UDB instance db2poc not
> > active!
> > crmd[6031]: 2009/08/14_13:07:02 info: process_lrm_event: LRM operation
> > db2poc_start_0 (call=48, rc=1) complete
> > crmd[6031]: 2009/08/14_13:07:03 info: do_lrm_rsc_op: Performing
> > op=db2poc_stop_0 key=1:27163:0:596c511b-85e0-40b6-b1df-2ef28e41fa94)
> > lrmd[6028]: 2009/08/14_13:07:03 info: rsc:db2poc: stop
> > db2[21059]:    2009/08/14_13:07:05 INFO: DB2 UDB instance db2poc stopped:
> > 08/14/2009 13:07:05     0   0   SQL1064N  DB2STOP processing was
> successful.
> > SQL1064N  DB2STOP processing was successful.
> > db2[21059]:    2009/08/14_13:07:06 INFO: DB20000I  The TERMINATE command
> > completed successfully.
> > db2[21059]:    2009/08/14_13:07:07 INFO: ipclean: Removing DB2 engine and
> > client's IPC resources for db2poc.
> > crmd[6031]: 2009/08/14_13:07:07 info: process_lrm_event: LRM operation
> > db2poc_stop_0 (call=49, rc=0) complete
> > cib[6027]: 2009/08/14_13:16:44 info: cib_stats: Processed 32 operations
> > (312.00us average, 0% utilization) in the last 10min
> >
> >
> > The folllowing is an extract from the ha-log file. It starts up the
> instance
> > but then somehow detects that the instance is not active then shuts down
> DB2
> > again.
>
> It looks like the db2 resource agent can't handle newer db2
> releases. In particular, the monitor operation fails since db2
> started using threads. Somebody reported it two-three weeks ago
> on this list. The problem is here:
>
> pscount=`runasdb2 $db2bin/db2_local_ps | cut -c9- |  grep ' db2[^ ]' | wc
> -l`
> test $pscount -ge 5
>
> We need to find out a db2 release running and then implement
> a proper test.
>
> Unfortunately I don't have a db2 instance for testing.
>
> Thanks,
>
> Dejan
>
> >
> > --
> > Timothy Carr
> > Technical
> > Gtalk: [email protected]
> > Skype: timothy.carr.foxtrail
> > _______________________________________________
> > Linux-HA mailing list
> > [email protected]
> > http://lists.linux-ha.org/mailman/listinfo/linux-ha
> > See also: http://linux-ha.org/ReportingProblems
> _______________________________________________
> Linux-HA mailing list
> [email protected]
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
>



-- 
Timothy Carr
Technical Specialist
University of Cape Town
Cell: +27834572568
Fax: +27865472190
Gtalk: [email protected]
Skype: timothy.carr.foxtrail
_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems

Reply via email to