View previous topic :: View next topic
|
Author |
Message |
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Hi,
A query is executed on a ASP webpage. Usually it returns the RESULTSET. It returned an error like this on the webpage.
Code: |
Error Occurred -: SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "10.12.9.100". Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001 |
I googled and found out this is error is Returned by DB2 CONNECT Product
Error Tech Spec
Communication Protocol : TCP/IP
Interface : SOCKETS
Location : 10.12.9.100
Communication Function : connect
Protocol Specific RC's : 10060", "*", "*"
I want to know, what are the possible way to resolve this error.
Help ME |
|
Back to top |
|
|
Prasanthhere
Active User
Joined: 03 Aug 2005 Posts: 306
|
|
|
|
We had a similar type of this issue previously at that time it was due to autentication/ security failure . The password used to connect to the server got expired.
If you were able to login previously through that ASP page you can talk to your DBA . |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
No, i asked him already is there any autentication and security problems. He said "this is not that".
He just said "ASP server error, it will automatically resolve in an hour or two".
Recently this is happening lot of times. For that reason, i want know "HOW TO RESOLVE IT" or "ANY POSSIBLE SOLUTION". Which i can suggest.... |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Quote: |
"ASP server error, it will automatically resolve in an hour or two".
|
If it automatically resolves after some time, it is probably not permissions/authorizations. It is more likely server/network instability or some timeout.
If the timeout is due to some very poor performing queries, you may be able to help by improving the queries. If it is not db2 backlog causing the timeout (if it is a timeout), you will need to have the other components investigated/fixed. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
Yes D.sch. This is due to time out. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
It may be a good time to work with the dba to identify some long-running queries.
Two rather harmful possibilities are queries that perform a full table scan or queries that generate a cartesian product. Either can have a major impact on a production multi-user environment. |
|
Back to top |
|
|
sushanth bobby
Senior Member
Joined: 29 Jul 2008 Posts: 1020 Location: India
|
|
|
|
OK. I will see that " CARTESIAN PRODUCT & FULL TABLE SCAN"
THANK YOU. |
|
Back to top |
|
|
|