Re: olsoctcp versus tcp

At 12:34 AM 8/22/95 GMT, Tim Helton wrote: }We are running Informix 5.02.UC1 backend with ISQL 4.11.UC1 and }I-Net 5.02.UC6 on a Sparc Station 5, and we have an sqlhosts file configured }as follows: } } . } . } . } myengine tcp mymach star1 'tcp', I believe is an improper entry. } myengineol olsoctcp mymach star1 'olsoctcp' is the correct entry. The 'ol' tells the system it is an OnLine database. The 'soc' instructs the system is using sockets to communicate, over 'tcp'. Check the documenation. It should include the correct format for allowable entries. Jon } } When we run the following } } begin work; } insert into mydb@myengine:mytable } values(0, "abc", "abc", "abc", "n", "ab" ); } commit work; } }the process hangs, but when we run } } begin work; } insert into mydb@myengineol:mytable } values(0, "abc", "abc", "abc", "n", "ab" ); } commit work; } }it completes successfully. } } Can anyone explain why this happens? Any words of wisdom on the }difference between olsoctcp and tcp? Would it be save to change the tcp }to olsoctcp (there are other applications currently running the machine }and accessing the databases via this alias.) }bilbo:/home/bilbo/timh/tmp> } } } } ==================================================== Jon Vemo Internet: jvemo@cyberspace.com Bothell, WA USA Watch out for road-kill on the information superhighway....SPLAT!! ====================================================