473,563 Members | 2,797 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: 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
Jul 23 '10 #1
0 1400

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

Similar topics

7
2669
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 current query, the results are listed in the order in which they were placed in the database. TIA
2
2496
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 user to save the spreadshet with a .xls name. Some times the browser will open up the file as text file within the bvrowser itself?
2
1730
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 best I've been able to do so far is use some javascript code to print an "X" if the value in the field is "true". Any help appreciated. Graham
12
2049
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 saves to a memo field. When displayed through results on a webpage, the links are inactive, unless the user was knowledgable enough to use html within...
4
5017
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 do it? I can bind data to datagrids and lists and stuff all day long, but can't seem to grasp this one. Any pointers to a useful article / demo (or...
2
1803
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; Response.Write(temp.Split(":"));
13
1728
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 RECORD 3 GOES HERE I need
1
1402
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 attempts to copy and paste the data in an Excel sheet, they get little graphics (it looks like a little robot) insteat of data. 2: When displaying the...
3
1972
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 dropdown menu (using the <select><option> tags). I am pleased to see that it worked well. Now all I want is to display another field from the same record...
1
1165
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 Results Error '‘http://10.1.1.60/Files/GACmove Setup.doc’'. Number: -2147217900 (0x80040E14) Source: Microsoft JET Database Engine"
0
7665
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7583
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8106
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
1
7642
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7950
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
5213
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3626
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2082
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 we have to send another system
0
924
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.