XPost: comp.databases.informix, comp.databases, comp.databases.ibm-db2   
   From: dmcbride@naboo.to.org.no.spam.for.me   
      
   Peter wrote:   
      
   > I think INFORMIX is a better and stable product of IBM on non   
   > Main Frames system. In DB2, when instance disappear the simple   
   > soution is to resrat it by db2start command. There are many   
   > companies that can effort it in production so they will not   
   > mind it at all.   
      
   The instance doesn't disappear - the processes disappear.  There's a   
   difference, and that's the difference that I think has confused a   
   number of people ;-)   
      
   In short, you managed to get DB2 to crash.   
      
   In DB2 v8, there is a new feature called the Fault Monitor which can   
   detect a crash and restart the server for you automatically.  This may   
   alleviate (but not eliminate) your problem.   
      
   All that said, there are a number of people who would be interested in   
   the PMR number for this problem to see what they can do about getting   
   it fixed even without the Fault Monitor.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)