multiple db2fm processes and a huge table with a BLOB field?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mjf - 23 Jun 2006 15:58 GMT

Hello,

We have seen up to 11 db2fm processes running at the same time, which
was consuming 100% of CPU. We could not run anything else on the
machine because of this. We have only one DB2 instance, so there should
be only one db2fm process. What could be causing so many db2fm
processes? Could this be because the fast growing of a table that has a
BLOB field? The field holds images, and each image is more than 1MB.
Now the table has grown to be more than 7GB. The correlation between
multiple db2fm processes and a huge table with BLOB data seems
unlikely, but we cannot see any other possible causes.

Thanks.

Reply to this Message

mjf - 23 Jun 2006 19:59 GMT

Also, I notice that each db2fm that showed up over the time all had
different PIDs. Does that mean that each db2fm exited after checking
the DB2 instance (there is only one instance on our system) and then
db2fmc would start a new db2fm after the specified interval (20 seconds
as default)? By the way, each db2fm process didn't always come up at
the specified interval (defined as STATUS_INTERVAL in fm.<system
name>.reg), though, and why is that?

> Hello,
>
[quoted text clipped - 9 lines]
>
> Thanks.

Reply to this Message