Read Error Occurred During Connection Attempt Informix
OAT OAT; 27001; connection; error; failed Technote (troubleshooting) Problem(Abstract) After installing OAT, running the StartApache script and attempting a new connection with OAT, you receive the following error: Connection Failed: -27001 [Informix][Informix ODBC Driver][Informix]Read error occurred during connection attempt. Cause The -27001 error on the client side can occur for several reasons, the most common are: 1) The server or network is very busy, causing the connection attempt to time-out 2) The server is off-line during the connection attempt 3) OAT is trying to connect to an incorrect port number Resolving the problem In the cases where the network is busy or the server is offline, ensuring the server is in online mode and retrying the connection will generally resolve the error, however setting the environment variable INFORMIXCONRETRY to a higher value can also be helpful on a busy server/network. In the case that OAT is connecting to an incorrect port number, it is necessary to review the services file on the server side to see what port number IDS is listening on. Then, on the OAT 'Edit a Connection' menu, ensure that the value entered in the 'Port' field is the port number that IDS is listening on. Also ensure that the 'idsd port' field is left blank. The idsd daemon should only be used to enable starting a server in a high-availability cluster or adding a shared disk secondary (SDS) server. Document information More support for: Informix Servers Software version: 11.5, 11.7, 12.1 Operating system(s): AIX, HP-UX, Linux, Solaris, Windows Reference #: 1682638 Modified date: 26 August 2014 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility
Sep 13 - telecompaper - Shaspa and Tatung have shown a new smart home platform at Ifa in Berlin. Powered by the IBM Informix software... Read 06 Sep 13 - IBM data magazine - Mission Accomplished - Miami, Florida will be the backdrop for the 2014 IIUG Informix Conference... Read 01 Feb 13 - IBM Data Magazine - Are your database backups safe? Lester Knutsen (IBM Champion) writes about database back up safety using "archecker"... Read 14 Nov 12 - IBM - IBM's Big Data For http://www-01.ibm.com/support/docview.wss?uid=swg21682638 Smart Grid Goes Live In Texas... Read 3 Oct 12 - The Financial - IBM and TransWorks Collaborate to Help Louisiana-Pacific Corporation Achieve Supply Chain Efficiency... Read 28 Aug 12 - techCLOUD9 - Splunk kicks up a SaaS Storm... Read 10 Aug 12 - businessCLOUD9 - Is this the other half of Cloud monitoring?... Read 3 Aug 12 - IBM data management - Supercharging the data http://members.iiug.org/forums/ids/index.cgi/noframes/read/405 warehouse while keeping costs down IBM Informix Warehouse Accelerator (IWA) delivers superior performance for in-memory analytics processing... Read 2 Aug 12 - channelbiz - Oninit Group launches Pay Per Pulse cloud-based service... Read 28 May 12 - Bloor - David Norfolk on the recent Informix benchmark "pretty impressive results"... Read 23 May 12 - DBTA - Informix Genero: A Way to Modernize Informix 4GL Applications... Read 9 Apr 12 - Mastering Data Management - Upping the Informix Ante: Advanced Data Tools... Read 22 Mar 12 - developerWorks - Optimizing Informix database access... Read 14 Mar 12 - BernieSpang.com - International Informix User Group set to meet in San Diego... Read 1 Mar 12 - IBM Data Management - IIUG Heads West for 2012 - Get ready for sun and sand in San Diego... Read 1 Mar 12 - IBM Data Management - Running Informix on Solid-State Drives.Speed Up Database Access... Read 26 Feb 12 - BernieSpan.com - Better results, lower cost for a broad set of new IBM clients and partners... Read 24 Feb 12 - developerWorks - Informix Warehouse Accelerator: Continuous Acceleration during Data Refresh... Read 6 Feb 12 - PRLOG - Informix port del
Thunder-Boy Google Discovery Evaldo Junior :: InFog Rui Miguel Feio Pesquisa A carregar... Download Blogger Tricks Blogger Themes Visitas Assuntos Access (1) Artigo (3) Informix (49) Linux (3) Mainframe (8) Oracle (4) SQL Server (1) SSIS (1) Meu http://claudemarmartins.blogspot.com/2014/03/informix-erro-27001-read-error-occurred.html Perfil Claudemar Martins de Sá Ver o meu perfil completo 3/10/2014 Informix Erro - http://www.dbforums.com/showthread.php?1051522-27001-Read-error-occurred-during-connection-attempt 27001 Read error occurred during connection attempt março 10, 2014Claudemar Martins de Sá Este erro aparece no log de mensagens do Informix, e os usuários não são capazes de se conectar ao servidor de banco de dados, abaixo vamos destacar as três maneiras de resolver este problema; 03/10/14 14:40:18 listener-thread: err = -27001: oserr = 0: errstr = read error : Read error occurred during connection attempt. 03/10/14 14:41:08 listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt. 03/10/14 14:42:59 listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt. 03/10/14 14:43:44 listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt. 03/10/14 14:44:24 listener-thread: err = -27001: oserr = 0: errstr = read error occurred : Read error occurred during connection attempt. 03/10/14 14:45:09 listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt. 03/10/14 14:47:55 listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt. 03/10/14 14:48:40 listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt. 03/10/14 14:49:25 listener-thread: err = -27001: oserr = 0: errstr = : Read error occurred during connection attempt. Resolvendo o Problema 1 Os arquivos da /INFORMIXTMP não foram removidos - acesse este diretorio e veja os arquivos lá salvos: [bloco01:informix]$/export/home/informix> cd /INFORMIXTMP Com o banco ar o diretório esta com esses arquivos [bloco01:informix]$/INFORMIXTMP> ls -la total 20 drwxrwxr-t 2 informix informix 4096 Mar 10 15:10 . drwxr-xr-x 28 root root 4096 Mar 10 14:56 .. -rw-rw-r-- 1 root informix 16 Feb 19 2013 .infxdirs -rw-rw-rw- 1 informix informix 195 Mar 10 15:17 .digital.alarm srwxrwx--- 1 root informix 0 Mar 10 14:57 VP.digital.010100s srwxrwx--- 1 informix informix 0 Mar 10 14:57 VP.digital.010101s srwxrwx--- 1 root informix 0 Mar 10 14:57 VP.digital.010102s srwxrwx--- 1 root informix 0 Mar 10 14:57 VP.digital.010103s srwxrwx--- 1 root informix 0 Mar 10 14:57 VP.digital.010104s ---- corte ---- srwxrwx--- 1 root informix 0 Jan 23 11:06 VP.digital.150100s srwxrwx--- 1 root
your first visit, be sure to 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 visit from the selection below. Results 1 to 9 of 9 Thread: -27001 Read error occurred during connection attempt 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 10-28-04,05:21 #1 pdraycott View Profile View Forum Posts Registered User Join Date Oct 2004 Posts 5 Unanswered: -27001 Read error occurred during connection attempt Hi, We are using Informix Dynamic Server 2000 on SCO Openserver 5. We keep getting -27001 Read error occurred during connection attempt error messages every couple of days. We use an IIS5 web server to connect to Informix using the Informix Iconnect ODBC driver (2.81). I have tried to sort this out myself, but I have failed. In the onconfig file there are 2 nettype lines :- NETTYPE ipcshm,1,200,CPU # Configure poll thread(s) for nettype NETTYPE tlitcp,1,20,NET # Configure poll thread(s) for nettype I think the tlitcp line doesn not have sufficient poll threads. We have about 50-100 people who access the informix database through a web page. Should i increase the number to 100? Cheers, paul Reply With Quote 10-28-04,09:25 #2 pathri View Profile View Forum Posts Registered User Join Date Apr 2004 Location zxczxczxc Posts 52 -27001 Read error occurred during connection attempt Hi Paul, In the NETTYPE there are only 20 concurrent users configured. You can increase it to 100-250 to handle your 50-100 users. The configuration would be like NETTYPE tlitcp,1,200,NET Bye. zxczxczc Reply With Quote 10-28-04,09:27 #3 artemka View Profile View Forum Posts Registered User Join Date May 2004 Location New York Posts 248 Do you get this error on the server or on the client side? You can try