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.