Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006
    Location
    Columbus, OH
    Posts
    69

    Unanswered: db2fmp process eats up CPU/memory

    AIX 5.2 "DB2 v8.1.1.64", "s040811", "U498350", and FixPak "7"

    Recently we had really slow performance on one of our DB2 Servers. Upon further investigation (topas), db2fmp processes were eating up the CPU. Alot of the processes had dates a couple weeks old. The info I've read states this is used for stored procedures and user defined functions but there have not been any created for this db as far as i know. Anyone know why db2fmp would be going crazy and why there may be stale processes left over. We ended up recycling the instance which fixed it, but not sure what is the real fix to the problem.

    # ps -ef | grep -i db2fmp
    moninp01 741492 942256 0 Sep 05 - 3:40 db2fmp (C) 0
    moninp01 786528 942256 0 Sep 12 - 13:02 db2fmp (C) 0
    root 1003574 1122528 0 13:22:13 pts/3 0:00 grep -i db2fmp
    moninp01 1118400 942256 120 Sep 28 - 11366:39 db2fmp (C) 0
    moninp01 1138920 942256 0 Sep 05 - 0:00 db2fmp (idle) 0]

    Thanks,
    Charlie

  2. #2
    Join Date
    Jun 2006
    Posts
    471

    fmp

    Best Regards, Guy Przytula
    DB2 UDB LUW certified V6/7/8

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •