var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: db2fmpr process on standby
ENV: DB2 9.5, RedHat 5.3
I have more HADR questions.
On my HADR standby , db2fmpr is taking up all CPU. After doing some lookup I realized that db2fmpr is a db2fmp process started by root.
Doing a ps -ef | grep db2fmp, shows alteast 30 db2fmpr processes all started by root. Here's a snippet from the ps -ef
root 637 21079 17 Jun07 pts/1 12:29:34 db2fmpr 1,0,0,0,0,0,1,0,8a1790,14,1e014,2,0,1,91fc0,0x2100 00000,0x210000000,1600000,37bb0012,2,419a805c
root 638 21079 17 Jun07 pts/1 12:30:31 db2fmpr 1,0,0,0,0,0,1,0,8a1790,14,1e014,2,0,1,b1fc0,0x2100 00000,0x210000000,1600000,37bb0012,2,419b005e
root 639 21079 17 Jun07 pts/1 12:29:30 db2fmpr 1,0,0,0,0,0,1,0,8a1790,14,1e014,2,0,1,d1fc0,0x2100 00000,0x210000000,1600000,37bb0012,2,419b805f
root 640 21079 17 Jun07 pts/1 12:29:19 db2fmpr 1,0,0,0,0,0,1,0,8a1790,14,1e014,2,0,1,f1fc0,0x2100 00000,0x210000000,1600000,37bb0012,2,419c0060
root 641 21079 17 Jun07 pts/1 12:29:31 db2fmpr 1,0,0,0,0,0,1,0,8a1790,14,1e014,2,0,1,111fc0,0x210 000000,0x210000000,1600000,37bb0012,2,419c8061
root 647 21079 17 Jun07 pts/1 12:27:54 db2fmpr 1,0,0,0,0,0,1,0,8a1790,14,1e014,2,0,1,131fc0,0x210 000000,0x210000000,1600000,37bb0012,2,419d8063
root 657 21079 17 Jun07 pts/1 12:27:05 db2fmpr 1,0,0,0,0,0,1,0,8a1790,14,1e014,2,0,1,151fc0,0x210 000000,0x210000000,1600000,37bb0012,2,41a08064
On standby db2fmp does not have much function, so i am guess it is safe to kill these process without effecting the hadr?
Why I am seeing so many db2fmpr processes on standby?
If anybody is having the same issue,
Did a reboot of the stanby server to get rid of all the run down db2fmpr processes.