Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
DB2 CONNECT error

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Sep 29, 2008 11:12 am    Post subject: DB2 CONNECT error
Reply with quote

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
View user's profile Send private message

Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Mon Sep 29, 2008 11:21 am    Post subject: Reply to: DB2 CONNECT error
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Mon Sep 29, 2008 11:26 am    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Sep 29, 2008 11:42 pm    Post subject:
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Sep 30, 2008 9:46 am    Post subject:
Reply with quote

Yes D.sch. This is due to time out.
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Sep 30, 2008 11:00 am    Post subject:
Reply with quote

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
View user's profile Send private message
sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Tue Sep 30, 2008 11:02 am    Post subject:
Reply with quote

OK. I will see that " CARTESIAN PRODUCT & FULL TABLE SCAN"

THANK YOU.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 0 Mon Sep 18, 2017 4:31 pm
No new posts Reply MQ open error Vignesh Sid COBOL Programming 5 Thu Sep 07, 2017 6:02 pm
No new posts Error in SQL-PLIST3 'Above value tru... rikdeb DB2 4 Wed Sep 06, 2017 1:34 pm
No new posts WER268A OUTREC STATEMENT : SYNTAX E... frozenblood87 SYNCSORT 12 Sat Aug 26, 2017 9:45 pm
No new posts DB2 Program abending without giving a... rahulgarg14 DB2 7 Mon May 29, 2017 8:10 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us