Hi,
system administrator told me to check out why is there so many db2 processes on DB2 Enterprice v8.2 FP11 Linux box.

Most of them are like this:
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
db2inst1 26345 0.0 1.2 151076 25712 ? S Sep16 0:31 db2agent (idle) 0

I have executed the following commands.
1. To check out number of all processes on Linux box:
Result:471

2. To check out number of processes started by user db2inst1 (db2 instance owner):
Result:396

3. To check out db2agent commands:
Result:369

4. To check out idle db2agent commands:
Result:314

I would like to know what is your number of processes on Linux/Unix box? To get an info if "my" number of processes are really so big as system admin told me.

Thanks,
Grofaty

For V8 of DB2, IBM was using a process model. This means that everything that DB2 does is a separate process. Every connection will have at least one process. Plus all the other processes of DB2. The numbers you are showing look about right to me.

Note, This will change under V9, where the process model goes to a threaded model.

Andy

Tell your system administrator that DBA's don't work for system administrators, system administrators work for DBA's, and he should mind his own business.