DB2 on Windows V9.5 FP2 - db2fmp.exe

itsonlyme44 · #1 (**permalink**) 10-22-08, 15:44

Can anyone explain to me what it means when there are multiple db2fmp.exe processes running???

We have a small Datamart on UDB and right now there are 18 db2fmp.exe processes running.

n_i · #2 (**permalink**) 10-22-08, 15:51

I think each db2fmp.exe runs one fenced routine at a time. Besides, the fenced routine processors are pooled, so some of them can be idle.

If it bothers you, I guess you can tweak the keepfenced and fenced_pool parameters...

stolze · #3 (**permalink**) 10-22-08, 16:13

db2fmp processes also run JVMs and they are used for fenced federated wrappers.

(If a fenced routine is declared as THREADSAFE, DB2 may decide to run multiple of such routines in the same db2fmp.)

Internet Services

Web Development

Digital Marketing

Consumer Tech