db2 activate database results in 1226 - Overflow agent is not allowed
in [DB2]
|
Prev: Q about DB2 Express-C and Admin Tools
Next: db2 activate database results in 1226 - Overflow agent is notallowed
From: db2 comp on 23 Jul 2010 04:56 Hi all, I'm currently facing a problem with a Db2 database. When I try to activate / connect to it, following error occurs : --------------------------------------------------------- "SQL1226N The maximum number of client connections are already started. SQLSTATE=57030" --------------------------------------------------------- I had a look to db2diag.log, and found followings : --------------------------------------------------------- CPU: total:4 online:4 Threading degree per core:2 Physical Memory(MB): total:3920 free:2985 Virtual Memory(MB): total:4432 free:3492 Swap Memory(MB): total:512 free:507 Kernel Params: msgMaxMessageSize:4194304 msgMaxQueueSize:4194304 shmMax:68719476736 shmMin:1 shmIDs:131072 shmSegments:68719476736 semIDs:131072 semNumPerID: 65535 semOps:1024 semMaxVal:32767 semAdjustOnExit:16384 Cur data size (bytes) = 0x7FFFFFFFFFFFFFFF Cur stack size (bytes) = 0x0000000100000000 Cur core size (bytes) = 0x0000000077359400 nofiles (descriptors) = 0x7FFFFFFFFFFFFFFF 2010-07-23-10.11.22.530711+120 I4980A396 LEVEL: Event PID : 286756 TID : 1 PROC : db2tcpcm 0 INSTANCE: db2inst1 NODE : 000 FUNCTION: DB2 UDB, base sys utilities, sqleGetAgent, probe:19 DATA #1 : String, 37 bytes Agent overflow for system application DATA #2 : Hexdump, 4 bytes 0x078000000021C1A8 : 0000 00A0 .... 2010-07-23-10.11.22.537162+120 I5377A418 LEVEL: Warning PID : 1105948 TID : 1 PROC : db2agent 0 INSTANCE: db2inst1 NODE : 000 APPHDL : 0-167 FUNCTION: DB2 UDB, Connection Manager, sqleUCagentConnect, probe:11 MESSAGE : Overflow agent is not allowed for gateway connection DATA #1 : Hexdump, 4 bytes 0x00000001109A526C : FFFF FB36 --------------------------------------------------------- I 'm (unfortunately) not a DB2 specialist, nor AIX guru, and would really appreciate any help. Thanks
From: Hardy on 23 Jul 2010 14:26 On Jul 23, 3:56 am, db2 comp <db2newco...(a)gmail.com> wrote: > Hi all, > > I'm currently facing a problem with a Db2 database. > When I try to activate / connect to it, following error occurs : > > --------------------------------------------------------- > "SQL1226N The maximum number of client connections are already > started. > SQLSTATE=57030" > --------------------------------------------------------- > > I had a look to db2diag.log, > and found followings : > > --------------------------------------------------------- > CPU: total:4 online:4 Threading degree per core:2 > Physical Memory(MB): total:3920 free:2985 > Virtual Memory(MB): total:4432 free:3492 > Swap Memory(MB): total:512 free:507 > Kernel Params: msgMaxMessageSize:4194304 msgMaxQueueSize:4194304 > shmMax:68719476736 shmMin:1 shmIDs:131072 > shmSegments:68719476736 semIDs:131072 semNumPerID: > 65535 > semOps:1024 semMaxVal:32767 semAdjustOnExit:16384 > Cur data size (bytes) = 0x7FFFFFFFFFFFFFFF > Cur stack size (bytes) = 0x0000000100000000 > Cur core size (bytes) = 0x0000000077359400 > nofiles (descriptors) = 0x7FFFFFFFFFFFFFFF > > 2010-07-23-10.11.22.530711+120 I4980A396 LEVEL: Event > PID : 286756 TID : 1 PROC : db2tcpcm 0 > INSTANCE: db2inst1 NODE : 000 > FUNCTION: DB2 UDB, base sys utilities, sqleGetAgent, probe:19 > DATA #1 : String, 37 bytes > Agent overflow for system application > DATA #2 : Hexdump, 4 bytes > 0x078000000021C1A8 : 0000 00A0 .... > > 2010-07-23-10.11.22.537162+120 I5377A418 LEVEL: Warning > PID : 1105948 TID : 1 PROC : db2agent 0 > INSTANCE: db2inst1 NODE : 000 > APPHDL : 0-167 > FUNCTION: DB2 UDB, Connection Manager, sqleUCagentConnect, probe:11 > MESSAGE : Overflow agent is not allowed for gateway connection > DATA #1 : Hexdump, 4 bytes > 0x00000001109A526C : FFFF FB36 > --------------------------------------------------------- > > I 'm (unfortunately) not a DB2 specialist, nor AIX guru, > and would really appreciate any help. > > Thanks check max_connections dbm cfg. it may be too small for your environment.
From: Mark A on 23 Jul 2010 15:23
"db2 comp" <db2newcomer(a)gmail.com> wrote in message news:6d253165-c50a-4409-be64-7f3443399ca6(a)x21g2000yqa.googlegroups.com... > Hi all, > > I'm currently facing a problem with a Db2 database. > When I try to activate / connect to it, following error occurs : > > --------------------------------------------------------- > "SQL1226N The maximum number of client connections are already > started. > SQLSTATE=57030" > --------------------------------------------------------- > > I had a look to db2diag.log, > and found followings : > > --------------------------------------------------------- > CPU: total:4 online:4 Threading degree per core:2 > Physical Memory(MB): total:3920 free:2985 > Virtual Memory(MB): total:4432 free:3492 > Swap Memory(MB): total:512 free:507 > Kernel Params: msgMaxMessageSize:4194304 msgMaxQueueSize:4194304 > shmMax:68719476736 shmMin:1 shmIDs:131072 > shmSegments:68719476736 semIDs:131072 semNumPerID: > 65535 > semOps:1024 semMaxVal:32767 semAdjustOnExit:16384 > Cur data size (bytes) = 0x7FFFFFFFFFFFFFFF > Cur stack size (bytes) = 0x0000000100000000 > Cur core size (bytes) = 0x0000000077359400 > nofiles (descriptors) = 0x7FFFFFFFFFFFFFFF > > > 2010-07-23-10.11.22.530711+120 I4980A396 LEVEL: Event > PID : 286756 TID : 1 PROC : db2tcpcm 0 > INSTANCE: db2inst1 NODE : 000 > FUNCTION: DB2 UDB, base sys utilities, sqleGetAgent, probe:19 > DATA #1 : String, 37 bytes > Agent overflow for system application > DATA #2 : Hexdump, 4 bytes > 0x078000000021C1A8 : 0000 00A0 .... > > 2010-07-23-10.11.22.537162+120 I5377A418 LEVEL: Warning > PID : 1105948 TID : 1 PROC : db2agent 0 > INSTANCE: db2inst1 NODE : 000 > APPHDL : 0-167 > FUNCTION: DB2 UDB, Connection Manager, sqleUCagentConnect, probe:11 > MESSAGE : Overflow agent is not allowed for gateway connection > DATA #1 : Hexdump, 4 bytes > 0x00000001109A526C : FFFF FB36 > --------------------------------------------------------- > > I 'm (unfortunately) not a DB2 specialist, nor AIX guru, > and would really appreciate any help. > > Thanks Since it says that: "Overflow agent is not allowed for gateway connection" It may be that you are trying to use the embedded DB2 Connect facilities to connect to a remote database. For DB2 Server products that come licensed with DB2 Connect, it has a max of 5 connections allowed to remote databases. |