Re: Migrating from SE to ONLINE

In article <01bc6ceb$45080880$c0026ac2@aids>, Cecilio Albero <orange@vlc.servicom.es> writes >I'm migrating from SE to ONLINE. >I work with NETTYPE ipcshm, and I have a problem: Sometimes the users >can't access to the Database, and the server writes into the log file: > > Error -27001 Read Error during conection attempt. > >The only way to solve temporaly the problem is doing Shutdown and >Starting-up ONLINE. > >Any idea? > >Thanks in advance... The full error is :- -27001 Read error occurred during connection attempt. A network I/O error occurred when connecting to the desired data-base server. If using the INFORMIX-OnLine Dynamic Server, verify that the database server is still online. If using the INFORMIX-SE data-base server, verify that the sqlexecd daemon for the database server is still running. Also, verify that the $INFORMIXDIR/etc/sqlhosts file entry for the desired database server is correct. If the error recurs, please note all circumstances and contact the Informix Technical Support Department. I would check sqlhosts /etc/services DBSERVERNAME and DBSERVERALIASES on both machines are correct. Check you can ping from one machine to the other. Check the release notes (under $INFORMIXDIR/release somewhere) - the file will be called ONLINE_7.1 or ONLINE_7.2. Possibly you need to set SHMBASE in the onconfig file on one of the machines. Or you may need patches to UNIX to fix UNIX bugs... -- David Williams