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
