Protocol Specific Error Codes 78
Contents |
errors; 30081; SQL30081; SQL30081N; 30081; -30081 Technote (FAQ) Question This document lists SQL30081N TCP/IP communication protocol errors sql30081n a communication error has been detected. sqlstate=08001 and recommended action plans associated with them. Cause The communication protocol protocol specific error code(s): "*", "*", "0". sqlstate=08001 errors depend on the platform you are working on. Each protocol error has its own definition
Protocol Specific Error Code(s) 10061 * * . Sqlstate=08001
and corresponding action plan. Answer For further discussion on this topic, visit this developerWorks forum thread: https://www.ibm.com/developerworks/community/forums/html/topic?id=cceab3ae-4dd4-425a-af81-0b4e3f965ee2 Problem Details The SQL30081N error message has the following format:
Communication Function Detecting The Error: "selectforconnecttimeout"
SQL30081N A communication error has been detected. Communication protocol being used: protocol . Communication API being used: interface . Location where the error was detected: location . Communication function detecting the error: function . Protocol specific error code(s): rc1 , rc2 , rc3 For example: SQL30081N A communication error has been detected. Communication protocol being communication function detecting the error recv used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "". Communication function detecting the error: "connect". Protocol specific error code(s): "111", "*", "*". The following table lists protocol specific errors that can occur on different platforms and the corresponding action plans to resolve these errors. If the error code is not listed in the table, search the operating system documentation /usr/include/errno.h (Linux/UNIX) or System Error Codes (Windows). Windows AIX SUN HP Linux Short Name Action Plan 10061 79 146 239 111 ECONNREFUSED Connection Refused Client attempts to establish a connection to server using an invalid IP or port. Check on server side: DB2 environment variable DB2COMM is set such as: DB2COMM=TCPIP DBM CFG's SVCENAME is set to the instance's port number or service name. The command to update this parameter is: "db2 update dbm cfg using svcename
Events Forums DB2-LDB2-L ArchivesNA ConferenceEMEA Conference Resources BlogsIDUG eBulletinIDUG NewsroomCommunitiesRegional User Groups Articles&Content IDUG Content ArticlesTech ChannelBeginner's BlogDB2 Hot Topics BlogContent LibraryIDUG YouTubePast Conference ContentCodeplace Library GetInvolved Volunteering with IDUGVolunteer PositionsJoin a Regional User GroupBecome an http://www.idug.org/p/fo/et/thread=25712 IDUG MentorSponsorship OpportunitiesJoin a CommunitySpeaker Community [LUW] Problems with nodes Aurora Emanuela Dell'Anno [LUW] Problems with nodes November 22, 2007 08:38 AM Hi guys, Am trying to replicate an http://dsxchange.com/viewtopic.php?t=97313&sid=f6eb49f8826eb6215100a7537a3157f9 instance on a new server, and in the DB2 application client server, I am having problems with cataloguing the node - I have catalogued the new node but am protocol specific having problems connecting to the db. Here is my output - does it give you any ideas on what I have done wrong please? Thanks in advance. Aurora $ db2 list db directory System Database Directory Number of entries in the directory = 2 Database 1 entry: Database alias = VDSA3CH1 Database name = VDSA3CH1 Node name = ND18VSA3 protocol specific error Database release level = a.00 Comment = Directory entry type = Remote Authentication = SERVER_ENCRYPT Catalog database partition number = -1 Alternate server hostname = Alternate server port number = Database 2 entry: Database alias = VDSA3DK1 Database name = VDSA3DK1 Node name = ND18VSA3 Database release level = a.00 Comment = Directory entry type = Remote Authentication = SERVER_ENCRYPT Catalog database partition number = -1 Alternate server hostname = Alternate server port number = [login to unmask email] /db2/db2insv1 $ db2 connect to VDSA3DK1 SQL1097N The node name was not found in the node directory. SQLSTATE=42720 [login to unmask email] /db2/db2insv1 $ db2 list node directory Node Directory Number of entries in the directory = 2 Node 1 entry: Node name = DOCEURV Comment = Directory entry type = LOCAL Protocol = TCPIP Hostname = 160.213.137.155 Service name = 50000 Node 2 entry: Node name = ND18VSA3 Comment = Directory entry type = LOCAL Protocol = TCPIP Hostname = hqadbd18.ctr.nestle.com Service name = 60000 [login to unmask email] /db2/db2insv1 $ IMPORTANT NOTICE: I
next topic View previous topic Add To Favorites This topic has been marked "Resolved." This topic is not resolved, but there is a WORKAROUND. Post new topic Reply to topic DSXchange Forum Index » IBM® Infosphere DataStage Server Edition Author Message kreddy Participant Joined: 30 Sep 2005 Posts: 12 Points: 129 Posted: Mon Dec 19, 2005 10:35 am Reply with quote Back to top DataStage Release: 7x Job Type: Server OS: Unix Hi, My job was running fine until yesterday. It suddenly started showing this error today morning. I did not change any of my usernames and passwords. EdwMedStatExtr..EDW: [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "". Communication function detecting the error: "connect". Protocol specific error code(s): "78", "*", "*". SQLSTATE=08001 Unable to connect to DB2 server 'edw_prod'. and i found a similar post in the forum but the reply was bit obscure and also I tried to connect to DB2 through command center it s connecting fine. Any suggestions ..plz and thanks in advance View user's profile Send private message ArndW Participant Group memberships:Premium Members, Inner Circle, Australia Usergroup Joined: 16 Nov 2004 Posts: 16257 Location: Germany Points: 92174 Posted: Mon Dec 19, 2005 10:39 am Reply with quote Back to top Can you connect from the UNIX shell using db2 connect and the same parameters you are using in the job. _________________ View user's profile Send private message Send e-mail Visit poster's website Rate this response: 0 1 2 3 4 5 Not yet rated kreddy Participant Joined: 30 Sep 2005 Posts: 12 Points: 129 Posted: Mon Dec 19, 2005 11:12 am Reply with quote Back to top hw to do that? never done it before View user's profile Send private message Rate this response: 0 1 2 3 4 5 Not yet rated ArndW Participant Group memberships:Premium Members, Inner Circle, Australia Usergroup Joined: 16 Nov 2004 Posts: 16257 Location: Germany Points: 92174 Posted: Mon Dec 19, 2005 11:23 am Reply with quote Back to to