472,968 Members | 1,530 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Error establishing simultaneous DB connections in UDB 8.1.

Environment: DB2 8.1.4; Windows 2000

We are evaluating the feasibility of upgrading our production DB from
7.2 to 8.1. During this process we've encountered an error when
starting our application program, which establishes several JDBC
connections to the database. However, this problem can be reproduced
in a variety of ways, including using the CLP. Here are the steps
required to reproduce the problem using the command-line processor:

1) Ensure that the DB is running on the server.
2) Open the first instance of the command-line processor on the
server.
3) Open a second instance of the command-line processor on the
server.
4) Enter the following text into each of the command-line processor
instances, WITHOUT pressing enter:
connect to <database> user <username> using <password>
5) Hit the enter key on the first CLP and then quickly hit enter in
the second CLP instance.

In most cases, one or both of the CLP instances will display the
following error:

SQL30082N Attempt to establish connection failed with security reason
"24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001

This error only occurs when attempting to establish simultaneous
connections. If we instead establish one connection in the first CLP
and then establish the second connection in the second CLP instance,
everything works fine.

We have had no such problem with DB27.2. Has anyone else experienced
this problem in 8.1.X? We've been unable to find any related APARs.
Is there a configuration setting that we're missing that will
alleviate this problem?
Nov 12 '05 #1
1 3344
We are on 7.2 EEE AIX and we are often making several virtual
simultaneous connections to DB2 and we get a similar error which is
[IBM][CLI Driver] SQL1403N The username and/or password supplied is
incorrect. SQLSTATE=08004. This doesn't happen all the time and is
very hard to reproduce. We resubmit our job that makes the connection
and it works perfectly the next time. We were never able to figure
this issue out and it still happens occasionally. We never were able
to even come up with a pattern which you apparently have and it sounds
as if maybe this issue is amplified in 8.1.
Spencer Tabbert
se********@hotmail.com (Semaj) wrote in message news:<e4************************@posting.google.co m>...
Environment: DB2 8.1.4; Windows 2000

We are evaluating the feasibility of upgrading our production DB from
7.2 to 8.1. During this process we've encountered an error when
starting our application program, which establishes several JDBC
connections to the database. However, this problem can be reproduced
in a variety of ways, including using the CLP. Here are the steps
required to reproduce the problem using the command-line processor:

1) Ensure that the DB is running on the server.
2) Open the first instance of the command-line processor on the
server.
3) Open a second instance of the command-line processor on the
server.
4) Enter the following text into each of the command-line processor
instances, WITHOUT pressing enter:
connect to <database> user <username> using <password>
5) Hit the enter key on the first CLP and then quickly hit enter in
the second CLP instance.

In most cases, one or both of the CLP instances will display the
following error:

SQL30082N Attempt to establish connection failed with security reason
"24" ("USERNAME AND/OR PASSWORD INVALID"). SQLSTATE=08001

This error only occurs when attempting to establish simultaneous
connections. If we instead establish one connection in the first CLP
and then establish the second connection in the second CLP instance,
everything works fine.

We have had no such problem with DB27.2. Has anyone else experienced
this problem in 8.1.X? We've been unable to find any related APARs.
Is there a configuration setting that we're missing that will
alleviate this problem?

Nov 12 '05 #2

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

Similar topics

1
by: slugger | last post by:
Hope this is not OT: I am running into some strange things whenever my ASP pages send out simultaneous requests to another ASP page which in turn gains access to a MySQL database using a DSNless...
12
by: Dan V. | last post by:
Since an ASP.NET/ADO.NET website is run on the server by a single "asp_net worker process", therefore doesn't that mean that even 50 simultaneous human users of the website would appear to the...
7
by: deltalimagolf | last post by:
I now get the following error message after copying an asp.net application to the deployment web server. I don't have SQLExpress or any version of SQL 2005 installed. I found the "LocalSQLServer"...
1
by: John Shadel | last post by:
I have the following setup: 1. ASP.NET 2.0 web app hosted on a web server (inetpub directory hosting physical files of the web site on a different drive name, E: than the SQL Server Instance,...
0
by: Tor Inge Rislaa | last post by:
Just for testing deployment of an asp.net application to the remote server I have crated an application based on the StarterKit application in Visual Studio 2005. When trying to run the...
5
by: James | last post by:
Hello, I have written a simple logon page that redirects to another page when successful. All works fine on my computer but when I upload it I get the error message below. I have written it...
1
by: NEWS | last post by:
My application is giving error .pls help . error : Server Error in '/webpdms' Application. -------------------------------------------------------------------------------- An error has...
0
by: aboutjav.com | last post by:
Hi, I need some help. I am getting this error after I complete the asp.net register control and click on the continue button. It crashed when it tries to get it calls this Profile property ...
5
by: Cirene | last post by:
I just deployed my new ASP.NET (3.5 FW) site to the hosting company I'm using, webhost4life. NOTE: I HAVE deployed other SQL Server sites to the same account with no issues. Now I'm getting...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
1
by: Teri B | last post by:
Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...

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.