Re: informix hang when nfs server is down

In article <CFz67D.19Hq@austin.ibm.com> bruce@austin.ibm.com (Bruce Bramhall) writes: > >I am running SE 5.0 on an IBM RS/6000 AIX 3.2 (call it dbmach). There is a >user on the same system who nfs mounts a directory onto his home directory >on dbmach (/u/johndoe). We'll call the other machine he is mounting >from johnsmach. Informix is installed in /usr/informix and the database is >in /usr/informix/db/mydb.dbs. > >The problem is when johnsmach goes down for some reason I cannot run Informix. >If I start ISQL with isql I get the menus ok, but when I do "DATABASE" "SELECT" >"mydb" I get the normal "Running...", then a long pause then what seems to >be an AIX message "NFS server johnsmach not responding". The only way to >get Informix to run is to either 1) wait for johnsmach to come back or 2) >kill the informix processes, unmount /u/johndoe and start informix again. >Why does informix even care about /u/johndoe? I ran a trace and found >informix (sqlexec I think) looking though all of the /u directories along >with many more unrelated directories. Does anyone know how to fix this >or know of a work around? If directories from NFS mounted filesystems are in $PATH and/or $DBPATH, you will see hangs if the machines providing those filessystems are down. Scott