Protocol Specific Error Codes 78 * * . Sqlstate=08001
Contents |
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing sql30081n sqlstate=08001 and Revenue ManagementMaster Data Management for CommerceOmnichannel sql30081n a communication error has been detected communication protocol being used tcp ip CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and protocol specific error code(s): "*" , "*" , "0". sqlstate=08001 AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive
Protocol Specific Error Code(s) 10061 * * . Sqlstate=08001
ManufacturingMarketingOverviewMarket with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect sql30081n sqlstate=08001 recv ProcurementSelf-Service ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT ManagementOverviewApplication Lifecycle ManagementIT Infrastructure ManagementSecurity SoftwareOverviewApplication and IT Infrastructure SecurityIdentity, Access and Authentication ManagementBrowse by ProductAnalyticsContent and CollaborationCustomer Relationship ManagementData ManagementEnterprise ManagementFinanci
Technology and Trends Enterprise Architecture and EAI ERP Hardware IT Management and Strategy Java Knowledge Management Linux Networking Oracle PeopleSoft Project and Portfolio Management SAP SCM Security Siebel Storage UNIX communication function detecting the error: "selectforconnecttimeout" Visual Basic Web Design and Development Windows < Back CHOOSE A DISCUSSION GROUP Research
Communication Function Detecting The Error Recv
Directory TOPICS Database Hardware Networking SAP Security Web Design MEMBERS Paul_Pedant DACREE MarkDeVries Inside-ERP Inside-CRM VoIP_News MacProTX I_am_the_dragon maxwellarnold Michael
Sqlstate=08001 Sqlcode=-30081
Meyers-Jouan TerryCurran Chris_Day Andrew.S.Baker Ramnath.Awate JoeTorre Craig Borysowich Locutus Dennis Stevenson DukeGanote Richard iudithm mircea_luca Clinton Jones bracke Nikki Klein AbhaiTripathi Adrian_Grigoriu Iqbalyk numbersguyPA RichardChan COMPANIES Compuware ZOHO Corporation Cisco HighJump Software View https://scn.sap.com/thread/625933 All Topics View All Members View All Companies Toolbox for IT Topics Database Groups Ask a New Question DB2 LUW The DB2 LUW (Linux, Unix, Windows) group is for the discussion of technical issues related to the installation, configuration, or daily administration of IBM DB2 LUW databases. Home | Invite Peers | More Database Groups Your account is ready. You're now being signed in. Solve problems http://database.ittoolbox.com/groups/technical-functional/db2-l/connecting-to-a-remote-database-fails-with-sql30081n-a-communication-error-has-been-detected-5610884 - It's Free Create your account in seconds E-mail address is taken If this is your account,sign in here Email address Username Between 5 and 30 characters. No spaces please The Profile Name is already in use Password Notify me of new activity in this group: Real Time Daily Never Keep me informed of the latest: White Papers Newsletter Jobs By clicking "Join Now", you agree to Toolbox for Technology terms of use, and have read and understand our privacy policy. Connecting to a Remote Database Fails With 'SQL30081N A communication error has been detected.' beard asked Oct 22, 2014 | Replies (7) I'm trying to set things up so that I can access a remote database and load data into my local database from it. I want to be able move data from a remote database into my local database using load from cursor. I cataloged the remote environment yet when I test connectivity to the remote source, I get the SQL30081N error. db2 "connect to MRIIN user NINA using *****" SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "192.168.1.28". Communication fu
on db2/portal on https://bytes.com/topic/db2/answers/185400-com-ibm-db2-jdbc-db2exception-ibm-cli-driver-sql30081n-communication-error-db2-portal-aix aix + Ask a Question Need http://dsxchange.com/viewtopic.php?t=97313&sid=f6eb49f8826eb6215100a7537a3157f9 help? Post your question and get tips & solutions from a community of 418,623 IT Pros & Developers. It's quick & easy. COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] SQL30081N communication error on protocol specific DB2/POrtal on AIX P: n/a Praveen Hi, I have installed WebSphere Portal on AIX and connected to DB2 on a remote machine, Getting the followin errors when trying to get the values from database thru applications installed protocol specific error on Portal. Any Help Appreciated. Thanks in advance. Praveen Singh IBM Workplace, India COM.ibm.db2.jdbc.DB2Exception: [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: "9.33.12.221". Communication function detecting the error: "connect". Protocol specific error code(s): "78", "*", "*". SQLSTATE=08001 at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExceptionGenerator.java(Compiled Code)) at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(SQLExceptionGenerator.java(Compiled Code)) at COM.ibm.db2.jdbc.app.DB2Connection.connect(DB2Conn ection.java(Compiled Code)) at COM.ibm.db2.jdbc.app.DB2Connection.
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 top At unix, enter the command "db2 connect to