[comp.databases] Problems with Informix in an NFS environment

weigelt@Thalatta.COM (Mikael Weigelt) (10/04/89)

Problems with Informix in an NFS environment

We have a NFS network with one server and several diskless clients. Our
problem is that we cannot run Informix from our clients. To get our
application running we need to remote login to the server and start it
from there.

We know that the Informix process is running as root, therefore we
modified NFS so that root on each client has also root access to the
server.  But it is still not working.

I would appreciate any help to get rid of this annoyance.

Thanks for the help in advance.

Mikael Weigelt


-- 

In-Real-Life: Mikael Weigelt, Thalatta Corporation, (+1 206 455 9838)
Domain: weigelt@Thalatta.COM   Path: ...!sun!sunup!thebes!weigelt

prc@erbe.se (Robert Claeson) (10/06/89)

In article <1766@thebes.Thalatta.COM> weigelt@Thalatta.COM (Mikael Weigelt) writes:

>We have a NFS network with one server and several diskless clients. Our
>problem is that we cannot run Informix from our clients. To get our
>application running we need to remote login to the server and start it
>from there.

That's because Informix doesn't believe in NFS record locking. The C-ISAM
library actually checks if the file system you're running on is an NFS
file system and, if this is the case, complains and refuses to do any work.
Furthermore, Informix can only deal with one file system type at a time
(I believe it's a compile time option). So, on our system which is using
multiple file system types, we can only use Informix on one of them,
namely the old System V 1K file system. We have all our file systems except
for the root file system in BSD 8K format...

And now a question for you guys using RFS: Does Informix run over it?

-- 
          Robert Claeson      E-mail: rclaeson@erbe.se
	  ERBE DATA AB

trt@rti.UUCP (Thomas Truscott) (10/08/89)

> >We have a NFS network with one server and several diskless clients. Our
> >problem is that we cannot run Informix from our clients. ...
> 
> That's because Informix doesn't believe in NFS record locking. ...

I suspect Informix doesn't believe in the correctness of
NFS file caching, either.

I suggest you junk NFS and run Freedomnet instead.  Several customers
have used Informix over Freedomnet for years with zip problems.
AT&Ts RFS would probably do okay too,
but I suspect RFS is not available on your favorite machines.

Also, Freedomnet allows "true remote execution",
which means that if any of your machines has Informix
they all do.  Very handy if your Informix is on a Sun
but you have a bunch of Dec machines too.
(This is useful for more than just Informix.
For example, if *any* of your machines has a Korn Shell,
you can make it your login shell.  That's what I do here,
so kind of HP-UX to give me a ksh server!)

Sorry this is a commercial, but this Non-Faithful-Semantics
stuff really ticks me off sometimes.  For more info on Freedomnet
contact Tom Warren, wtw@rti.rti.org, (919) 541-6110.
	Tom Truscott
P.S. You don't have to junk NFS.  Run both and take your choice :-)

Hmm, I guess I need a disclaimer:  These are my opinions exclusively.