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