How to monitor db2fmp ?

How to monitor db2fmp:


From a DB2 perspective we can determine the application and routine calling the routine along with some diagnostics to help the developer that wrote the routine troubleshoot any performance problems.

The db2fmp process runs outside of the DB2 process db2sysc, it runs under a separate user id than db2sysc. See below:

sa1x-db2rc-d1[/home/db2inst1/gopi]$ ps -ef|grep -i db2sysc
db2inst2 10813518 11337886   0   Mar 21      - 14:49 db2sysc
db2inst1 25624708 15007866   2   Mar 20      - 831:32 db2sysc
sa1x-db2rc-d1[/home/db2inst1/gopi]$ ps -T 15007866
      PID    TTY  TIME CMD
 15007866      -  0:00 db2sysc
  4391098      -  0:24    |\--db2fmp
  6226034      -  0:15    |\--db2fmp
  9502786      -  0:01    |\--db2fmp
 11010262      -  0:06    |\--db2fmp
 19464408      -  0:04    |\--db2fmp
 25231500      -  7:33    |\--db2fmp
 25624708      - 831:32     \--db2sysc
 17760322      -  0:01        |\--db2sysc
 21692584      -  0:00        |\--db2vend
 25755662      -  0:01        |\--db2sysc
 26607772      -  0:01         \--db2sysc

To find fmp:

db2pd -fmp

To find the history of execution by fmp:

db2pd -fmpexechistory

Links:

https://www.ibm.com/developerworks/community/blogs/IMSupport/entry/tech_tip_what_the_db2fmp_process_does?lang=en


http://www-01.ibm.com/support/docview.wss?uid=swg21383251

AIX TIPS

AIX TIPS

To find the directory sizes:

du -sg ./* | sort -rn | head -5

The above command prints the directory sizes in GB and sorts it in reverse and shows top 5.

This can be used to troubleshoot the archive log file system filling up.