AIX 5.2 "DB2 v18.104.22.168", "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.