DB2 WSE 8.1 FP 5
Red Hat Linux AS 2.1
(LUW)
I am having ongoing issues w/ FMP processes in my DB2 server, and
thought I would ask for opinions.
My dbm cfg KEEPFENCED is set to YES, and I use several very simple
DB2 UDFS (NOT java, I thought they were the problem, and have
eliminated them). The UDFS are simple, in most cases just wrapping
DB2 built-in functions, or returning comma-delimited lists from tables.
Here's the problem: after a while (ranging from days to weeks), a
BUNCH of db2fmp processes get built up. I counted 79 the other day.
Is this normal? Once a bunch of these build up, funny stuff starts to
happen in the database, with things like:
APP_CTL_HEAP_SZ not being big enough (its 512)
sqlccipcdarihandshake errors
maximum number of agents exceeded (then refuses new connections)
sqlerDisassociateWithFmp errors
sqlerGetFmpThread errors
If I bounce the database (and therefore get rid if all the fmps),
the all the errors/symptons go away, until a bunch of fmps build
up again, and it starts all over.
My theory is that all these fmp's are not normal, and are slowly
starving the engine of resources. How many should there be?
If I kill -9 these fmp process, i get db2diag.log messages "A non-EDU
child crashed", which makes me skittish...
Here's an ps -ef example:
oltpfenc 7756 21755 0 07:35 pts/2 00:00:00 db2fmp
,0,0,0,0,1,1,1e010,2,0,1
oltpfenc 7757 7756 0 07:35 pts/2 00:00:00 db2fmp
,0,0,0,0,1,1,1e010,2,0,1
oltpfenc 7758 7757 0 07:35 pts/2 00:00:00 db2fmp
,0,0,0,0,1,1,1e010,2,0,1
They always come in groups of 3, with consecutive PID's...
Any thoughts?
TIA
aj