AIX 5.2 "DB2 v8.1.1.64", "s040811", "U498350", and FixPak "7"
Recently we had really slow performance on one of our DB2 Servers. Upon further investigation (topas), db2fmp processes were eating up the CPU. Alot of the processes had dates a couple weeks old. The info I've read states this is used for stored procedures and user defined functions but there have not been any created for this db as far as i know. Anyone know why db2fmp would be going crazy and why there may be stale processes left over. We ended up recycling the instance which fixed it, but not sure what is the real fix to the problem.
# ps -ef | grep -i db2fmp
moninp01 741492 942256 0 Sep 05 - 3:40 db2fmp (C) 0
moninp01 786528 942256 0 Sep 12 - 13:02 db2fmp (C) 0
root 1003574 1122528 0 13:22:13 pts/3 0:00 grep -i db2fmp
moninp01 1118400 942256 120 Sep 28 - 11366:39 db2fmp (C) 0
moninp01 1138920 942256 0 Sep 05 - 0:00 db2fmp (idle) 0]
Thanks,
Charlie