By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,924 Members | 1,727 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,924 IT Pros & Developers. It's quick & easy.

db2fmp process

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a
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.