db2 error ( Agent not allocated, sqlcode = -1225 )

From: oracle_db2_dba <udbadmin_at_gmail.com>
Date: Mon, 10 Mar 2008 12:57:53 -0700 (PDT)
Message-ID: <f84181e0-806f-4e48-a7e3-450f61e70e00@13g2000hsb.googlegroups.com>


Hi,

We are getting following errors in diaglog. We have 4096 value as MAXAGENTS and 512 for maxuproc
I am confused as which value we are hitting. are we hitting OS ( maxuproc ) value or MAXAGENTS.
is there anything else i am missing which need to be looked into ?


2008-03-07-10.41.59.535278-300 I46678299C345      LEVEL: Severe
PID     : 307324               TID  : 1           PROC : db2tcpcm 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, oper system services, sqloCreateEDU, probe:5
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x2FF194E8 : 0000 000B                                  ....

2008-03-07-10.41.59.543759-300 I46678645C343      LEVEL: Severe
PID     : 307324               TID  : 1           PROC : db2tcpcm 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleCreateNewAgent, probe:25 RETCODE : ZRC=0x870F00F2=-2029059854=SQLO_NORES

          "no resources to create process or thread"

2008-03-07-10.41.59.544311-300 I46678989C351      LEVEL: Severe
PID     : 307324               TID  : 1           PROC : db2tcpcm 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleGetAgentFromPool, probe:30
MESSAGE : DiagData
DATA #1 : Hexdump, 4 bytes
0x2FF19984 : FFFF FB37                                  ...7

2008-03-07-10.41.59.544469-300 I46679341C282      LEVEL: Error
PID     : 307324               TID  : 1           PROC : db2tcpcm 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, base sys utilities, sqleGetAgent, probe:70 MESSAGE : Agent not allocated, sqlcode = -1225
2008-03-07-10.41.59.560744-300 E46679624C421      LEVEL: Error
PID     : 307324               TID  : 1           PROC : db2tcpcm 0
INSTANCE: db2inst1             NODE : 000
FUNCTION: DB2 UDB, common communication, sqlcctcpconnmgr_child, probe: 125
MESSAGE : ADM7009E An error was encountered in the "TCPIP" protocol support.

          A possible cause is that the maximum number of agents has been

          exceeded.



regards Received on Mon Mar 10 2008 - 14:57:53 CDT

Original text of this message