IBM Support

Why am I getting dumps from db2fmp process' when DB2 engine is up and running

Technical Blog Post


Abstract

Why am I getting dumps from db2fmp process' when DB2 engine is up and running

Body

db2fmp  process are Fenced Mode Process'  which are run outside of DB2's  main  address space.

Not-Fenced  ->  Runs inside DB2's  address space.  Example, SQL procedures,  C Stored Procedures.

Fenced        ->    Runs outside of DB2's  address space.   Those use  db2fmp  process'   which  are not part of db2sysc  process. Example,   Java, C  Stored Procedures and  User Defined Functions (UDF).

 

This is a way to  run  a  non-DB2 code as part of procedures or,  functions  inside DB2.    If it's run as  Not-Fenced  then it will run  in DB2's address space.   So,  any  code bug in those procedures and functions  will bring down the entire DB2 engine.

The  fenced  procedures are used to  avoid that kind of DB2 crash.  Instead,  it will crash only  the db2fmp  process'  and cause associated dumps.   But,  not affect  running  of the main DB2 engine.

 

So,   if it's noticed that  dumps  are getting generated from db2fmp  process'   the first thing should be  checked is,   what products  or, applications are owning  the code  as part of those  procedures/functions and involve the product team to  find the cause of the crashes.   The  application providing those codes might have their  own diagnostic ways which might help to  find  the source of the problem.

 

In rare  situations  it  might be  a defect  related to DB2's  infrastructure or,   some  tuning   need  related  to resources in the box and  in specific  users.

 

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

UID

ibm11140688