Home > protocol specific > protocol specific error 10061

Protocol Specific Error 10061

Contents

connecting Controller application server to DB2 database server Technote (troubleshooting) Problem(Abstract) Administrator is trying to test communication between the Controller application sql30081n a communication error has been detected. sqlstate=08001 server and the DB2 database server. For example, administrator opens a command

Ibm Cli Driver Sql30081n A Communication Error Has Been Detected

prompt (D:\Program Files\IBM\SQLLIB\BIN) and runs a command similar to: db2 connect to user using . Administrator protocol specific error code(s): "*", "*", "0". sqlstate=08001 receives error message. Symptom 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

Communication Function Detecting The Error: "selectforconnecttimeout"

function detecting the error: "connect". Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001 Cause DB2 server's firewall preventing communication from remote (application server) device. Diagnosing the problem Try connecting to the DB2 server (from the application server) using the command "telnet". If there is an error "Connecting To ...Could not open connection to the host, on port 50000: Connect failed" communication function detecting the error: "recv" then it is an indication that there is a firewall blocking communication. Instead, if everything is working correctly, then the screen *should* change instantly to black. Example: Assuming that the DB2 server is running on the default TCP port (50000) then the command would be: telnet 50000 Resolving the problem Reconfigure the Windows firewall (running on the DB2 server) to allow communication in via the DB2 TCP port (default = 50000). Steps: 1. Logon to the DB2 server as an administrator 2. Launch "Control Panel\System and Security\Windows Firewall" 3. Click "Advanced settings": 4. Click "New Rule" 5. Choose "Port": 6. Choose TCP and 50000 (if necessary modify this value to match your specific settings) 7. Choose "Allow the Connection": 8. Ensure that all locations are ticked: 9. Name the rule appropriately: 10. Click ' Finish' and test. Related information 1499220 - Error connecting to DB2 database. SQL30081N A 1164785 - SQL30081N TCPIP communication errors Document information More support for: Cognos Controller Controller Software version: 8.5.1, 10.1, 10.1.1 Operating system(s): Windows Reference #: 1503305 Modified date: 21 June

check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to http://www.dbforums.com/showthread.php?337623-IBM-CLI-Driver-SQL30081N visit from the selection below. Results 1 to 14 of 14 Thread: [IBM][CLI Driver] SQL30081N Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 03-29-02,04:13 #1 msalvador View Profile View Forum Posts Registered User Join Date Mar 2002 Posts 2 Unanswered: [IBM][CLI Driver] SQL30081N Microsoft OLE DB Provider for ODBC Drivers error '80004005' [IBM][CLI Driver] SQL30081N protocol specific 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): "10060", "*", "*". SQLSTATE=08001 /selfscan/sswadmin/menus/exec/cmsea.asp, line 1908 This error appear when i try to open a connection. But what does it means Reply With Quote 04-02-02,13:47 #2 ljrong View Profile View Forum Posts Registered User Join Date Jan 2002 Location protocol specific error USA Posts 53 you must use Db2 update dbm cfg using svcename service_name to setup your correct servicename. Reply With Quote 02-04-03,15:27 #3 darrentk View Profile View Forum Posts Registered User Join Date Feb 2003 Posts 5 What did you update the service name to, or where do i find that out? Originally posted by ljrong you must use Db2 update dbm cfg using svcename service_name to setup your correct servicename. Reply With Quote 02-05-03,05:39 #4 sathyaram_s View Profile View Forum Posts Visit Homepage Super Moderator Join Date Aug 2001 Location UK Posts 4,650 You will have to define a service/port in /etc/services file ... Eg ... db2cdb2inst1 50000 db2idb2inst1 50001 and then db2 update dbm cfg using svcename db2cdb2inst1 or you can do db2 update dbm cfg using svcename 50000 without adding anything to /etc/services ... Technically speaking, using either makes no difference ... But my recommendation is to use the first method as it provides better documentation of the ports used on your system ... HTH Sathyaram Originally posted by darrentk What did you update the service name to, or where do i find that out? Reply With Quote 02-05-03,15:22 #5 darrentk View Profile View Forum Posts Registered User Join Date Feb 2003 Posts 5 sathyaram_s This was done on the installation. Did you hav

 

Related content

30081 error

Error table id toc tbody tr td div id toctitle Contents div ul li a href Protocol Specific Error Code s Sqlstate a li li a href Communication Function Detecting The Error Recv a li li a href Sql n Sqlstate Recv a li ul td tr tbody table p p p p p p

been being communication communication detected error has protocol sql30081n used

Been Being Communication Communication Detected Error Has Protocol Sql n Used table id toc tbody tr td div id toctitle Contents div ul li a href Protocol Specific Error Code s Sqlstate a li li a href Sql n a li li a href Protocol Specific Error Code s Sqlstate a li li a href Sql n Sqlstate Recv a li ul td tr tbody table p errors SQL SQL N - Technote FAQ Question This relatedl document lists SQL N TCP IP communication protocol errors and p h id Protocol Specific Error Code s Sqlstate p recommended action plans

connect protocol specific error code s 10061

Connect Protocol Specific Error Code S table id toc tbody tr td div id toctitle Contents div ul li a href Protocol Specific Error Code s Sqlstate a li li a href Communication Function Detecting The Error selectforconnecttimeout a li li a href Sql n Sqlstate Recv a li ul td tr tbody table p errors SQL SQL N - Technote FAQ Question This document lists SQL N relatedl TCP IP communication protocol errors and recommended action plans protocol specific error code s sqlstate associated with them Cause The communication protocol errors depend on the platform p h id Protocol

db2 protocol specific error codes 10061

Db Protocol Specific Error Codes table id toc tbody tr td div id toctitle Contents div ul li a href Protocol Specific Error Code s Sqlstate a li li a href Sql n Db a li li a href Communication Function Detecting The Error Recv a li ul td tr tbody table p p p connecting Controller application server to DB database server Technote troubleshooting Problem Abstract Administrator is trying to test relatedl communication between the Controller application server and the DB p h id Communication Function Detecting The Error Recv p database server For example administrator opens a command

db2 protocol error

Db Protocol Error table id toc tbody tr td div id toctitle Contents div ul li a href Db Protocol Specific Error Code s Sqlstate a li li a href ibm cli Driver Sql n A Communication Error Has Been Detected a li li a href Communication Function Detecting The Error selectforconnecttimeout a li ul td tr tbody table p connecting Controller application server to DB database server Technote relatedl troubleshooting Problem Abstract Administrator is trying to test communication db protocol specific error code s sqlstate between the Controller application server and the DB database server For p h id

db2 protocol specific error 10061

Db Protocol Specific Error table id toc tbody tr td div id toctitle Contents div ul li a href Protocol Specific Error Code s Sqlstate a li li a href Sql n A Communication Error Has Been Detected a li li a href Sql n Db a li li a href Communication Function Detecting The Error Recv a li ul td tr tbody table p errors SQL SQL N - Technote FAQ Question This document lists SQL N TCP IP communication protocol errors and relatedl recommended action plans associated with them Cause The communication p h id Protocol Specific Error

db2 error 10060

Db Error table id toc tbody tr td div id toctitle Contents div ul li a href Protocol Specific Error Code s Sqlstate a li li a href Communication Function Detecting The Error selectforconnecttimeout a li li a href Db Sql n Recv a li li a href Sql n Sqlstate Recv a li ul td tr tbody table p connecting Controller application server to DB database server Technote troubleshooting Problem Abstract Administrator is trying to relatedl test communication between the Controller application server and the sql n a communication error has been detected DB database server For example administrator

db2 protocol specific error codes 111

Db Protocol Specific Error Codes table id toc tbody tr td div id toctitle Contents div ul li a href Protocol Specific Error Code s Sqlstate a li li a href Protocol Specific Error Code s Sqlstate a li li a href Communication Function Detecting The Error selectforconnecttimeout a li ul td tr tbody table p errors SQL SQL N - Technote relatedl FAQ Question This document lists SQL N TCP IP db sql n sqlstate communication protocol errors and recommended action plans associated with them p h id Protocol Specific Error Code s Sqlstate p Cause The communication protocol

db2 protocol specific error codes 10061 * * . sqlstate=08001

Db Protocol Specific Error Codes Sqlstate table id toc tbody tr td div id toctitle Contents div ul li a href Sql n Sqlstate Recv a li li a href Communication Function Detecting The Error selectforconnecttimeout a li ul td tr tbody table p connecting Controller application server to DB database relatedl server Technote troubleshooting Problem Abstract Administrator is trying to sql n sqlstate test communication between the Controller application server and the DB database protocol specific error code s sqlstate server For example administrator opens a command prompt D Program Files IBM SQLLIB BIN and runs a command similar

error code=-30081 sqlstate=08001

Error Code - Sqlstate table id toc tbody tr td div id toctitle Contents div ul li a href Protocol Specific Error Code s Sqlstate a li li a href Sql n A Communication Error Has Been Detected a li li a href Communication Function Detecting The Error selectforconnecttimeout a li li a href Communication Function Detecting The Error Recv a li ul td tr tbody table p connecting Controller application server to DB database server Technote troubleshooting Problem Abstract Administrator is trying to relatedl test communication between the Controller application server and the p h id Protocol Specific Error

protocol specific error code sqlstate=08001

Protocol Specific Error Code Sqlstate table id toc tbody tr td div id toctitle Contents div ul li a href Protocol Specific Error Code s Sqlstate a li li a href Sql n Sqlstate Recv a li li a href Protocol Specific Error Code s Sqlstate a li ul td tr tbody table p connecting Controller application server to DB database server Technote troubleshooting Problem Abstract Administrator relatedl is trying to test communication between the Controller sql n a communication error has been detected sqlstate application server and the DB database server For example administrator opens a p h id

protocol specific error codes 10060

Protocol Specific Error Codes table id toc tbody tr td div id toctitle Contents div ul li a href Sql n A Communication Error Has Been Detected Sqlstate a li li a href Protocol Specific Error Code s Sqlstate a li li a href Communication Function Detecting The Error recv a li li a href Sql n Sqlstate Recv a li ul td tr tbody table p errors SQL SQL N - relatedl Technote FAQ Question This document lists SQL N TCP IP p h id Sql n A Communication Error Has Been Detected Sqlstate p communication protocol errors and

protocol specific error codes 10053 sqlstate 08001

Protocol Specific Error Codes Sqlstate table id toc tbody tr td div id toctitle Contents div ul li a href Sql n A Communication Error Has Been Detected Communication Protocol Being Used Tcp Ip a li li a href Protocol Specific Error Code s Sqlstate a li li a href Protocol Specific Error Code s Sqlstate a li ul td tr tbody table p sql n RC QUERYTIMEOUTINTERVAL Technote troubleshooting Problem Abstract Client applications fail with relatedl error IBM CLI Driver SQL N A communication error has sql n sqlstate been detected Communication protocol being used TCP IP Communication API

protocol specific error codes 10054 * 0 . sqlstate=08001

Protocol Specific Error Codes Sqlstate p for Linux Unix and Windows Forum lrm Topic JDBC Driver Seems to Hang After Some UseThis topic has been locked reply Latest Post - x f - - T Z by SystemAdmin Display ConversationsBy Date relatedl - of Previous Next SystemAdmin D XK Posts Pinned topic JDBC Driver Seems to Hang After Some Use x f - - T Z Tags Answered question This question has been answered Unanswered question This question has not been answered yet Hello I've recently implemented a web application on IPlanet that uses DB and the COM ibm db

protocol specific error code is 10061

Protocol Specific Error Code Is table id toc tbody tr td div id toctitle Contents div ul li a href Ibm Cli Driver Sql n A Communication Error Has Been Detected a li li a href Protocol Specific Error Code s Sqlstate a li li a href Communication Function Detecting The Error Recv a li ul td tr tbody table p errors SQL SQL N - Technote FAQ Question This document lists SQL N TCP IP communication protocol errors and recommended action relatedl plans associated with them Cause The communication protocol errors sql n a communication error has been detected

protocol specific error codes 10054

Protocol Specific Error Codes table id toc tbody tr td div id toctitle Contents div ul li a href Communication Function Detecting The Error Recv a li li a href Sql n Sqlstate Recv a li ul td tr tbody table p to check out the FAQ by clicking the link above You may have to relatedl register before you can post click the register link sql n a communication error has been detected sqlstate above to proceed To start viewing messages select the forum that you protocol specific error code s sqlstate want to visit from the selection below

protocol specific error code 10061 sqlstate 08001

Protocol Specific Error Code Sqlstate table id toc tbody tr td div id toctitle Contents div ul li a href Sql n A Communication Error Has Been Detected Sqlstate a li li a href Sql n A Communication Error Has Been Detected Communication Protocol Being Used Tcp Ip a li li a href Communication Function Detecting The Error recv a li li a href Sql n Db a li ul td tr tbody table p errors SQL SQL N - Technote FAQ Question relatedl This document lists SQL N TCP IP communication protocol errors p h id Sql n A

protocol specific error code s 10060 sqlstate 08001 db2

Protocol Specific Error Code S Sqlstate Db table id toc tbody tr td div id toctitle Contents div ul li a href Sql n Db a li li a href Protocol Specific Error Code s Sqlstate a li li a href Communication Function Detecting The Error selectforconnecttimeout a li li a href Communication Function Detecting The Error Recv a li ul td tr tbody table p errors SQL SQL N - Technote FAQ Question relatedl This document lists SQL N TCP IP communication protocol errors sql n a communication error has been detected and recommended action plans associated with them

protocol specific error codes 10061

Protocol Specific Error Codes table id toc tbody tr td div id toctitle Contents div ul li a href Sql n A Communication Error Has Been Detected Communication Protocol Being Used Tcp Ip a li li a href Protocol Specific Error Code s Sqlstate a li li a href Protocol Specific Error Code s Sqlstate a li ul td tr tbody table p errors SQL SQL N - Technote FAQ Question This document lists SQL N relatedl TCP IP communication protocol errors and recommended action plans sql n a communication error has been detected sqlstate associated with them Cause The

protocol specific error code s 10061

Protocol Specific Error Code S table id toc tbody tr td div id toctitle Contents div ul li a href Protocol Specific Error Code s Sqlstate a li li a href Communication Function Detecting The Error selectforconnecttimeout a li li a href Sql n a li ul td tr tbody table p connecting Controller application server to DB database server Technote troubleshooting relatedl Problem Abstract Administrator is trying to test communication between sql n a communication error has been detected sqlstate the Controller application server and the DB database server For example administrator sql n a communication error has been

protocol specific error codes s tcp ip

Protocol Specific Error Codes S Tcp Ip table id toc tbody tr td div id toctitle Contents div ul li a href Ibm Cli Driver Sql n A Communication Error Has Been Detected a li li a href Protocol Specific Error Code s Sqlstate a li li a href Communication Function Detecting The Error recv a li ul td tr tbody table p errors SQL SQL N - Technote FAQ Question This document lists SQL N TCP IP communication protocol errors and recommended action plans associated relatedl with them Cause The communication protocol errors depend on the sql n a

protocol specific error codes 10061 * * . sqlstate=08001

Protocol Specific Error Codes Sqlstate p Post your question and get tips solutions from a community relatedl of IT Pros Developers It's quick easy Error connecting to V remote database P n a mairhtin o'feannag Hello I'm having problems connecting to my new v db box The pertinent information is below DB db inst tcp DB db inst tcp DB db inst tcp DB db inst END tcp TCP IP Service name SVCENAME DB db inst db inst mairhtin db dump db set AUTOSTART yes DB COMM tcpip SQL N A communication error has been detected Communication protocol being used

protocol specific error codess tcp/ip sockets

Protocol Specific Error Codess Tcp ip Sockets table id toc tbody tr td div id toctitle Contents div ul li a href Protocol Specific Error Code s Sqlstate a li li a href Protocol Specific Error Code s Sqlstate a li li a href Communication Function Detecting The Error recv a li li a href Protocol Specific Error Code s Sqlstate a li ul td tr tbody table p errors SQL SQL N - Technote FAQ Question This document lists SQL N TCP IP communication protocol errors and recommended action relatedl plans associated with them Cause The communication protocol errors

protocol specific error codes 104

Protocol Specific Error Codes table id toc tbody tr td div id toctitle Contents div ul li a href Protocol Specific Error Code s Sqlstate a li li a href Communication Function Detecting The Error recv a li li a href Db Sql n a li ul td tr tbody table p p p p p Technology and Trends Enterprise Architecture and EAI relatedl ERP Hardware IT Management and Strategy Java a href http database ittoolbox com groups technical-functional db -l error-sql n-a-communication-error-has-been-detected-communication-protocol-being-used-tcpip- http database ittoolbox com groups technical-functional db -l error-sql n-a-communication-error-has-been-detected-communication-protocol-being-used-tcpip- a Knowledge Management Linux Networking Oracle PeopleSoft

protocol specific error codes 10061 * * . sqlstate=08001 sqlcode=-30081

Protocol Specific Error Codes Sqlstate Sqlcode - p Google p p Google p p Server R While relatedl running Configuration Assistant VERY FIRST TIME i'm not a href http www databaseuser info post api assistant being catalog cataloged center cfg cli client communication configuration configured connect connecting connection db cdb inst db comm db set dbm detected detecting http www databaseuser info post api assistant being catalog cataloged center cfg cli client communication configuration configured connect connecting connection db cdb inst db comm db set dbm detected detecting a able to connect to the remote db server Below error a

protocol specific error codes 111

Protocol Specific Error Codes table id toc tbody tr td div id toctitle Contents div ul li a href Protocol Specific Error Code s Sqlstate a li li a href Communication Protocol Being Used Tcp ip Communication Api Being Used Sockets a li li a href Communication Function Detecting The Error selectforconnecttimeout a li li a href Sql n a li ul td tr tbody table p p p p p and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing and Revenue ManagementMaster Data Management for CommerceOmnichannel CommerceFinanceOverviewAccounting a href http www dbforums com showthread php -Error-while-cataloging-remote-database http www dbforums com showthread

protocol specific error codes s tcp ip sockets db2connectioncorrelator

Protocol Specific Error Codes S Tcp Ip Sockets Db connectioncorrelator table id toc tbody tr td div id toctitle Contents div ul li a href Validationquery Select a li li a href Testonborrow a li ul td tr tbody table p for Linux relatedl Unix and Windows Forum lrm validation query Topic HELP Error trying to connect to p h id Validationquery Select p DB This topic has been locked replies Latest Post - x f - - T Z p h id Testonborrow p by SystemAdmin Display ConversationsBy Date - of Previous Next SystemAdmin D XK Posts Pinned topic

protocol specific error codes 78 * * . sqlstate=08001

Protocol Specific Error Codes Sqlstate table id toc tbody tr td div id toctitle Contents div ul li a href Protocol Specific Error Code s Sqlstate a li li a href Communication Function Detecting The Error Recv a li li a href Sqlstate Sqlcode - a li ul td tr tbody table p and relatedl SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing sql n sqlstate and Revenue ManagementMaster Data Management for CommerceOmnichannel sql n 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

protocol specific error codess tcp/ip sockets db2connectioncorrelator

Protocol Specific Error Codess Tcp ip Sockets Db connectioncorrelator p for Linux Unix and relatedl Windows Forum lrm Topic HELP Error trying to connect to DB This topic has been locked replies Latest Post - x f - - T Z by SystemAdmin Display ConversationsBy Date - of Previous Next SystemAdmin D XK Posts Pinned topic HELP Error trying to connect to DB x f - - T Z Tags Answered question This question has been answered Unanswered question This question has not been answered yet Hi I get this error when i try to connect to my database com

protocol specific error codes 113

Protocol Specific Error Codes p for Linux Unix and Windows Forum lrm Topic SQL N error in client connect to DB serverThis topic has been locked relatedl No replies Display ConversationsBy Date - of Previous Next yangwtao B N Post Pinned topic SQL N error in client connect to DB server x f - - T Z Tags Answered question This question has been answered Unanswered question This question has not been answered yet I am a new comer to DB The problem DB v express-c installed on both server and client OS are Enterprise Linux catalog node and DB

protocol specific error codes 10060 * * . sqlstate=08001

Protocol Specific Error Codes Sqlstate p ManagementTechnical library Simulating Massively Parallel Database Processing on Linux In spite of what you may think MPP does not have to stand for relatedl massive purchase price You can explore massively parallel processing MPP database technology on a single laptop using DB for Linux This article describes how to set up a simulated MPP environment and create partitioned tables Share Marty Lurie lurie us ibm com Systems Engineer IBM Close x Marty Lurie started his computer career generating chads while attempting to write Fortran on an IBM His day job is in Systems Engineering

protocol specific error codes 78

Protocol Specific Error Codes table id toc tbody tr td div id toctitle Contents div ul li a href Protocol Specific Error Code s Sqlstate a li li a href Communication Function Detecting The Error selectforconnecttimeout a li li a href Sql n Sqlstate Recv a li ul td tr tbody table p errors SQL SQL N - Technote FAQ Question relatedl This document lists SQL N TCP IP communication protocol errors sql n a communication error has been detected sqlstate and recommended action plans associated with them Cause The communication protocol protocol specific error code s sqlstate errors depend

protocol specific error codes 10048

Protocol Specific Error Codes table id toc tbody tr td div id toctitle Contents div ul li a href Communication Function Detecting The Error selectforconnecttimeout a li li a href Socket Error Codes Linux a li li a href Socket Error Connection Reset By Peer a li ul td tr tbody table p errors SQL SQL N - Technote relatedl FAQ Question This document lists SQL N TCP IP sql n a communication error has been detected sqlstate communication protocol errors and recommended action plans associated with them protocol specific error code s sqlstate Cause The communication protocol errors depend

protocol specific error codes 10053

Protocol Specific Error Codes table id toc tbody tr td div id toctitle Contents div ul li a href Sql n A Communication Error Has Been Detected Sqlstate a li li a href Protocol Specific Error Code s Sqlstate a li li a href Sql n Sqlstate Recv a li li a href Db Sql n a li ul td tr tbody table p sql n RC QUERYTIMEOUTINTERVAL Technote troubleshooting Problem Abstract Client applications fail with relatedl error IBM CLI Driver SQL N A communication error has p h id Sql n A Communication Error Has Been Detected Sqlstate p