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>
DATA #1 : Hexdump, 4 bytes
DATA #1 : Hexdump, 4 bytes
MESSAGE : ADM7009E An error was encountered in the "TCPIP" protocol support.
regards Received on Mon Mar 10 2008 - 14:57:53 CDT
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:5MESSAGE : 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 : 000FUNCTION: 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:30MESSAGE : 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 : 000FUNCTION: 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 : 000FUNCTION: 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