473,226 Members | 1,573 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,226 software developers and data experts.

DB2Connect V.8

Hello all!

Does anybody use DB2Connect on United Linux 1.0 We have the following
Problem:

The DB2Connect Software enables access from DB2 Clients (e.g. for
connecting Application Servers to Databases) to
to DB2 Databases on Z/oS Systems. You can say that DB2Connect works as
a gateway.

At the moment we can't open more then 1100 parallel connections per
DB2Connect installation. But doing the same on AIX 4000 - 5000
connections are possible at the same time.
At the moment, suing United Linux 1.0 reach 1100 Connections then the
whole machine hangs and must be rebooted. We don't achieve the CPU and
RAM limits.

Are there e.g. any kernel parameters that limit the number of parallel
calls to a Server ?? We are using kernel 2.4.21!
First of all, we get a sempahore error, but after changing the values
in sysctl.conf, the were no further errors.

Is it possible, that Linux can't handle more then 1000 parallel
connections? I don't hope so.

Thanks for answering!

Nov 12 '05 #1
3 1460
<up*********@vrweb.de> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...
Hello all!

Does anybody use DB2Connect on United Linux 1.0 We have the following
Problem:

The DB2Connect Software enables access from DB2 Clients (e.g. for
connecting Application Servers to Databases) to
to DB2 Databases on Z/oS Systems. You can say that DB2Connect works as
a gateway.

At the moment we can't open more then 1100 parallel connections per
DB2Connect installation. But doing the same on AIX 4000 - 5000
connections are possible at the same time.
At the moment, suing United Linux 1.0 reach 1100 Connections then the
whole machine hangs and must be rebooted. We don't achieve the CPU and
RAM limits.

Are there e.g. any kernel parameters that limit the number of parallel
calls to a Server ?? We are using kernel 2.4.21!
First of all, we get a sempahore error, but after changing the values
in sysctl.conf, the were no further errors.

Is it possible, that Linux can't handle more then 1000 parallel
connections? I don't hope so.

Thanks for answering!

Just a wild guess, but try increasing the kernel.msgmni parm in the
/etc/sysctl.conf:

kernel.msgmni = nnnn
Nov 12 '05 #2
The standard value for kernel.msgmni is set to 1024. We had changed to
2048 and 4096, but the number of connections didn't increase

Thanks!

Nov 12 '05 #3
What is the exact error msg that you receive for the connection atttemps
beyond 1100?

Larry Edelstein

up*********@vrweb.de wrote:
Hello all!

Does anybody use DB2Connect on United Linux 1.0 We have the following
Problem:

The DB2Connect Software enables access from DB2 Clients (e.g. for
connecting Application Servers to Databases) to
to DB2 Databases on Z/oS Systems. You can say that DB2Connect works as
a gateway.

At the moment we can't open more then 1100 parallel connections per
DB2Connect installation. But doing the same on AIX 4000 - 5000
connections are possible at the same time.
At the moment, suing United Linux 1.0 reach 1100 Connections then the
whole machine hangs and must be rebooted. We don't achieve the CPU and
RAM limits.

Are there e.g. any kernel parameters that limit the number of parallel
calls to a Server ?? We are using kernel 2.4.21!
First of all, we get a sempahore error, but after changing the values
in sysctl.conf, the were no further errors.

Is it possible, that Linux can't handle more then 1000 parallel
connections? I don't hope so.

Thanks for answering!

Nov 12 '05 #4

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

Similar topics

3
by: Niklas Södergren | last post by:
Hi, I have downloaded DB2 UDB v8.1 PDE for Windows from the IBM Website. Now, I am trying to connect to our iSeries OS/400 Server. But it gives the following error: SQL8002N Connect...
4
by: Kona | last post by:
Hello, I would like to known if it is possible to limit acces to a UDB database on Solaris system through db2connect to only specified clients ? My client is a db2connect on Windows platform. ...
3
by: Kona | last post by:
Hello, Do I need db2connect to connect an ODBC client application (Windows) to a DB2 database on a Unix platform (SUN) ?
0
by: Andreas Schmied | last post by:
Hello, I have a probleme with the db2connect, hope someone can help me. A Javaprogramm connect to the db2 with db2connect and the ibm db2class. Now i need to check if the pw is expired or not,...
1
by: lfo | last post by:
Hello, I use the db2connect of Aix 5.2 to communicate with AS/400 and I have the error message common_communication sqlcctcpconnr Probe:110 DIA3202C The TCP/IP call "connect" returned an...
2
by: Valentin via DBMonster.com | last post by:
Hello, this is my db2icrt.log.xxxxx: ------------------------------------------------------ Program name = db2idbm Instance home dir = /home/db2inst1, Sysadm group = db2iadm1 Instance type =...
0
by: anokun7 | last post by:
We are using DB2 v7 on OS/390. I have installed db2connect enterprise on my local windows XP box. Using db2connect I have created a dsn and could successfully connect using the DB2 control...
0
by: MAHALINGAMJ | last post by:
My stored proc in DB2 version 9 is failing to return CURSOR. I am using DB2connect. Would appreciate any help on this. CLI window error: db2 => call TST_SCH.PR_TST_RETURN_CURSOR(1) SQL1224N ...
0
by: Gaurav3187 | last post by:
I need to know, what are the prerequisites to be completed in order to install db2connect Version 9.5 FP2? E.g. I need this for Windows, AIX, Solaris and LINUX all the OS
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

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.