Re: db2 error ( Agent not allocated, sqlcode = -1225 )
From: Michael Austin <maustin_at_firstdbasource.com>
Date: Wed, 12 Mar 2008 02:59:26 GMT
Message-ID: <iGHBj.17001$Ch6.8416@newssvr11.news.prodigy.net>
>>>> 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
Date: Wed, 12 Mar 2008 02:59:26 GMT
Message-ID: <iGHBj.17001$Ch6.8416@newssvr11.news.prodigy.net>
The Boss wrote:
> Michael Austin wrote: >> DA Morgan wrote: >>> oracle_db2_dba wrote:
>>>> 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
>>> Well I'm confused as to why you think someone at c.d.oracle.server >>> would know much about DB2 UDB. > > Confused? > http://en.wikipedia.org/wiki/Soap_(TV_series) > > You (Daniël) should have known by now there are DBA's administering more > than one RDBMS. > >>> Well I guess with Serge spending more time here than in the DB2 space >>> perhaps you're right. <g> > > This is like saying you (Daniël again) spend more time in the DB2 ng than in > this one. > As a mather of fact, Serge already answered this same question on > c.d.ibm-db2 > >>> Sorry but if you lob 'em over the net I just have to return 'em. >> seems like the DB2 so-called DBA's have the same problem as a lot of >> dba's in this forum. The inability to use google. > > A bold conclusion, based on just this one incident. > And what's a "DB2 so-called DBA"?
Just a snide remark about the qualifications of the untold number of individuals who call themselves DBA's - but are counted among the hundreds of IT personnel who got a diploma because they thought they could make a lot of money and thought that being a DBA was "easy". Many of which have cost companies $$$$$$ by doing silly things like deleting production database files because they needed more space...
Then there are guys like some of us in this NG that have had to come in a mop up their mess. Received on Tue Mar 11 2008 - 21:59:26 CDT