Hi,
I am getting the error as "maximum number of agents
has been exceeded." When I looked into the list
applications and counted on the no. of applications ,
it is showing very less, [1/5]th of MAXAGENTS.
The error message is as below. And all new client
connections are being thrown out complaining the above

reason. We have MAXAGENTS as 600 and no. of
connections as 102. But I am seeing this error. oes
'list applications' really say how many agents are
there [applications]. If not which command should I
use to get the total no. of agents.

Any help is greatly appreciated.

Thanks in advance
Girish

2004-06-16-21.31.27.839075 Instance:PKstdb2
Node:000
PID:30382(db2tcpcm 0) TID:1 Appid:none
common communication sqlcctcpconnmgr_child Probe:125

ADM7009E An error was encountered in the "TCPIP"
protocol support. A possible cause is that the
maximum number of agents has been exceeded.

2004-06-16-21.31.27.868989 Instance:PKstdb2
Node:000
PID:30382(db2tcpcm 0) TID:1 Appid:none
common communication sqlcctcpconnmgr_child Probe:126

Return code from sqleGetAgent =
0x0FFFFFFFFFFFA174 : 0xFFFFFB36

Hi,

"list application" shows the total num. of connected app.

Error does't tell much. Can you post the SQLCODE and SQLSTATE error number. Please also specify operat. system and db2 version + fp level. Command db2level will give you the info.

Thanks,
Grofaty

max agents is at the instance level (so for all active databases) There is a setting for each database that states the maximum number of connected applications (MAXAPPLS). If you have multiple databases up and running you may well exceed the total of 600 agents........