473,461 Members | 2,308 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Maximum Number of Connections has been removed (JR18223)

Hello,

The 'maxconn' has been removed according to IBM documentation APAR JR18223.
The question is how can the 'maxconn' be configured and what is the default
value? Is there a corresponding configuration parameter on the DB2 Server?

- PI
--------------------
Philipp Ineichen
www.skagitsystems.ch
Oct 12 '06 #1
1 1598
Ian
Philipp Ineichen wrote:
Hello,

The 'maxconn' has been removed according to IBM documentation APAR JR18223.
The question is how can the 'maxconn' be configured and what is the default
value? Is there a corresponding configuration parameter on the DB2 Server?
This is a documentation APAR - just updating the documentation to fix
something that was changed in V8.

I believe the default is 0 -- meaning that a client app can make as many
CLI connections as it wants, limited only by system resources (i.e.
memory).
On the server, you control the number of connections to a database using
the MAXAPPLS database configuration parameter. There are some related
instance-level parameters (max_coordagents,max_connections...) as well.
Oct 12 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: sumithradevi | last post by:
Hello Friends, I am getting the following error. java.sql.SQLException: ORA-00020: maximum number of processes (100) exceeded I am closing all my resultsets and all my connections in the try...
8
by: Maddman | last post by:
Newbie here. I've got my database set up in SQL 2000, and have started an Access adp for a front end. I have 10 licenses, and at the moment the only accesses are the server through Remote...
1
by: Mark Harrison | last post by:
We have the situation where it would be convenient if we could support a large number (>1024, possibly in the 2000-3000 range) of client connections. What are our options for this? Many TIA,...
3
by: Raghu Rudra | last post by:
By default, the machine.config contains following information: <system.net> ....... <connectionManagement> <add address="*" maxconnection="2"/> </connectionManagement> </system.net> This...
2
by: Philip Townsend | last post by:
I have a web an asp.net web app that is periodically experiencing exceptions stating that the connection pool maximum has been reached. I have checked and rechecked all of the code to be sure that...
2
by: John J. Hughes II | last post by:
What is the maximum value for "backlog" when running on Windows 2003 server? It is my impression this value is based on the OS so Windows XP Pro has a maximum value of 10. Based on the document...
5
by: alingsjtu | last post by:
Hello, every body. When execute dynamic generated multiple OPENQUERY statements (which linkes to DB2) in SQLServer, I always got SQL1040N The maximum number of applications is already connected...
1
by: cefrancke | last post by:
I have a Back End database (split) that is on a smokin' hot machine (dual processor, 2 gig RAM, XP Pro SP2) and I'm getting an error that says the database (back end file) is "opened exclusively"...
2
by: Bremanand | last post by:
Hi, If i am having more than two FTP Connection at a time in my C# code it terminates all the connection. If two at a time is working fine. What is the maximum number of connections...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
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
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
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
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,...
0
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...

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.