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: msgMaxMessageSi ze:4194304 msgMaxQueueSize :4194304
shmMax:68719476 736 shmMin:1 shmIDs:131072
shmSegments:687 19476736 semIDs:131072 semNumPerID:
65535
semOps:1024 semMaxVal:32767 semAdjustOnExit :16384
Cur data size (bytes) = 0x7FFFFFFFFFFFF FFF
Cur stack size (bytes) = 0x0000000100000 000
Cur core size (bytes) = 0x0000000077359 400
nofiles (descriptors) = 0x7FFFFFFFFFFFF FFF
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
0x078000000021C 1A8 : 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, sqleUCagentConn ect, probe:11
MESSAGE : Overflow agent is not allowed for gateway connection
DATA #1 : Hexdump, 4 bytes
0x00000001109A5 26C : FFFF FB36
---------------------------------------------------------
I 'm (unfortunately) not a DB2 specialist, nor AIX guru,
and would really appreciate any help.
Thanks for your help
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: msgMaxMessageSi ze:4194304 msgMaxQueueSize :4194304
shmMax:68719476 736 shmMin:1 shmIDs:131072
shmSegments:687 19476736 semIDs:131072 semNumPerID:
65535
semOps:1024 semMaxVal:32767 semAdjustOnExit :16384
Cur data size (bytes) = 0x7FFFFFFFFFFFF FFF
Cur stack size (bytes) = 0x0000000100000 000
Cur core size (bytes) = 0x0000000077359 400
nofiles (descriptors) = 0x7FFFFFFFFFFFF FFF
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
0x078000000021C 1A8 : 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, sqleUCagentConn ect, probe:11
MESSAGE : Overflow agent is not allowed for gateway connection
DATA #1 : Hexdump, 4 bytes
0x00000001109A5 26C : FFFF FB36
---------------------------------------------------------
I 'm (unfortunately) not a DB2 specialist, nor AIX guru,
and would really appreciate any help.
Thanks for your help