What determines the number of agents an application opens?

I have four databases within one instance (DB2 V8.2 on Linux) and when I list applications one database always shows 3 agents for each connected application. All the other databases only have 1 agent per connection.

All the parameters that would seem to have anything to do with the number of agents are set in the DBM configuration. There has to be a configuration parameter at the database configuration that controls this, but I havn't been able to find it.

I haven't been able to find much helpful info about this in the doc.
Thanks for you input in advance
Bob.

Is this a partitioned database, by any chance?

Could you provide a sample of the LIST APPLICATIONS output?

It's not a partitioned database.

Here's a sample of the list applictions output.


Auth Id Application Appl. Application Id DB # of
Name Handle Name Agents
-------- -------------- ---------- ------------------------------ -------- -----
PUB db2jccServlet. 416 GA32281D.N293.041220141458 INV 3
PUB db2jccServlet. 450 GA32281C.C1A2.041220132050 INV 3
HR db2jccmain 330 GA65214D.H192.041220161446 HRP 1
HR db2jccServlet. 288 GA32281C.HEA2.041220161435 HRP 1
HR db2jccmain 68 GA65C94A.AB89.041220160749 HRP 1
HR db2jccServlet. 504 GA32281D.KDC1.041220154116 HRP 1

Thanks again.

Do you have intra-partition parallellism enabled? If you have DFT_DEGREE set to 2 I guess you'll have 3 agents working on an applications: a coordinator agent and two subagents.

Thanks, it looks like the DFT_DEGREE is the difference. It is set to "ANY" on the database that has 3 agents. It is set to 1 on the other databases. That would seem to explain it.

Thanks again for the info.
Bob

Thanks, it looks like the DFT_DEGREE is the difference. It is set to "ANY" on the database that has 3 agents. It is set to 1 on the other databases. That would seem to explain it.

Thanks again for the info.
Bob