467,199 Members | 1,020 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,199 developers. It's quick & easy.

db2fmp process

Hi,
we use DB2 8.1 EEE on a Linux server.
Currently, there is a long run'ner process in the task list which
occupies one processor to 99%.
The proces user is db2fenc and the command is db2fmp.

Does anybody knows, what does it means and how I can terminate the
process (or should I kill it)?

Thanks, Toralf
Nov 12 '05 #1
  • viewed: 28034
Share:
2 Replies
Toralf Kirsten wrote:
Hi,
we use DB2 8.1 EEE on a Linux server.
Currently, there is a long run'ner process in the task list which
occupies one processor to 99%.
The proces user is db2fenc and the command is db2fmp.

Does anybody knows, what does it means and how I can terminate the
process (or should I kill it)?


This is the db2 fenced mode process (hence the abbreviation db2fmp). Those
processes are used to run external routines like UDFs or stored procedures
(if those routines are declared as FENCED in the database). The FMPs run
under a different user id (db2fenc in your case) to prevent any malicious
or problematic code inside a routine from accessing and messing around with
database resources like files or shared memory. If routines are not
running fenced, then they have a much better chance to crash the database
server. Fenced routines are protected from bringing the DB2 engine down.

Whether you can simply kill those processes or not depends on the current
activity of all you databases. If there are some applications running and
executing SQL statements, then you should be carefuly. If nothing is
running, you can simply kill those processes and db2 will start new ones
the next time an FMP is needed.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena
Nov 12 '05 #2
You should also install 8.1.5. It fixes a problem with runaway db2fmp.exe
tasks - at least if fixes one we PMR'd.

"Toralf Kirsten" <tk******@izbi.uni-leipzig.de> wrote in message
news:ce**********@news1.uni-leipzig.de...
Hi,
we use DB2 8.1 EEE on a Linux server.
Currently, there is a long run'ner process in the task list which
occupies one processor to 99%.
The proces user is db2fenc and the command is db2fmp.

Does anybody knows, what does it means and how I can terminate the
process (or should I kill it)?

Thanks, Toralf

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by ChrisWinterscheid | last post: by
reply views Thread by Ralf Gross | last post: by
1 post views Thread by kavallin@hotmail.com | last post: by
2 posts views Thread by db2admin | last post: by
reply views Thread by Lew | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.