473,499 Members | 1,725 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

db2 activate database results in 1226 - Overflow agent is not allowed

1 New Member
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 for your help
Jul 23 '10 #1
0 1397

Sign in to post your reply or Sign up for a free account.

Similar topics

7
2667
by: Robert | last post by:
I have a php/mysql query working like so: $Query = "SELECT * FROM $TableName WHERE name LIKE '%".$searchterm."%' " All I want to do now is sort them alphabetically. By using the above...
2
2493
by: Jawahar Rajan | last post by:
All, I am trying to export a result set as an excel spread sheet. Most of the time this works as expected, when a user chooses to save as excel the browser pop-up a save as dialog to allow the...
2
1728
by: Graham Taylor | last post by:
I am reading data from an MDB Access database into an ASP page. Four fields in the database are Yes/No fields, and I want to show those on the ASP page as check boxes. How do I do this? The...
12
2043
by: magmike | last post by:
When users of my site submit articles to our database (http://www.netterweb.com/articles/) they almost always have http:// addresses within the text. They are pasting that text into a box which...
4
5014
by: Haydnw | last post by:
Hi, I'd like to put a load of database results (several rows for 5 fields) into a two-dimensional array. Now, this may be a really stupid question, but can someone give me a pointer for how to...
2
1797
by: needin4mation | last post by:
Hi, thanks for any help here: SqlCommand cmd = new SqlCommand("SELECT categories FROM catalog" conn); rdr = cmd.ExecuteReader(); String temp; while (rdr.Read()) { temp = rdr;...
13
1721
by: TheBATManPhln | last post by:
I'm a newbie (less than a week of php) and I'm curious about how results can lay out. Is it possible to have the results layed out in 4 columns? Usual RECORD 1 GOES HERE RECORD 2 GOES HERE...
1
1396
by: Brave | last post by:
I have MS Access databases that are viewed via ASP pages made in Frontpage. I have two issues that have the same problem. 1: When someone views database results on one of my webpages, and...
3
1968
by: dlamarche | last post by:
Hello I am new to PHP and I am reading the book Build you own database driven website using PHP and MySQL. I am trying something on my own as an exercise from the book. I sucessfully created a...
1
1164
by: shamlafazal | last post by:
When i use Send Form Results to a Database and an E-mail Address and Use the File Upload Component Simultaneously , am getting an error mentioned below. Please any can help me on this. "Database...
0
7215
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6892
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7385
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5467
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4917
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3088
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1425
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
661
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
294
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.