On a solaris server using db2 v8.1 fix pack 3 there seems to be a build up
of idle agents,
to the point where an error occurs -
PID:3862(db2ipccm 0) TID:1 Appid:none
base sys utilities sqleGetAgentFromPool Probe:97

Error getting an agent. Return code =
0xFFBEC050 : 0xFFFFFB39 ...9

2005-01-29-03.58.58.654493 Instance:db2inst1 Node:000
PID:3862(db2ipccm 0) TID:1 Appid:none
base sys utilities sqleGetAgent Probe:70

Agent not allocated, sqlcode = -1223

Is this a known problem or is it related to the db2 confioguration.
Extract from dbm cfg
Max number of existing agents (MAXAGENTS) = 800
Agent pool size (NUM_POOLAGENTS) = 400
Initial number of agents in pool (NUM_INITAGENTS) = 0
Max number of coordinating agents (MAX_COORDAGENTS) = (MAXAGENTS -
NUM_INITAGENTS)
Max no. of concurrent coordinating agents (MAXCAGENTS) = MAX_COORDAGENTS
Max number of client connections (MAX_CONNECTIONS) = MAX_COORDAGENTS

Regards,
Tom




***************************************************************
The information contained in this e-mail and any files transmitted
with it is confidential and may be subject to legal professional
privilege. It is intended solely for the use of the addressee(s).
If you are not the intended recipient of this e-mail, please note
that any review, dissemination, disclosure, alteration, printing,
copying or transmission of this e-mail and/or any file transmitted
with it, is prohibited and may be unlawful.
If you have received this e-mail by mistake, please promptly
inform the sender by reply e-mail and delete the material.
Whilst this e-mail message has been swept for the presence of
computer viruses, eircom does not, except as required by law,
represent, warrant and/or guarantee that the integrity
of this communication has been maintained nor that
the communication is free of errors, viruses, interception or
interference.
***************************************************************


DB2 & UDB email list listserv db2-l LazyDBA home page